Skip to content

Balance sheet reconciliations

Updated:

Support the ledger balance per balance sheet account, prepare it and certify it with four eyes.

Open General ledger in Fiatto
In this article

Under Accounting → General ledger → Review & reporting → Balance sheet reconciliations (/dashboard/grootboek/balansspecificaties) you support the ledger balance per balance sheet account and period. One colleague prepares the reconciliation, another certifies it. Approvers and accountants work here.

Steps

  1. Choose the period and click Generate reconciliations. Every balance sheet account with a balance or movement gets a reconciliation; accounts that must always get one (even at zero balance) are set under Required reconciliations.
  2. Open a reconciliation and support the balance with manual lines, a schedule or a link to payables, receivables, bank or GRNI. Copy from … takes over the support from the previous reconciliation. On an account that is matched, Copy from open items takes over the open items at period end, one line per item. The difference between ledger and support is shown; Propose correcting journal entry creates a correction.
  3. Click Prepare. A colleague then clicks Certify or Reject with a reason; whoever prepared it cannot certify it. For a material balance movement under the flux thresholds, certifying requires an explanation.
  4. Prepare all reconciling items at once with Prepare reconciling specs; certify clean reconciliations in bulk with Certify clean reconciliations. A reconciliation with open items older than 90 days at period end does not count as clean; the overview shows such an account with a link to those items.
  5. Export the overview as CSV or PDF, or download the period's control file as PDF. You share the same file with your accountant via a personal link.

Tips

  • Per account you set a risk class and frequency. The Close schedule shows per risk class by which working day after period end certification is due. The account's assigned owner gets a reminder on the working day before that deadline, on the day itself and once it has passed: the preparer until the reconciliation is prepared, then the certifier.
  • On the ledger hub, My work shows the reconciliations waiting for you.
  • With Reconciliations required to close, month-end close refuses a period as long as a reconciliation of that period is open, prepared or rejected.
  • If the balance changes after certification, the reconciliation flags it. See also Roll-forward and reconciliations.
  • Through Close performance → at the top of the overview (/dashboard/grootboek/balansspecificaties/prestatie) you see, over the last six past periods, how many reconciliations were certified on time against the close plan deadline: per period, By risk class and By fixed preparer, with On time, Late, Open, overdue and Open, within deadline.
  • On the detail page of a reconciliation, the block Changes since the reconciliation of (date) shows which lines are new, which are gone and which got a different amount compared with the previous reconciliation, with the difference in total. That way the certifier also sees at a glance what changed.
Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.