Skip to main content
2,200+ service businesses benchmarked. Do you know your gross profit per labor hour? See where you stand →
Level
← All finance systems

Open finance skill

Bank-to-ledger reconciliation

Which bank transactions do not match the ledger?

Compare two synthetic transaction lists, identify exact matches, and surface unresolved items for human review.

Inputs

  • Bank transactions
  • Ledger transactions
  • Date and amount tolerances

Outputs

  • Matched transactions
  • Unmatched bank items
  • Unmatched ledger items

Checks performed

  • Exact reference match
  • Amount and date tolerance match
  • Duplicate candidate warning

Guided synthetic example

See the check from input to decision

A customer payment appears in the bank, but the amount recorded in the ledger is different.

This is the operating model we use at Level. The percentages are estimated shares of the work in a typical review. Actual effort varies with data quality, complexity, and the issue found.

1

Start with the source records

About 15% of work
SourceReferenceDateAmount
BankDeposit B-104Jul 8$12,480
LedgerReceipt L-221Jul 8$12,840
2

Run the deterministic check

About 20% of work

Match reference, date, and amount. Flag any amount variance greater than $1.

3

Surface the flagged result

About 10% of work

Needs review

$360 mismatch between the bank deposit and ledger receipt.

4

Use recorded finance judgment to analyze possible reasons

About 25% of work

At Level, we record the review logic, known explanations, and questions our finance professionals use in this situation. AI applies that documented human judgment to organize the most plausible reasons, without pretending it knows which reason is true.

Possible reasons to investigate

The difference could be a posting error, processing fee, partial payment, or a transposed amount. The check cannot choose among them.

5

Make the final human judgment

About 20% of work

A Level finance professional validates the source evidence, challenges the AI-assisted analysis, and decides which explanation is supported.

Was a fee netted from the deposit?
Does the customer remittance support either amount?
Was another receipt combined into the bank deposit?
6

Make the operating decision

About 10% of work

Inspect the deposit support and customer remittance before closing the account.

Financial Systems Field Tests

What this synthetic example is designed to prove

These are repeatable Level Operating Rule tests using invented records only. They identify a control boundary and a refusal condition. They do not establish vendor behavior or replace review of your actual configuration.

FST-015 · LOR-004 · LOR-006 · LOR-042

Payroll journal and bank-feed duplicate trace

Test: Trace one pay run from register through journal, liabilities, cash settlement, bank match, and job-cost allocation.

Expected: A suspected duplicate is classified before any mapping change or deletion.

Refuse when: Missing pay-run evidence, Unclear source authority.

Use this system

Start with the example, then inspect the structure

  1. Download the invented input and expected output.
  2. Replace one field at a time with a safe test value.
  3. Compare the result with the expected structure.
  4. Have a finance professional review every exception before acting.

MCP preview

run_synthetic_example {"slug":"reconcile-account"}

Human review is part of the system

This check organizes evidence and surfaces exceptions. A person with finance domain expertise still needs to interpret the result, validate the source records, and discuss the operating decision.

Open source does not mean open client data. We publish reusable finance tools, checks, templates, and playbooks. Client records, workpapers, credentials, communications, and private configurations remain confidential.

Use it yourself, or bring us the messy part

Get a one-page evidence map for bank-to-ledger reconciliation

Tell us where the records stop making sense. We will reply with the first check to run, the records it needs, and the decision that still needs human finance judgment.

Install the free skills yourself

No commitment. We will reply with the first check, the records needed, and the decision a finance lead must make.