Need some free spreadsheets to track your income and expenses in your church or nonprofit organization?
Free Accounting Workbooks
To receive your free accounting software downloads described below, simply fill in the form on my free newsletter page or the form above to subscribe to my free newsletter.
My free spreadsheets are just single entry fund accounting spreadsheets. See this basic accounting
page. If your church or nonprofit organization needs to track assets and liabilities, double entry software such as Aplos would the best for your accounting needs.
if you are a start up or small church or nonprofit, my free accounting software downloads may be just
what you are looking for.
See what other individuals are saying about the free accounting spreadsheets.
Note: You must have MS Excel or another compatible spreadsheet
application like OpenOffice installed on your computer to open up and
run these accounting spreadsheets.
The Spreadsheet Package includes:
- Contribution Tracking Workbook
- 5 Fund Automatic Accounting Workbook
- Bank Reconciliation Workbook
- Collection Count Sheet
- Mileage Log Workbook
- Much more - Click here for details
PLUS a Word document with 3 examples of contribution statements for cash, non cash, and quid pro quo donations that you can customize for your own use!
Church Accounting Package
A set of 4 ebooks that covers the following topics...
- Fund Accounting Examples and Explanations
- Setting up a fund accounting system
- Donation management
- Minister compensation and taxes
- Internal controls and staff reimbursements
- Much more - Click here for details
Automatic Free Spreadsheets
PLEASE NOTE: These are "free" spreadsheets! They are made for a very small organization that does not need very many income and expense accounts. Adding more accounts in the "auto populate" spreadsheets require a proficient knowledge of spreadsheets and a LOT of time!
If you need more income and expense accounts, look into an accounting software such as Aplos or QBO or my 5 fund spreadsheet in my Spreadsheet Package.
Please know that if you decide to use them...you are "on your own". I work around 10 hours plus a day in my bookkeeping business, so if you write me and ask for help with these "free" spreadsheets, I cannot answer back and cannot help you set them up =(
This workbook (set of
spreadsheets) consists of monthly general ledgers that automatically
carry all totals to a monthly financial statement and quarterly reports. Then all the totals from the monthly reports automatically generate an annual report.
- 1 Chart of Accounts
- 1 Budget vs Actual Report
- 1 Summary by Month Report
- 12 General Ledgers
- 12 Monthly Reports
- 4 Quarterly Reports
- 1 Annual Report
- 1 Info Page (it is the first tab...please take a moment to read it first)
Manual Free Spreadsheet
This workbook (set of spreadsheets) consists of a monthly general
ledger, monthly report, and an annual report. Unlike my regular
accounting free spreadsheets....only the annual report is automatically
generated. You will have to manually put in all the totals for the monthly
The general ledger is set up for 1 fund
accounts. The monthly report has no formulas (except for set up) and is
easy to modify.
NOTE: The accounting workbooks have an INFORMATION worksheet. It is the first tab on the bottom titled: INFO. Please
take a moment to review this worksheet as well as utilizing the
instructions page on this site. There will be a link to the instruction
page on the INFORMATION worksheet or click here: Accounting Workbook Instructions
The above 1 fund accounting workbook is a bonus for signing up for Free Church Accounting's newsletter; however, if you need an accounting workbook with 5 funds already set up or a contribution tracking workbook, please see the Spreadsheet Package!
If you want to DIY your payroll, I highly recommend you look at using Gusto! It is very user friendly and their support is awesome! Plus they know how to set up and maintain payrolls for churches and nonprofit organizations.
Note: I am a "partner" of Gusto, but as I have told you before ... I never recommend anything that we or our clients have not tried and love =)