What causes the discrepancy?
When you retrieve the VAT return in Accountflow, it is compared with accounting data from the chart of accounts. If the setup in the chart of accounts or VAT code settings is wrong, it can cause discrepancies between the reports.
Step by step: How to solve the problem
1. Undo and run auto-reconciliation again
Go to VAT under Reconciliation in the menu on the left.
Click on the Report tab.
Click Undo reconciliation, and then Auto-reconcile.
💡 If you previously reconciled vouchers manually in the period, these will be undone and must be reconciled manually again.
2. Check chart of accounts setup
Go to Reconciliation under Settings & Admin in the menu on the left.
Select the Chart of accounts settings tab.
Check that the accounts used for VAT calculation are linked to the correct account mapping.
💡 In PowerOffice, only the accounts defined as “Standard account mapping” are included in the calculation. The accounts selected in the VAT code settings must match these.
3. Adjust VAT settings
Switch to the VAT settings tab.
Look for codes that pull incorrect figures from the general ledger.
Change to the correct accounts for input and output VAT.
4. Run auto-reconciliation again
When the setup is corrected, go back to VAT > Report and run auto-reconciliation again.
Check if the discrepancy is resolved.