The Income Statement is a report that shows the actuals for specifically income and expense accounts over a selected time period. This report will let you see both year-to-date and monthly time periods and you can review the same time period across multiple fiscal years.
- To access the Income Statement, in the Finance module of Shepherd's Staff, click on "Other Reports" and then click "Income Statement".
- To set the time period you're running this report for, set the year of the report in the "Finance Year" field and set the month of the report in the "Period" field.
- You can filter which fields you'd like to include on this report by book in the "Books" field, by responsibility code in the "Responsibility" field and by church body code in the "Church Body" field.
- The "Format" field offers three different selections for the way your report can be formatted, and they are described below:
- Period, year-to-date - This report format will show the actuals for each account, first for the selected month, and then for the year-to-date.
- Period history - This format will show the actuals for the selected month over 5 years starting with the selected finance year.
- Year-to-date history - This format will show the year-to-date actuals through the selected month over 5 years, starting with the selected finance year.
- 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 Income Statement includes several different options. These options are outlined below:
- Consolidate books by Major and Minor - If you're running an income statement 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.
- 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.