Bookkeeping & General Ledger
Double-entry journal, trial balance, income statement and balance sheet.
See what is insideEXCELCRAFT PRO TEMPLATE
Bank reconciliation
template for Excel.
Close the month knowing your cash is right. Match the bank statement to your books with a simple ID, and the reconciliation builds itself: deposits in transit, outstanding payments, bank-only items and a difference that should be zero.
Planned pricing: $8 a month or $60 a year. No payment is taken today.
ExcelCraft / Bank ReconciliationFictional sample
- Match by ID
- Reconciles to $0.00
- Statement self-check
INSIDE THE WORKBOOK
Every sheet
has one job.
Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.
- Reconciliation
- Adjusted bank and adjusted book balances side by side, the difference, reconciling items and a chart of what is left to clear.
- Bank Statement
- Every statement line with a match ID; status shows Matched, Bank only or Amount differs.
- Book Entries
- Your cash entries for the period, plus earlier items that had not cleared; status shows Cleared or Outstanding.
- Settings · Checks · Instructions
- Statement dates and balances, and checks that the statement adds up and the reconciliation balances.
WHY IT HELPS
Built around
the real task.
Match statement lines to your books and prove the difference is zero.
One ID connects both sides
Give a statement line and its book entry the same match ID, such as the cheque number. Mismatched amounts are flagged immediately.
The classic layout, built for you
Statement balance plus deposits in transit, less outstanding payments, equals the adjusted bank balance. Books plus bank-only items equals the adjusted book balance.
The statement checks itself
Opening balance plus every line must equal the printed closing balance, so a missing or mistyped line shows up before you start matching.
GETTING STARTED
Three steps
to your own version.
The sample shows a working example; the blank version keeps every formula ready for your records.
Enter the statement details
On Settings, add the period and the opening and closing balances from the statement, and your book balance at the start.
Paste both sides
Put statement lines on Bank Statement and your cash entries on Book Entries, money in positive and money out negative.
Match and finish
Add match IDs until only genuine reconciling items remain. The difference should read $0.00.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
What are bank-only items?
Lines on the statement that are not in your books yet, such as bank fees, interest or an unrecognised deposit. Record them in your books next.
How do I carry items to next month?
Copy outstanding book entries (deposits in transit and uncleared payments) into next month's Book Entries. They clear when they appear on the statement.
Can I paste a CSV export from my bank?
Yes. Paste the date, description and amount columns. Make sure money out is negative.
Does it connect to my bank?
No. Nothing is uploaded. You paste the statement lines yourself.
How do I keep my changes?
Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.
Will it work in Excel and Google Sheets?
The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.
Can I change the currency?
Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.
EXCELCRAFT PRO · EARLY ACCESS
Part of
ExcelCraft Pro.
Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.
- Every Pro workbook as it is released, with dashboards, checks and instructions
- Planned: monthly AI credits for editing spreadsheets through chat
- Planned launch pricing; final terms are not set
$8/ month
or $60 / year · planned launch price
No payment today. We email you once when Pro opens.
How Pro worksRELATED
Works well with.
Separate workbooks for neighbouring jobs. Records do not sync between files.
Your workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.
Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.