Drag all three source files into the drop zones to walk through a complete bank reconciliation — from raw bank statement and GL detail to a balanced, exception-flagged reconciliation report.
1
Drop Files
2
Preview Data
3
Map Columns
4
Reconciling
5
Report
💳
Bank Statement
Metro Ford — Operating Account
Click to select MetroFord_BankStmt_Nov2024.pdf
✓ MetroFord_BankStmt_Nov2024.pdf loaded
📊
Cash GL Detail
Capital Subaru — Account 1010 Export
Click to select GL_Cash_1010_Nov2024.xlsx
✓ GL_Cash_1010_Nov2024.xlsx loaded
📋
Batch Entry Schedule
Daily Deposit Batch Log
Click to select BatchDeposit_Nov2024.xlsx
✓ BatchDeposit_Nov2024.xlsx loaded
No real files needed — click any zone to simulate the upload. All three must be loaded before proceeding.
Select File
Select a file to load into the demo
Bank Statement — Metro Ford Operating Account · Nov 2024 · Ending Balance $284,190.42
Date
Ref #
Description
Debit
Credit
Balance
Status
11/01
—
Opening Balance
$241,880.00
11/01
DEP-1128
Deposit — Deal batch 11/01
$18,400.00
$260,280.00
Cleared
11/04
CHK-4388
Check — ABC Parts Supply
$1,900.00
$258,380.00
Cleared
11/06
DEP-1131
Deposit — Service receipts 11/06
$9,720.00
$268,100.00
Cleared
11/08
CHK-4391
Check — Tri-County Electric
$2,840.00
$265,260.00
Cleared
11/10
DEP-1134
Deposit — Deal batch 11/10
$31,500.00
$296,760.00
Cleared
11/12
CHK-4395
Check — Metro Insurance Agency
$4,200.00
$292,560.00
Cleared
11/14
ACH-8812
ACH — Ford Motor Credit floor pymt
$22,400.00
$270,160.00
Cleared
11/15
DEP-1137
Deposit — Service & parts 11/15
$7,880.00
$278,040.00
Cleared
11/18
CHK-4399
Check — Lakewood Advertising Group
$6,100.00
$271,940.00
Cleared
11/20
DEP-1139
Deposit — Deal batch 11/20
$24,600.00
$296,540.00
Cleared
11/22
CHK-4403
Check — Office Max
$890.00
$295,650.00
Cleared
11/24
NSF-0041
NSF — Returned check, customer deposit
$380.00
$295,270.00
Not in GL
11/25
DEP-1141
Deposit — Service & parts 11/25
$11,200.00
$306,470.00
Cleared
11/26
CHK-4407
Check — Valley Office Supplies
$1,440.00
$305,030.00
Cleared
11/28
FEE-1124
Monthly service charge
$45.00
$304,985.00
Not in GL
11/29
INT-1124
Interest earned — Nov 2024
$475.00
$305,460.00
Not in GL
11/29
CHK-4410
Check — Lakewood Auto Detail
$2,670.00
$302,790.00
Cleared
—
CHK-4401
Check — Route 9 Parts & Supply (outstanding)
—
—
Outstanding
—
CHK-4418
Check — Valley Advertising (outstanding)
—
—
Outstanding
—
CHK-4421
Check — Valley Utilities (outstanding)
—
—
Outstanding
—
CHK-4422
Check — Pinnacle Office Solutions (outstanding)
—
—
Outstanding
11/29
DEP-1142
Deposit — Deal batch 11/29 (in transit)
—
—
In Transit
11/30
DEP-1143
Deposit — Service & parts 11/30 (in transit)
—
—
In Transit
11/30
—
Ending Balance
$284,190.42
Cash GL — Account 1010 · Nov 2024 · Book Balance $269,420.42
Date
Ref #
Description
Debit
Credit
11/01
DEP-1128
Deal batch deposit
$18,400.00
11/04
CHK-4388
ABC Parts Supply
$1,980.00
11/06
DEP-1131
Service receipts
$9,720.00
11/08
CHK-4391
Tri-County Electric
$2,840.00
11/10
DEP-1134
Deal batch deposit
$31,500.00
11/12
CHK-4395
Metro Insurance Agency
$4,200.00
11/14
ACH-8812
Ford Motor Credit — floor payment
$22,400.00
11/15
DEP-1137
Service & parts deposit
$7,880.00
11/18
CHK-4399
Lakewood Advertising Group
$6,100.00
11/20
DEP-1139
Deal batch deposit
$24,600.00
11/22
CHK-4403
Office Max
$890.00
11/23
CHK-4401
Route 9 Parts & Supply
$8,400.00
11/25
DEP-1141
Service & parts deposit
$11,200.00
11/26
CHK-4407
Valley Office Supplies
$1,440.00
11/27
CHK-4418
Valley Advertising
$12,750.00
11/28
CHK-4421
Valley Utilities
$6,200.00
11/29
DEP-1142
Deal batch — in transit
$9,200.00
11/29
CHK-4410
Lakewood Auto Detail
$2,670.00
11/30
CHK-4422
Pinnacle Office Solutions
$2,250.00
11/30
DEP-1143
Service & parts — in transit
$5,600.00
11/30
Book Balance
$269,420.42
Batch Entry Schedule — Daily Deposit Log · Nov 2024
Synthetic Auto Group — Operating Account Bank: Metro Ford Account #...4892 GL Account: 1010 — Cash — Operating Statement Period: November 2024 Generated: Nov 30, 2024 · 11:59 PM
18
Matched Items
4
Outstanding Checks
2
Deposits in Transit
4
GL Adjustments
$0.00
Difference
Adjusted Bank Balance
$269,390.42
=
Adjusted GL Balance
$269,390.42
✓ Reconciliation Balanced
Bank Side — Metro Ford
Ending balance per bank statement$284,190.42
Add: Deposits in transit+$14,800.00
DEP-1142 — Deal batch 11/29$9,200.00
DEP-1143 — Service & parts 11/30$5,600.00
Less: Outstanding checks-$29,600.00
CHK-4401 — Route 9 Parts & Supply$8,400.00
CHK-4418 — Valley Advertising$12,750.00
CHK-4421 — Valley Utilities$6,200.00
CHK-4422 — Pinnacle Office Solutions$2,250.00
Adjusted Bank Balance$269,390.42
GL Side — Account 1010
Book balance per GL (Acct 1010)$269,420.42
Less: NSF charge not yet recorded-$380.00
NSF-0041 — Returned customer check$380.00
Less: Bank service fee not recorded-$45.00
FEE-1124 — Monthly service charge$45.00
Add: Interest income not recorded+$475.00
INT-1124 — Interest earned Nov 2024$475.00
Less: Recording error — CHK-4388-$80.00
GL recorded $1,980.00; cleared $1,900.00$80.00
Adjusted GL Balance$269,390.42
Outstanding Checks — In GL, Not Yet Cleared Bank
Check #
Date Issued
Payee
GL Amount
Days Outstanding
Status
CHK-4401
11/23/24
Route 9 Parts & Supply
$8,400.00
7 days
Outstanding
CHK-4418
11/27/24
Valley Advertising
$12,750.00
3 days
Outstanding
CHK-4421
11/28/24
Valley Utilities
$6,200.00
2 days
Outstanding
CHK-4422
11/30/24
Pinnacle Office Solutions
$2,250.00
0 days
Outstanding
Deposits in Transit — In GL, Not Yet on Bank Statement
Batch #
Date
Source
Items
Amount
Status
DEP-1142
11/29/24
New Vehicle Deals — 3 contracts
3
$9,200.00
In Transit
DEP-1143
11/30/24
Service & Parts — end of month
14
$5,600.00
In Transit
GL Adjustments Required — Post Before Closing
NSF charge — Returned customer check (NSF-0041)
$380.00
Bank deducted $380.00 on 11/24 for a returned customer check. No corresponding entry exists in GL Account 1010. Post debit to 1010 Cash / credit to 1200 Accounts Receivable (or applicable customer AR account). Obtain copy of returned item from your bank and follow up with customer.
Bank service charge — FEE-1124
$45.00
Monthly service fee of $45.00 deducted by bank on 11/28. Not recorded in GL. Post debit to 6010 Bank Charges Expense / credit to 1010 Cash.
Interest income — INT-1124
$475.00
Bank credited $475.00 interest on 11/29. Not yet recorded in GL. Post debit to 1010 Cash / credit to 4900 Interest Income. Confirm with CFO whether interest should be allocated by department.
Recording error — CHK-4388 (ABC Parts Supply)
$80.00
Check cleared bank on 11/04 for $1,900.00 but was recorded in GL as $1,980.00 — an $80.00 overstatement. Post correcting entry: debit 1010 Cash $80.00 / credit the applicable expense account. Verify original invoice amount and correct the GL posting.
Live app exports as Excel or PDF — includes signed-off reconciliation worksheet