Free Nonprofit Balance Sheet Template (Excel & Google Sheets)

Running the finances of a nonprofit organization shouldn’t require an accounting degree. Yet nonprofit leaders often wrestle with complicated financial statements that obscure the organization’s true health, making it hard to plan for the future and report to the board and donors. Clear financial information is essential for decision‑making and transparency.

This free Excel and Google Sheets template helps you build a clear, accurate nonprofit balance sheet (also called a statement of financial position) without jargon or confusion. Nonprofit accounting experts built it with plain‑language prompts that guide you through each line item, and you can use the template alongside accounting software to generate detailed financial information that supports strategic planning.

The template auto‑generates a complete balance sheet tailored for nonprofit organizations, supporting financial transparency so you can focus on your mission instead of spreadsheets.

Key takeaways

• Snapshot of your organization’s health: A balance sheet shows what your nonprofit owns (assets), what it owes (liabilities) and its net worth on a specific date.
• Nonprofits report net assets, not equity: Instead of retained earnings, nonprofits track net assets with and without donor restrictions.
• Build trust and make better decisions: Accurate reports build trust with donors and boards and guide strategic decisions.
• Designed for nonprofit accounting: A template created specifically for nonprofits properly handles designated funds, pledges and mission‑related assets.

What is a nonprofit balance sheet and why does it matter?

A nonprofit balance sheet, formally known as a statement of financial position, shows what your organization owns (assets), what it owes (liabilities) and its net worth (net assets). It’s a key financial statement used for regular reporting and accountability, giving leadership and stakeholders a clear overview of the organization’s financial situation.

A well‑prepared balance sheet lets you:

• Practice good stewardship. Provide transparent data to your board and donors to support financial reporting and accountability.
• Ensure donor compliance. Track restricted gifts and prove funds were used as intended.
• Make informed decisions. Answer questions like “Can we afford a new program?” by using financial statements to understand your organization’s financial situation.
• Maintain financial health. Detect shrinking cash reserves or rising debt early.

Nonprofit balance sheets track restricted and unrestricted funds to ensure compliance with donor directives and financial regulations.

The three core components

A balance sheet follows the basic accounting equation:

Assets = Liabilities + Net Assets

Below is a summary of each section and typical accounts for nonprofits.

1. Assets (what your organization owns)

The assets section provides a clear overview of the organization’s resources, itemizing what you own and categorizing these items for transparency. Nonprofits categorize assets as current, fixed, or other based on liquidity and how quickly they can be accessed or converted to cash.

• Current assets: Cash, receivables (pledges, program service fees), short‑term investments, and operating funds.
• Fixed assets: Buildings, land, vehicles, furniture and equipment. These are depreciated over time.
• Other assets: Long‑term investments, CDs or security deposits.

2. Liabilities (what your organization owes)

The liabilities section details each obligation and the total liabilities owed by the nonprofit.

• Current liabilities: Accounts payable, credit‑card balances, deferred revenue, short‑term loans or the current portion of long‑term debt.
• Long‑term liabilities: Mortgages, capital leases and loans due in more than one year.

Accurate reporting of each liability and the total liabilities is essential for meeting legal requirements. Nonprofits are required to file their balance sheets as part of Form 990 to the IRS annually.

3. Net assets (your organization’s financial worth)

Nonprofits don’t report retained earnings or profits on their balance sheets. Instead, they use net assets to reflect their overall financial position. Net assets represent the nonprofit's total assets minus total liabilities, indicating financial sustainability. Net assets are divided into two categories:

• Without donor restrictions (unrestricted): Funds that can be used for any purpose aligned with your mission.
• With donor restrictions (restricted): Funds earmarked for specific programs, projects or time periods.

Download your free nonprofit balance sheet template

Inside the Excel and Google Sheets file you’ll find:

• Guided structure: Simple prompts for assets, liabilities and net assets, making it straightforward to create accurate financial statements.
• Built‑in formulas: Totals auto‑calculate and confirm that assets equal liabilities plus net assets.
• Nonprofit‑specific accounts: Pre‑filled accounts that you can customize for your organization.
• Sample data: A filled‑out example to help you get started.
• Comprehensive reporting: Use the template alongside accounting software for complete financial management.

Use the form on our tools page to download the template and receive a copy in your inbox. A Google Sheets version is available if you prefer cloud‑based editing.

How to use the template

1. Input your data. Open the Input Data tab and replace the sample numbers with real balances from your accounting system or bank statements.
2. Check the balance sheet. Switch to the Balance Sheet tab and verify that assets equal liabilities plus net assets.
3. Monitor trends. Save or export a copy each month to track changes over time. Analyzing a balance sheet over time can reveal trends that indicate whether a nonprofit is improving or declining financially.

If you need help building other statements, our integrated software can automatically generate financial reports and track donor restrictions.

Common mistakes to avoid

Many nonprofits make these mistakes in financial reporting:

1. Mixing restricted and unrestricted funds, which muddles compliance and donor trust.
2. Skipping depreciation, which overstates the value of buildings and equipment.
3. Omitting liabilities, which inflates net assets and masks cash‑flow pressure.
4. Entering data on formula tabs, which breaks calculations and hides errors.
5. Using a business template, which introduces equity language that doesn’t belong in nonprofit reports.
6. Forgetting to archive copies, which makes year‑over‑year comparisons impossible.

How A Nonprofit Balance Sheet Helps (Example)

Bright Horizons Community Center operates a youth arts program and a community garden. Two years ago, the organization’s leaders discovered that they were mixing restricted and unrestricted funds in a single bank account and weren’t recording depreciation on a van and art equipment. After adopting best practices, they separated restricted grants from general funds, added depreciation schedules and kept a close eye on liabilities.

Within eighteen months, cash reserves grew from $15,000 to $45,000 and the outstanding loan on their building dropped by 30%. When an opportunity arose to purchase additional space for the garden, the board knew they could afford it without jeopardizing existing programs. The clear balance sheet increased donor confidence and helped secure a new grant for capital improvements.

From balance sheet to confident leadership

A clear balance sheet demonstrates responsible stewardship, builds trust within your community and supplies real‑time insight for strategy. Ready to move beyond spreadsheets and manage your resources more effectively?

👉 Try Aplos Free for 15 Days