YN

Bank Reconciliation

Yenuit · Accounts Module
v20.5
1
Upload
2
Verify
3
Reconcile
4
Review
5
Export

Source documents

Step 1 of 4
QB raw exports often have running-balance issues. Override with the actual closing balance shown on your QB report. Opening Balance Difference carries forward the unreconciled gap from prior month — usually 0, or the small variance from your prior rec.
How the AI reconciliation works
Debit / Credit convention: all sections and column labels use the company's books perspective — funds received = Debit (In), funds paid out = Credit (Out). (This is the inverse of how the bank statement labels the same line: a bank-statement “debit” is funds leaving your account, which is a credit on your books.)
The engine performs 6 passes in priority order:
  1. Carry-forward clearing: Items unreconciled from prior month are checked against this month's transactions and auto-cleared if found.
  2. Exact match: Same amount, same/close date, same direction (in↔in or out↔out) and entity name overlap.
  3. Reversal pairing: ATM withdrawal reversals (funds-out immediately followed by same-amount funds-in) are detected and netted.
  4. Split match (1:N): One QB entry matches multiple bank lines — e.g. a 200K cash withdrawal QB entry against 4 × 50K ATM bank lines.
  5. Aggregate match (N:1): Multiple QB entries sum to one bank line — e.g. multiple JE charges netting to one bank fee.
  6. Semantic matching (strict amount): Considers vendor / employee name, type and date proximity — but only pairs entries when the amounts also agree (within ≤ 1 MVR rounding). If the names look the same but the amounts differ, the entries are deliberately left unmatched so the excess or short flows into the appropriate unreconciled section (A / B / C / D) where it stays visible until investigated.
— Use when the bank has no transactions for the period. Type the balances OR upload last month's rec to pre-fill them and carry forward any uncleared items.

Reconcile by balances only

For dormant accounts or months with no transactions. Enter the closing balances (or upload last month's rec to pre-fill them automatically). Any uncleared items from the prior rec carry forward — only the period changes.