TL;DR: Fire up Excel → hit File → New → type “balance sheet” in the search box → pick a template → plug in your numbers → export as PDF. Microsoft Support
What’s Happening
A balance sheet is a financial snapshot that shows what someone owns (assets), owes (liabilities), and the leftover value (equity) at one moment.
Think of it like a single photograph of your—or a company’s—financial health taken on a specific date. As of 2026, Excel still rules this space because it ships with ready-made templates and crunches the numbers for you. The math is simple: Assets = Liabilities + Equity. When the numbers don’t match, nine times out of ten it’s a typo or a misplaced minus sign.
Step-by-Step Solution
Open Excel, pick a template, fill in the blanks, and save as PDF.
- Launch Excel (2021 or newer works best). Hit File → New.
- Find a template: Type “balance sheet” in the search bar. You’ll see choices like “Personal Balance Sheet” and “Business Balance Sheet.”
- Grab one: Pick the template that fits your life. The “Business Balance Sheet,” for instance, already labels the asset, liability, and equity sections.
- Drop in your figures:
- Assets: Slap in cash, receivables, inventory, real estate, gear—whatever you’ve got.
- Liabilities: Toss in payables, loans, credit lines, and any other IOUs.
- Check the totals: Excel does the adding for you. Make sure the grand total of assets equals the grand total of liabilities plus equity. If it doesn’t, backtrack and fix the typos.
- Export to PDF: File → Save As → choose PDF from the dropdown, pick where you want it, and click Save.
If This Didn’t Work
Fix missing formulas, hunt down errors, or try a different template.
- Add your own math: If the template forgot the formulas, drop in =SUM(range). For assets, try =SUM(B2:B10).
- Track down the gremlins: Excel’s Error Checking tool (Formulas tab → Error Checking) flags mismatches. Watch for negative numbers where they shouldn’t be or decimals in the wrong place.
- Grab a fresh template: If Microsoft’s offerings feel too basic, snag a third-party template from Office Templates.
Prevention Tips
Update quarterly, back up your files, and compare past sheets to spot trouble early.
- Keep it current: Refresh the sheet every three months so mistakes don’t pile up. Use Excel’s Data Validation (Data tab → Data Validation) to block anything but numbers.
- Save a safety copy: Export the final PDF, but keep the original .xlsx file around. Stash it in OneDrive or Google Drive so a crashed hard drive won’t ruin your day.
- Look for patterns: Build a quick PivotTable to stack this quarter’s sheet against last quarter’s. If liabilities are climbing or equity is shrinking, you’ll see it right away.
