Balance sheet template
An editable balance sheet template: add, edit or delete lines across current and non-current assets and liabilities plus equity, get automatic subtotals and a check that assets equal liabilities plus equity, and export a hand-written CSV with a BOM so Excel opens it cleanly.
Runs in your browserEvery computation happens in your browser — your data never leaves this device.
Balance sheet lines
All money is handled as integer cents, entered in yuan; both the line names and the amounts are editable and every section can gain or lose rows.
| Line item | Amount (yuan) | |
|---|---|---|
| Current assets | ||
| Subtotal | 700,000.00 | |
| Non-current assets | ||
| Subtotal | 800,000.00 | |
| Current liabilities | ||
| Subtotal | 270,000.00 | |
| Non-current liabilities | ||
| Subtotal | 380,000.00 | |
| Equity | ||
| Subtotal | 850,000.00 | |
Total assets
1,500,000.00650,000.00850,000.001,500,000.000.00What this tool does
- Produce a monthly statement for a small business: enter the amounts against the example lines and the tool subtotals current and non-current assets and liabilities plus equity, then checks that assets equal liabilities plus equity.
- Chase down a sheet that will not balance: when the difference is not zero the hint tells you which way it leans and by how much, so you know where to look in the vouchers.
- Use it as a template: delete the lines you do not need, add lines to any section, and rename them to match your own chart of accounts.
- Hand it to your accountant or bank: export a CSV with a BOM that Excel opens without garbling, ready to paste into an existing workbook.
Example
Input
Example lines: cash 300,000, receivables 150,000, inventory 200,000, other current assets 50,000, fixed assets 500,000, intangibles 100,000, long-term investments 200,000; short-term borrowings 100,000, payables 120,000, payroll 30,000, other current liabilities 20,000, long-term borrowings 300,000, long-term payables 80,000; paid-in capital 500,000, capital reserve 100,000, surplus reserve 50,000, retained earnings 200,000
Output
Current assets 700,000.00; non-current assets 800,000.00; total assets 1,500,000.00; current liabilities 270,000.00; non-current liabilities 380,000.00; total liabilities 650,000.00; total equity 850,000.00; liabilities plus equity 1,500,000.00; difference 0.00 with the hint "In balance"
Change cash from 300,000 to 299,998.76 and the difference becomes 1.24 with the hint that assets fall short of liabilities plus equity by 1.24, which is how you spot a keying error.
Frequently asked questions
Why is the difference not zero?
The accounting identity requires assets to equal liabilities plus equity, so a non-zero difference usually means an amount was keyed wrong, a line is missing, or something is classified oddly (putting a long-term loan under current liabilities does not change the total but does change the subtotals). The hint tells you the size and direction so you can check the vouchers.
Can amounts be negative?
Yes. Accumulated losses, inventory write-downs and similar items can be negative, and the tool adds them as signed integers so they flow correctly into the subtotals and the identity check.
What about Excel garbling the exported CSV?
It will not: the export starts with a UTF-8 BOM, which Excel uses to detect the encoding. Commas, quotes and line breaks inside fields are quoted per RFC 4180 and lines end with CRLF, so Excel and other spreadsheet tools read it cleanly.
Can I file this as the official statement?
Use it as a working paper. A formal statement has to follow the applicable accounting standard: the line names, the required breakdowns (such as non-current liabilities due within a year) and the consolidation scope all depend on your situation. The template gives the skeleton; the definitions come from the standard and your regulator.
Is my data uploaded anywhere?
No. The lines and amounts live only in browser memory, the export is generated locally as text, the page makes no requests, and a refresh returns you to the example data.
Keywords：balance sheetaccounting templateassets liabilities equitycsv export资产负债表会计模板资产等于负债加所有者权益财务模板导出csv