Don't have time to read? Watch the instructional videos here:
...
See our VAT help section here: https://tphsupporttphglobal.freshdesk.com/support/solutions/folders/2100032163atlassian.net/wiki/spaces/TPHCS/pages/1694990396/Digital+VAT
VAT Report
For every transaction in the VAT Control Account, the system looks at the Tax Flag and it’s Transaction Number and calculates the total based on this. The VAT Report calculates the NET amounts backwards by looking at every tax flag coded to each transaction number in the VAT account, it then uses this transaction number to calculate the NET amount of each transaction. This report is prone to error when using multiple entries that use the same transaction number, such as Journals and Distribution Changes.
...
1. From the main menu bar select General Ledger > Ledger Inquiry. Select Reports button
2. Select Preview from the Report Type drop-down menu
3. Select Vat Ledger from the Report Defaults drop-down menu
...
4. In the Report Layout section, select Vat Account Report. Insert your VAT ACCOUNTS (purchases & sales) for the account range. You can run purchases and sales reports separately if needed.
Note: When entering transactions, use the tax balance button in the Unposted Batch List window to ensure your coding and flagging are correct. If items are not flagged correctly an error window will appear listing each transaction number out of balance. You can also tick Balance Tax Before Posting checkbox (System Defaults, Tax Balance tab) to automatically check before each posting. It's easier to use the tax balance button or force a tax balance during a post to sort out any problems at the time of entering, rather than waiting for month end.
...
5. Click the Selection tab, in the Date fields enter the end date you are reporting on.
...
7. Return to the Report Details tab and click the Save icon. Press OK to run the report. Here you can also export your ledger into Excel so you have a record for audit. The data is summarised and it will show if it reconciles back to your VAT account. If it doesn't balance you can inspect the transactions to see if there are wrong flags or items have not been split.
Note: A question that comes up a lot is when the VAT amount per transaction in the VAT Report doesn't reconcile back to 20% or items without VAT are not shown on the report. The report uses the TX to calculate the net amount of all transactions. For amounts not calculating correctly it is because a line has not been split and flagged separately between VAT and non-VAT. This then introduces another problem, you then need two lines in your VAT account for this transaction even though the non-VAT line will be zero. There is an option in System Defaults, Tax Balance tab to automatically add two lines to every transaction to make this process easier. This will also solve the problem where items with no VAT are not shown on the report.
8. As an extra precaution, once you have the report and have prepared your return for HMRC, immediately perform a Vat Reconciliation (see below). If you have trouble balancing your VAT next period you will be able to see all the unreconciled items in your VAT account to work out what is not being included in your report.
...
1. Create, enter and post a Journal to match your VAT Report, moving the expenses from the VAT Purchases TB account to VAT Control/ Suspense account. VAT purchases should be a credit and VAT sales should be a debit. VAT control is a debit if you are expecting money back or a credit if you owe money to HMRC.
...
2. In Eclipse from the main menu bar select General Ledger > Budget Worksheet. Select your VAT Purchases TB code and click the Transactions tab.
3. Tick the Select All checkbox and then click the Reconcile button. If all transactions do not equal zero you will not be able to reconcile them and must find the problem.