How to create a balance sheet
You can create a balance sheet manually using standard spreadsheet software. The most basic sheet will list assets on the left side and liabilities on the right. The item in question may be written in the middle of the sheet.
Let’s say you own an ice cream shop. The current asset list might look like this:
- $2,000 cash in the bank
- $500 in accounts receivable
- $3,000 worth of inventory
Plus fixed assets such as:
- $500 for tables and chairs
- $7,000 for freezers
- $1,000 for your computers and point-of-sale equipment
In total, your ice cream shop has $14,000 in assets:
($2,000 + $500 + $3,000) + ($500 + $7,000 + $1,000) = $14,000
On the right side, you’ll list the liabilities. If you're noting the items in the centre, it may look a bit like this:
- Accounts payable $1,000
- Sales tax $500
- Salary and wages owed $1,500
Long-term liabilities might include an outstanding business loan of $4,000 you used for startup.
The numbers on the liabilities side of your balance sheet will look like this:
($1,000 + $500 + $1,500) + $4,000 = $7,000
When you subtract your liabilities from your assets ($14,000 – $7,000), the remaining $7,000 is your owner's equity.
If you’d rather not create your own balance sheet from scratch, try using a balance sheet template instead.
Keep in mind that your balance sheet is an ever-changing document. You may choose to fill it out once each year, or you might opt to update it as frequently as each month.
Whether you choose to start from scratch or use our template, be sure to customize it for your specific needs. Include the asset and liability categories that work best for your company.
The above balance sheet template will help guide you through the process. You can change the account titles and the amounts listed in the spreadsheet to fit your needs. You can also add rows when you need to add new accounts and balances. The total amounts will automatically populate based on the embedded formulas.