Sample Spreadsheets

There are a number of sample spreadsheets provided by Codis, to illustrate the different structures and methods of calculating VAT and some advanced applications of Excelerator

SLMultCustInvVat.xls

This sample illustrates:

• Multiple Customers and Invoices
• VAT calculated from Invoice gross and VAT

SLMultiInvVAT.xls

This sample illustrates:

• Single Customer,Multiple Invoices
• VAT calculated from Invoice gross and VAT

SLMultiInv.xls

This sample illustrates:

• Single Customer,Multiple Invoices
• VAT Entered on each line, or auto allocated

SLInvoice.xls

This sample illustrates:

• Single Customer, Single Invoice
• VAT Code

SLSingleVAT.xls

This sample illustrates:

• Single Customer, Single Invoice
• VAT Calculated from Net Amount and VAT Code

SLInvoiceGV.xls

This sample illustrates:

• Single Customer, Single Invoice
• Vat Entered Using Goods/VAT Indicator