How to make a balance sheet in Excel: Free template

A balance sheet shows your business's assets, liabilities, and equity at a moment in time. Without it, you can't accurately track your company's financial health.

Building one from scratch in Excel can be time-consuming and prone to errors. Download Ramp's free Excel balance sheet template to save time, stay organized, and improve accuracy in your reporting.

A well-structured Excel template gives you a clear picture of your finances and helps you keep assets, liabilities, and equity in balance.

What is a balance sheet?

A balance sheet is a financial statement that shows your company's assets, liabilities, and equity at a specific point in time. It's a snapshot of your financial health, highlighting what you own and what you owe.

Every balance sheet follows a simple formula:

Assets = Liabilities + Equity

• Assets: What your company owns
• Liabilities: What your company owes
• Equity: The value remaining for owners after debts are paid

The equation must always balance. Your total assets should equal your total liabilities and equity.

Balance sheets in business

A balance sheet helps you track financial progress and make informed business decisions. It also promotes transparency by ensuring compliance with accounting standards and giving stakeholders an accurate view of your company's position.

Regularly maintaining your balance sheet ensures financial statements reflect reality, which supports better management, planning, and reporting. Lenders and investors often rely on these statements when evaluating your business.

The balance sheet is one of three key financial statements. Here's how it compares to an income statement and cash flow statement:

Key components of a balance sheet

A balance sheet has three main components: assets, liabilities, and equity. Understanding how they relate gives you a clear picture of your company's financial health.

Assets

Assets are what your business owns that have value. Examples include:

• Cash on hand
• Accounts receivable, or money customers owe you
• Inventory ready to be sold
• Property, plant, and equipment (PP&E)

Assets are divided into two categories:

• Current assets: Short-term assets you can convert into cash within one year, such as cash, accounts receivable, and inventory
• Noncurrent assets: Long-term assets that can't be quickly converted to cash, such as property or equipment

Liabilities

Liabilities are what your business owes to others. Common examples include:

• Credit card balances
• Mortgages
• Short-term loans
• Long-term loans
• Bonds payable

Liabilities are also classified as:

• Current liabilities: Debts due within one year
• Noncurrent liabilities: Debts due after one year

Equity

Equity reflects the value of funds shareholders have invested in the company, along with retained earnings. Retained earnings are profits kept in the business instead of being distributed as dividends.

The formula for shareholders' equity is:

Shareholders' equity = Total assets – Total liabilities

This represents the residual value of the company's assets after subtracting liabilities. It includes both contributed capital and accumulated retained earnings.

Maintaining a healthy debt-to-equity ratio is key to long-term stability. While benchmarks vary by industry, a ratio between 0.5 and 2.0 is generally considered healthy.

How to create a balance sheet in Excel

Now that you understand the components, here's the step-by-step process to build a balance sheet in Excel that's accurate, clear, and easy to maintain.

Step 1: Set up your spreadsheet

Open a new Excel workbook and name the first worksheet "Balance Sheet." At the top, add a title row for your company name. Below that, create three main section headers: Assets, Liabilities, and Equity. Add subheadings like "Current Assets" and "Long-term Liabilities" to keep things organized.

Step 2: Enter the balance sheet date

Add the specific date for the report in the header (e.g., "As of March 31, 2026"). Balance sheets are point-in-time snapshots, not reports covering a period, so the date matters. Most companies pick the last day of the month, quarter, or fiscal year.

Step 3: List your assets

List your current assets in order of liquidity (cash, accounts receivable, inventory) below the Assets header. Then list your noncurrent assets (property, equipment, long-term investments) in separate rows. Leave an adjacent column for the dollar amounts, which you'll pull from your accounting records or general ledger.

Step 4: Calculate total assets

Use Excel's formula to add all your asset line items. For example, if your assets sit in cells B5 through B12, enter in a clearly labeled "Total Assets" row. Verify the total against your general ledger to catch any mismatches.

Step 5: List your liabilities

Under the Liabilities header, enter your current liabilities first (accounts payable, short-term loans, accrued expenses), followed by your long-term liabilities (mortgages, bonds payable, long-term debt) in separate grouped rows.

Step 6: Calculate total liabilities

Use again to total each subsection, then sum both subtotals into a "Total Liabilities" row. For example: for current liabilities, then add that to your long-term liabilities total.

Step 7: Calculate owners' equity

List equity components such as common stock, contributed capital, and retained earnings. If you're entering values manually, total equity should equal Total Assets minus Total Liabilities. Otherwise, sum the individual line items with .

Step 8: Verify the balance sheet balances

Confirm the accounting equation holds:

Total Assets = Total Liabilities + Total Equity

Add a verification formula like in an empty cell, where B15 is Total Assets, B25 is Total Liabilities, and B30 is Total Equity. The cell will show TRUE if it balances and FALSE if it doesn't.

If it doesn't balance, double-check for data entry errors, missing accounts, or formula ranges that don't include every row.

For a quicker solution, use Ramp's pre-made balance sheet template to skip the setup.

How to customize your Excel balance sheet template

Tailoring the template to your business makes it genuinely useful. A few common ways to customize include:

• Adding or removing line items: Right-click a row to insert a new line or delete one you don't need. Rename labels so every line reflects a real asset or liability.
• Modifying formulas: When you add or remove rows, update any totals. Click a total cell to check the formula range and adjust it to include the right rows.
• Formatting and branding: If you plan to share the sheet with stakeholders, polish the presentation. Add your logo, align fonts and colors with your brand, and keep spacing consistent.
• Documenting assumptions: Add a short "Notes" area (date, preparer, methodology for estimates like depreciation). Clear notes make reviews and audits faster.
• Versioning: Duplicate the tab for each period (e.g., "Balance Sheet – Mar 2026") so you can compare changes over time without overwriting prior periods

Common tweaks to consider:

• Cash breakdown: Separate operating cash from restricted cash
• Receivables aging: Add a line for allowance for doubtful accounts
• Inventory detail: Split raw materials, WIP, and finished goods if relevant
• Debt schedule link: Reference a separate tab for loan balances and amortization
• Equity detail: Add rows for owner draws, additional paid-in capital, or treasury stock

Retail businesses

• Add separate inventory lines for merchandise in stock, in transit, and goods on consignment
• Include sales taxes payable and gift card liabilities under current liabilities
• Track payment processors (e.g., card payouts) in accounts receivable and vendor balances in accounts payable

Service businesses

• Replace inventory with unbilled business revenue or work in progress for projects
• Add prepaid expenses for software, insurance, or retainers
• Include deferred revenue for up-front client payments as a current liability

Manufacturing businesses

• Split inventory into raw materials, work in progress, and finished goods
• Add machinery and equipment under noncurrent assets, plus cumulative depreciation
• Build a separate schedule for overhead allocation and depreciation expenses feeding back into the balance sheet

When you add or rename rows, update the total ranges so assets, liabilities, and equity still tie out.

Balance sheet formulas in Excel

A handful of Excel formulas can make your balance sheet faster to build and easier to verify. Here are the ones you'll use most:

SUM for totaling categories

To total your asset or liability sections, use . Click and drag to select the range of cells you want to add, or type the range directly into the formula.

Balance verification formula

To automatically verify the accounting equation, use , where B15 is Total Assets, B25 is Total Liabilities, and B30 is Total Equity. The cell will display "Balanced" when everything ties out and flag you when it doesn't.

Ratio calculation formulas

Add quick formulas to analyze financial health on the same sheet:

• Current ratio: =Current Assets/Current Liabilities
• Debt-to-equity ratio: =Total Liabilities/Total Equity
• Quick ratio: =(Current Assets - Inventory)/Current Liabilities

Balance sheet best practices

A few habits will keep your balance sheets accurate and useful over time. Here's what to focus on.

Sample balance sheet

Here's an example for a hypothetical company that shows how line items might appear:

Useful balance sheet ratios to track

Simple ratios help you interpret the numbers in your balance sheet:

• Current ratio = Current assets / Current liabilities. A ratio above 1.0 suggests you can cover short-term obligations comfortably.
• Quick ratio = (Current assets – Inventory) / Current liabilities. A stricter liquidity test that excludes inventory, since it isn't always easy to convert to cash quickly.
• Debt-to-equity ratio = Total liabilities / Shareholders' equity. Most industries aim between 0.5 and 2.0, depending on leverage tolerance.

Common balance sheet mistakes to avoid

Watch for these common issues when preparing your balance sheet:

• Not balancing the sheet: Your assets should always equal your liabilities plus equity
• Misclassifying current vs. noncurrent items: Double-check that anything due within a year sits in the current section
• Overstating assets: Use current, accurate values and account for depreciation
• Omitting non-cash expenses: Non-cash expenses like depreciation or amortization affect true asset value
• Mixing personal and business finances: Keep them separate to ensure accuracy
• Ignoring accruals: Missing accrued income or expenses creates mismatched reports

Maintain clear documentation, compare against prior balance sheets, and use recognized accounting standards such as GAAP standards to ensure consistency and accuracy.

When and how often to update your balance sheet

How often you update your balance sheet depends on company size and reporting needs:

• Small business: Monthly or quarterly
• Mid-sized business: Monthly
• Large enterprise: Quarterly (as required by the SEC)
• Nonprofits: Quarterly

You should also refresh it when key financial events occur, such as:

• Major asset purchase or disposal
• New loans or repayments
• Change in ownership
• Mergers or acquisitions
• Company restructuring
• Financial audits

Year-over-year comparisons reveal growth and liquidity trends trends over time. Create a duplicate tab in Excel for each period so you can track changes and spot patterns easily.

Integration with accounting software

Automating your balance sheet with accounting software such as QuickBooks, FreshBooks, or Ramp helps ensure accuracy and real-time reporting. Integration allows for:

• Real-time data updates
• Automatic classification of assets and liabilities
• Audit trails and version history
• Connection to budgets and other financial reports
• Secure cloud storage

Free balance sheet template for Excel download

Skip the setup time with a pre-built Excel template. Ramp's free balance sheet template includes:

• Pre-built formulas for all totals
• Clearly defined sections for assets, liabilities, and equity
• An automatic verification formula that confirms your sheet balances
• Editable rows so you can tailor it to your business

Automate balance sheet prep with AI-powered accounting that codes, syncs, and reconciles for you

Creating accurate balance sheets in Excel is time-consuming and error-prone. You're manually pulling data from multiple sources, coding transactions, reconciling accounts, and double-checking formulas, all while racing against month-end deadlines.

Ramp's accounting automation software eliminates the manual work that slows down balance sheet preparation. Instead of exporting data and building spreadsheets from scratch, you get real-time visibility into your financial position with automated coding, syncing, and reconciliation built in.

Here's how Ramp streamlines balance sheet creation:

• AI codes transactions automatically: Ramp learns your accounting patterns and codes every transaction across all required fields as it posts, so your data is categorized correctly from the start
• Auto-sync to your ERP: Ramp identifies in-policy transactions and syncs them to your accounting system automatically, ensuring your balance sheet reflects current data without manual entry
• Real-time reconciliation: Use Ramp's reconciliation workspace to spot variances and surface missing entries instantly, so you catch discrepancies before they affect your balance sheet
• Automated accruals: Ramp posts and reverses accruals automatically when context is missing, ensuring all expenses land in the right period for accurate reporting
• Audit-ready records: Every transaction includes receipts, approvals, and coding history, so you have the documentation you need to support balance sheet figures

With Ramp handling the data collection and categorization, you spend less time in Excel and more time analyzing what your balance sheet reveals about your business.

Try a demo to see how Ramp helps finance teams close their books 3x faster.