FREE TEMPLATE
Get your free
Profit & Loss Tracker
A simple monthly profit and loss tracker for Excel and Google Sheets. Try it out first, completely free.
SEND MY FREE TRACKERJoin the list and claim your free template
Instant download · One-time purchase · No subscription
Help / Non-Profit Bookkeeping System
SETUP GUIDE
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.
VIDEO WALKTHROUGH
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.
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.
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.
Locked cells can’t be selected or changed. Click a white cell to keep going.
Because you own your copy, Sheets shows a warning instead of blocking you. If it pops up, click Cancel.
Your template has three kinds of tabs. White cells are always where you type.
Where you enter your information.
Automatic and protected. Some you just read; on others you pick the month, year or donor to view.
Mostly automatic, with a few white cells where you enter dates, balances or choices.
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.
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.
Have a question or something not working as expected? The template FAQ has quick answers, plus a troubleshooting section for common fixes.
Jump to a section
Tap a section to jump straight to it. Click any step to collapse or expand it.
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.
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.
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.
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.
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.
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.
Money your organization earns or receives, like donations, grants, fundraising events, program fees and interest. For example, 4000 Donations or 4100 Grants.
Money your organization spends. This template groups your expenses by function, the way charities report them:
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.
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.
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.
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.
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.
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.
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.
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.
Enter your budgeted surplus (deficit) by month. Your dashboards use it to track your progress.
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.
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.
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.
Enter all amounts as positive values, except for the following cases:
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.
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
Money your organization earns or receives, such as donations, grants, event sales, program fees and interest
Donated goods, services or use of space, with no cash coming into your organization
Money your organization spends on its programs, administration and fundraising, such as supplies, rent, wages and bills
Money moved between your own accounts, such as chequing to savings or paying the credit card (see the FAQ).
Money received that is not income, such as a refund, insurance claim, loan proceeds or petty cash deposit
Money taken out that is not an expense, such as a loan repayment, bank correction or withdrawal to petty cash
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.
All three fields below are optional.
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.
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.
Add anything you’d like to remember, such as a cheque number, grant reference or who approved the payment.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Both views stay in sync automatically.
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.
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.
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.
The Transaction History tab provides a consolidated, read only view of all transactions entered in the Transaction Log. All data flows in automatically.
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.
Every transaction with Unpaid ticked in your Transaction Log flows here automatically. Use the filter to choose what you see:
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.
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.
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:
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.
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!
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
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
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.
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.
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.
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.
Since this is a multi-year template, the Balance Sheet doesn’t roll forward on its own.
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.
Most questions are answered in the FAQ. Still stuck? Send me a message and I’ll help you get set up.