Income Statement

The Income Statement provides a detailed statement of your revenue and expense account balances for the current period and year to date. The report also displays the current period and year-to-date operating profit or loss amounts.

Settings that Affect GL Reports

You can only generate the cash-basis version of this report if you select the Cash-Basis Reporting option on the Reporting tab of the Accounting System Settings form (Settings > Advanced Accounting > System).

The Organization Record Access setting for your role on the General tab of the Roles form (Settings > Security > Roles) determines the organizations for which you can see data on this report.

Account Groups

You can use account groups to organize accounts on financial reports. You establish account groups on the General tab of the Accounts form (Settings > Accounting > Chart of Accounts).

Increase Performance with the Use Summary Table Option

Because of the calculations involved, it may take longer to generate this report than it does for most other reports. This is particularly true for large databases.

To get the best performance, do the following before you generate a Balance Sheet:

  • Run the Refresh GL Summary Table utility.
  • Select the Use Summary Table option on the General tab in the Options dialog box for the report.

Recommendation: The Refresh GL Summary Table utility calculates and stores the financial data needed for this report in a summary table. Schedule the Refresh GL Summary Table utility to run after business hours each night, so that financial reports printed the next day show current data as of close of business the day before.

Multiple Companies

You can generate a consolidated Income Statement for multiple companies. To generate that report, go to Reporting > Consolidated GL.

Multiple Currencies

If you use multiple currencies, a report may display amounts in different currencies. If a report contains a total for amounts in a mix of currencies, the report displays #### as the total, instead of an amount. If the report displays amounts in different currencies, it is a good idea to include currency symbols or currency codes. To do that, click the Layout tab of the Options dialog box and click in Currency to open the Format Currency dialog box. You may want to use the currency code in place of the currency symbol when the report includes more than one currency with the same symbol. For example, U.S. dollars and Canadian dollars both use $ as the currency symbol. If you use the code rather than the symbol, the report displays USD and CAD instead of $.

An alternative to mixing currencies on the report is to select a presentation currency. When you generate the report, DPS converts all amounts to the presentation currency. The advantage of this method is that you can make meaningful comparisons between amounts, and the report can display meaningful totals.

Options Dialog Box

Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.