VAT Returns (UK)

[Montanes]

Does anyone have a spreadsheet that calculates quarterly VAT?

I have made a mock spreadsheet (see attached) on how i think this would ideally look but i have no idea what formula would be used to make this work.

The idea is that in TAB1 i would list the invoices i have been sent from suppliers including columns for date, supplier, their VAT number, invoice number, Net amount, Gross Amount and VAT amount.

TAB2 is similar but would list the invoices i have sent to customers. Columns include date, customer, invoice number, net amount, gross amount and VAT amount.

TAB3 would then list the data for a specific 3 month period. On the left would be Supplier information listing date, supplier and VAT amount that i have paid. And to the right would be Date, customer and VAT i have collected.

At the bottom of this and any subsequent page would be a running total of how much VAT i have paid and collected over the 3 month period which i could then print for my records.

It doesn't have to look like this, if you have alternatives i would certainly appreciate your help.

I previously listed this in the General forum but i think it belongs here really.

Thanks in advance for your assistance

[Bob Phillips]

Duplicate posting.

[Richard Buttrey]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.