The Treasurer's Report is a report format that allows you to compare your budget figures to your account actuals over a specified time period. However, the Treasurer's Report is a flexible report, and allows you to look at just your actuals over a time period as well, and is also capable of comparing multiple fiscal years.
- To access the Treasurer's Report, in the Finance module of Shepherd's Staff, click on "Other Reports" and then click "Treasurer's report".
- You can set the time period for this report using the "Finance Year" field to set the year for the report and the "Period" field to set the month on the report.
- You can filter which accounts should be included on this report by using the "Book" field to filter which books should be included on the report. You can also filter by responsibility and church body codes by checking or uncheck the options in the "Responsibility" and "Church Body" fields respectively.
- The Format field will let you determine how your report is laid out. Several options are available and you can also create your own format by selecting the "Custom Report" option. If you select this option, the "Column" and "For" sections will light up. Here, you can select what data you want to view in each column, and over what time period (if relevant) in the "For" column.
- The "Level of detail" field will determine how your accounts are grouped on your report. You can show your report grouped by Major Group, Minor Group and Account, in different variations.
- The Treasurer's Report includes several different options, depending on which format of report you have selected in the "Format" field. These options are outlined below:
- Consolidate books by Major and Minor - If you're running a treasurer's report for multiple books at once, this will group accounts by major and minor groups, even across books. This means that you'll see accounts from one book, side-by-side with accounts from another book, if they share the same major or minor groups.
- Include inactive accounts - When checked, this option will include accounts on your report that have been marked as inactive.
- Exclude accounts with a zero balance - When checked, this will make sure any account that is not currently carrying a balance is excluded from your report.
- Hide account numbers - When this option is checked, the account numbers on the report will not be displayed, accounts will only be referred to by name.
- Sort accounts by name - When checked, this will sort accounts by name only within their account type, instead of account number.
- Include Dedicated In/Out - When selected, this option will include dedicated accounts on your report. Dedicated In and Out will each have their own sections on the report after Income and Expense.
- Include current bank balances - When selected, this includes a section before the summary at the end of the report that shows each of your bank accounts, their beginning balances, the change that has occurred on each account and the balance as of the end of the selected time period.
- Use "this year"/"last year" in heading - When selected, this will swap out showing the name of the current or previous fiscal year in the headings of the report with "This year" and "Last year" instead. For example, showing "Actual as of July this yr." instead of "Actual July 2024"
- Click "Print" to generate your report. This will bring up the Print Preview, and if you want to export this report to Excel (or the spreadsheet program of your choice), in the bottom right corner of the preview window, you will see a button that looks like the Excel logo, click on that to send this report to Excel.