Bookkeeping
A free balance sheet template is a snapshot on one date. Harbor Goods, a one-owner shop, closed March 31, 2026 with cash of $8,420, receivables of $1,260, inventory at cost of $1,860, and equipment of $2,400. Total assets are $13,940. Debts are supplier bills $980, sales tax collected $210, and a short-term loan of $1,500. Equity is owner investment $8,000 plus retained earnings $3,250. The check row is zero.
The free balance sheet template Excel file adds each group, then checks that assets equal liabilities plus equity. You type the yellow amounts. Total assets, total liabilities, total equity, and the check are green.
Sales tax collected is money in the bank that is not yours. Inventory is what you paid, not the shelf tag. Retained earnings is a number you bring from your books. The sheet does not pull it from the free profit and loss template.
Profit for March belongs on the profit and loss template. This page is only the snapshot. If the check is not zero, a number is missing or it was typed in the wrong group.
Download the free balance sheet template. More bookkeeping guides are on the blog.
Workbooks for a small shop, a freelancer, or a contractor. Sample amounts are in dollars.
Yes. Download the free balance sheet template for one snapshot date.
Zero. Assets should equal liabilities plus equity. If the check is not zero, a number is in the wrong group.
No. Profit and loss is the month. The balance sheet is one date.