Home
Free Stuff What's New
Free Newsletter
Free Spreadsheets
Instructions
Customize Sheets
Freebies
Church Accounting Packages Church Accounting
Accounting  eBook
Manage Contribution
Accounting Basic Accounting
Fund Accounting
Financial Statements
Accounting Software
Contributions Contributions
Annual Statement
Love Offerings
Track Contributions
Administration  Church Budget
Budget Tips
Audits
Staff
Internal Controls
Tax Exempt Status
Records Retention
Reimbursements
Clergy/Minister Clergy Tax
Housing Allowance
Estimated Taxes
Payroll Payroll Set Up
FICA
Form 941
Form W-2
1099-MISC
Annual To-Do List
Misc. QuickBooks
Office Supplies
Fundraiser Tips
Appreciation
Humor
Resources Questions/Comments
Church Web Site
SiteSearch
Resources/Links
Privacy Policy
Disclaimer
Contact Information About Me
Contact Me

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines

 

Free Spreadsheets for Your Church or Nonprofit Accounting Needs


As a special thank you for signing up for my free newsletter- Stewardship, I am offering some of my church accounting spreadsheets, 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 below 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.



(Automatic) Regular Accounting Spreadsheet

free spreadsheets Note: You must have MS Excel installed on your computer to open up and run these accounting spreadsheets.

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 2 available:

One is set up for 5 separate fund accounts.

and the other one is set up for 3 funds.

I have done several revisions, but the spreadsheets still look basically like these pictures.



Basic Accounting Spreadsheet

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




*See instructions for setting up and using my spreadsheets.

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


Additional Resources

Microsoft Office Home and Student 2007 includes 2007 versions of Excel, PowerPoint, Word, and OneNote

One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear—Excel 2007 For Dummies is here.

If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.

Return to Home page from Free Spreadsheets


footer for free spreadsheets page