Standard Finance Reports

The standard finance reports are used by the Finance Department, especially controllers and CFOs.

The data in these reports focuses on finance data, and to some extent data from the Project Management solution. The following set of finance reports are available in addition to those mentioned previously.

Report	Description
AP Aging	Shows aging unpaid transactions for individual vendors down to single transactions, including aged numbers by month.
AR Aging	Shows aging unpaid transactions for individual customers for separate projects down to the single transaction. Typically shows numbers aged by month and including DSO.
WIP Aging	Shows the value of the work in terms of work in progress (WIP), both on revenue and cost, including invoiced and recognized revenue in total. It also provides the ability to show accrued WIP. This can be grouped by company, customer, project, project manager, and so on.
WIP Aging Transactions	Shows the balance between what has been entered (or revenue recognized) and what has been invoiced and aged over time.
Profit & Loss	Displays the financial postings of all profit and loss accounts, summarized for the chosen fiscal periods. One view compares the periodic amounts to the year-to-date amounts, and another compares the periodic amounts to the amounts from the corresponding fiscal periods for another year. This report compares all actuals with budgeted amounts, based on a budget model.
Profit & Loss Periodic	Shows company or department performance, month-by-month, comparing actuals to budget on an account basis structure.
Profit & Loss Fiscal Year	Shows P&L performance numbers month-by-month for the full fiscal year.
Profit & Loss Dimension	Uses the same format as the P&L report, but does not compare the period data to data of other periods. It groups data by an additional, selected dimension and is aligned in columns. For example, you can have the report group data by department and present one column for each department
Balance Sheet	Displays the financial balances of all balance sheet accounts, summarized for the selected fiscal periods: One view compares the periodic amounts to the year-to-date amounts, and another compares the periodic amounts to the amounts from the corresponding fiscal periods for another year. The year-end closing account displays the total retained earnings. This amount is based on the year-end closing amount from the previous year plus the total amount of current-year earnings (profit & loss) for the selected fiscal periods.
Trial Balance	Displays all financial postings summarized for the selected fiscal periods for each account. Both profit and loss and balance sheet accounts are included.
Trial Balance Analysis	This report is the same as the Trial Balance report, but with drilling over the dimension grouping levels.
Trial Balance No Grouping	This report is the same as the Trial Balance report, except that it displays two columns—Account No and Account Name—instead of the hierarchical structure provided by the dimension grouping.
Finance Transactions	Displays detailed information about the finance transactions for selected fiscal periods, as well as specified restrictions by account, company, and so on. You can display amounts in account, company, or enterprise currency, or using a selected reporting currency. Amounts are grouped by currency, company, and account.
Cash Flow Statement	Provides an overview of cash flow actual amounts for a selected set of fiscal periods. The report consists of three main sections: Opening Balance: This section includes only one summary line for all accounts selected. Closing Balance: This section includes only one summary line for all accounts selected. Movement: This section has a table in which each line displays information about the actuals posted to the corresponding group of accounts. The structure of this section uses the first two levels of the dimension grouping. Totals for the section display as a separate line named Net movement.
Cash Flow Statement, By Dimension	Provides an enhanced version of the Cash Flow Statement, which provides an overview of cash flow opening, movement, and closing balances as of a selected period.
Cash Flow Forecast	Provides an overview of cash flow budget data for a selected set of fiscal periods.
Bank Reconciliations	Displays the financial bank reconciliations performed for each bank account. Both reconciled and outstanding amounts are displayed.