Bank Reconciliation
Match statement lines to your books and prove the difference is zero.
See what is insideEXCELCRAFT PRO TEMPLATE
Bookkeeping & general ledger
for Excel.
Proper double-entry books without accounting software. Post balanced journal entries, and the trial balance, income statement, balance sheet and account ledgers update together, with checks that tell you when something does not add up.
Planned pricing: $8 a month or $60 a year. No payment is taken today.
ExcelCraft / Bookkeeping & General LedgerFictional sample
- Double-entry journal
- Trial balance & statements
- Account ledgers
INSIDE THE WORKBOOK
Every sheet
has one job.
Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.
- Dashboard
- Revenue, expenses, net income and cash, monthly revenue and expenses, month-end cash and a balance sheet summary.
- Journal
- Every entry line with date, entry number, account, description, debit or credit; unbalanced entries are flagged and excluded.
- Accounts
- Chart of accounts with types and opening balances; debits, credits and balances for the year calculate per account.
- Trial Balance · Statements · Ledger
- Debit and credit balances, income statement and balance sheet, and a month-by-month ledger for any account.
- Settings · Checks · Instructions
- Fiscal year, report date and cash account; checks for unbalanced entries, opening balances and the balance sheet equation.
WHY IT HELPS
Built around
the real task.
Double-entry journal, trial balance, income statement and balance sheet.
Entries must balance
Each journal entry's debits must equal its credits. An entry that does not balance is flagged and left out of every report until it does.
Statements from the same numbers
Trial balance, income statement and balance sheet all read from the journal, so they always agree. Assets equal liabilities plus equity, or Checks tells you.
Any account, month by month
Choose an account on Ledger to see its opening balance, debits, credits and closing balance for each month of the year.
GETTING STARTED
Three steps
to your own version.
The sample shows a working example; the blank version keeps every formula ready for your records.
Review the accounts
Adapt the sample chart of accounts and enter opening balances for assets, liabilities and equity.
Post entries
Record each transaction as two or more journal lines with the same entry number: debits on one side, credits on the other.
Read the results
Check the Dashboard and Statements, and keep Checks at zero before you rely on the figures.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
Do I need to know double-entry bookkeeping?
It helps. Instructions include the common entries: money in, paying an expense, invoicing a customer. The checks catch most mistakes.
Can it replace accounting software?
For a small business that wants clear books in a spreadsheet, it covers the essentials. It does not file taxes, run payroll or produce statutory accounts.
How do I start a new year?
Copy closing balances of balance sheet accounts into opening balances, add the year's earnings to equity, change the fiscal year start and clear the journal.
How many entries can it hold?
The journal holds 500 lines. Extend the ranges as described in Instructions for more.
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.