Handled by Morning Book a free look

Make a simple balance sheet

This balance sheet template lists what the business owns, what it owes and what is left for the owners on one date. Type or paste your numbers on the left and the balance sheet builds itself on the right, with every total worked out and a check that it balances. It is a plain form with arithmetic, not AI. Nothing you type leaves this page, and closing the tab clears it.

About the balance sheet

Type amounts as positive numbers, including what you owe. The one usual exception is accumulated depreciation, which goes in as a negative, such as -25,000 or (25,000). Lines with no amount are left off the balance sheet.

Current assets

Cash, and things that turn into cash within a year. Accounts receivable is money customers owe you. Prepaid expenses are bills paid ahead, such as a year of insurance.

Fixed assets

Things the business owns and uses for years, at what they cost. Accumulated depreciation is the part of that cost already counted as used up; enter it as a negative.

Other assets

Anything else the business owns, such as a deposit held by a landlord.

Current liabilities

What the business owes and must pay within a year. Accounts payable is money you owe suppliers.

Long-term liabilities

Loans and other debts due more than a year from now.

Equity

The owners' share: what they put in, plus profit kept from earlier years (retained earnings), plus the net profit so far this year from your profit and loss statement. Money the owners took out goes in as a negative line.

Paste from a spreadsheet

Copy two columns from a spreadsheet or an exported report, the line name and then the amount, and paste them here. Heading rows and rows starting with Total are skipped. The pasted lines replace the lines in the section you pick.

To save a PDF, choose Print, then Save as PDF as the printer. Only the balance sheet prints.

Want to see cash and what you owe without waiting for month end?

I connect your books read-only and send one page each morning with cash in the bank, what customers owe you and what you owe suppliers. A free 30-minute look shows what your books could answer today.

This sends your email address and nothing else. Nothing you put into the tool is sent.

Book a free look

How to read a balance sheet

A balance sheet is a snapshot of one day. The top half lists the assets, everything the business owns. The bottom half lists the liabilities, everything it owes, and the equity, the part that belongs to the owners. The two halves always come to the same total:

assets = liabilities + equity

That is why it is called a balance sheet. Equity is simply what would be left if the business sold everything at the values in its books and paid every debt.

Current means within a year. Current assets are cash and what turns into cash soon; current liabilities are what must be paid soon. Comparing the two tells you whether the business can pay its near-term bills.

working capital = current assets − current liabilities

current ratio = current assets ÷ current liabilities

A current ratio above 1 means current assets cover everything due within a year. Below 1, the business is relying on future sales or new borrowing to pay those bills. To see how many days cash is tied up in what customers owe and in stock, use the DSO and DPO calculator.

Where the numbers come from

Most accounting software has a report called Balance Sheet. Run it as of the date you want, export it to a spreadsheet, then copy the line names and amounts into the paste box above, one section at a time. Without accounting software, start from bank and loan statements, a list of unpaid customer invoices, a list of unpaid bills, and what you paid for equipment and vehicles.

The current year profit line is the net profit from your profit and loss statement for the year up to the same date.

Questions

My balance sheet does not balance. What usually causes it?

Check three things first. The current year profit may be missing or from a different date. Accumulated depreciation may have been typed as a positive number, which makes assets too high by twice that amount. A line may sit in two sections at once. If you built the sheet by hand from bank and loan statements, the gap is often something never written down, such as money the owners took out.

What is the difference between a balance sheet and a profit and loss statement?

A profit and loss statement covers a period, such as a quarter, and shows what was earned and spent. A balance sheet covers one day and shows what is owned and owed on it. The net profit from the first flows into equity on the second.

What are retained earnings?

Profit from earlier years that was kept in the business, after anything paid out to the owners. It is part of equity.

How often should I make one?

As often as you make a profit and loss statement. Read the two side by side, because the balance sheet shows cash, what customers owe and what is owed to suppliers, none of which appears on the profit and loss statement.

Is anything I type sent anywhere?

No. The balance sheet is put together in your browser and the page stores nothing. It is a plain form with arithmetic, not AI. Download the spreadsheet or save the PDF to keep a copy.

Who made this?

Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools.