The new Statement of Income and Expense has received more customizations in addition to retaining most, if not all, of the formatting from previous versions of the report under the name Treasurer reports.
Statement of Income and Expense report > Current Month, YTD, budget remaining format
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year. It does not matter what you choose for the month in the Period field for this format
- Choose any book/fund, responsibility, and church body selections, if any.
- For the format, choose "Current month, YTD, budget remaining".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- Choose if and where you would like pages to break in the report.
- Click Print to preview your report.
Statement of Income and Expense report > Current Month and YTD
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book/fund, responsibility, and church body selections, if any.
- For the format, choose "Custom report".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- For the column selections, choose:
- Actual for Period
- Budget for Period
- Actual for Year-to-date
- Budget for Year-to-date
- (blank)
- Click Print to preview your report.
Statement of Income and Expense report > Treasurer's Report
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book/fund, responsibility, and church body selections, if any.
- For the format, choose "Treasurer's report".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- Click Print to preview your report.
Statement of Income and Expense report > All months: actual
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year. It does not matter what you choose for the month for this format.
- Choose any book/fund, responsibility, and church body selections, if any.
- For the format, choose "All months: actual".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- Click Print to preview your report.
Statement of Income and Expense report > All months: actual less budget
- Go to the Other reports tab of the Finance module.
- If not selected by default, choose the "Account and trial balance report" from the list of report options to the left of the window.
- Choose the finance year you want to report on. Choose the last month of your fiscal year as the ending month.
- Choose any books/funds, account types, responsibility, and church body selections, if any.
- For the format, choose "Budget vs actual".
- Check any options you would prefer for your report, including showing monthly totals.
- Click Print to preview your report.
Statement of Income and Expense report > All months: budget
There are a few different areas where you can get the budget for all months in a finance year.
The most straightforward would be the under the Plan / Analyze button.
- Go to the Plan / Analyze tab of the Finance module.
- Go to the Budgeting section.
- Choose the finance year you want to report on.
- Choose the fund you want to report on.
- Choose the types of accounts you want to show and whether you want to filter out inactive accounts.
- Click Print to preview your report.
Statement of Income and Expense report > All months: budget vs actual
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year. It does not matter what you choose for the month for this format.
- Choose any book/fund, responsibility, and church body selections, if any.
- For the format, choose "All months: actual vs budget".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- Click Print to preview your report.
Statement of Income and Expense report > One month: actual, budget, prior year
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book/fund, responsibility, and church body selections, if any.
- For the format, choose "Custom report".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- For the column selections, choose:
- Actual for Period
- Actual 1 year ago for Period
- Budget for Period
- Budget 1 year ago for Period
- (blank)
- Click Print to preview your report.
Statement of Income and Expense report > One month: actual, prior year, change
There isn't an exact translation to this report as the percentages are calculated differently.
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book/fund, responsibility, and church body selections, if any.
- For the format, choose "Custom report".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- For the column selections, choose:
- (blank)
- Actual 1 year ago for Period
- Actual for Period
- Change: col. 3 less col. 2 "Budget Remaining"
- Percent: col. 2 divided by col. 3 "Percent of Budget"
- Click Print to preview your report.
Statement of Income and Expense report > One month: five-year trend
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book, responsibility, and church body selections, if any.
- For the format, choose "Period history".
- Choose the level of detail you'd like your report to generate.
- Check any options you'd prefer for your report.
- Click Print to preview your report.
Statement of Income and Expense report > Year-to-date: actual, budget, prior year
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book, responsibility, and church body selections, if any.
- For the format, choose "Custom report".
- Choose the level of detail you'd like your report to generate.
- Check any options you'd prefer for your report.
- For the column selections, choose:
- Actual for Year-to-date
- Actual 1 year ago for Year-to-date
- Budget for Year-to-date
- Budget 1 year ago for Year-to-date
- (blank)
- Click Print to preview your report.
Statement of Income and Expense report > Year-to-date: actual, prior year, change
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book, responsibility, and church body selections, if any.
- For the format, choose "Custom report".
- Choose the level of detail you'd like your report to generate.
- Check any options you'd prefer for your report.
- For the column selections, choose:
- (blank)
- Actual 1 year ago for Year-to-date
- Actual for Year-to-date
- Change: col. 3 less col. 2 "Change"
- Percent: col. 2 divided by col. 3 "Percent of Actual"
- Click Print to preview your report.
Statement of Income and Expense report > Year-to-date: five-year trend
- Go to the Other reports tab of the Finance module.
- Choose "Treasurer reports" from the list of report options to the left of the window.
- Choose the current finance year and month.
- Choose any book, responsibility, and church body selections, if any.
- For the format, choose "Annual history".
- Choose the level of detail you would like your report to generate.
- Check any options you would prefer for your report.
- Click Print to preview your report.