Open items and matching
Updated:
View the unmatched lines on a balance sheet account at a date, review them by age, match them and export them.
Open General ledger in FiattoIn this article
On a clearing, suspense or transit account you want to know which lines make up the balance. Open the account card of a balance sheet account (Recording → Account card, /dashboard/grootboek/rekeningkaart) and click Open items and matching below the card. You see the lines that have not yet been matched against others; together they make up the balance on the chosen date. Approvers and accountants work here.
Steps
- Choose the date under As of and click Show. Above the list you see the number of open items and the open balance, and the Age table with count and amount in 0–30 days, 31–90 days and More than 90 days. A line that has been open for more than 90 days gets a label with the number of days.
- Tick two or more lines that net to zero, optionally fill in a Note (optional) and click Match. If the selected lines do not net to zero, the button stays disabled and Fiatto says why. If the difference is small, Write off residual of … appears: choose an Offset account and Posting date and click Create draft. Nothing is posted yet: a draft journal entry is created that follows the normal approval. After posting, match the lines together with the new line.
- Under Suggested matches Fiatto proposes pairs: a debit and a credit line with the same amount and the same document number or description, or with an amount that occurs only once on each side. Check each pair and click Match next to it. Fiatto also suggests groups: one line against several lines with the same document number (Same document number, nets to zero), or against exactly one combination of two or three lines with the same total.
- Under Matches you see the account's earlier matches. Undo reverses one; the lines are open again afterwards.
- Download the list with Export CSV or Export XLSX, for the same date and the same book.
Tips
- In balance sheet reconciliations you take over the open items at period end as support with Copy from open items. This is possible once the account has been matched at least once.
- The balance sheet reconciliations overview shows open items older than 90 days at period end next to the account, and Certify clean reconciliations does not bulk-certify such a reconciliation.
- Matching posts nothing: it only links lines that are already in the ledger. Parked bank items are reclassified via bank reconciliation and suspense account.
- Up to which amount a residual may be written off this way is set by an approver under Residual write-off threshold at the bottom of the balance sheet reconciliations (Threshold (euro), default 10; 0 turns write-offs off).