Separate VAT from bulk sales income

[Danny]

Our EPOS system hits our statement every day without fail. I tag the entries on the statement to a nominal code within the sales range. Unfortunatly, these amounts do not show VAT. I have the VAT amounts, but I am struggling to journal these amounts so they are included in the VAT return figures. Please advise.

[QFMathew]

Hi @Danny

Do you know the VAT amount, gross amount, net amount, or none of these?

Would it show, for example, £100 (inc 20% VAT)?

[Danny]

All of these.
Although the amount taken hits the account in one lump, EPOS will print us a report showing full breakdown.

[QFMathew]

Ok great!

In that case, you would just create a sales invoice to account for it, and include a new line for each VAT amount, similar to the below:

Or alternatively, if you know the VAT total, you may find our daily sales tool helpful:

Cash Register Tool

Introduction If your business operates a cash register then no doubt you will have realised that logging each customer transaction to a unique invoice in QuickFile is not practical. In such cases what you would typically do is log your daily, weekly or even monthly totals to a lump sum invoice and pay that invoice to a cash account in the banking section. Where can I find the Cash Register Tool? The Cash Register tool is located in the Sales tab (Enter cash register takings). How does the Cas…