Bank reconciliation

Bank reconciliation that runs itself, month after month

fiscal50 reconciles your bank, credit card and loan accounts for you. Auto-reconciliation predicts each period’s ending balance from your books and the bank feed and checks it against the bank: the balance verdict. When they agree, fiscal50’s AI agents clear the matching transactions, reconcile the period and move straight on to the next one, month after month, until every account is up to date or something needs you, such as an ending balance that doesn’t agree or a transaction that isn’t recorded yet. They stop on that period and tell you exactly why. You can also reconcile any period yourself: enter the statement balance, review what cleared, and complete it when the Difference is 0.

Reconciliations by month: each bank and credit card account in a row, with a status for every month of the fiscal year (reconciled, changed after reconciliation, started, not reconciled, in progress) and a Done count.

See it work

Auto-reconciliation, month after month

fiscal50 predicts each period’s ending balance and checks it against the bank. When they agree, the AI agents reconcile it and move on to the next period, for every account, until everything is current or something needs you. Then they stop and show you why.

Bank reconciliation

What bank reconciliation in fiscal50 does for you

Reconciliation proves that what fiscal50 says you have matches what your bank, card issuer or lender says you have, one period at a time.

Auto-reconciliation

AI agents reconcile each account period by period without you starting every month, and keep going until every account is current or one needs your attention.

Balance verdict first

Before a period is reconciled, fiscal50 predicts its ending balance from your books and checks it against the bank, so nothing is marked reconciled unless the numbers agree.

Stops with a reason

When it can’t go on, such as a charge that isn’t recorded or a balance that differs, it stops on that period and shows why. Fix it and auto-reconciliation picks up from there.

Automatic clearing

When reconciliation starts, fiscal50 runs an algorithm on each transaction and clears the ones that are correctly recorded and matched on amount, date and account. You only review the exceptions: Pending items to record and Uncleared items to investigate.

Bank, credit card and liability accounts

Bank accounts reconcile by calendar month, credit cards by statement period generated from the card's closing day, and loans or lines of credit by the lender's period. Loans connected through Plaid appear on the Banks tab automatically; others are added with Add Liability Account.

Clear status on every transaction

Each transaction in the period is marked Cleared, Uncleared or Pending, so you can see what is matched, what hasn't reached the bank yet, and what still needs recording.

Locked chain of balances

Periods reconcile in sequence, and each opening balance is locked by the previous completed period. Completing a period marks it Reconciled, unlocks the next one and carries the ending balance forward.

Details and Summary reports

Completed periods get a Details Report (beginning, clearing, uncleared and ending balances plus every cleared and uncleared deposit and withdrawal) and a Summary. Both export to Excel.

How it works

Reconcile a period yourself

  1. Open Reconciliation

    Go to the Banks tab, click the three-dot menu next to the bank, credit card or liability account and select Reconciliation. A summary screen lists each period with its status.

  2. Enter the ending balance

    Select the month or statement period, type the ending balance from the statement, and click Start Reconciliation (Resume Reconciliation on later visits). Changes save automatically.

  3. Work the exceptions

    fiscal50 auto-clears matched transactions. Record Pending items from the Deposits or Withdrawals screen, and tick Select for clearing for Uncleared items that are on the statement.

  4. Complete the period

    When the Difference is 0, Complete Reconciliation becomes active. Click it to mark the period Reconciled and unlock the next one.

  5. Open the reports

    On the summary screen, click the icon under Details Report or Summary for a completed period, and use the Excel button at the top right to export it.

In your books

Reconciliation posts nothing by itself. Clearing only marks transactions as matched; a Pending item posts when you record it from Deposits or Withdrawals.

For bookkeepers

How does a bookkeeper reconcile every client’s accounts?

Reconciliation runs inside each client’s own fiscal50 books, where the transactions were categorized and posted, and the Bookkeeper Workspace shows where every client stands.

Recommendations come first

Banks to Books recommends how to book each bank and card transaction with a reason, a confidence percentage and the evidence. Once you post, the entries are already in the ledger the reconciliation checks.

You review the exceptions

Auto-clearing marks transactions that match on amount, date and account. Anything that does not match stays Uncleared, and pending items are recorded through Deposits or Withdrawals, until the Difference is 0.

Ledger-native, not an add-on

Categorization, posting and reconciliation happen in the same books, so there is no separate app to sync before the bank balance can be checked.

Every client on one grid

The Workspace reconciliation view shows each client’s banks and cards month by month and flags anything posted or deleted after a reconciliation.

See the Bookkeeper Workspace · Month-end close checklist

FAQ

Bank reconciliation: common questions

More Banks to Books questions →

What does auto-reconciliation do?

For each account, fiscal50 predicts the period’s ending balance from your books and checks it against the bank. When they agree, its AI agents clear the matching transactions, reconcile the period and move on to the next, month after month, until the account is up to date or something needs you.

Why did auto-reconciliation stop?

It stops on the first period where the books and the bank don’t agree yet, for example an ending balance that differs or a bank transaction that isn’t recorded in fiscal50. It shows the period and the reason; fix it and it carries on from there.

How do I reconcile my bank account?

Banks tab › the bank's three-dot menu › Reconciliation. Pick the month, enter the ending balance from the bank statement, click Start Reconciliation, record Pending items and tick Uncleared ones on the statement until the Difference is 0, then click Complete Reconciliation.

What is automatic transaction clearing?

When reconciliation starts, fiscal50 runs an algorithm on each transaction and clears the ones that are correctly recorded and matched, so you only review exceptions: Pending items to record and Uncleared items to investigate.

Why wasn't a transaction cleared automatically?

Auto-clearing needs amount, date and account to match. A different date, a rounding difference or a wrong account keeps it Uncleared. Fix the recording, or tick Select for clearing if it is on the statement.

Do I have to reconcile months in order?

Yes. You must complete the previous month before moving to the next, because each month's opening balance is locked by the month before it. The first month of a financial year needs the previous year's reconciliation completed.

How do I reconcile a credit card?

Banks tab › the credit card's three-dot menu › Reconciliation. The first time, select the card's closing day so fiscal50 can generate the statement periods. Then select the statement period, enter the statement ending balance, Start Reconciliation, clear or record until the Difference is 0, and Complete Reconciliation.

Does reconciliation post anything to the books?

No. Clearing only marks transactions as matched. Recording Pending items posts them through Deposits or Withdrawals, and completing a period locks its ending balance.

Can a bookkeeper see reconciliation status for every client?

Yes. In the fiscal50 Bookkeeper Workspace, the reconciliation view shows a month-by-month grid for each client’s banks and cards and flags anything posted or deleted after a reconciliation. Open the client’s books with Log in to finish a period.

Make this the last month you do bookkeeping by hand.

Start free. Connect a bank. Watch the agents go to work.