Free Spreadsheets: Thank You Gift

To request your free financial spreadsheets described below, simply fill in the form below to subscribe to my free newsletter: "Stewardship".

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.

P.S. Our church secretary has built her own site: freechurchforms.com. It has free church forms such as a church membership form, a counseling form, reimbursement form, etc. She also has a great membership database at a very reasonable price that will keep track of your membership information and contributions.

My free spreadsheets are just single entry fund accounting spreadsheets. See my Basic Accounting page. If your church or nonprofit organization can afford it, double entry software is the best for your accounting needs.

However, if you are a start up church or nonprofit or cannot afford any accounting software, my free spreadsheets may be just what you are looking for.

Regular Accounting Spreadsheet

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

It is set up for 5 separate fund accounts. It also has revenue, expense, and financing accounts set up in the general ledger.

Unless you are proficient in Excel, it is 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 pictures of the Regular Accounting Spreadsheets

Basic Accounting Spreadsheet

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 modify.

Click here to see pictures of the Basic Accounting Spreadsheets.

Bank Reconcilation Spreadsheets

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 pictures of the Bank Reconciliation Spreadsheet.

Collection Count Sheet

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 "Name" cell and type in your organization's name. Then it is ready to use.

Spreadsheets' Instructions

Note: I've put Google Ads and affiliate partners on my site because I have to pay an annual fee on this website.

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 :)

Tired of living on antacids? Try these natural heartburn remedies that have been proven effective. Visit my website: www.vickeys-home-remedies.com for these and many more home and herbal remedies.

Return to Home page from Free Spreadsheets