Introduction

Batch Invoices are used for any invoices where it is not necessary to record detailed product entries, such as movement or quantity.  You can use it for small purchases such as household cleaning items, manual repairs, and business consumables. 

Each line entered represents a separate invoice, which is directly posted to the Supplier account and to the General Ledger. You can reuse the same external reference on each line if you have multiple lines to record for the same invoice (e.g. representing different Tax rates or to be posted to different expenditure accounts in the GL).

Prerequisites

You need to set up the following prerequisites:

• Supplier Master Records
• Codes tables (General Ledger Codes, Currency Codes and Tax Rates)

Keyboard Shortcuts

 

See:

Creating Purchase Invoices (Non PO Process)‍ 

Creating Purchase Invoices (PO Process)‍ 

Creating Batch Invoices

1. Go to Purchases > Batch Invoice > New Batch Invoice.
   
   
2. Delete

   Info: Our New Look

   If you are using our new look navigation, Batch Invoices can be found in the AP tab in the new sidebar. Hover over the plus icon and select New Batch Invoice:

   

   
   

2. In Batch Invoice, each line represents a Supplier Invoice. A Batch can comprise single or multiple entries. If the lines contain the same Supplier, Date, and Reference, they will post as one Purchase Invoice.
3. For each Line, enter:

• Account: Select from the dropdown. This auto-fills the Supplier defaults (General Ledger Code, BI Code, and Tax Code). If your Supplier doesn’t exist in the system, click +Add new Account to complete and save their details. The new account will then auto-fill in the Account field.

• GL Acc: This comes from the Supplier Master record. You can override it here by selecting from the dropdown or by entering a General Ledger Code.
• BI Code: This is available if you are using Extended Business Analysis. The default comes from the Supplier Master Record. 
• Date: This is the date of the transaction. It defaults to today’s date, but you can override it here.
• Ref:  This is a Supplier Reference. It can be the Supplier  Invoice No. that appears on the Purchase Invoice. If there is a duplicate Batch Invoice Numbers from the Supplier, you will receive a warning and must change the Invoice number.
• Description: Enter a short description.
• Net Amt, VAT, VAT Amt: Enter Net Amt. Select the Vat Code from the dropdown. VAT Amt will auto-fill. If there are differences between the Supplier VAT (Tax) calculation and the calculated VAT (Tax) Amt, use the Supplier VAT (Tax) Amount and Line Total. To override the VAT (Tax) Amt, double-click in the field. In the dialog box enter the new amount. A warning displays this amount is more than 0.10 above the originally calculated value. However, this does not prevent posting.

• Line Total: The total amount is the sum of the Net Amt plus the VAT (Tax) Amt. 
• Exchange Rate:  The exchange rate entered here will determine the base currency value of this invoice when posted. If the batch invoice is for a foreign currency supplier, then the Exchange Rate will come from the currency table, but you can override it here. The view rate history link is for reference purposes only as these rates are not linked to the Invoice entry date.  
   

• Sub Total: This is the Net total of all the lines. This appears in both the Supplier currency and the Base Currency
• VAT (Tax) Total: This is the VAT (Tax) total of all the lines. This appears in both the Supplier currency and the Base Currency
• Total: This is the VAT (Tax) plus the Net amounts of all the lines. This appears in both the Supplier currency and the Base Currency

4. You can now do the following:

• Click Post to post the entire Batch of transactions. This clears the screen. The last Processed Invoice No appears at the bottom of the screen. 
• You can also Print the Batch.
• If you don’t want to post, click Clear Batch. The Batch clears and you will not be able to retrieve it.
• To save a Batch without posting, click Close. Your progress is autosaved and you can return to it later.

Viewing posted Batches

Go to Purchases > Batch Invoices. Each purchase invoice within the batch posts separately with a unique reference. Find your entry in the grid. The Purchase Invoice shows a negative amount and PI type. The entries associated Supplier Ledger Accounts and General Ledger/ BI Codes Accounts have been updated (unlike non-batch Item Invoices which might require Approval).

View posted transactions that have changes to the VAT (Tax) amounts

Go to Reports > Report Manager >Tax Reports > Tax Exceptions Report. 
 

See: 

Using Extended Business Analysis‍ 

Managing Batch Invoice

Go to Purchases > Batch Invoices. 

In the grid, note the following:

• Reference:  This is the auto-generated audit-trail transaction reference. You cannot change it. This displays as Ref. in the Transaction Browser after posting.
• Number:  This is the Internal Number or Int. No of the transaction. Here it is a sequential number continuing from the previous Batch Line. In other cases, it is the Document number controlled by the parameters in the Company Details and Settings, such as the Supplier Invoice or Order Number.
• External Reference:  This is the Ref. quoted on the Batch Line entry and can be the Supplier Document No. 

• Actions:  You can also choose some of the following actions from the dropdown:
  • Mark as Disputed
  • Remove
  • Create Purchases Payment