Release Notes

Version: 2027.01
Release Date: 10/11/2026
Learn how to migrate from an old version to a new version

  • Added a Recurring Transactions worksheet to simplify entering transactions that repeat each month.
    • Enter recurring details once, then copy the transactions into your Journal each month.
    • Leave dates and variable amounts blank until pasted into your Journal.
  • Added a Health Check worksheet to help identify common data-entry and setup errors.
    • Checks for incomplete transactions, dates outside the fiscal year, invalid dropdown values, and amounts that are not numbers.
    • Also checks settings, contacts, funds, account groups, and accounts/budgets for missing information, duplicate values, and other common problems.
    • Each check displays an error count, a link to the sheet with the error, and helpful explanations to help resolve the error when issues are found.
  • Added a customizable Checklist worksheet.
    • Includes example bookkeeping tasks to help organize monthly tasks.
    • Users can change the tasks to match their organization’s needs and track completion throughout the year.
  • Added an optional Receipt Link column to the Journal.
    • Paste links to receipts, invoices, or other supporting documents stored in Google Drive or another online location.
    • Documents remain in their original storage location; the spreadsheet stores the link to connect transactions to supporting documentation.
  • Improved error highlighting (bright red) throughout the workbook.
    • Invalid dropdown values and non-numeric amounts are easier to spot.
    • Duplicate contacts, fund names, account groups, and accounts are highlighted.
  • Improved consistency of fiscal-year date issues.
    • Transactions dated outside the fiscal year are excluded from financial calculations and reports and flagged by Health Check.
  • Adjusted formulas to reduce the chance that rows inserted by the user will be excluded from reports.
  • Added more "protected" ranges, ensuring that users will see a warning when deleting critical columns.
  • Other minor fixes and adjustments to improve reliability and performance.
  • User guide has been updated to reflect changes for version 2027.01

Version: 2026.01
Release Date: 9/6/2025
Learn how to migrate from an old version to a new version

  • Adjusted giving statement to better align donor address with standard window envelopes when printed.
    • If users print via the Google Sheets file menu (not the browser file menu!) with print settings: letter size, portrait, fit to width, normal margins (most of these are the default print settings), then makes the first fold near the faint gray line (above Amount), the donor’s address should be visible in a standard window envelope.
    • This assumes the user does not make any adjustments to columns or rows other than choosing a tax year and donor from their respective dropdowns.
  • Added a Date Controls worksheet to allow users to decide when to "publish" a month to their standard reports.
    • Reports without their own period filters (cell A1) can now have their date range limited by the date control dropdown on the Date Controls worksheet.
    • Setting to “Current Date” (the default) retains the report behavior from previous versions.
    • This can allow users to wait until a month is completed and reconciled before “publishing” the data to these reports.
  • Added a new Monthly Cash Flow report showing each month’s beginning and ending balance, along with monthly revenue, expenses, and net change for the month.
  • User guide has been updated to reflect changes for version 2026.01

Version: 2025.01
Release Date: 1/30/2025
Learn how to migrate from an old version to a new version

  • Moved critical formulas from the Journal worksheet to hidden “admin” worksheets to improve stability and improve performance - reducing the chance that users could inadvertently alter critical formulas previosly hidden on the Journal worksheet.
  • Removed the running balance column from Journal – replaced with single value calculation for the current journal balance at top of the Journal (starting fund balances + net change from all journal transactions). Improves stability and performance.
  • Added instructions/features for users to convert to their local date format using localization.
  • Added a translations table. This allows users to change terminology used throughout the workbook: either to their native language, or to their preferred English terminology.
  • Other minor adjustments to improve stability and performance.
  • User guide has been updated to reflect changes for version 2025.01

Version: 2024.02
Release Date: 2/1/2024
Learn how to migrate from an old version to a new version

  • You can now enter up to 100 funds:
    • Each fund will be classified as “restricted” or “unrestricted”.
    • A new required column was added to the Journal where you’ll select a fund for each transaction.
    • Many new reports were added to track fund balances and fund activity.
    • Donor statements will now show the fund names rather than account names.
    • See the funds user guide for more info.
  • A new column has been added to the Journal allowing you to indicate if revenue from a donor is not tax deductible (quid pro quo). Classifying income as not tax deductible in the journal will exclude the amount from their donor's tax statement.
  • Enhancements to budget reports:
    • Annual and year-to-date budget reports have been broken out into separate reports for easier readability.
    • The difference column in budget reports will now show in green or red as a visual indicator showing if you are over or under budget.
    • You now have greater flexibility for how/when your year-to-date budget values will increase. You can choose to have them increase by 1/12th the annual budget on the first day of the month, or by 1/12th the annual budget on the last day of the month, or by 1/365th daily. This is controlled in the Settings sheet.
  • A link has been added to the “Date” header in the Journal. Clicking this link will take you to the last transaction entered in your Journal.
  • Critical warnings and alerts:
    • On the Accounts/Budget sheet, if you enter a negative annual budget for a revenue account, or a positive annual budget for an expense account, the value will be highlighted in red (critical warning).
    • If you enter a date in your Journal that is outside the fiscal year, it will be highlighted in red (critical warning).
    • If you choose a revenue account in your journal, but enter a negative amount, the amount will be highlighted in yellow (alert). Similarly, if you choose an expense account, but enter a positive value, it will be highlighted in yellow (alert). Alerts can be ignored in some cases (refunds, accruals).
  • Most critical formulas have been hidden to reduce the chances of accidentally altering them. All formulas have also been “protected” so a warning will pop-up if you do something that could alter them.
  • The Check and Notes columns have been added to donor statements (but can easily be hidden if desired).
  • A new sheet to track “in-kind” giving has been added.
  • Improved help:
    • The most critical information for using the templates effectively has been added to the templates themselves.
    • There is now a welcome sheet, with a quick overview of how to get setup, with links to the sheets required for setup (and a recommended order of setup).
    • There are also a couple sheets explaining reports.
    • Many column headers now have helpful notes if you hover or click on them.
    • Links to relevant sections of the user guide have been added throughout.
  • User guide has been updated to reflect changes for version 2024.02