How to Put Together a Church Expense Spreadsheet

Create a church expense spreadsheet by adapting current expense report templates.

Organizing a church expense spreadsheet can assist the church is seeing where money is being spent. Expense report templates are available with spreadsheet software or from a variety of websites. These spreadsheets can be adapted to your church's needs. Make minor edits and have a working copy ready in little time.

Instructions

Excel 2010

1. Click the "File" tab and select "New" in the Excel 2010 program. Type "Expense" in the search box. Review the templates that appear. Click the church budget template and the "Download" icon in the right task pane.

2. Review the default template expense in the spreadsheet. Click any expenses that you don't' need and type in the ones that are unique to your church.

3. Save your changes by clicking the "Save" icon on the Quick Access Toolbar.

Google Documents

1. Access the Google Documents website. Type "Church Expense" in the search box. Review the templates that appear. Click the one of the expense template and the "Use This Template" icon in the right task pane.

2. Add your expenses to the spreadsheet. Assign the expense to a "Ministry" and "Account." If a credit card was used, add the last four digits of the credit card in the "Credit Card #" field.

3. Save your changes by clicking the "Save" icon on the main menu.

OpenOffice

1. Access the OpenOffice website. Type "Expense" in the search box. Review the templates that appear. Click the one of the expense template and the "Use This Template" icon in the right task pane.

2. Add your expenses to the spreadsheet. Assign the expenses to an "Account."

3. Save your changes by clicking the "Save" icon on the main menu.

References

• Microsoft: Expense Templates
• Google Documents: Church Expense Templates
• OpenOffice: Expense Report Templates