Free Spreadsheets!Need some free spreadsheets to track your income and expenses in your nonprofit organization?As a special thank you for signing up for my free newsletter- Stewardship, I am offering my accounting spreadsheets for nonprofits, completely free of charge. (If you are looking for free accounting software downloads for your "for-profit" small business. Please visit my web site: BasicAccountingHelp.com.
Free Spreadsheets: To receive your free accounting software downloads described below, simply fill in the form on my free newsletter page to subscribe to my free newsletter: 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 accounting software downloads may be just what you are looking for. See what others are saying about the free accounting spreadsheets!
(Automatic) Regular Accounting Spreadsheet
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.
Warning: the automatic spreadsheets are not compatible with Microsoft Works...if you can get them open they will not contain the formulas that automatically carry over the GL totals to the Reports. 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. I have 3 available: One is set up for 5 separate fund accounts, anther one is set up for 3 funds, and the third one is set up for 1 fund. I have done several revisions, but the spreadsheets still look basically like
these pictures.
Basic Accounting 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 hand put in all the totals for the monthly reports.The general ledger is set up for 3 separate fund accounts. The monthly report has no formulas (except for set up) and is easy to modify. Now you can add or delete fund accounts to your heart's content! Click here for detailed step-by-step instructions to modify and customize your basic and regular accounting free spreadsheets. Click here to see pictures of this
free spreadsheet.
Bank Reconcilation Spreadsheets
This workbook (set of spreadsheets) 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 pictures of the
Bank Reconciliation Spreadsheet.
Collection Count SheetIt 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 "Name" cell and type in your organization's name. Then it is ready to use.
*See instructions for setting up and using my
spreadsheets.
Additional ResourcesMicrosoft Office 2010 Home & Student Microsoft Excel 2010 Plain & Simple Return to Home page from Free Spreadsheets |
includes 2010 versions of Excel, PowerPoint, Word, and OneNote. Enjoy the same great features you know and love with Office and get some new ones when you upgrade to Office 2010.
Get the guide that makes learning Microsoft Excel 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.
Church Accounting Package
- Want to learn some basic church accounting basics?
- Need to know how to fill out a noncash donation receipt?
- How about some tips on setting up a fund accounting system?
Would Highly Recommend. Took the mystery out of Church Accounting for me ...more...
Excellent Book! I highly recommend these books.
They are a necessity, WRITTEN IN PLAIN ENGLISH!
Errol James
Real Eye Opener. Not knowing a thing about church finances, this was a real eye opener and a great way to get us started ...more...
Very Helpful and Detailed I would recommend these books to everyone, I am from Canada and would also recommend it to all of the Canadian people involved in the Finance part of the church. Very helpful and detailed. A must get!! ...more...
more testimonies on bottom of this page...
Free Accounting Spreadsheets
when you...
Subcribe to my free newsletter: Stewardship
Your spreadsheets work wonderful-I have Pastored for 17 years in 3 different churches, and this is the best and easiest finance program for the Church that I have seen yet!
Pastor Tim
Thank you so much for sharing your spreadsheets! I expect the Lord will reward you in heaven for helping those of us that needed some quick help...more...
Darla
Free Spreadsheets I've downloaded several of your spreadsheets and I had no problem with them. They have helped me to keep better records, also they are well structured professionally...
more...
Mary
The free accounting spreadsheets were a life saver. I was able to immediately start using them and they saved me more time than I could ever imagine being able to save! I'm now organized!... more...
Recommended Products
