Browse roboledger docs

Reconcile your accounts

Tie the ledger each month to your QuickBooks books, your schedules or a statement, sign the result off, and have the close wait until it ties.

A reconciliation checks the ledger against something outside it at a month end and shows where the two disagree. RoboLedger keeps each one as a record: what was compared, when, what it found, and who signed it off. The close can wait until it ties.

What a reconciliation compares

  • Against the synced books. Every account in the ledger against QuickBooks' own trial balance at the month end, in one check for the whole ledger. Balance-sheet accounts are compared to the month end, income-statement accounts from the start of the fiscal year. A difference here is often activity that hasn't synced yet, so sync before you dig.
  • Against its schedules. Each account a schedule carries a balance on, such as a prepaid, accumulated depreciation or the asset's cost, against what its schedules say it should hold. The ledger side includes the month's drafts and any schedule entries not yet drafted, so it shows the balance the close will leave. See Schedules for recurring entries.
  • Against its statement. A bank account, a card or a loan against the ending balance on its statement, once you record one.

Run them

Open Ledger → Closing Book → Reconciliations, pick the month, and choose Run reconciliations. That runs the check against the synced books (the group parent's), the check for each scheduled account, and the check for each account with a statement covering the month, and records the result of each. Open a row to see what was compared and which accounts differ.

Each row shows its status:

  • Not run: nothing has been compared for this month.
  • Does not tie: the two sides differ by more than the materiality.
  • Out of date: the books changed after it was compared. Run reconciliations again.
  • Reconciled: the two sides agree within the materiality.
  • Reviewed: reconciled and signed off.

Materiality is zero unless you set one, so the two sides have to agree to the cent. Open a row and set Counts as reconciled within, or ask your assistant, and a difference up to that amount still counts as tied. It applies from the next comparison.

Record a statement balance

Choose Record statement, pick the account, and enter the Statement ending date and the Ending balance as the statement shows it. An amount owed on a loan or a card is a positive number. Only balance-sheet accounts can be reconciled to a statement. In a reporting group, the balance is recorded for the company you have selected, against its own accounts.

Attach the statement itself as a PDF, or a photo of it as a PNG or JPEG, up to 25 MB. It is kept with the balance as the evidence for it, and a reconciliation that rests on a statement offers Download statement beside it. A stored statement isn't searchable, and it can't be deleted while a balance still rests on it.

A statement that ends mid-month is compared with the ledger at its own date. Recording the same account and date again replaces the earlier balance.

Statements that don't end at the month end

Not every statement ends on the last day of the month. A card's cycle might end on the 17th, and a savings account may only be statemented once a quarter. Open a statement reconciliation and set Statement issued to Monthly, Quarterly or Annual. A month is covered by the latest statement that ends within the cycle ending with that month. A monthly statement covers the month it ends in. A quarterly one also covers the two months before the next statement arrives. The close never waits for a statement that hasn't been issued yet.

Bank accounts on a bank feed

When a bank feed keeps an account, every line the feed brought in is the bank's own record, so it has already cleared. The lines that may not have cleared are the ones that didn't come from the feed, such as a payment you recorded against a bill or a journal entry. Those dated on or before the statement are listed under Not yet cleared by the bank and explain the gap between the statement and the ledger. One the bank has had a full statement cycle to clear is listed apart, under Older than this statement's cycle — not counted: it no longer explains anything, so the difference stays open until the line clears, or is voided or re-dated. Only a difference nothing explains keeps the reconciliation from tying. Lines dated before the feed started, such as an opening balance, count as cleared.

A statement that ends before the month end is carried forward to it by the feed's lines after the statement. That gives the bank balance at the month end, set beside the ledger's balance. The bank feed's own reported balance is shown next to it as a check. If the two disagree, a line may be missing or dated differently. It's a check only: the statement is what you reconcile and sign off.

Signing off pins the uncleared lines as well as the balances. If one of them changes, the sign-off lapses.

When the close waits on one

A reconciliation with Holds the close ticked must be Reconciled before its month can close, or Reviewed if it needs a review. One that hasn't been run for the month holds the close too. Untick the box to release it.

The first time you run reconciliations, the check against the synced books starts holding the close. A scheduled account's check holds it only if it ties on that first run; one that doesn't is reported without holding the close, so you can look into it first. A statement check holds the close only once you tick the box, which makes it a statement you owe every month.

Once you've run reconciliations and closed your first month, each QuickBooks sync runs the next month's again for the group parent's books, so the close never waits on a comparison nobody remembered to run. Before the first close, and for a subsidiary, run them yourself. A sync refreshes the checks you have and doesn't add new ones.

A month's comparison only goes out of date while the month is open. Once it closes, the comparison stands as the record the close was made on.

Sign off

On a reconciled row, choose Sign off. Only someone added to the graph itself as a member or admin can sign off. Access that comes only from an organization role isn't enough.

A sign-off is for the figures as they stood. If a balance at that month end changes, the sign-off lapses, and the reconciliation needs running and signing again. A run that finds the same balances keeps it.

Two settings, on the opened row or through your assistant, make the review part of the close:

  • Needs a sign-off to close. The close waits for a sign-off, not only for the two sides to tie.
  • Signed off by someone other than who ran it. The person who signs off must be someone other than the one who ran the comparison or recorded the statement balance. It needs at least two members of the graph who can make changes, and the first setting ticked.

If a reconciliation can't be cleared before the close, the close can still run without it: the app offers Close without reconciling when it's the only thing in the way, and the override is kept in the close's audit note. See Close the month with your AI assistant.

Try asking

  • "Run August's reconciliations and tell me what doesn't tie."
  • "Compare the ledger with QuickBooks at August 31 without recording anything."
  • "The checking account statement ends August 31 at 18,250.75. Record it and reconcile."
  • "I've uploaded September's checking statement. Read its ending balance and reconcile the account to it."
  • "Set a $25 materiality on the synced-books reconciliation."
  • "The savings account is only statemented quarterly. Set that on its reconciliation."
  • "What's not yet cleared by the bank on checking at September 30?"
  • "Which reconciliations are holding the September close, and why?"
  • "Require a separate reviewer on the bank reconciliations."

Go deeper

  • Period close: how reconciliations are recorded, what holds the close, and the operations behind them.