A company balance sheet shows its financial position on a specific date using the equation Assets = Liabilities + Equity. The Excel-ready format below includes current and prior-period columns, automatic subtotals, a balance check, and a status warning. Copy it into Excel, or start with a customizable template from Microsoft Excel or the Wolters Kluwer/BizFilings balance-sheet template.
This is a practical format for learning, planning, and internal reporting. It is not automatically GAAP-, IFRS-, tax-, audit-, or lender-compliant.
As an Amazon Associate I earn from qualifying purchases.
Free company balance sheet format for Excel
Use the following vertical format as a general-purpose company balance sheet. Replace the sample labels with the accounts in your company’s chart of accounts. Enter ending balances from a trial balance or accounting system—not simply a list of bank transactions.
| Section | Account | Current period | Prior period |
|---|---|---|---|
| ASSETS | |||
| Current assets | Cash and cash equivalents | ||
| Accounts receivable | |||
| Inventory | |||
| Prepaid expenses | |||
| Other current assets | |||
| Total current assets | =SUM(C5:C9) |
=SUM(D5:D9) |
|
| Noncurrent assets | Property, plant, and equipment | ||
| Less: accumulated depreciation | |||
| Long-term investments | |||
| Intangible assets | |||
| Other noncurrent assets | |||
| Total noncurrent assets | =SUM(C11:C15) |
=SUM(D11:D15) |
|
| TOTAL ASSETS | =C10+C16 |
=D10+D16 |
|
| LIABILITIES AND EQUITY | |||
| Current liabilities | Accounts payable | ||
| Accrued expenses and payroll | |||
| Short-term loans | |||
| Current portion of long-term debt | |||
| Taxes payable | |||
| Deferred or unearned revenue | |||
| Total current liabilities | =SUM(C20:C25) |
=SUM(D20:D25) |
|
| Long-term liabilities | Long-term debt | ||
| Lease liabilities | |||
| Deferred tax or other long-term liabilities | |||
| Total long-term liabilities | =SUM(C27:C29) |
=SUM(D27:D29) |
|
| TOTAL LIABILITIES | =C26+C30 |
=D26+D30 |
|
| Equity | Common stock or share capital | ||
| Additional paid-in capital | |||
| Retained earnings | |||
| Less: treasury stock, if applicable | |||
| Current-period profit or loss, if not already closed | |||
| TOTAL EQUITY | =SUM(C33:C37) |
=SUM(D33:D37) |
|
| TOTAL LIABILITIES AND EQUITY | =C31+C38 |
=D31+D38 |
|
| BALANCE CHECK | =C17-C39 |
=D17-D39 |
|
| Status | =IF(ABS(C41)<0.01,"Balanced","Investigate") |
=IF(ABS(D41)<0.01,"Balanced","Investigate") |
|
The row numbers assume the header occupies row 4 and the first cash row is row 5. If your worksheet uses different rows, adjust every formula to match its actual position.
#1 Best Overall
Company details to add above the table
Place these fields at the top of the worksheet:
- Company name: [Company Name]
- Statement title: Balance Sheet
- Reporting date: As of [Month Day, Year]
- Currency: Identify the currency and whether amounts are shown in whole units, thousands, or millions.
A balance sheet is a snapshot at a date, unlike an income statement or cash-flow statement, which normally cover activity over a period. The SEC’s financial-statement guide describes the balance sheet as reporting assets, liabilities, and shareholders’ equity at a point in time.
Illustrative completed balance sheet
The figures below are fictional and demonstrate how the equation works:
| Category | Amount |
|---|---|
| Cash | $25,000 |
| Accounts receivable | $18,000 |
| Inventory | $32,000 |
| Fixed assets, net | $75,000 |
| Total assets | $150,000 |
| Total liabilities | $60,000 |
| Total equity | $90,000 |
| Total liabilities and equity | $150,000 |
Because $150,000 equals $60,000 plus $90,000, the illustrative statement balances. That proves arithmetic consistency only; it does not prove that the underlying amounts are complete or correctly valued.
What goes on a company balance sheet?
Assets
Assets are resources the company owns or controls. Common examples include cash, accounts receivable, inventory, prepaid expenses, marketable securities, equipment, buildings, long-term investments, patents, trademarks, and other intangible assets.
Liabilities
Liabilities are amounts the company owes or obligations it must settle. Examples include supplier invoices, accrued payroll, taxes payable, credit-card balances, loans, lease liabilities, and deferred revenue.
Equity
Equity is the owners’ residual interest after liabilities are deducted from assets:
Rank #2
Equity = Assets - LiabilitiesCorporate equity may include share capital, additional paid-in capital, retained earnings, accumulated other comprehensive income, and treasury stock. A noncorporate business may instead use owner or partner capital, contributions, draws, and distributions.
Current versus noncurrent items
In a basic U.S. presentation, current assets are generally expected to be realized, sold, or consumed within about one year, while current liabilities are generally expected to be settled within about one year. The SEC explains these common distinctions.
This is a useful starting point, not a universal rule for every business. The operating cycle, industry practice, jurisdiction, and accounting framework can affect classification. For formal reporting, confirm the treatment under the applicable GAAP, IFRS, or other requirements.
Vertical and horizontal balance-sheet formats
The vertical format used above lists assets first, followed by liabilities and equity. It is usually easiest to read, print, and maintain in Excel.
An alternative account-style format places assets on one side and liabilities and equity on the other:
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Assets Liabilities and Equity
Current assets Current liabilities
Noncurrent assets Long-term liabilities
EquityBoth layouts can be valid when the totals and classifications are correct. A vertical worksheet is generally the more practical default for a small business.
How to create the balance sheet in Excel
- Open Excel and create a blank workbook.
- Rename the worksheet Balance Sheet.
- Add the company name, title, reporting date, currency, and period columns.
- Enter the asset, liability, and equity accounts that apply to the business.
- Use
SUMformulas for each subtotal rather than typing subtotal amounts manually. - Calculate total assets and total liabilities and equity.
- Add the balance-check and status formulas.
- Enter ending account balances from a reconciled trial balance or accounting records.
- Format amounts consistently as currency or accounting values.
- Save an untouched blank copy, then protect formula cells while leaving input cells unlocked.
Microsoft’s current Excel guidance also recommends starting with a template, adding or removing rows for the company’s accounts, entering balances, and checking that assets equal liabilities plus equity.
Recommended Excel formatting and controls
- Use bold section headings and strong borders under grand totals.
- Display negative amounts in parentheses.
- Use a “Less:” label for contra-accounts such as accumulated depreciation or treasury stock if amounts are entered as positive deductions.
- Keep account names in one column and avoid merged cells in the calculation area.
- Shade input cells differently from formula cells.
- Freeze the top rows for large workbooks.
- Use consistent decimal precision.
- Add conditional formatting to the balance-check cell: green for zero or an allowed tolerance, red otherwise.
For the example above, a conditional-formatting rule could be:
=ABS($C$41)>=0.01A $0.01 tolerance accommodates minor rounding differences. A bookkeeping workbook using unrounded balances may instead use:
Recommended Free Tools
=IF(C41=0,"Balanced","Investigate")Never add a “plug” to equity simply to make the status read Balanced. A plug can conceal omitted transactions, duplicate entries, incorrect signs, missing depreciation, or an unrecorded transfer of profit into equity.
Where to get the numbers
A reliable balance sheet is produced from accounting records. Typical source documents include:
- Reconciled bank and credit-card accounts
- Accounts-receivable aging reports
- Inventory records or counts
- A fixed-asset register
- Accounts-payable aging reports
- Loan statements
- Payroll and tax records
- Owner contribution and distribution records
- The general ledger or trial balance
Before entering figures, identify the reporting date, reconcile cash and credit cards, review receivables and payables, validate inventory, record applicable depreciation and amortization, confirm debt and current portions, reconcile taxes and payroll liabilities, and transfer the correct profit or loss into equity.
Adapting the equity section by entity type
Corporation
Use labels such as common stock or share capital, additional paid-in capital, retained earnings, accumulated other comprehensive income where applicable, and treasury stock where applicable. Use shareholders’ equity terminology.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallLLC
The appropriate presentation depends on the LLC’s accounting and tax treatment. A simple internal worksheet might include members’ capital, contributions, distributions, and accumulated or retained earnings, but there is no single equity layout that applies to every LLC.
Partnership
Use separate capital accounts where appropriate, such as Partner A capital and Partner B capital, along with contributions, withdrawals or distributions, and allocated profit or loss.
Sole proprietorship
Use owner’s capital, owner’s draws, and current-period earnings. Do not relabel corporate share capital as owner’s equity without changing the underlying structure.
The BizFilings resource describes a downloadable Excel balance-sheet form that can be modified for corporations or partnerships, but its example should be treated as a starting point rather than a universal entity format. Its page describes an older Excel 4.0-and-above format, so save a modern .xlsx copy and test formulas and formatting before relying on it.
How to fix an unbalanced balance sheet
- Confirm that each subtotal includes the intended rows.
- Look for formulas replaced by hard-coded amounts.
- Check whether liabilities or equity were entered with the wrong sign.
- Review accumulated depreciation and other contra-accounts.
- Confirm that current-period profit or loss has been included in equity exactly once.
- Check owner distributions, dividends, and contributions.
- Separate the current portion of long-term debt if required.
- Reconcile bank, credit-card, receivable, payable, and loan balances.
- Search for duplicate or omitted accounts.
- Confirm that income-statement accounts were not accidentally placed in the balance sheet.
- Check whether rounding exceeds the tolerance.
- Verify that the underlying trial balance itself balances.
Why retained earnings often causes problems
Retained earnings generally reflects accumulated profits and losses less dividends or distributions, subject to the company’s accounting records and applicable framework. A common error is to enter an ending retained-earnings balance that already includes current-year profit and then add current-period profit again. That double-counts earnings.
Can assets or liabilities be negative?
Some negative amounts are legitimate, especially for contra-accounts such as accumulated depreciation or treasury stock. Decide whether your workbook uses positive presentation values with “Less:” labels or natural debit-and-credit signs from the trial balance, and do not mix conventions without documenting the treatment.
Excel template versus accounting software
| Option | Best for | Advantage | Limitation |
|---|---|---|---|
| Excel template | Learning, projections, and simple internal reporting | Flexible and inexpensive | Manual entry and weaker controls |
| Wave | Very small businesses seeking low-cost bookkeeping | Free Starter plan and accounting reports | Features, payment tools, and bank connections vary |
| Xero | Growing businesses needing cloud collaboration | Bank reconciliation, reports, and forecasting | Recurring subscription and plan limits |
| QuickBooks Online | Businesses needing a broad accounting platform | Bank feeds, reports, accountant access, and Excel synchronization | Paid plans and feature complexity |
| Bookkeeper or accountant | Formal or complex reporting | Professional judgment and review | Higher cost |
Check current features, eligibility, and prices directly: Wave, Xero U.S. plans, and QuickBooks Online. Promotional prices and plan terms can change.
When Excel is not enough
Use accounting software or professional help when you need continuous bookkeeping, bank feeds, invoicing, payroll, inventory, sales-tax workflows, multiple currencies or entities, audit trails, role-based permissions, consolidation, complex revenue recognition, lease accounting, stock compensation, or foreign operations.
Do these 3 things before closing this tab:
1Fix the driver behind crashes, sound loss and screen glitches2Clear out junk files and repair common Windows errors3Scan for outdated or missing drivers - takes under a minuteDo not submit an unreviewed spreadsheet as a formal statement to a lender, investor, regulator, or tax authority. Excel automates formulas; it does not establish correct valuation, cutoff, classification, completeness, or compliance with GAAP or IFRS. A sheet can balance while containing the wrong bank balance, omitted liabilities, inaccurate inventory, or invalid depreciation.
Saving and maintaining the workbook
- Keep a blank master copy separate from completed reports.
- Record the reporting date and source documents.
- Use a notes or assumptions tab for unusual classifications and estimates.
- Protect formulas and restrict editing of calculated cells.
- Use clear file names and version history.
- Save a modern
.xlsxversion after testing compatibility. - Have an accountant review the workbook when it supports formal reporting or an important financing decision.
Frequently Asked Questions
Is this Excel balance sheet GAAP-compliant?
No automatic compliance claim should be made. The worksheet is a general-purpose format; formal GAAP, IFRS, tax, statutory, audit, or lender reporting requires the applicable rules and, often, professional review.
Can I use the template in Google Sheets?
Yes, you can generally import or recreate the layout and formulas, but check imported formatting, formula behavior, and file compatibility before relying on the result.
How do I compare two years?
Use one column for each reporting date, such as Current period and Prior period, and copy the same subtotal, total, balance-check, and status formulas across both columns.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
