Home
What's New
Free Newsletter
Church Web Site
Free Spreadsheets
Basic Accounting
Accounting eBook
Fund Accounting
Contributions
Track Contributions
Annual Statement
Tax Exempt Status
 Church Budget
Audits
Internal Controls
Staff
Housing Benefit
Reimbursements
Clergy Tax
Payroll Set Up
FICA
Form 941
Form W-2
1099-MISC
Annual To-Do List
Freebies
Savings
Fundraiser Tips
Fundraising
Appreciation
Humor
FAQs
Customer Service
About Me
Contact Me
SiteSearch
Resources/Links
Disclaimer
Build a Website

[?] Subscribe To This Site

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

 

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

Enter your E-mail Address
Enter your First Name (optional)
Then

Don't worry -- your e-mail address is totally secure.
I promise to use it only to send you Stewardship E-zine.

As a special thank you for signing up for my free newsletter "Stewardship", I am offering all four of my church accounting spreadsheets, completely free of charge.

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

free spreadsheets This workbook (set of spreadsheets) consists 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.

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

basic accounting This workbook (set of spreadsheets) consists 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 modify.

Click here to see pictures of the Basic Accounting Spreadsheets.



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.




Spreadsheets' Instructions

Regular Accounting Instructions


Basic Accounting Instructions


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


The information provided on this site is not meant to substitute for the advice and covered opinions of a qualified tax professional. The materials contained on this website are provided for general information purposes only and do not constitute legal or other professional advice on any subject matter. The tax advice on freechurchaccounting.com does not fall within the IRS definition of a covered opinion; therefore, it cannot be used to avoid IRS penalties. www.freechurchaccounting.com does not accept any responsibility for any loss which may arise from reliance on information contained on this site or use of its free software.



Return to Home page from Free Spreadsheets


footer for free spreadsheets page