Non-Profit Bookkeeping: Setup Guide

Help  /  Non-Profit Bookkeeping System

SETUP GUIDE

Non-Profit Bookkeeping System

Thank you for purchasing the Non-Profit Bookkeeping System! This is a complete multi-year bookkeeping system built for charities and non-profit organizations, with donor tracking, fund tracking and in-kind contributions. Work through this guide at your own pace, one step at a time, and keep it handy as a reference as you go.

Step-by-step guide Excel and Google Sheets Donor and fund tracking

VIDEO WALKTHROUGH

Prefer to watch? Coming soon.

A video walkthrough of the full template, tab by tab, is coming soon. In the meantime, the steps below walk you through everything you need to get set up.

COMING SOONVideo walkthrough of the Non-Profit Bookkeeping System

Before you start

First time using the template?

Start here! This is a full bookkeeping system, so follow the steps below in order. Helper notes and smart prompts are built in to guide you as you go.

Not sure where to begin? Work through the steps below in order. Have a quick question? Check the template FAQ.

Protected cells

Your template has locked cells that protect the formulas and links between tabs. Keep the protection on so nothing breaks by accident. You only type in the white cells.

EXCEL

Locked cells can’t be selected or changed. Click a white cell to keep going.

  • Turn protection offReview → Unprotect Sheet
  • Turn it back onReview → Protect Sheet → OK
  • Excel for the webReview → Manage Protection, then switch it off or on
GOOGLE SHEETS

Because you own your copy, Sheets shows a warning instead of blocking you. If it pops up, click Cancel.

  • Turn protection offData → Protect sheets and ranges → click the sheet → trash icon
  • Turn it back onData → Protect sheets and ranges → Add a sheet or range
  • Each tab is separateProtection is set tab by tab, so only remove it where you need to
Before you unprotect: save a copy of your file first, only change what you need, then turn protection back on. Formula cells can’t be undone once they’re overwritten and saved.

Legend

Your template has three kinds of tabs. White cells are always where you type.

INPUT TABS

Where you enter your information.

  • SetupOrganization details, accounts, funds, valuation basis and categories. Do this first.
  • Donor DirectoryYour donor list and contact details. Optional.
  • BudgetYour monthly surplus targets, year by year.
  • Transaction LogWhere you’ll spend most of your time. One row per transaction.
  • Balance SheetUpdated at month end: enter your balance sheet account names and amounts.
REVIEW TABS

Automatic and protected. Some you just read; on others you pick the month, year or donor to view.

  • Chart of AccountsYour categories at a glance, built from the Setup tab. Nothing to select.
  • Income & ExpensePick the year to see monthly income, expenses and surplus.
  • DashboardsPick the month and year for the Monthly, Annual and 5 Year views.
  • Donor Giving StatementPick a donor and year to create their statement.
  • Donor SummaryPick a year to see giving by donor.
  • Unpaid SummaryFilter to see your unpaid and paid transactions.
  • Fund TrackerPick a month and year to see each fund’s balance.
HYBRID TABS

Mostly automatic, with a few white cells where you enter dates, balances or choices.

  • Accounts ReconciliationEnter your statement dates and balances to confirm each account matches.
  • Accounts CustomChoose any date range to check your account balances.
  • Transaction HistorySelect a category to see its transactions.

See a fully populated example

See how everything flows together in a completed version, with 18 months of sample transactions, donors, funds and in-kind contributions. The button opens the Google Sheets example. Using Excel? The example file is in your download folder.

Bank CSV import file

Skip the typing. Paste your bank or credit card transactions into the CSV import file and it lines them up for your Transaction Log. Instructions are inside the file.

The file has two import tabs. Use North America for month first dates (MM/DD/YYYY) or International for day first dates (DD/MM/YYYY). If a date shows a warning, try the other tab.

Using Excel? The CSV import file is in your download folder.

Template FAQ

Have a question or something not working as expected? The template FAQ has quick answers, plus a troubleshooting section for common fixes.

Let’s get started

Jump to a section

Tap a section to jump straight to it. Click any step to collapse or expand it.

Setup tab Your organization details, accounts, funds, payment methods, valuation basis and categories.

Step 1⚙️ Your details

  • Organization Name – enter your organization’s name
  • Charity or Tax Registration Number – this prints on your Donor Giving Statements
  • Start Year – the year you begin using the template
  • Statement Name – select one from the drop down, for example Statement of Operations
  • Currency – replace the dollar symbol with your own
  • Optional: Fiscal Start Month – select the starting month of your fiscal year, or leave it as January if you follow the calendar year. The template confirms your first fiscal year right below, so you know which year to select throughout the workbook. Don’t log transactions before your start date.

Step 2🏷️ Understand your Transaction Types

Your template comes with six Transaction Types. They can’t be edited, and are shown on the Setup tab so you can see what each one is for. Each type is explained in detail in the Transaction Log section below.

Step 3🏦 Set up your accounts

Add up to 10 accounts where money comes in or goes out, like bank accounts, credit cards, PayPal or loans, along with their opening balances. These are used later for your account reconciliations.

  • Your opening balance should reflect the balance at the time you first begin using your template. For example, if you selected January as your starting month and 2025 as your start year in Step 1, enter the opening balances as of January 1, 2025.
  • Bank accounts: enter as positive amounts.
  • Credit cards and loans: enter as negative amounts.

Step 4🎯 Set up your funds or programs

Add up to 10 funds or programs with their opening balances. Each transaction can be tagged to a fund so you can see how money is allocated across different purposes. For example, General Operating for day to day operations, Capital for building repairs, or Youth Program for a specific grant. Your template comes pre-populated with examples, but you can type over them to fit your organization.

  • Restricted? Select Yes if a donor or grant agreement limits how the money can be spent.
  • Purpose or Restriction: a short note on what the fund can be used for.
  • Opening balances should be as of your template start date, the same as your accounts.

Step 5💳 Set up your payment methods

Add up to 10 payment methods used to receive or make payments, for example Cash, Cheque or E-Transfer. This is for your own record keeping and is especially useful for matching cash and cheque donations to your bank deposits.

Step 6⚖️ Set up your In-Kind Valuation Basis

Add up to 10 valuation methods. This is how you decide what a donated item or service is worth, and one is required for every In-Kind Contribution. The template comes with common methods such as the donor’s invoice or receipt, comparable retail price, supplier quote, independent appraisal and fair rental value.

Keep your supportKeep supporting documents for every in-kind value. If you issue official donation receipts, follow CRA (Canada) or IRS (US) rules for what can be receipted and how it’s valued.

Step 7📁 Set up your main categories

Create up to 15 income, 15 expense and 15 in-kind main categories. These are your high level reporting buckets that show up on your Income & Expense statement and dashboards. Keeping the number of main categories limited is intentional. Too many main categories reduces clarity and makes financial analysis harder. Names must be unique.

Income (Monetary)

Money your organization earns or receives, like donations, grants, fundraising events, program fees and interest. For example, 4000 Donations or 4100 Grants.

Expense (By Function)

Money your organization spends. This template groups your expenses by function, the way charities report them:

  • Canada (T3010): Charitable Programs, Management and Administration, Fundraising, and Gifts to Qualified Donees
  • US (Form 990): Program Services, Management and General, and Fundraising
In-Kind (Non Cash)

Donated goods, services or use of space, with no cash coming into your organization. For example, 4900 Donated Food, 4920 Donated Professional Services or 4930 Donated Use of Space. In-kind categories don’t have sub-categories.

Pre-populated categoriesYour template comes pre-populated with income, expense and in-kind main categories, numbered the way an accountant numbers a chart of accounts: 4000s for income, 5000s to 7000s for expenses and 4900s for in-kind. This keeps your reports in a logical order, but it’s just a guide. If they don’t fit your organization, type over them, or clear the cells and start from a blank list.

Step 8📂 Add your sub-categories

Under each income and expense main category, add the detail. First, select the main category from the drop down menu, which automatically lists the main categories you set up in Step 7. Then type the sub-category next to it. For example, 5000 Program Expenses might include Program Salaries & Wages, Program Supplies & Materials and Participant Support. They all roll up into their main category on your reports.

  • Up to 75 income and 75 expense sub-categories
  • To maintain performance and ensure the template runs smoothly, each main category is limited to 25 sub-categories.
  • Your categories won’t appear in the Transaction Log until this step is complete.
  • Sub-categories also come pre-populated and numbered to match their main category (for example, 4010 Individual Donations under 4000 Donations). Keep them, type over them, or clear them and add your own.

DuplicatesIf a category or sub-category is highlighted on the Setup tab, it’s a duplicate. Rename or remove it so your reports stay accurate.

Why it works: This structure mirrors how professional accounting systems are designed. It gives you detailed tracking at the transaction level while keeping dashboards and reports clean, readable, and decision focused.

Optional👀 Hide notes

Helper notes are built in throughout the workbook. To hide them for a cleaner view or for printing, tick the checkbox (Google Sheets) or type YES (Excel). Clear it any time to bring them back.

Golden rule for your Setup tab

Once you’ve entered transactions, don’t rename anything you’ve set up: your accounts, funds or programs, payment methods, valuation basis, categories and sub-categories, or donor names in the Donor Directory. Your transactions are linked by name, so renaming breaks the links between tabs.

Don’t need one? Simply leave it as is or leave the cell blank. You can always add new ones as you need them.

Chart of Accounts A clean view of how your categories roll up.
No manual input required

The Chart of Accounts tab is automatically generated based on the categories you define in the Setup tab. As you add or update income, expense and in-kind categories in the Setup tab, they will automatically appear here, organized by Main Category and Sub-Category.

Error checkCheck the warning at the top of the tab. If any income or expense main category is missing a sub-category, a red warning appears and those transactions won’t show on your dashboards. Clear the warning before you move on.

Donor Directory Your donor list. Optional, but it powers your giving statements.

If your organization tracks donors for giving statements, receipts or tax filing, enter your donors here. The names feed the Donor Name drop down in your Transaction Log, the Donor Giving Statement and the Donor Summary.

  • Donor ID is assigned automatically in sequential order. Don’t edit it.
  • Donor Name is the only required field. Each name must be unique.
  • Optional fields: Status (Active, Pending or Inactive), Donor Type, Contact Person, Address, Phone, Email, Receipt Preference and Comments.
  • Contact Person is for businesses, foundations and groups. It shows as “Attention” on the donor’s giving statement.
  • First Gift Date and Last Gift Date calculate automatically from your Transaction Log and can’t be edited.

Not tracking donors?Simply leave this tab blank or hide it, along with the Donor Giving Statement and Donor Summary. It won’t affect any other part of the template.

Budget Set your surplus goal for each month.

Enter your budgeted surplus (deficit) by month. Your dashboards use it to track your progress.

  • Budget up to 10 years, starting with the Start Year on your Setup tab
  • No need to fill in every year now. Add each year’s budget when it begins.
  • Enter a positive number for a planned surplus and a negative number for a planned deficit
  • Totals calculate on their own and flow into your dashboards
Transaction Log This is where you record every transaction. Do this daily or weekly as you go.

Every report in the template is built from this tab, so this is where you’ll spend most of your time. Date, Amount and Transaction Type are always required. The Transaction Type you pick decides what else is needed, and the Smart Prompt column tells you exactly what’s missing.

Step 1🗓️ Input date of transaction

Enter the date the donation was received, the bill was dated or paid, or the purchase was made. This is the transaction date. It’s often the same date the money shows on your bank or credit card statement, but it doesn’t have to be. If the money is paid or received later, tick Unpaid and enter the Paid or Received Date once it moves (see Pay or receive later).

If a date is not entered correctly, a pop-up will appear. Ensure a valid date is entered.

Step 2✏️ Enter the Description

Enter a description for the transaction. This is for your own recordkeeping and can be as brief or detailed as you like. You can also use the description directly from your bank statement.

Step 3💰 Enter the amount or value

Enter all amounts as positive values, except for the following cases:

  • Returns and Discounts → negative values
  • Expense Recoveries (e.g., insurance reimbursement or grant refund) → negative values

For an In-Kind Contribution, enter the fair value of the donated item or service.

💡 Save timeSteps 1 through 3 can be completed all at once using the CSV import method. It’s a great way to bring in your bank and credit card transactions and get started quickly. You can still add transactions that aren’t on your statements, like in-kind contributions or unpaid bills, as part of your month end close. See CSV Import at the bottom of this step.

Step 4🏷️ Pick your Transaction Type

This is the most important field. The following are the transaction types, and they decide which columns you need to fill in.

Shows on your Income & Expense statementMoves cash between, into or out of your accounts only

Income

Money your organization earns or receives, such as donations, grants, event sales, program fees and interest

  • Select a Category and Sub-Category
  • Select a To Account (where the money was deposited) and leave From Account blank
  • Optional: select the Donor Name and the Fund or Program
  • If the money is received on a later date than the transaction date, tick Unpaid (see Pay or receive later)
In-Kind Contribution

Donated goods, services or use of space, with no cash coming into your organization

  • Select an In-Kind Category (no sub-category needed)
  • Select a Valuation Basis
  • Leave To Account and From Account blank
  • Optional: select the Donor Name and the Fund or Program
Expense

Money your organization spends on its programs, administration and fundraising, such as supplies, rent, wages and bills

  • Select a Category and Sub-Category
  • Select a From Account (where it was paid from) and leave To Account blank
  • Optional: select the Fund or Program
  • If the money is paid on a later date than the transaction date, or paid personally by a volunteer, board member or staff member, tick Unpaid (see Pay or receive later)
Transfer

Money moved between your own accounts, such as chequing to savings or paying the credit card (see the FAQ).

  • Select both a From Account and a To Account
  • Leave everything else blank
Other Deposit

Money received that is not income, such as a refund, insurance claim, loan proceeds or petty cash deposit

  • Select a To Account only
  • Leave everything else blank
Other Withdrawal

Money taken out that is not an expense, such as a loan repayment, bank correction or withdrawal to petty cash

  • Select a From Account only
  • Leave everything else blank

Don’t worry!You don’t need to memorize this. As you enter each transaction, the Smart Prompt column in your Transaction Log will guide you and show a clear message if something needs to be fixed.

Step 5🤝 Who and what for

All three fields below are optional.

  • Payment Method: how the money was received or paid, based on the methods you set up in Step 5 of the Setup tab. Useful for matching cash and cheque donations to your bank deposits.
  • Donor Name: names come from your Donor Directory. Select the donor for each gift so it flows into the Donor Giving Statement and Donor Summary.
  • Fund or Program: tag a donation, grant or expense to the fund it relates to. Only transactions with a fund selected appear in the Fund Tracker. If it doesn’t relate to a specific fund, leave it blank.

Step 6📂 Select your Category and Sub-Category

  • The drop down shows only the categories that match your Transaction Type: income categories for Income, expense categories for Expense, and in-kind categories for In-Kind Contributions.
  • Required for all Income, Expense and In-Kind transactions. These selections drive your dashboards and Income & Expense statement.
  • Sub-Category is required for Income and Expense only.
  • Not required for transfers, deposits or withdrawals.

Step 7⏳ Pay or receive later

Tick Unpaid? if the money is paid or received after the transaction date, then enter the Paid or Received Date once it happens. This applies to Income and Expense only. See Pay or receive later below for how it works, with examples.

Step 8🏦 Select your Accounts

  • Select the To and/or From Account based on the Transaction Type. These drive your Accounts Reconciliation and Accounts Custom tabs.
  • For an unpaid transaction, leave the account blank until it’s paid or received.

Step 9⚖️ Select the Valuation Basis (In-Kind only)

For every In-Kind Contribution, select how you valued it, from the list you set up in Step 6 of the Setup tab. Leave it blank for all other transaction types.

Optional📝 Notes

Add anything you’d like to remember, such as a cheque number, grant reference or who approved the payment.

Step 10⚠️ Check your warning counter before reviewing dashboards

The counter at the top of the Transaction Log must show “No errors flagged” before your dashboards will be accurate. If you see a warning, the row will tell you exactly what to fix. Just follow the message.

  • Warning: something needs to be fixed, such as a missing Transaction Type, the wrong Category for the Transaction Type, a missing account, or a Transfer with the same From and To Account.
  • Reminder: not an error. It means a transaction is still unpaid. The counter shows how many, for example “Reminder: 2 transaction(s) unpaid.”

💡 CSV Import: Copy and Paste from your Bank Statement

You can save significant time by copying transactions directly from your bank statement CSV download instead of entering them one by one. See the separate “CSV Import File” included in your downloads, which includes detailed instructions.

The file has two import tabs. Use North America for month first dates (MM/DD/YYYY) or International for day first dates (DD/MM/YYYY). If a date shows a warning, try the other tab.

  1. Download your bank statement as a CSV from your online banking portal, and open the CSV and arrange your columns to match the Transaction Log order: Date, Description and Amount.
  2. Use Paste Special (not regular paste) to paste values only. This preserves the existing formatting and formulas in the template. You can paste directly into the Transaction Log, or use the CSV Import File for assistance.
  3. Once pasted, go through each row and select the Transaction Type, Category, Sub-Category and Accounts from the dropdowns.
Pay or receive later How the Unpaid checkbox works for bills, reimbursements and money still to come in.

Sometimes the money moves on a different day than the transaction. A bill arrives in March but is paid in April. A volunteer buys supplies with their own card and is repaid later. A grant is approved in June but deposited in July. The Unpaid? checkbox handles all of these, so your reports and your bank balances are both right.

When to tick Unpaid

Bills paid later

An Expense you owe but haven’t paid yet, such as a utility bill or an invoice from a contractor. In accounting, this is an accrued expense or accounts payable.

Reimbursements

An Expense paid personally by a board member, volunteer or staff member that the organization will repay. Record it as an Expense on the purchase date and tick Unpaid until they’re repaid.

Money still to come in

Income you’ve earned or been promised but haven’t received yet, such as an approved grant, a sponsorship invoice or program fees billed to a partner. In accounting, this is accrued income or accounts receivable.

Only for Income and ExpenseUnpaid only applies to Income and Expense. Leave it unticked for In-Kind Contributions, Transfers, Other Deposits and Other Withdrawals.

How to enter it

  1. On the transaction date: enter the Expense or Income as usual, with the Category and Sub-Category. Tick Unpaid? and leave the From Account (Expense) or To Account (Income) blank.
  2. While it’s unpaid: the Smart Prompt shows a Reminder, for example “Pending. Once paid, enter the Paid or Received Date and the From Account.” This is not an error, and the counter at the top shows how many transactions are still unpaid.
  3. Once it’s paid or received: go back to the same row and enter the Paid or Received Date and the account. Keep the Unpaid box ticked. The reminder clears on its own.

See everything in one place: every transaction with Unpaid ticked also shows on the Unpaid Summary tab, so you can see what’s still outstanding at a glance. See Unpaid Summary below.

Approval Status (optional): use it to track where a transaction is, such as Draft, Pending Approval or Approved, for example while a reimbursement waits for sign off. It’s for your own records only and doesn’t affect any calculations.

How it shows in your reports

Transaction Date

Income & Expense and dashboards

Your Income & Expense statement, dashboards, Fund Tracker, Donor Giving Statement and Donor Summary use the transaction date. The income or expense shows in the month it was earned or incurred, whether or not it’s been paid.

Paid or Received Date

Accounts Reconciliation and Custom

Your account tabs use the Paid or Received Date, so your balances only change when the money actually moves, matching your bank statement. Until a date is entered, the transaction stays out of your account balances.

Note: If Unpaid is not ticked, your account tabs use the transaction date instead.

Example
  • March 3: a volunteer buys $85 of program supplies with their own card. Enter an Expense dated March 3 under 5030 Program Supplies & Materials, tick Unpaid, and leave From Account blank.
  • April 20: you repay the volunteer by e-transfer. On the same row, enter April 20 as the Paid or Received Date and Checking Account as the From Account.
  • Result: the $85 shows as a March expense on your Income & Expense statement, and your Checking Account drops by $85 in April. At the end of March, it shows as unpaid on your Unpaid Summary.
Income & Expense Your surplus by month, in a summary and a detailed view.
No manual input required (other than the year)

Enter the year and your Income & Expense statement fills in from the Transaction Log, using the categories from your Setup tab. The title uses the statement name you picked in Setup, such as Statement of Operations. Blue cells calculate on their own.

  • Summary view: main categories only, for a clean, high level view
  • Detailed view: every sub-category under its main category, listed alphabetically, so you can see exactly what makes up each category line
  • Surplus (Deficit): your income less your expenses for each month and the year
  • In-Kind Contributions: shown in their own section below your Surplus (Deficit), so they never change your surplus or your cash. Total Support Received shows your income plus in-kind, for a full picture of the support you received.
  • Net Cash Flows: Other Deposits and Other Withdrawals are shown last, so you can see your surplus after cash movements

Both views stay in sync automatically.

Monthly, Annual and 5 Year Dashboards Select a month or enter a year and your charts fill in.

Monthly Dashboard

Select a month and enter the year to automatically populate the Monthly Dashboard for the selected period. The dashboard provides a high level view of key metrics, including total income, total expenses, surplus (deficit), surplus margin, expenses as a percentage of income, income and expenses by category, in-kind contributions, and progress toward your budget.

  • Automatic prior year comparison: prior year results populate automatically, so you can quickly review variances and identify seasonal trends.
  • 15 month trailing chart: when a month is selected, income, expenses and surplus for the prior 15 months are displayed to help visualize performance trends over time.
    • For example, selecting May 2026 populates May 2025 comparatives and displays a trailing period from March 2025 through May 2026.

Annual Dashboard

Enter the year to automatically populate the Annual Dashboard for the selected year. This dashboard provides similar charts and key metrics as the Monthly Dashboard but presents results by month across the full year, along with full year totals and in-kind contributions.

5 Year Dashboard

Enter the first year in the 5 year range to automatically populate the 5 Year Dashboard. The following four years will auto populate, displaying totals and visual charts for the full five year period.

This dashboard provides a high level view of long term performance, including income, expenses, surplus and key trends over multiple years. Use this view to assess growth, consistency, and overall financial direction, or to support grant applications and board reports.

Transaction History Drill into the transactions behind any category.
No manual input required (other than category selection)

The Transaction History tab provides a consolidated, read only view of all transactions entered in the Transaction Log. All data flows in automatically.

  • Two sides: income and in-kind history on the left, expense history on the right
  • Select the type on the income side: Monetary for cash income, or In-Kind for donated goods and services
  • Filter by main category to view all related activity
    • To drill down further, select a sub-category to narrow your results
    • Optional: filter by year by entering the year directly

This drill down functionality mirrors how professional accounting systems allow users to explore general ledger activity. It helps you understand your transactions, investigate variances, and analyze activity at both a high level and a detailed level.

Unpaid Summary Everything you’ve ticked as Unpaid, in one list.
No manual input required (other than the filter)

Every transaction with Unpaid ticked in your Transaction Log flows here automatically. Use the filter to choose what you see:

  • All: every transaction ticked Unpaid, paid or not
  • Unpaid: transactions with no Paid or Received Date yet. This is what’s still outstanding.
  • Paid: transactions that have since been paid or received

Each row shows the date, transaction type, description, amount, category, sub-category, approval status and paid date. The total at the top shows Income and Expense separately for the filter you selected.

Owed by you or to you?Look at the transaction type. Expense transactions are amounts you owe, like bills and reimbursements. Income transactions are money owed to you, like an approved grant not yet deposited.

Donor Giving Statement and Donor Summary Thank your donors and see who’s giving.

Both tabs pull from the Income and In-Kind Contributions in your Transaction Log that have a Donor Name selected. Contributions are based on the calendar year (January to December) to match your donors’ tax receipts.

Donor Giving Statement

A printable statement for each donor

  1. Enter your contact information once at the top: your address, email and phone. Your organization name and registration number come from the Setup tab.
  2. Select a Donor Name and enter the year.
  3. The donor’s contact details, last gift date and every contribution for the year fill in automatically, with monetary and in-kind totals shown separately.
  4. Print or save it as a PDF to send with your thank you.
Donor Summary

Giving by donor for the year

Enter the year to see total contributions, the number of contributions and your top 5 donors. The table lists every donor who gave that year, sorted from largest to smallest, with:

  • Gift count, monetary, in-kind and total contributions
  • Giving insights: last gift date, largest gift, prior year total and the variance from last year

Not an official receiptThe giving statement summarizes contributions received. It is not an official receipt for income tax purposes unless you issue it as one. If you’re a registered charity, follow CRA or IRS rules for official donation receipts.

Account Reconciliation Two ways to review your account balances. Use one or both.

This template includes two ways to review your account balances. Both tabs allow you to monitor all cash activity across your accounts, including bank and credit card statements. All transactions flow automatically from the Transaction Log based on the account selected.

ImportantFor this to function properly, each transaction must include the correct From Account or To Account. Unpaid transactions are included on their Paid or Received Date, once it’s entered.

Review each option to decide which is more suitable for you, and hide the other tab. Or feel free to use both!

Option 1

Accounts Custom tab

A flexible way to monitor cash activity across your accounts using custom date ranges. Great for checking balances for any period you choose. It does not perform statement reconciliation.

Custom View

  • Input the “From” and “To” date.
  • The opening balance reflects all activity before the “From” date, plus the opening balance entered in the Setup tab.
  • It pulls all transactions in the Transaction Log within the selected date range and calculates the ending balance for each account.
Option 2

Accounts Reconciliation tab

Reconcile your accounts directly to your bank or credit card statements, similar to traditional accounting software. The template determines the statement period and compares the balance from your Transaction Log to the balance on your statement.

Accounts Reconciliation View

  1. Select the Account: scroll to the Input Section on the far right of the tab and choose the account from the drop-down menu. The list comes from your account setup in the Setup tab.
  2. Enter the Statement Start & End Date exactly as shown on your bank or credit card statement.
  3. Enter the Statement Balance: the ending balance from your statement.
  4. Let the template do the rest: it pulls every transaction from your Transaction Log within the statement period, calculates the ending balance and compares it to the statement balance you entered.
  • If the difference falls within the tolerable range ($), the account displays “Reconciled.” You can set this range at the top of the Input Section.
  • If it displays “Unreconciled,” review your Transaction Log to ensure all transactions have been entered correctly, including any unpaid items that now have a Paid or Received Date.
Both options include
  • Current View: the opening balance reflects the first day of the template start date defined in the Setup tab, and pulls all transactions from the beginning of the year up to and including today’s date to calculate the ending balance for each account.
  • Summary Charts: key metrics are summarized at the top of the tab for a quick overview, and two charts on the left show total cash flow activity and ending balances across all accounts.

First monthThe statement start date defaults to the template start date defined in the Setup tab. For example, if the template begins in January 2026 and your first statement ends on January 25, 2026, transactions will be pulled from January 1 to January 25, 2026. Any activity before the template start date should be reflected in the opening balances entered in the Setup tab.

ImportantOnly one statement date per account per month should be entered. Duplicate months will trigger an error warning, and statement dates should be entered in chronological order.

Fund Tracker See how much is left in each fund or program.
No manual input required (other than the month and year)

Select a month and enter the year to see the balance of every fund you set up in Step 4 of the Setup tab. Only transactions tagged with a Fund or Program in the Transaction Log are included.

  • Year to date and current balances: total inflows, outflows and the ending balance across all funds
  • Monthly fund reconciliation: for each fund, the opening balance, receipts, expenses, other deposits, other withdrawals and the ending balance for the selected month
  • Month end fund balances and a chart of monthly inflows vs outflows

Watch restricted fundsIf a restricted fund goes negative, more has been spent than was received for that purpose. Check that expenses are tagged to the right fund, or that the income for that fund has been recorded.

Balance Sheet Enter your month end balances once your books are done.

At the end of each month, once all your transactions are in, enter the closing balances for your bank accounts, petty cash, credit cards, loans and other assets and liabilities. The account names are a starting point, so rename them to fit your organization.

Using Unpaid?At the end of each month, go to your Unpaid Summary tab and filter for Unpaid. The total at the top shows your accounts receivable (Income, money owed to you) and accounts payable (Expense, amounts you owe). Enter these totals on your Balance Sheet.

At the end of your fiscal year

Since this is a multi-year template, the Balance Sheet doesn’t roll forward on its own.

  1. Save or export a copy of your completed Balance Sheet for your records.
  2. Clear the balances in the template.
  3. Start the new year with fresh opening balances.

That’s it. Close your month with confidence and be ready for year end.

Disclaimer: This template is provided for non-profit bookkeeping and reporting purposes only and does not constitute professional financial, accounting, or tax advice. It does not issue official donation receipts or prepare charity filings such as the T3010 or Form 990. Always review your numbers carefully and consult a qualified professional before making financial or tax decisions.

© 2026 InsightSheets. For personal and organizational use only. Not for resale or redistribution.