Se rendre au contenu
Menu
Cette question a été signalée
1 Répondre
984 Vues

Our accountant performed a bank reconciliation for old records with a large gap (only two reconciliations were done from 2022 until mid-2023). This has caused the bank balance on the dashboard to appear incorrectly.

My question is: how can we modify these entries to apply to other payments (while maintaining the same sequence) for proper reconciliation?


Avatar
Ignorer
Meilleure réponse

Steps to Fix the Reconciliations (Properly Reassign)

  1. Enable Developer Mode
    → Go to Settings > Activate Developer Mode.
  2. Review the Incorrect Bank Statement Lines
    • Go to Accounting > Bank > Bank Statements.
    • Filter by the reconciliations made during that large gap.
    • Identify which statement lines are reconciled with the wrong journal items.
  3. Unreconcile Incorrect Statement Lines
    • Open the statement line.
    • Click the “Unreconcile” button.
    • This does not delete the journal entry, it just removes the link.
  4. Match Each Statement Line to the Right Payment
    • After unreconciling, go back to the statement line.
    • Use the "Match Existing Entries" button.
    • Search and select the correct payment (use filters like partner, date, amount).
    • Match it to the appropriate journal item.
    • Save the reconciliation.
  5. Repeat for All Mismatched Entries
    • Reconcile each line chronologically.
    • This ensures the sequence and balance buildup match the real bank flow.
  6. Check the Bank Journal Dashboard
    • Once reconciliations are corrected, the dashboard should show:
      • Bank Balance = actual journal balance.
      • Latest Statement Balance = final closing from the last reconciliation.
    • Any difference should be explainable by outstanding/unreconciled items only.

Avatar
Ignorer
Publications associées Réponses Vues Activité
3
sept. 25
287
1
août 25
223
1
août 25
303
0
août 25
179
1
août 25
226