I’m trying to reconcile the total amount of revenue in 2018 in my P&L with the total amount of revenue reported via declared tax using the Dutch report Concept BTW Aangifte. I’m with no luck. I’ve used the Billable Expenses module, so part of my reported tax revenue went via the balance sheet and isn’t reported in my P&L. I’ve registered some revenue using Receipts and most via Sales Invoices.
I can reconcile my P&L via the Profit and Loss Statement report with the Tax Audit report after summarizing the totals per account in Tax Audit. I can reconcile the Concept BTW Aangifte report with the Tax Summary report. But I can’t reconcile the Tax Audit report with the Tax Summary report.
I can’t reconcile the total of revenue in the Tax Transactions with no other report. I’ve created a custom report to report all transactions using one of the tax codes (BTW 21%) and filter in Excel the debit amounts. No luck.
So, I need to know the report definition of the Tax Summary report to understand the relationship with the P&L to make correction journals to create my fiscal P&L that reconciles with my declared Tax revenues. Can anybody help me out? After 6 hours of puzzling I gave up.