Sales

1. File your invoices in number order.

2. List the invoices on a spreadsheet following the example below.

Note on VAT

Gross includes VAT. Net is before VAT is added on. If your business is not registered for VAT or there is no VAT due on the sale or expense, then VAT is ignored and net will be the same amount as gross.

3. Add up the columns from the beginning of the financial year to the end of the financial year. Prepare a separate spreadsheet for each year.

4. When the customer has paid, note it on the same line as the invoice in the ‘amount paid’ column and note down how much is still owed in the ‘money owed’ column.

Sales invoices
Invoice number	Customer Name	Invoice Date	Date paid	Gross Amount	Amount paid	Money owed	VAT	Net

Spot checks

1. Agree the total of the net sales column to turnover on the annual summary.

2. Agree the total of the VAT column to VAT in the VAT control line of the ‘List of sales’ column in the annual summary.

3. Agree total gross sales to sales in the customer control line of the annual summary.

4. Agree the sum of the VAT and Net column totals to the Gross column total