Free Spreadsheets: Stressed Out Trying to Keep all Your Church or NonProfit Accounting on Paper?

Maybe I can help.

As I told you on my home page, I built my church and nonprofit accounting spreadsheets for our church secretary who was trying to keep track of all our church's finances on paper.

They made her work a little easier, so I decided to share them and see if they might help someone else.

My free spreadsheets are just single entry fund accounting spreadsheets.

They consist of monthly general ledgers that automatically carry all totals to a monthly financial statement.

Then all the totals from the monthly reports automatically generate an annual report and cash flow statement.

They are set up with 5 columns for 5 separate fund accounts. They also have revenue, expense, and financing accounts set up in the general ledger.

Unless you are proficient in Excel they are a little hard to modify. So if you want something you can modify easily you might want to consider my basic spreadsheets (see description below).

Click here to see what the regular accounting spreadsheets look like.

Okay, I received several comments that my "regular" spreadsheets were just too complex for some churches and was too hard to change to fit their needs. So...I went back to the basics and built some accounting spreadsheets for small churches (without very many separate fund accounts) and startup churches.

They consist of a monthly general ledger, monthly report, and an annual report. Unlike my regular accounting spreadsheets…only the annual report is automatically generated. You will have to hand put in all the totals for the monthly reports.

The general ledger is set up like a paper ledger. It is set up for only 3 separate fund accounts and is not separated into revenue, expense, and financing accounts. The monthly report has no formulas (except for set up) and is easy to change up.

Click here to see what the basic accounting spreadsheets. look like.

If you would like to have either the "Regular Accounting Spreadsheets and Instructions", or the "Basic Accounting Spreadsheets and Instructions" fill out the contact me form and I'll email them to you.

There is no hidden cost, free trial period, or "want all your information so I can sell to the highest bidder" cost.

I just simply want to help churches and nonprofits that do not have the funds to purchase expensive accounting software.

""Bank Reconciliation Spreadsheet and Instructions".

It will help you keep your fund accounting general ledger and bank statement reconciled.

This wonderful chore should be done every month. It is my least favorite accounting chore that I do for our church. It is especially fun if your bank sends out statements on any day but the last day of the month.

So, I am not responsible for any hair pulling, crying, or strong urges to throw your computer out the window these spreadsheets may cause.

Click here to see what the Bank Reconciliation Spreadsheet look like.

It is very important to keep accurate records of your contributions and donations. My free spreadsheet: "Contribution Spreadsheet and Instructions" are pretty simple.

They are set up to do a mail merge for an "Annual Contribution Letter" and will keep a running total of individual contributions.


I have had several requests for a "Collection Count Sheet". It is a simple form to use for your offerings.

This is the one I made for our church. It is very basic, but it works for us. All you need to do is click on the "Church" cell and type in your church's name. Then it is ready to use.

Click here to see what the Contribution Spreadsheet and Collection Count Sheet look like.

Click here to Contact Me to request any of these spreadsheets.

Note: I've put Google Ads on my site because I have to pay an annual fee on this website. I had no idea how to build a website when I got this idea, so I found a wonderful host that helped me build it and does all the upkeep on it.

I want to provide my spreadsheets free of charge and this is a way I can do it.

So...if you see something that interests you...please visit their websites and of course...I hope you come back to mine:)

Return to the home page from "Free Spreadsheets"