Skip to content

Account reconciliation

Know what ties before month-end.

Rebase continuously compares your ledger with the systems, subledgers and records behind it, matches what belongs together and surfaces anything that does not reconcile.

Every match, difference and conclusion stays linked to the underlying evidence.

See a reconciliationTalk to us
An illustration of Rebase's reconciliations for the March 2026 close on 31 March, before the close opens: 42 accounts, 40 of them tied. 1010 Operating account ties to the bank at 2,184,920.00, and receivables, cards and payroll tie too. 2000 Accounts payable is 7,200.00 short of its subledger, isolated to invoice INV-88213, and 2100 Accrued expenses is 11,400.00 short of its support, with an entry proposed.

The work behind the balance

Comparing two balances is the easy part.

The work starts when transactions come from different systems, settle on different dates, carry different descriptions or do not appear on both sides at all.

An illustration of the same reconciliation done two ways: by hand, nine steps across the ledger, the bank's export, the card provider and a workbook, repeated for every account; and by Rebase, which reconciles the operating account's 2,480 March bank lines, investigates three items and leaves nothing unexplained.

Worked example

From source records to a reconciled account.

Operating cash for March: every bank line read, matched or explained, and the balances proven equal before the close opens.

An illustration of the March 2026 reconciliation of 1010 Operating account in six stages. Rebase reads 2,480 bank lines from Plaid and 2,491 ledger lines from Business Central, normalizes them, matches 2,478 bank lines, and investigates the three items left: AWS's 12,480.00 and a 45.00 bank fee, both missing postings, entered as JE-4471 and JE-4474, and a 12,400.00 receipt in transit. The statement's 2,172,520.00 plus the deposit in transit is 2,184,920.00, the ledger's balance, so the difference is 0.00, and Dana Ruiz, Controller, signs the reconciliation off.

Common reconciliations

The accounts accounting teams tie every month.

Six kinds of reconciliation, each the ledger against what proves it. Open one to see what Rebase does and what it leaves behind.

  • Cash and bankDoes cash in the ledger agree with the bank?1010 · 2,480 of 2,480 bank lines matched · 0.00 unexplained
    What Rebase does

    Matches bank activity against ledger entries, separates timing from real differences, and investigates every line left unmatched.

    Typically reads Plaid, Business Central, and Bank statements.

    1010 · 2,172,520.00 at the bank + 12,400.00 in transit = 2,184,920.00 in the ledger

  • Accounts payableDoes the vendor subledger agree with the control account?2000 · −7,200.00, traced to one invoice
    What Rebase does

    Compares the subledger's open items with the control account's postings, document by document, and isolates what is on one side only.

    Typically reads Business Central and Vendor ledger entries.

    INV-88213 · Brightwater Freight · 7,200.00 — in the subledger, posted to 2100

  • Accounts receivableDo customer balances agree with the ledger?1200 · 1,642,300.00 in both · 0.00 difference
    What Rebase does

    Ties the customer subledger to the control account, matches receipts to invoices, and flags cash applied to the wrong customer or not applied at all.

    Typically reads Business Central and Plaid.

    1200 · 1,642,300.00 in the subledger and the ledger · no unapplied receipts

  • Corporate cardsDid card activity reach the ledger correctly?2050 · Ramp 84,316.42 · ties
    What Rebase does

    Matches card transactions and statements to their postings, and catches duplicates, missing receipts and charges coded to the wrong account.

    Typically reads Ramp and Business Central.

    Duplicate 2,140.00 charge on 6 Mar, refunded 9 Mar · 2050 ties at 84,316.42

  • PayrollDo payroll expense and liabilities tie back to payroll?2200 · 148,900.00 · ties
    What Rebase does

    Ties the payroll register's gross pay, taxes and deductions to the journals and the liability accounts, and the net pay to the bank.

    Typically reads Payroll register, Plaid, and Business Central.

    Payroll clearing: a 27 Mar timing item that clears 2 Apr · 2200 ties at 148,900.00

  • Other balance sheet accountsDoes every balance have evidence behind it?1500 · 318,750.00 · ties to four schedules
    What Rebase does

    Ties prepaid, fixed asset, inventory and clearing accounts to the schedule, register or source behind them, and names the owner when support is missing.

    Typically reads Schedules and registers and Business Central.

    1500 · 180,000.00 + 90,000.00 + 26,250.00 + 22,500.00 = 318,750.00

Reconciled does not mean “the AI said so.”

Every reconciled account carries what it was reconciled against, the rules it was matched by, what was found and who signed it off.

An illustration of the reconciliation record for 1010 Operating account, March 2026: its sources, Business Central, Plaid and the March statement; its matching rules; three exceptions, two entries posted and one deposit in transit; its sign-off by Dana Ruiz, Controller; fourteen recorded actions; and the result, 2,172,520.00 plus 12,400.00 in transit, 2,184,920.00, a difference of 0.00.

If Rebase cannot establish that an account ties, it does not mark it reconciled.

Where a difference goes next.

An account that does not tie is the start of the work, not the end of it. March's payables difference, from the reconciliation to an account that ties.

An illustration of the March payables difference through the close: 7,200.00 detected in 2000 Accounts payable on 31 March, traced to invoice INV-88213 posted to 2100, reclassed by RB-3F2A1C, approved by Dana Ruiz, posted to Business Central on 2 April, and 2000 tied at 911,360.00.

  1. Reconcile

    Difference detected

    2000 · −7,200.00 · 31 Mar

    Current page

  2. Investigate

    Cause established

    INV-88213 posted to 2100

    Resolve close exceptions

  3. Adjust

    Accounting treatment prepared

    RB-3F2A1C · Dr 2100 / Cr 2000

    Prepare accruals

  4. Review

    Human approval

    Approved · Dana Ruiz

  5. Post

    ERP updated

    Business Central · 2 Apr

  6. Verify

    Account reconciled

    2000 ties at 911,360.00

    Current page
The productRebase Autonomous CloseReconcile accounts, investigate exceptions, prepare adjustments and move the close forward across the finance stack you already use.Explore Autonomous Close

Bring us one reconciliation from last month.

We'll show you what Rebase could have matched automatically, what it would have investigated and what your accountant would have been left to review.

Book a working session