Balance Sheet_Quarterly Template

Free Excel download β€’ Use online β€’ Print or share

4 pagesβ€’25–30 min to useβ€’Difficulty: Complexβ€’Signature requiredβ€’Legal review recommended
Learn more ↓
FreeXLSBalance Sheet_Quarterly Template

At a glance

What it is
A Quarterly Balance Sheet is a formal financial statement that reports a company's assets, liabilities, and shareholders' equity at the close of each fiscal quarter. This free Word download gives you a structured, audit-ready starting point you can edit online and export as PDF to share with lenders, investors, boards, or regulatory bodies every 90 days.
When you need it
Use it at the end of each fiscal quarter β€” March 31, June 30, September 30, and December 31 β€” to document financial position for internal reporting, bank covenant compliance, investor updates, or regulatory filings. It is also required when applying for a line of credit, presenting to a board, or preparing for an audit.
What's inside
Current and non-current assets, current and non-current liabilities, shareholders' equity (including retained earnings and paid-in capital), the accounting period header, comparative prior-period columns, and certification or sign-off blocks for the authorized preparer and reviewer.

What is a Quarterly Balance Sheet?

A Quarterly Balance Sheet is a formal financial statement that reports a company's assets, liabilities, and shareholders' equity as of the final day of each fiscal quarter. Unlike an income statement, which measures performance over a period of time, the balance sheet captures financial position at a single point β€” answering the question of what the business owns, what it owes, and what remains for its owners every 90 days. It is structured around the fundamental accounting equation: Assets = Liabilities + Shareholders' Equity, and every figure must reconcile to that equation to the cent. Prepared on an accrual basis under GAAP or IFRS, a quarterly balance sheet is the document lenders, investors, boards, and regulators reach for when they need to assess liquidity, solvency, and capital structure between annual filings.

Why You Need This Document

Without a properly prepared and signed quarterly balance sheet, you risk covenant defaults, stalled credit decisions, and lost credibility with the people who control your access to capital. Commercial lenders typically require a certified balance sheet within 45 days of each quarter-end as a condition of your loan agreement β€” submitting a draft, an unsigned document, or one that doesn't balance can technically trigger a reporting default even when your underlying business is healthy. Investors reviewing your company for follow-on funding or acquisition will cross-reference your quarterly balance sheets against the projections you presented at closing; unexplained gaps between the two end conversations quickly. A clean, consistently prepared quarterly balance sheet also gives your own management team the working capital, debt, and equity data needed to make sound decisions on hiring, capital expenditure, and dividend distributions before the year-end audit surfaces problems that are too late to fix. This template gives you an audit-ready structure, a certification block, and a comparative prior-period column β€” everything required for lender submission or board reporting from the moment you open the file.

Which variant fits your situation?

If your situation is…Use this template
Reporting financial position at fiscal year-end for audit or tax purposesAnnual Balance Sheet
Producing a quick snapshot for internal management review onlyBalance Sheet (Simple)
Filing monthly financials for a bank covenant with tight reporting windowsBalance Sheet Monthly
Preparing a consolidated balance sheet for a parent and subsidiariesConsolidated Balance Sheet
Reporting alongside a quarterly income statement for a full P&L packageIncome Statement Quarterly
Presenting combined financials for an investor data room or Series A roundFinancial Statements Package
Tracking nonprofit fund balances and net assets by restriction classNonprofit Statement of Financial Position

Common mistakes to avoid

❌ Presenting gross accounts receivable without the allowance deduction

Why it matters: Overstated receivables inflate current assets and working capital, potentially masking a covenant breach or misleading a lender on creditworthiness.

Fix: Always net accounts receivable against the allowance for doubtful accounts and disclose both the gross balance and the allowance in the notes or on the face of the statement.

❌ Omitting the current portion of long-term debt from current liabilities

Why it matters: Classifying all long-term debt as non-current understates current liabilities and overstates the current ratio, which lenders use directly in covenant testing.

Fix: Review every loan amortization schedule at quarter-end and reclassify any principal due within 12 months to the current liabilities section.

❌ Leaving the certification block unsigned before external submission

Why it matters: An unsigned balance sheet is a draft document β€” lenders, investors, and auditors will not rely on it for credit decisions, covenant testing, or financial review.

Fix: Obtain the authorized officer's signature and date before distributing the balance sheet to any external party, and retain the signed original on file.

❌ Omitting the comparative prior-period column

Why it matters: A single-period balance sheet gives readers no basis to assess trend, growth, or deterioration β€” most lenders and investors require a comparative statement as a condition of review.

Fix: Always include a second column showing balances as of the immediately preceding quarter or fiscal year-end, using the same line-item structure for direct comparability.

❌ Using a vague accounting period label instead of a specific date

Why it matters: Labels like 'Q1 2026' or 'First Quarter' are ambiguous for covenant testing and audits, which require a precise balance sheet date to match to loan agreements and regulatory filings.

Fix: State the exact calendar date (e.g., 'As of March 31, 2026') in the statement header on every quarterly balance sheet.

❌ Combining paid-in capital and retained earnings into a single equity line

Why it matters: Merged equity disclosure obscures how much capital was contributed versus earned β€” information investors and lenders specifically use to assess capital structure and dividend capacity.

Fix: Present paid-in capital (common stock plus additional paid-in capital) and retained earnings as separate line items, consistent with GAAP and IFRS presentation requirements.

The 10 key clauses, explained

Statement Header and Accounting Period

In plain language: Identifies the company's legal name, the statement title, and the precise date as of which the balance sheet is prepared.

Sample language
[COMPANY LEGAL NAME] | Balance Sheet | As of [QUARTER END DATE, e.g., March 31, 2026] | Prepared in accordance with [GAAP / IFRS / Cash Basis]

Common mistake: Using 'Q1 2026' instead of a specific date like 'March 31, 2026.' Lenders and auditors require a precise balance sheet date to match covenant testing periods.

Current Assets

In plain language: Lists all assets convertible to cash within 12 months β€” cash and equivalents, short-term investments, accounts receivable (net of allowances), inventory, and prepaid expenses.

Sample language
Cash and cash equivalents: $[AMOUNT] | Accounts receivable (net): $[AMOUNT] | Inventory: $[AMOUNT] | Prepaid expenses: $[AMOUNT] | Total current assets: $[TOTAL]

Common mistake: Reporting gross accounts receivable without deducting the allowance for doubtful accounts. This overstates assets and can trigger a covenant breach when the allowance is later corrected.

Non-Current Assets

In plain language: Lists long-term assets including property, plant and equipment (net of accumulated depreciation), intangible assets, long-term investments, and deferred tax assets.

Sample language
Property, plant and equipment (net): $[AMOUNT] | Intangible assets (net): $[AMOUNT] | Long-term investments: $[AMOUNT] | Deferred tax asset: $[AMOUNT] | Total non-current assets: $[TOTAL]

Common mistake: Omitting accumulated depreciation from the PP&E line and presenting gross asset cost instead. Net book value is required for GAAP and IFRS compliance, and the difference can be material.

Total Assets

In plain language: The sum of current and non-current assets β€” the figure that must equal total liabilities plus shareholders' equity (the fundamental accounting equation).

Sample language
TOTAL ASSETS: $[AMOUNT] (Current: $[X] + Non-Current: $[X])

Common mistake: Allowing a balance sheet to go out of balance β€” total assets not equalling total liabilities plus equity. Even a $1 discrepancy signals a data-entry error that invalidates the document for lender or audit use.

Current Liabilities

In plain language: Lists all obligations due within 12 months β€” accounts payable, accrued liabilities, short-term debt, deferred revenue, and the current portion of long-term debt.

Sample language
Accounts payable: $[AMOUNT] | Accrued liabilities: $[AMOUNT] | Current portion of long-term debt: $[AMOUNT] | Deferred revenue: $[AMOUNT] | Total current liabilities: $[TOTAL]

Common mistake: Classifying the current portion of long-term debt as non-current. Any principal payment due within 12 months must be reclassified as current β€” failure to do so understates current liabilities and overstates working capital.

Non-Current Liabilities

In plain language: Lists long-term obligations maturing beyond 12 months β€” term loans, bonds payable, capital lease obligations, pension liabilities, and deferred tax liabilities.

Sample language
Long-term debt (net of current portion): $[AMOUNT] | Deferred tax liability: $[AMOUNT] | Capital lease obligations: $[AMOUNT] | Total non-current liabilities: $[TOTAL]

Common mistake: Omitting deferred tax liabilities entirely. Companies on the accrual basis that use accelerated depreciation for tax purposes typically carry a deferred tax liability β€” leaving it out understates total liabilities.

Total Liabilities

In plain language: The sum of current and non-current liabilities, representing the company's total obligations to creditors and other third parties.

Sample language
TOTAL LIABILITIES: $[AMOUNT] (Current: $[X] + Non-Current: $[X])

Common mistake: Presenting total liabilities without the current/non-current split. Lenders use the split to calculate the current ratio and quick ratio for covenant testing β€” a blended figure forces them to reject the statement.

Shareholders' Equity

In plain language: Presents paid-in capital (common stock plus additional paid-in capital), retained earnings (or accumulated deficit), and any accumulated other comprehensive income or loss.

Sample language
Common stock ($[PAR VALUE] par, [SHARES ISSUED] shares): $[AMOUNT] | Additional paid-in capital: $[AMOUNT] | Retained earnings (deficit): $[AMOUNT] | Total shareholders' equity: $[TOTAL]

Common mistake: Combining paid-in capital and retained earnings into a single 'equity' line. Separate disclosure is required under GAAP and IFRS, and investors rely on retained earnings specifically to assess historical profitability versus capital contributed.

Comparative Prior-Period Column

In plain language: A second column presenting the same line items as of the immediately preceding quarter or fiscal year-end, enabling readers to track changes in financial position.

Sample language
As of [PRIOR PERIOD DATE, e.g., December 31, 2025]: [PRIOR PERIOD AMOUNTS FOR EACH LINE ITEM]

Common mistake: Omitting the comparative column entirely. Most lenders, auditors, and investors expect a two-column statement β€” a single-period balance sheet raises immediate questions about what changed and why.

Preparer Certification and Sign-Off

In plain language: Identifies the authorized preparer (controller, CFO, or external accountant), states the basis of accounting, and includes a signature line with date for the certifying officer.

Sample language
Prepared by: [NAME, TITLE] | Date: [DATE] | Basis of accounting: [GAAP / IFRS / Other] | Certified by: [AUTHORIZED OFFICER NAME, TITLE] | Signature: ________________________

Common mistake: Leaving the certification block unsigned before submitting to a lender or investor. An unsigned balance sheet is treated as a draft β€” lenders will not use it for covenant testing or credit decisions until it is executed.

How to fill it out

  1. 1

    Set the statement header and accounting period date

    Enter the company's full legal name, the document title ('Balance Sheet'), and the specific quarter-end date (e.g., March 31, 2026). State the accounting basis β€” GAAP, IFRS, or cash basis β€” in the header.

    πŸ’‘ Lock the accounting basis in the header before entering any figures. Switching from cash to accrual mid-year invalidates comparisons and can trigger lender questions.

  2. 2

    Populate current assets from your general ledger

    Pull cash, accounts receivable (net of allowance for doubtful accounts), inventory (at cost or net realizable value, whichever is lower), and prepaid expenses from your trial balance as of the quarter-end date.

    πŸ’‘ Reconcile the accounts receivable balance to your AR aging report before entering it β€” a discrepancy between the two is a common audit finding.

  3. 3

    Enter non-current assets with accumulated depreciation

    List property, plant, and equipment at gross cost, then deduct accumulated depreciation to arrive at net book value. Separately disclose intangible assets net of amortization, long-term investments at fair value or cost, and deferred tax assets.

    πŸ’‘ Run a fixed-asset register reconciliation at each quarter-end β€” unrecorded disposals inflate PP&E and total assets.

  4. 4

    List current liabilities including the current portion of long-term debt

    Enter accounts payable, accrued liabilities (wages, taxes, interest), deferred revenue, and the principal payments on long-term debt due within the next 12 months. Reclassify any long-term debt maturing within 12 months from the non-current section.

    πŸ’‘ Review your loan amortization schedules at each quarter-end to catch any debt that should be reclassified as current β€” banks test the current ratio and a missed reclassification skews it.

  5. 5

    Complete non-current liabilities

    Enter term loans and bonds payable net of the current portion, capital lease obligations maturing beyond 12 months, deferred tax liabilities, and any pension or post-retirement benefit obligations.

    πŸ’‘ Confirm deferred tax liability balances with your tax advisor at each quarter-end β€” temporary timing differences compound quickly and the balance is frequently misstated.

  6. 6

    Fill in the shareholders' equity section

    Enter common and preferred stock at par value, additional paid-in capital, and retained earnings (opening balance plus net income for the period minus dividends declared). For entities with accumulated other comprehensive income, present it as a separate line.

    πŸ’‘ Retained earnings is the most frequently misstated equity line β€” tie it back to the prior-period balance plus the net income figure on your quarterly income statement.

  7. 7

    Verify the balance sheet balances

    Confirm that total assets equal total liabilities plus total shareholders' equity. Any discrepancy β€” even $1 β€” must be traced and corrected before the statement is shared externally.

    πŸ’‘ Build a running cross-check formula in the template: =Total Assets - (Total Liabilities + Total Equity) should return exactly $0.

  8. 8

    Add the comparative prior-period column and obtain sign-off

    Populate the second column with balances from the immediately preceding quarter or fiscal year-end. Have the authorized officer β€” CFO or controller β€” review, sign, and date the certification block before distributing.

    πŸ’‘ Store the signed PDF in your accounting records immediately β€” lenders and auditors frequently request the original signed copy months after filing.

Frequently asked questions

What is a quarterly balance sheet?

A quarterly balance sheet is a formal financial statement that reports a company's assets, liabilities, and shareholders' equity as of the last day of each fiscal quarter β€” typically March 31, June 30, September 30, and December 31. It provides a snapshot of financial position at a specific point in time and is used by lenders, investors, boards, and regulators to assess solvency, liquidity, and capital structure every 90 days rather than waiting for the annual audit.

What is the difference between a quarterly balance sheet and an annual balance sheet?

The structure and line items are identical β€” the difference is the reporting period and level of scrutiny applied. An annual balance sheet is typically audited or reviewed by an external CPA and forms part of the year-end financial statements. A quarterly balance sheet is usually internally prepared or compiled and submitted for interim lender reporting, investor updates, or board packages. Both must be prepared on a consistent accounting basis and balance to the cent.

Does a quarterly balance sheet need to be audited?

In most cases, no. Quarterly balance sheets for private companies are typically internally prepared or compiled by an accountant without a formal audit opinion. Public companies registered with the SEC must file reviewed (not audited) quarterly financials on Form 10-Q. However, some loan covenants and investment agreements require quarterly financials to be reviewed or certified by an independent CPA β€” check your specific agreement terms.

What accounting standard should a quarterly balance sheet follow?

In the United States, GAAP (Generally Accepted Accounting Principles) is the standard for most businesses. IFRS is used by companies operating in or reporting to jurisdictions that have adopted it, including Canada (for public companies), the UK, and the EU. Smaller private businesses sometimes prepare balance sheets on a cash or modified cash basis for internal use, but lenders and investors typically require accrual-basis statements. State the accounting basis clearly in the statement header.

Why does a balance sheet need to balance?

A balance sheet must balance because of the fundamental accounting equation: Assets = Liabilities + Shareholders' Equity. Every transaction affects at least two accounts in equal and opposite amounts, maintaining this equality. If the totals do not match, it indicates a data-entry error, a missing transaction, or a misclassified item β€” any of which makes the statement unreliable for decision-making, covenant testing, or audit purposes.

What is working capital and how is it calculated from a balance sheet?

Working capital is calculated as total current assets minus total current liabilities. It measures the short-term liquidity available to fund day-to-day operations. A positive working capital balance means the company can meet its near-term obligations from existing assets. Lenders commonly include a minimum working capital covenant β€” for example, maintaining working capital of at least $500,000 at each quarter-end β€” which makes accurate quarterly balance sheet preparation critical.

Who signs a quarterly balance sheet?

Typically the company's CFO, controller, or chief accounting officer signs the certification block, attesting that the statement has been prepared in accordance with the stated accounting basis and fairly represents the company's financial position. For lender submissions, some loan agreements require the signature of the CEO or an authorized officer in addition to the preparer. Always check the specific requirements in your credit agreement or investor reporting obligations.

Can a quarterly balance sheet be submitted to a bank for a loan?

Yes β€” banks and SBA lenders routinely request interim quarterly balance sheets as part of ongoing covenant compliance monitoring and as supporting documentation for new loan applications. The statement must be signed by an authorized officer, prepared on an accrual basis, and include a comparative prior-period column in most cases. Some lenders require quarterly financials to be compiled or reviewed by an independent CPA before they will accept them.

What is the difference between a balance sheet and an income statement?

A balance sheet reports what a company owns (assets), owes (liabilities), and the residual equity at a single point in time. An income statement reports revenues, expenses, and net profit or loss over a period of time β€” typically a quarter or a year. The two statements are linked: net income from the income statement flows into retained earnings on the balance sheet. Both are required for a complete quarterly financial package.

How this compares to alternatives

vs Annual Balance Sheet

An annual balance sheet is prepared at fiscal year-end and typically subjected to an external audit or review, making it the authoritative year-end financial record. A quarterly balance sheet provides the same snapshot every 90 days for interim monitoring, covenant testing, and investor updates. Annual statements carry greater credibility for financing purposes; quarterly statements provide the frequency lenders require for ongoing compliance.

vs Income Statement Quarterly

A quarterly income statement reports revenues, expenses, and net profit over the 90-day period. A quarterly balance sheet reports financial position β€” what is owned and owed β€” at the period's end date. They are complementary, not interchangeable: lenders and investors require both as part of a complete quarterly financial package, and net income from the income statement feeds directly into retained earnings on the balance sheet.

vs Cash Flow Statement

A cash flow statement explains how cash moved in and out of the business during the quarter β€” through operations, investing, and financing activities. A balance sheet shows the resulting cash balance at period-end alongside all other assets, liabilities, and equity. The cash flow statement answers 'where did the money go?'; the balance sheet answers 'what do we have and owe right now?'

vs Financial Projections (12-Month)

Financial projections are forward-looking estimates of future performance and position based on assumptions. A quarterly balance sheet is a historical record of actual financial position as of a specific past date. Lenders and investors use the quarterly balance sheet to validate whether actual results are tracking against the projections presented during the financing process.

Industry-specific considerations

Financial Services

Regulatory capital ratios (Tier 1 capital, leverage ratio) are calculated directly from quarterly balance sheet figures and reported to banking regulators every 90 days.

Manufacturing

Inventory valuation methods (FIFO, LIFO, weighted average) materially affect current assets on the quarterly balance sheet and must be applied consistently to support lender reporting.

SaaS / Technology

Deferred revenue from annual or multi-year subscriptions is a significant current liability line that grows with ARR and must be correctly split between current and non-current portions.

Real Estate

Investment properties carried at cost or fair value, mortgage debt reclassifications, and interest reserves all require careful quarterly balance sheet presentation for lender covenant compliance.

Healthcare

Accounts receivable net of contractual adjustments and bad-debt allowances is the most scrutinized line item, given the gap between gross billed charges and expected reimbursement from insurers.

Retail / E-commerce

Inventory carrying value, seasonal working capital swings, and gift-card deferred revenue all create material quarterly balance sheet fluctuations that lenders and investors track closely.

Jurisdictional notes

United States

Private companies typically follow US GAAP but are not required to have quarterly financials audited unless contractually obligated by a lender or investor. Public companies must file SEC Form 10-Q with reviewed (not audited) quarterly financials within 40–45 days of quarter-end. Many SBA and commercial loan agreements require quarterly balance sheets certified by an authorized officer. State-chartered financial institutions must file call reports with their primary regulator each quarter.

Canada

Public companies must follow IFRS as adopted in Canada and file quarterly financial statements with SEDAR+ within 45 days of quarter-end. Private companies may use ASPE (Accounting Standards for Private Enterprises) or IFRS; ASPE does not require quarterly reporting but lenders commonly impose it by covenant. Quebec-based businesses must ensure any externally distributed financial statements are available in French upon request under the Charter of the French Language.

United Kingdom

UK-listed companies must comply with the UK Corporate Governance Code and publish half-yearly financial reports; true quarterly reporting is less common for private businesses. IFRS as adopted by the UK is required for listed entities; FRS 102 applies to most private companies. Lenders routinely require quarterly management accounts β€” which include a balance sheet β€” as a covenant condition, even when not legally mandated. Companies House annual filings do not require interim balance sheets, but loan documentation often does.

European Union

The EU Transparency Directive requires regulated markets to publish half-yearly financial reports under IFRS, but many member states and lenders impose quarterly reporting by contract. GDPR considerations apply if the balance sheet or supporting workpapers contain personally identifiable information about customers or employees in accounts receivable or payable details. Germany, France, and the Netherlands have additional local GAAP requirements for private entities. Cross-border lenders operating under ECB supervision frequently require quarterly IFRS balance sheets as a covenant condition regardless of the borrower's domestic requirements.

Template vs lawyer β€” what fits your deal?

PathBest forCostTime
Use the templateSmall and mid-sized businesses preparing quarterly financials for internal use or standard bank covenant complianceFree1–3 hours per quarter
Template + legal reviewBusinesses submitting quarterly financials to lenders under loan covenants, or presenting to institutional investors$150–$500 per quarter (CPA compilation or review)3–5 business days
Custom draftedPublic companies, regulated financial entities, businesses under audit, or those with complex multi-entity consolidations$1,500–$10,000+ per quarter (audit or full CPA preparation)2–6 weeks

Glossary

Current Assets
Assets expected to be converted to cash or used within 12 months, including cash, accounts receivable, inventory, and prepaid expenses.
Non-Current Assets
Long-term assets not expected to be liquidated within 12 months, such as property, plant, equipment, and intangible assets.
Current Liabilities
Obligations due within 12 months, including accounts payable, accrued expenses, short-term debt, and the current portion of long-term debt.
Non-Current Liabilities
Debt and obligations maturing beyond 12 months, such as long-term bank loans, bonds payable, and deferred tax liabilities.
Shareholders' Equity
The residual interest in assets after all liabilities are deducted β€” comprising paid-in capital, retained earnings, and accumulated other comprehensive income.
Retained Earnings
Cumulative net income earned since inception minus all dividends or distributions paid to owners.
Working Capital
Current assets minus current liabilities β€” the net short-term liquidity available to fund day-to-day operations.
Accounting Period
The specific date as of which the balance sheet is prepared β€” for a quarterly statement, typically the last calendar day of the fiscal quarter.
Comparative Period
The prior-period balance sheet column shown alongside the current period to allow readers to identify trends and changes in financial position.
Going Concern
The assumption that a business will continue operating for the foreseeable future β€” a going-concern qualification from an auditor signals material doubt about this assumption.
Accrual Basis
An accounting method that records revenues when earned and expenses when incurred, regardless of when cash changes hands β€” the basis required for GAAP-compliant balance sheets.
Intangible Assets
Non-physical assets with economic value, such as patents, trademarks, software licenses, and goodwill arising from a business acquisition.

Part of your Business Operating System

This document is one of 3,000+ business & legal templates included in Business in a Box.

  • Fill-in-the-blanks β€” ready in minutes
  • 100% customizable Word document
  • Compatible with all office suites
  • Export to PDF and share electronically

Create your document in 3 simple steps.

From template to signed document β€” all inside one Business Operating System.
1
Download or open template

Access over 3,000+ business and legal templates for any business task, project or initiative.

2
Edit and fill in the blanks with AI

Customize your ready-made business document template and save it in the cloud.

3
Save, Share, Send, Sign

Share your files and folders with your team. Create a space of seamless collaboration.

Save time, save money, and create top-quality documents.

β˜…β˜…β˜…β˜…β˜…

"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."

Managing Director Β· Mall Farm
Robert Whalley
Managing Director, Mall Farm Proprietary Limited
β˜…β˜…β˜…β˜…β˜…

"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."

Business Owner Β· 4+ years
Dr Michael John Freestone
Business Owner
β˜…β˜…β˜…β˜…β˜…

"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."

Owner Β· Upstate Web
David G. Moore Jr.
Owner, Upstate Web

Run your business with a system β€” not scattered tools

Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.

Start freeΒ Β·Β No credit card required