Bookkeeping & General Ledger
Double-entry journal, trial balance, income statement and balance sheet.
See what is insideEXCELCRAFT PRO TEMPLATE
Balance sheet
with reconciliation.
A clear balance sheet for two dates side by side, with the ratios lenders ask about and a record of which balances you have actually checked.
Planned pricing: $8 a month or $60 a year. No payment is taken today.
ExcelCraft / Balance Sheet & ReconciliationFictional sample
- Two periods side by side
- Key ratios
- Reconciliation status
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
- Total assets, liabilities, equity and current ratio, with ratios for both periods and reconciliation progress by section.
- Balance Sheet
- The statement: current and non-current assets and liabilities, equity, totals, change and % change, and the balance check.
- Accounts
- Each line with its section, prior and current balance, quick-ratio flag, reconciled status and evidence.
- Settings · Checks · Instructions
- Company and period-end dates; checks that both periods balance and every line is reconciled.
WHY IT HELPS
Built around
the real task.
Two-period balance sheet with ratios and a reconciliation status for every line.
The statement builds itself
Add lines on Accounts with a section; the Balance Sheet lays them out with subtotals and totals in the right order.
Ratios for both dates
Current ratio, quick ratio, working capital, debt to equity and equity ratio, now and at the prior period end.
Know what has been checked
Mark each balance reconciled and note the evidence: a bank statement, an aged debtors report, a stock count.
GETTING STARTED
Three steps
to your own version.
The sample shows a working example; the blank version keeps every formula ready for your records.
Pick the dates
Enter the current and prior period-end dates on Settings.
Enter balances
Add each balance sheet line with its section and both balances. Reductions such as accumulated depreciation are negative.
Reconcile and review
Mark lines reconciled as you check them. Both periods must balance before you share the figures.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
Where do the balances come from?
From your bookkeeping system, trial balance or the Bookkeeping & General Ledger workbook.
Why does my balance sheet not balance?
Usually retained earnings: it must include the profit for the period. Checks shows the difference for each period.
What is the quick ratio?
Current assets that can be turned into cash quickly (excluding the lines you flag, usually inventory and prepayments) divided by current liabilities.
Is this suitable for statutory accounts?
It is a management balance sheet. Statutory accounts have specific formats and notes.
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.
Bank Reconciliation
Match statement lines to your books and prove the difference is zero.
See what is inside
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.