A balance sheet is a snapshot of what a business owns and owes on one date. The template starts with typical small-business lines — cash, receivables, inventory, equipment, payables, credit cards, loans, owner's capital and retained earnings — filled with example figures so you can see how it works. Replace them with your own, add or remove lines, and it totals every section, checks that assets equal liabilities plus equity, compares against last year and works out working capital, the current ratio, the quick ratio and debt to equity.
Assets on top, split into current assets (cash and anything that turns into cash within a year: receivables, inventory, prepaid expenses) and fixed or non-current assets (equipment, vehicles, property, less accumulated depreciation). Then liabilities, split the same way: current (bills, credit cards, taxes owed and the next twelve months of loan payments) and long-term (the rest of the loan). Last, owner's equity: what you put in plus the profits left in the business.
The two sides always match: assets = liabilities + equity. In the example, $86,600 of assets equals $32,100 of liabilities plus $54,500 of equity. If yours doesn't balance, the template shows by how much and what equity would make it balance — usually a missing loan, an unrecorded owner draw, or retained earnings that haven't been updated from the profit and loss.
Working capital is current assets minus current liabilities — the cushion for paying the next year's bills. The current ratio divides the two: $43,200 ÷ $15,900 = 2.72 in the example. The quick ratio leaves inventory out, because stock can't always be sold fast: ($43,200 − $14,300) ÷ $15,900 = 1.82. Debt to equity is total liabilities ÷ equity, $32,100 ÷ $54,500 = 0.59. Lenders look at all three; compare them with your own previous years rather than a rule of thumb.
Take the cash figure from your bank statements on the balance sheet date, receivables from unpaid invoices, and loan balances from the lender's statement or the loan amortization schedule. Retained earnings move with each year's profit from your profit and loss sheet. For the months ahead rather than one date, use the cash flow forecast.
Any current-asset line with "inventory" or "stock" in its name is left out of the quick ratio. Use "Roll forward" at year end to move this year's figures into the comparison column.
A statement of what a business owns (assets), what it owes (liabilities) and the owner's stake (equity) on one date. Assets always equal liabilities plus equity.
Usually something is missing: a loan or credit card balance, an owner draw or contribution, or retained earnings that weren't updated with the year's profit. The template shows the difference and the equity that would balance it.
A profit and loss covers a period and shows income minus expenses. A balance sheet is a snapshot on one date of what you own and owe. The year's profit flows into retained earnings on the balance sheet.
It depends on the industry and how quickly your customers pay. Above 1 means current assets cover current liabilities; track your own ratio over time and ask your lender what they expect.
Yes. Export the CSV and open it in any spreadsheet. Your figures are also saved in this browser.
These templates do the same job as an editable document you can fill in again and again.
Excel and Google Sheets workbooks made by DixonAppStudio, the company behind this site.