Example output · Accountant & Bookkeeper AI
What the Monthly Reconciliation Report Writer actually produces
Takes bank balance, book balance, outstanding items, and adjustments, then drafts a full reconciliation: summary narrative, itemized outstanding items, adjustment notes with journal entries, and a plain-English client note.
- Client Name:
- Maple & Vine Café LLC
- Period:
- March 2025
- Bank Balance:
- $18,432.67
- Book Balance:
- $17,905.14
- Outstanding Items:
- Checks #1042 ($310.00) and #1047 ($225.53) not yet cleared; deposit made 3/29 ($412.00) not yet reflected on bank statement
- Adjustments:
- Bank service fee $35.00 not yet recorded in books; interest earned $8.00 added; corrected duplicate entry for supplier payment of $420.00
For the period ending March 31, 2025, the bank statement balance for Maple & Vine Café LLC was reported at $18,432.67, while the book (general ledger) balance stood at $17,905.14, resulting in an initial unreconciled variance of $527.53. After accounting for all identified outstanding items and adjustments, the adjusted bank balance is $18,309.14 and the adjusted book balance is $18,298.14. The reconciliation identifies three outstanding items on the bank side (two uncleared checks and one deposit in transit) and three adjustments required on the book side (a bank service fee, interest income, and correction of a duplicate supplier payment entry). Once these items are applied, the majority of the original variance is resolved; however, a residual unexplained difference of $11.00 remains between the adjusted bank balance and adjusted book balance. This remaining $11.00 discrepancy is not accounted for by any of the items currently identified and warrants further investigation—potentially an additional uncleared item, a data entry error, or a rounding discrepancy in a prior period. We recommend a review of transaction detail for late February and early March to identify the source before formally closing the period. Net Reconciled Balance (pending resolution of the $11.00 variance): approximately $18,298.14–$18,309.14.
OUTSTANDING CHECKS (Not Yet Cleared Bank)
- Check #1042 — Date Issued: March 2025 — Amount: $310.00
- Check #1047 — Date Issued: March 2025 — Amount: $225.53
Subtotal – Outstanding Checks: $535.53
DEPOSITS IN TRANSIT (Recorded in Books, Not Yet Reflected on Bank Statement)
- Deposit — Date: 3/29/2025 — Amount: $412.00
Subtotal – Deposits in Transit: $412.00
BANK-RECORDED ITEMS NOT YET IN BOOKS
- Bank Service Fee — Amount: $35.00 (reduces book balance)
- Interest Earned — Amount: $8.00 (increases book balance)
Subtotal – Net Bank-Recorded Adjustment: -$27.00 (net reduction to book balance)
UNRESOLVED VARIANCE
- Unexplained Difference — Amount: $11.00 — Status: Under Investigation (see Reconciliation Summary)
TOTAL OUTSTANDING/ADJUSTING ITEMS IMPACTING RECONCILIATION: $535.53 (checks) + $412.00 (deposit) + $35.00 (fee) + $8.00 (interest) + $420.00 (duplicate correction) = Net effect resolves balance to within $11.00 of full reconciliation.
- BANK SERVICE FEE
Description: The bank assessed a monthly service charge of $35.00 that has not yet been recorded in the company's books. Reason for Adjustment: Bank fees are recognized as an operating expense and must be recorded to bring book balance in line with actual cash activity. Journal Entry: Debit: Bank Service Charges (Expense) — $35.00 Credit: Cash – Operating Account — $35.00
- INTEREST EARNED
Description: The bank account earned $8.00 in interest income during March, credited by the bank but not yet recorded in the books. Reason for Adjustment: Interest income increases cash and must be recognized as revenue in the period earned. Journal Entry: Debit: Cash – Operating Account — $8.00 Credit: Interest Income — $8.00
- CORRECTION OF DUPLICATE SUPPLIER PAYMENT
Description: A supplier payment of $420.00 was inadvertently recorded twice in the accounting records, overstating expenses (or accounts payable reductions) and understating the true cash/book balance by $420.00. Reason for Adjustment: The duplicate entry must be reversed to accurately reflect the single, actual payment made to the supplier. Journal Entry: Debit: Cash – Operating Account — $420.00 Credit: Accounts Payable / Supplier Expense (as originally recorded) — $420.00
Note: All adjustments above have been reflected in the Adjusted Book Balance calculation of $18,298.14. Client approval is requested before these entries are formally posted to the general ledger.
Hi team, we've completed the March 2025 bank reconciliation for Maple & Vine Café LLC. The good news is that most of the difference between your bank and book balances is explained by two outstanding checks (#1042 and #1047), a deposit still in transit, a small bank fee, interest earned, and a duplicate supplier payment we corrected in your books. After these adjustments, a small $11.00 difference remains unexplained, and we'll be digging into transaction detail to track down the source—no action needed from you on that yet. Please review and approve the three journal entries noted in the Adjustment Notes section (bank fee, interest income, and the duplicate payment correction) so we can post them to your books. Let us know if you have any questions or recall any transactions around late March that might explain the remaining discrepancy.
Swap in your client's real name, period, balances, and the specific outstanding checks/deposits/adjustments from your working papers; also revise the client note's tone to match how formal or casual you are with that client.
Human review: Verify every dollar figure, journal entry, and the unresolved variance against your actual bank statement and ledger before sending—this is a drafting aid, not a substitute for completing and checking the reconciliation yourself.
Generate this for your own situation — free.
5 runs a day, no credit card.
Try the Monthly Reconciliation Report Writer