1¢ Discrepancy & GL Auditor
1¢ Discrepancy & GL Reconciliation Auditor Variance Hunter
Pinpoint transpositions ($45 vs $54), timing delays, and 1-cent rounding variances between Bank Feeds and Client GL with auto-balancing adjusting entries.
i How to Reconcile Discrepancies in 3 Simple Steps
Ingest Side-by-Side Feeds
Compare Bank Statement Cleared Feed against Client's General Ledger (GL) cash account for the month-end period.
Spot Transpositions & Timing
The algorithm isolates inverted keying errors (e.g. difference of 9, like $45 entered vs $54 cleared) and uncleared timing checks.
Post Balancing Entry
Review the auto-generated Adjusting Journal Entry (AJE) and post it with one click to balance the books to $0.00.
Bank Feed Cleared Items
| Date | Description & Ref | Amount | Status |
|---|---|---|---|
| 2026-09-05 |
Client Wire - Horizon Tech
WIRE-991
|
$5,400.00 | Matched |
| 2026-09-09 |
Gusto Payroll Taxes & Net Pay
ACH-411
|
$-3,200.50 | Matched |
| 2026-09-14 |
WeWork Commercial Lease
DEB-812
|
$-2,100.00 | Matched |
| 2026-09-18 |
Office Depot Store #482 Supplies
POS-912
Transposition Flag: Bank cleared $54.00, GL recorded $45.00. Divisible by 9!
|
$-54.00 | Transposition |
| 2026-09-22 |
Stripe Merchant Daily Deposit
STRIPE-1
|
$1,890.20 | Matched |
| 2026-09-26 |
Amazon Web Services Monthly
AWS-SUB
|
$-420.15 | Matched |
| 2026-09-30 |
Operating Account Interest Credit
INT-CR
|
$14.25 | Matched |
Client General Ledger (GL Cash #1000)
| Date | Description & Ref | Amount | Status |
|---|---|---|---|
| 2026-09-05 |
AR Payout Horizon Tech Invoice #201
GL-01
|
$5,400.00 | Matched |
| 2026-09-09 |
Payroll Entry Gusto PP-18
GL-02
|
$-3,200.50 | Matched |
| 2026-09-14 |
Rent Expense Sept 2026
GL-03
|
$-2,100.00 | Matched |
| 2026-09-18 |
Office Depot Paper Cartridges
GL-04
Bookkeeper keying error ($45 vs $54 actual cleared debit). Needs $9.00 adjustment.
|
$-45.00 | Transposition |
| 2026-09-22 |
Stripe Web Invoices Batch #41
GL-05
|
$1,890.20 | Matched |
| 2026-09-26 |
AWS Cloud Infrastructure Sept
GL-06
|
$-420.15 | Matched |
| 2026-09-29 |
City Water & Sewer Utility Check #1049
CHK-1049
Outstanding Check: Written on Sept 29, not yet presented at bank. Timing lag.
|
$-36.00 | Timing Lag |
| 2026-09-30 |
September Bank Interest Earned
GL-07
|
$14.25 | Matched |
Algorithmic Balancing Journal Entry (AJE-0930)
Adjusting Entry for Month-End Reconciliation: 1) Correction of transposition error on Office Depot receipt ($45 GL vs $54 Bank cleared, $9.00 variance), 2) Timing lag adjustment for outstanding check #1049 ($36.00). Total Net Discrepancy: $45.00.
| General Ledger Account | Debit (DR) | Credit (CR) | Line Audit Explanation |
|---|---|---|---|
| 6100 - Office Supplies Expense | $9.00 | - | Correct transposition typo ($45 entered vs $54 actual) |
| 1000 - Operating Cash (Bank) | $36.00 | - | Reverse uncleared timing check #1049 |
| 1010 - Cash Clearing / Reconciliation Suspense | - | $45.00 | Balance month-end variance to zero |