How to Put Together a Church Expense Spreadsheet

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.

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

Excel 2010

Step

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.

Step

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.

Step

Save your changes by clicking the “Save” icon on the Quick Access Toolbar.

Google Documents

Step

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.

Step

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.

Step

Save your changes by clicking the “Save” icon on the main menu.

OpenOffice

Step

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.

Step

Add your expenses to the spreadsheet. Assign the expenses to an “Account.”

Step

Save your changes by clicking the “Save” icon on the main menu.