Live Product Demo

See ReconTraq in action

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.

This sample-data preview illustrates a workflow, not support for your files. Explore accounting consulting or discuss your bank reconciliation process →

Drop Files

Preview Data

Map Columns

Reconciling

Report

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

Batch #	Date	Source	Items	Batch Total	GL Posted
DEP-1128	11/01	New Vehicle Deals	4	$18,400.00	Posted
DEP-1131	11/06	Service Department	18	$9,720.00	Posted
DEP-1134	11/10	New Vehicle Deals	6	$31,500.00	Posted
DEP-1137	11/15	Parts & Service	24	$7,880.00	Posted
DEP-1139	11/20	New Vehicle Deals	5	$24,600.00	Posted
DEP-1141	11/25	Parts & Service	21	$11,200.00	Posted
DEP-1142	11/29	New Vehicle Deals	3	$9,200.00	In Transit
DEP-1143	11/30	Parts & Service	14	$5,600.00	In Transit

✓ 8 deposit batches parsed · 6 cleared · 2 in transit ($14,800.00)

✓ ReconTraq auto-mapped 12 of 12 fields across all three sources with high confidence

Bank Statement — Field Mapping

Date Field

Reference #

Debit Amount

Credit Amount

Cash GL — Account 1010

Date Field

Reference #

Debit Amount

Credit Amount

Batch Entry Schedule

Batch Ref #

Batch Date

Batch Total

GL Posted Flag

Reconciliation Preview — Items Requiring Attention

Outstanding Checks

$29,600.00 total

Deposits in Transit

$14,800.00 total

GL Adjustments Needed

NSF, fee, interest, error

Matching bank transactions to GL entries...

BookTraq · ReconTraq

Bank Reconciliation Report

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

Matched Items

Outstanding Checks

Deposits in Transit

GL Adjustments

$0.00

Difference

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