Accounting template
Balance Sheet Template
List what the business owns and owes. The check row confirms that assets equal liabilities plus equity.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Item | Amount |
| 2 | Cash | 150,000 |
| 3 | Accounts receivable | 80,000 |
| 4 | Equipment | 220,000 |
| 5 | Total assets | =SUM(B2:B4) |
| 6 | Accounts payable | 60,000 |
| 7 | Loans | 140,000 |
| 8 | Total liabilities | =SUM(B6:B7) |
| 9 | Equity | =B5-B8 |
| 10 | Check (should be 0) | =B5-B8-B9 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B5 =SUM(B2:B4)
Everything the business owns.
B8 =SUM(B6:B7)
Everything the business owes.
B9 =B5-B8
Equity is assets minus liabilities.
B10 =B5-B8-B9
Zero means the balance sheet balances.
Make it yours by asking
Try a request like this in Tabstra:
"Create a balance sheet with current and fixed assets, liabilities, equity and a balance check"