The Reports Summary Sub-Menu

<< Click to Display Table of Contents >>

Navigation:  THE MAIN MENU >

The Reports Summary Sub-Menu

Income StatementLists your income and expenses, consolidated across all funds, for a selected range of dates. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report. You can drill-down on total fields for accounts that don't have sub-accounts to see a detail report of the transactions that make up that total.

 

Income Statement

  by MonthsLists your income/revenue and expenses for two or more complete months, with one column per month, plus a totals column, for a selected range of dates. This report may be printed in either portrait or landscape mode, depending on how many months are included. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report.

 
Warning: If you select enough months that the report is multiple pages wide, the Save PDF button will not operate properly, and part of the 2nd page will be at the right edge of the first page, etc. To avoid this, print to a PDF printer instead, like "Microsoft Print to PDF" which is included in Windows 10.
 

Income Statement

  by QuartersLists your income/revenue and expenses for two or more complete fiscal quarters, with one column per quarter, plus a totals column, for a selected range of dates. This report may be printed in either portrait or landscape mode, depending on how many quarters are included. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report.

 
Warning: If you select all four quarters, so that the report is multiple pages wide, the Save PDF button will not operate properly, and part of the 2nd page will be at the right edge of the first page, etc. To avoid this, print to a PDF printer instead, like "Microsoft Print to PDF" which is included in Windows 10.

 

Income Statement

  Yr/Yr ComparisonLists your income and expenses, consolidated across all funds, for a selected range of dates in one year, the same dates in the previous year, and the difference between them. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report. You can drill-down on total fields for accounts that don't have sub-accounts to see a detail report of the transactions that make up that total.
This report puts the current year in the first column, and the previous year in the 2nd column. If you want it the other way around, you can do that with the Income Statement General Comparison report.
 
The Difference column shows how much "better" the later year is than the earlier year. So for Income accounts a Difference amount is "better", and so positive, if the later year's amount is more than the earlier year's amount. For Expense accounts it is positive if the later year's amount is less than the earlier year's amount.

 

Income Statement

 General ComparisonLists your income and expenses, consolidated across all funds, for one specified range of dates, and a second specified range of dates, and the difference between them (later amounts minus earlier amounts). It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report. You can drill-down on total fields for accounts that don't have sub-accounts to see a detail report of the transactions that make up that total.
 
The Difference column shows how much "better" the later date's amount is than the earlier date's amount. So for Income accounts a Difference amount is "better", and so positive, if the later date's amount is more than the earlier date's amount. For Expense accounts it is positive if the later date's amount is less than the earlier date's amount.

 

Balance SheetShows the Asset, Liability and Fund (Equity) balances as at a given date. Fund balances are the "implicit" balances, that include totals of all income and expenses on accounts with that as their associated fund. Hidden accounts with zero balances are omitted. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report.

 

Balance Sheet

   ComparisonShows the Asset, Liability and Fund (Equity) balances, for two given dates, and the difference between them. The "Date 1" initially defaults to the previous fiscal year-end date, but can be changed. Whether the "Date 1" is earlier or later than the "Date 2" is remembered for future prompting of the same report. Fund balances are the "implicit" balances, that include totals of all income and expenses on accounts with that as their associated fund. Hidden accounts with zero balances at both dates are omitted. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report.

 

Budget ComparisonLists your income and expenses, along with the budget for the same period, and the difference between the actuals and the budget. This report prompts for a range of dates for the report, within one budget year. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report. You can drill-down on total fields for accounts that don't have sub-accounts to see a detail report of the transactions that make up that total.
 
The Difference column shows how much "better" the actuals are than the budget. So for Income accounts, a Difference amount is positive (better) if the actual amount is more than the budget amount. For Expense accounts it is positive if the actual is less than the budget.
 
The report includes all accounts with a budget (even if that is $0) plus any other accounts with transactions within the selected range of dates.

 

Percentage of

  Annual BudgetLists your income and expenses for a selected period, along with the budget for the entire year, the difference between the actuals for the period and the annual budget, and the percentage that the actuals are of the annual budget. This report prompts for a range of dates for the actuals, within one budget year. It also prompts for an "Include" setting to determine the levels of accounts and sub-accounts to be included in the report.
You can drill-down on total fields for accounts that don't have sub-accounts to see a detail report of the transactions that make up that total.
 
The Difference column shows how much "better" the actuals are than the budget. So for Income accounts, a Difference amount is positive (better) if the actual amount is more than the budget amount. For Expense accounts it is positive if the actual is less than the budget.
Percentages are omitted when the budget is 0, because they would not make sense.

 

Government Form

   AmountsLists all accounts with no sub-accounts that are attached to government form lines for one selected form, a specified range of dates, and whether to omit lines for $0, with their balances, by lines of the form. The report is split into one or more pages for the Balance Sheet accounts connected to that form, then one or more pages for the Income Statement accounts connected to that form. (For the balance sheet accounts, the ending date of the specified range of dates is used.)
 
It is strongly recommended that you run Reports ⇒ Listing ⇒ Chart of Accounts with Government Form Lines before running this report, to make sure that all accounts listed on it that should have lines associated with the desired form do have such lines, and that those lines are all correct.
 
You also need to understand that not all lines on the form may be uniquely representable by this association of form lines with accounts.
 

Note: The names of the Income Statement reports and Balance Sheet reports can be changed via the Maintenance ⇒ Entity and Report Names menu option, and will change on this sub-menu accordingly.

 

Cash Flow Report

 

Users sometimes ask whether ACCOUNTS has a Cash Flow Statement report. It does not. Users have told us that a Cash Flow Statement is not commonly used or needed by small to mid-sized charities, churches and non-profits, which is who this program is primarily intended for. Usually a combination of an Income Statement and a Balance Sheet Comparison report will give you all of the information you really need about cash flow.

 

In fact, it is not actually clear how realistic it would be to think we could enable the program to figure out what should go on a Cash Flow Statement, because that really requires a deep understanding of the meanings of the accounts your chart of accounts, which cannot be determined just from their names and types. As a result, such a report is something that your accountant or bookkeeper needs to do, if you really need it.

 


This topic was last edited on Apr 4, 2023