Thesaurus Payroll 2025 is now available to download - please click on this link 2025 Payroll Download 

Click here for 2024 FAQs

Sales - Multi VAT Invoice Entry

 

SALES INVOICE PRODUCTION IS TO RECORD SALES TO CUSTOMERS AND TO PRODUCE AN ACTUAL INVOICE FOR PRINTING.
 
THERE ARE A NUMBER OF DIFFERENT SALES INVOICE PRODUCTION OPTIONS WHICH ALL RESULT IN SALES TO CUSTOMER RECORDED IN THE SAME MANNER BUT PRODUCE DIFFERENTLY DISPLAYED INVOICES.
 
THE MULTI VAT INVOICE ENTRY OPTION IS SIMILAR TO THE NORMAL INVOICE ENTRY SCREEN EXCEPT THAT IT IS EXTENDED TO ALLOW THE USER TO APPORTION THE INVOICE ACROSS NUMEROUS SALES ACCOUNTS AND / OR VAT RATES.
 
 

SALES >  INVOICE PRODUCTION>  INVOICE PRODUCT ENTRY

 
                        

Invoice/Credit Note 

Select Invoice or Credit Note as appropriate.  Once selected the program will automatically post the transaction in the appropriate manner.

 

 

Reference                                                              

This will be the sales invoice number, these numbers should work sequentially, once entered the system will automatically generate the next number on the next sales batch entry / invoice production option.  If you are entering invoices using all invoice entry screens this reference field is linked to all sales transaction screens and will run sequentially no matter which sales entry screen you use.

 
 

Date                                                                                                

Date of sale

 
 

Customer                                                               

Select a Customer name from the drop down list of Customers to whom the sale relates.

 
 

Setting up New Customer during transaction entry

If the sale is to a new Customer which does not already exist within the Customer listing then, without closing the invoice production entry screen, from the main menu, select Sales> Add/Amend Customer> and setup the new Customer.

This will add the Customer to the drop down list within the Invoice Production screen.
 
 

Nominal Account                                      

Select the relevant sales nominal account to which the sale relates:

 
  • Sales at Standard Rate                                 VAT @ 23%       
  • Sales at Low Rate                                           VAT @ 13.50%        
  • Sales at Zero Rate                                          VAT @ 0%                 
  • Sales VAT Exempt                                          VAT @ Nil                  
 
 
Narrative                                        
 

Type the appropriate narrative to appear on the invoice related to this line of entry e.g. brief description with batch number/purchase order number.

There is the option to add two more lines of entry to the invoice at varying VAT rates. There is no restriction to the mix of VAT used, i.e 3 lines of entry all at standard rate or one line at standard rate one line at low rate etc.

Once printed the invoice will detail each line of entry will the attached narrative detailing the VAT rate and VAT amount per line of entry.

An example of an entry posted from the above transaction is :

 
Sales Invoice relating to the sale of Parts to the net value of 100.00 and Labour to the net value of 50.00.
                                                
1. Parts:
 
Cr        Sales account                         (100.00)          Net Amount P&L account Income
 
Cr        VAT account                           (  23.00)          VAT element payable to revenue Balance Sheet Payable to Revenue
 
 
 
2. Labour:
 
Cr        Sales account                         ( 50.00)           Net Amount P&L account Income
 
Cr        VAT account                           (   6.75)           VAT element payable to revenue Balance Sheet Payable to Revenue
 
 
 
Dr        Trade Debtors account             179.75             Gross Amount  Balance Sheet Receivable from Customer
 
 

The profit and loss account (P&L) records the actual income generated by the company on this particular sale, therefore the P&L can only ever reflect a particular sale once as the income generated on this sale is only generated once.

The Balance Sheet (B/S) records amounts payable/receivable and amounts paid/received.  In posting a sales invoice the amount of the invoice is recorded as a receivable so is therefore automatically posted to the “Trade Debtors” account which represents amounts receivable from Customers.

In the above transaction the invoice relates to a two part sale.  The initial part of the entry will result in the Net Amount (excluding VAT, 100.00) credited to the “Sales at Standard Rate” account in the P&L. 

As the business is VAT registered the business must pay the VAT element of the invoice to the Revenue therefore they are not actually gaining the full income (Gross amount) of the invoice only the amount excluding VAT (Net Amount).   Therefore the Net amount (excl VAT) is posted as the actual P&L income and the VAT element is posted to the VAT account (B/S) as a credit meaning it is payable to the Revenue. The total Gross amount (incl VAT) is receivable from the Customer so this amount is posted to the Trade Debtors account as a debit as it is receivable.

The secondary part of the transaction will have the same results attaching the lower rate in place of the standard rate.  The Net Amount (excluding VAT, 50.00) will be credited to the “Sales at Lower Rate” account in the P&L.  The VAT element will be posted to the VAT account as a payable to Revenue. 

The Gross amount (incl VAT) is receivable from the Customer so this amount is posted to the Trade Creditors account as a debit as it is a receivable.

 

N.B.   Accounting works on a double entry basis and must always balance

 

Expense/Payment/Payable :                                    

P&L     Expense                                  Debit   +                      

B/S      Payable/Paid                          Credit  -                      

 

Income/Received/Receivable :

P&L     Income                                      Credit   -

B/S      Receivable/Received                 Debit    +

 

AN INVOICE IS NOW AVAILABLE TO PRINT FROM THE INVOICE PRINTING MENU UNDER THE SALES> INVOICE PRODUCTION> MENU.

ALTERNATIVELY SIMPLY SELECT "PRINT" TO BRING YOU STRAIGHT THE INVOICE PRINTING MENU.

  

Need help? Support is available at 01 8352074 or thesauruspayrollsupport@brightsg.com.

GeneralBureau Users OnlyCompany SetupCustomersSuppliersProductsOpening BalancesCustomising for your useSales EntrySales Invoice PrintingCustomer StatementsReceipts EntrySales Related ReportsBad DebtsPurchases EntryPayments EntryPurchases Related ReportsBank TransfersReconciling Bank AccountsCorrections and DeletingVAT ReportingDirectors TransactionsSubcontractorsPrincipal ContractorsFixed AssetsReportsPetty Cash TransactionsLease RepaymentsHire Purchase RepaymentsDirectors Salary / RemunerationThesaurus Payroll JournalThird Party Payments / Form 46GJournal EntryAudit FileAccounts ProductionStock ControlArchive TransactionsBacking up your Company FilesRestoring a Back UpCSV ImportSchools Version