Non-Profit Bookkeeping System
Non-Profit Bookkeeping System

$38.95

Add to cart

Non-Profit Bookkeeping System

$38.95

Finally, bookkeeping built for how non-profits actually work.

A complete CPA designed fund accounting system for treasurers and administrators, with donor tracking, giving statements and board ready reports all in one file. No expensive software and no accounting degree required.

  • Fund accounting for up to 10 restricted and unrestricted funds
  • Giving statements for any donor in seconds
  • Up to 1,000 donors with giving history
  • Board and audit ready income and expense statement
  • Monthly, annual and 5 year dashboards
  • Works in Microsoft 365 and Google Sheets

Not a business template with a new name. A real bookkeeping system for non-profits.

Most bookkeeping templates were built for businesses. This non-profit bookkeeping spreadsheet was designed specifically for fund based accounting, with donor tracking, fund management and treasurer reporting built in. It’s structured the way your board and auditor expect to see it, and simple enough for any treasurer or administrator to use with confidence.

What makes it different

Giving statements in seconds. Select any donor and any year, and a complete giving statement is ready for their tax receipt. No more digging through a year of deposits at year end.

True fund accounting. See exactly where your General, Program, Grant and Capital funds stand at any time. Restricted and unrestricted funds are always clear.

What’s included

  • One transaction log. Tag every transaction to a fund, account and donor, with smart prompts guiding each entry.
  • Fund accounting. Track up to 10 customizable funds separately, restricted and unrestricted.
  • Non-profit chart of accounts. Ready to go with donation revenue, grant income, program expenses and administrative costs. Fully customizable.
  • Donor management and giving statements. Up to 1,000 donors with contact details, status and years active.
  • Donor summary. Every donor’s giving month by month for any year, plus a top donors chart.
  • Monthly, annual and 5 year dashboards. Year over year comparisons and key metrics for treasurer and board reporting.
  • Income and expense statement. Generated automatically and always ready for your board or auditor.
  • Account reconciliation. Reconcile your bank accounts and credit cards against your statements.
  • Multi year tracking. Every year in one file, so you never start over.
  • Easy setup tab. Enter your organization name, start year, currency, funds and categories once and they fill in everywhere.
  • Built in checks. Smart prompts guide every entry and keep your reports accurate.

Who it’s for

  • Non-profit treasurers managing donations, grants and program expenses
  • Small and medium organizations that need fund accounting without expensive software
  • Administrators tracking restricted and unrestricted donations across funds
  • Finance committees preparing monthly reports for leadership or the board

What you get

  • Excel file, built for Microsoft 365
  • Google Sheets version that works on any device
  • A filled in example file so you can see everything working before you start
  • Step by step setup instructions
  • Please note: this template is built for Microsoft 365 (including Excel for the web) and Google Sheets. Older versions of Excel may not be fully supported.

Color

Professional Teal

1Instant download

Your files are ready right after checkout. You'll find the download link on your order confirmation page and in your email.

2Excel or Google Sheets

For Excel, unzip the folder first, then open the template. For Google Sheets, open the link in your instructions and click Make a copy. Not compatible with Apple Numbers.

3Setup made easy

Step-by-step instructions are included with every template, plus a video walkthrough for most templates.

4Real support from a CPA

Stuck on something? Send me a message with your template name and I'll help you get set up.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.