Correct Reporte Amounts

When analyzing some reports, you may come across amounts that differ from expectations, especially in accounting reports.

One of the first validations to perform is to check whether the fiscal year has been closed.

Next, you must compare the report data with the actual system entries.

Your investigation should depend on the source of the discrepancy:

  • If the issue is with clients, check the client account statement
  • If it’s with suppliers, check the supplier account statement
  • If it’s with banks, check the bank reconciliation
  • And so on

🧪 Practical Example

Report: Account Summary
Line Item: Client Debts

  • Report for Dec/2021: €3,000
  • Client statement from 01/01/2021 to 31/12/2021: €2,750

🔎 Step 1 – Narrow down the discrepancy

Analyze the report month by month until you identify the exact period where the difference appears.

  • Report for Jan/2021: €5,000
  • Client statement from 01/01/2021 to 31/01/2021: €5,035

➡ The difference already exists in January, so the error lies before this period.

Let’s now review year 2020:

  • Report for Dec/2020: €1,500
  • Client statement from 01/01/2020 to 31/12/2020: €700

➡ The discrepancy persists. If there are no previous entries, the error is likely in the opening document (usually in journal X).

🛠️ Step 2 – Correct the opening document

  • Open the document via Accounting > Accounting Documents
  • In the Account Statement tab, click a line to view the totals
  • In the Details tab, validate whether account 2111 matches the expected total
  • If not, adjust:
    • Update the debit in account 2111
    • And the offsetting account (e.g., Retained Earnings for opening balances)

✅ Step 3 – Reopen and close the fiscal year

After saving:

  1. Reopen and reclose the fiscal year
  2. Re-run the report — the values should now be correct

⚠️ Recommendation: Perform regular reconciliations and checks to prevent the accumulation of accounting errors.