Batch Bill Input

Batch input is designed for those who need to rapidly input significant volumes of Supplier Bills or credit notes. It may be that a catch up of transaction data is necessary or that volumes of transactions are such that the a large number need to be input. Batch input simply means that a number of Supplier bills or credit notes can all be entered at once. The Information needed is the same as that for the single bill/credit note transaction, and as such in order for the process to be as easy and simple as possible a few minutes spent setting up supplier and other details in advance is well spent. If an entity is not registered for VAT, then there will be no references to VAT in the screen, also therefore ignore references to VAT in the guide below

You can add as many transactions to the screen as you wish, however we recommend that no more than 20 lines per batch be entered for optimum efficiency. The system has a session time-out period of 40 minutes, so please be sure to submit a batch before leaving your computer for a period or the information may be lost and will need to be re-input.

This screen is used for batch input of bills and credit notes received from suppliers.

Screen Navigation

As well as using the mouse you can navigate around the batch screen using key strokes. The only exception is the SUBMIT button. Press the access Key (ALT asterixor CTRL) at the same time as the bracketed letter on the button.

Navigation Key Strokes
Keystroke Action
ALT+A add a new transaction
ALT+C copy the previous line item
ALT+U undo the current line item
ALT+S save the current line item entry in the browser
ALT+R reset the screen and remove all existing entries
ALT+Up or Down Arrow open a dropdown box, the arrow keys can then be used make the selection
TAB Key move to the next field
SHIFT + TAB Key move back to the previous field

asterix In the Windows environment use the ALT key, for Apple Mac use CTRL+ALT or CTRL depending upon the browser.

Document Type

Indicate the type of transaction that you are entering by selecting either bill or credit. Select bill when you wish to record the details of a bill you have received from a supplier. Select credit when you wish to record the details of a credit note you have received from a supplier.

Transaction Date

The date of the transaction. Dates can either be entered manually or selected from the pop-up calendar by clicking on the Calendar icon. Dates must be entered in the format DD/MM/YYYY, for example, 21/1/2000.

For batch input items the tax point for VAT purposes will be the same as the transaction date.

When entering dates manually, a date guessing routine speeds up the input by taking the user input and assuming the missing month and or year based on the current date as the user leaves the field i.e.

the date today is 30th October 2009

Supplier

The supplier list contains all active suppliers associated with the business.

Auto-complete field names

Rather than a drop-down to select from a list, simply start typing and the system will identify any occurrences of the combination of characters entered and you select from that shorter list. As an example, type 'able' and the system will offer:

Able Contractors

Capable Cleaning

Reasonable Roofers

etc.

Adding new customers / suppliers

If the combination of characters you enter does not provide any results, press tab and the system will know you need to add the customer/supplier and ask you to confirm the details. At this point add address, email contact etc if required.

Departments, Activities and Funds

Line item entries may be analysed to Departments and/or Activities where this has been activated. In addition, for Not-for_profit Organisations a Fund must be selected.

In each case use the drop-down to choose the analytical area appropriate to the line item. If no selection is needed just leave the field or select Not Applicable.

For information about analysis areas see Sites, Departments and Activities

Employee for P11d Purposes

Visible only if Personnel P11D Expense & Benefit Tracking has been selected in the optional features tab on the Organisation Profile.

Select an employee/director to whom this transaction is to be associated for P11D purposes.

Reference

The reference to be associated with the transaction.

When creating items in the Batch Input screens all items with the same reference will be grouped together and treated as a single transaction when submitted.

Account

The account drop down list is used to associate the line item of a transaction with an account from the chart of accounts.

If nothing is displayed either
simply start typing an account name or ledger code and the system will provide a list of potential selections; choose the required account by clicking on it.
or click the Search icon
to display a list of document-type sensitive account possibilities. Note to change to other account-type options click the small down arrow at the base of the screen
If an account is displayed
In many instances once a counterparty (customer, supplier or employee etc) has been selected the account box will display a default learned account. For other associated learned accounts click the Search icon. Note to change to other account-type options click the small down arrow at the base of the screen

Net Amount

The net amount associated with the item.

When recording purchases, if you have a gross amount and want liberty to calculate the net amount and vat amount simply enter the gross amount in this field, select the appropriate VAT code, and type "g" in the VAT amount field.

VAT Rate

The appropriate VAT rate for the account must be selected. Default VAT rates can be associated with an account via the Account Maintenance screen which is available from the chart of accounts view.

If the business is on the HMRC Flat Rate VAT Scheme, as defined on the VAT details tab of the Business Profile, the VAT rate will default to "Out of Scope" for all purchase transactions. This can be changed if necessary. Exceptions may apply for purchases of capital assets of significant value, please consult your professional advisor.

Current VAT Rates

17.5%, 5% & zero, used for normal UK VAT transactions.

Exempt

Used when a transaction is an exempt supply; such as the purchase of insurance. See the VAT Guide (Notice 700) for more details or visit the Revenue and Customs site at www.hmrc.gov.uk

EU Acquisition

Used when you purchase from a VAT registered business in an EU member state. Make sure that the VAT code is set to EU Acquisition, and that the VAT amount shows the VAT which would have applied if the purchase had taken place in the UK.

EU VAT

Only used if you have you have incurred VAT in an EU member state, (i.e. local VAT). This CANNOT be recovered as input tax for UK VAT. You may make a claim for refund from the member state. A scheme exists to do this known as "Refunds of VAT in the European Community for EC and non-EC businesses" The details are in notice 723, refer to the Revenue and Customs site at www.hmrc.gov.uk Use of this VAT code is described more fully in the "VAT and Liberty Accounts" user guide.

Out of Scope

Used when a transaction is not in the VAT system at all. For example payments into a money purchase pension scheme are out of scope because they are equivalent to savings. Using this code will result in no VAT reporting impact.

None

This code is used where there is no VAT on a transaction. This is not the same as zero rated, exempt or out of scope. The impact is that the value of either the supply or purchase is included in the VAT 100 return.

Special Note - Reverse Charge for Purchases From Non EU Countries

Typically this is required for a purchase from a non-EU country where no VAT has been paid. It simply provides a means of accounting for the VAT that would have been paid if the good or service was purchased in the UK. Applying a reverse charge VAT process will have no impact on your VAT liability.

Reverse Charging for non-EU purchases is not currently supported in the batch input screens. To apply the reverse charge VAT procedure on a purchase created via batch input simply open the transaction in the normal screen after it has been created and set the reverse charge flag.

If you subsequently view the item you will notice that the VAT rate has been set by the system to "Out of Scope". This is correct. If you need to make changes to the transaction you must reset the VAT codes to the appropriate code so that the Reverse Charge can be created again using the correct VAT amounts.

VAT Amount

The amount of VAT charged on this item is automatically calculated based on the vat code selected but can be changed.

When recording purchases, if you have a gross amount and want liberty to calculate the net amount and vat amount simply enter the gross amount in the net amount field, select the appropriate VAT code, and type "g" in the VAT amount field.

Editing a Supplier Bill/Credit Note Transaction

After a batch of bill transactions has been entered, each individual bill may be edited (Note that the original batch screen is not available to be edited). If a bill has been included in a VAT return then the details of the bill may only be viewed they cannot be changed or deleted. Likewise if a bill is dated in a closed financial year it also cannot be changed.

To locate the individual bill/credit note transaction: -

Expenses - Supplier Bills/Credits - Edit the relevant document

Paying Bills

Paying Bills entered via batch is the same process as for singly input bills. See Pay Bills for more information.

Expenses - Pay Bills - Select the relevant Supplier

Reports

After creating via batch input bills are handled and reported in the same way as single bill inputs. So that batch input bills remaining unpaid will appear listed on the Home page as well as in an Aged Creditors report and Supplier Account Listing.

Reports - Suppliers