Open Excel and create a new worksheet
Enter the balance sheet title at the top
Create two main sections: Assets and Liabilities & Equity
List current assets first
List non-current assets below current assets
Add a total for current assets
Add a total for non-current assets
Calculate total assets
List current liabilities first
List non-current liabilities below current liabilities
Add a total for current liabilities
Add a total for non-current liabilities
Calculate total liabilities
List owner’s equity or shareholders’ equity
Add retained earnings or capital accounts
Calculate total equity
Calculate total liabilities and equity
Ensure total assets equal total liabilities and equity
Use formulas for all totals
Format amounts as currency
Apply bold formatting to section headers and totals
Add borders or shading for clarity
Save the worksheet