Report Overviews

The Balance Sheet report is a classic columnar balance sheet that provides current year-to-date values compared to values from prior year-to-date actual or selected budget. It is an itemized statement that lists the total assets and liabilities for the company.

The displayed account structure is based on the selected Account Map. The report includes a summary and detail view option. The summary view provides high-level information. The detail view displays each section with an additional level of account information. This report does not provide any drill-down or hide capabilities. Sample Report.

The Bank Reconciliation report presents information on Bank Reconciliations that have been performed.

The report includes a summary and detail view option. The summary view provides high-level bank reconciliation information with the ability to drill-down into additional data in the detail view to show transactions included in the reconciliation. Sample Report

The Bill Process Control report is a list of prebills and final bills that have not been posted. This report allows you to review items that are currently available in the billing process and identify any potential data issues. It should be run prior to starting a billing cycle.

The report includes a billing status summary of each project in a billing cycle. It contrasts the revenue position to billable value and documents previous and current write offs and values put on hold. Work in Progress (WIP), Receivables (A/R), and Collections values are also included. When final bills have been generated, the bill number and amount are also displayed; once the billing cycle is closed, this information is no longer available. Sample Report.

The Bill Register report is a record of bills that will be included when bills are closed. The report includes final bills that have been generated but are not posted. For each bill, project and client information as well as the retainage, tax, and net bill amounts are included.

This report should be run prior to billing close to ensure that the projects and bill amounts to be posted are correct; this information is no longer available once the bills are posted.

The report can be used for the following purposes:

• Review a list of bills that are in the billing process and identify any potential data issues.
• Verify that all project / bill groupings have been invoiced.
• Verify receivables postings.
• Review billings by project manager, organization, etc.

The report includes a summary and detail view option. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section expanded; it does not provide any drill-down or hide capabilities. Sample Report.

The Bill report (also known as client invoice) itemizes work completed based on client contract terms and the sum due for the work.

The bill report has a general structure of a cover page section and a backup section. The cover page section contains high-level information, which includes client information (name and billing address), project and invoice information, and a summary of billing charges, billing adjustments (e.g. surcharges, retainage and taxes) and net amount due. The backup contains detail of the billing charges. The structure of the backup is defined in the bill format.

The Bill report is generated and maintained as part of the Prebill and Final Bill features. For more information, see Prebill and Final Bill.

For a compilation of sample bills, see Sample Bills.

The CPFF Agency Pool Bill report is based on organization level multipliers​. The Agency Pool Type is used on the CPFF Agency Pool Bill Report Bill Control History as an attribute to record previous billings and to display the Bill Report by Pool Type. Labor and Expense Agency Pool Schedules are used to calculated Effort on the Project, while Agency Pool Schedules on the Bill Term are used to calculate the CPFF Agency Pool Bill Report.

The Agency Pool Type and Labor Expense attributes are used on the CPFF Agency Pool Bill Report to support Bill Control History. Sample Report.

The Employee Expense report generates a printable version of an expense report for an employee's personal records. The report includes a summary and detail option. It does not contain any receipt attachments. Sample Report.

The General Ledger Detail report is a detailed list of transactions by company, account, organization, and posting period. Sample Report.

The Income Statement report is a comparison of a summary of actual operations financials against the values from prior year-to-date actual or selected budget.

The displayed account structure is based on the selected Account Map. The report includes a summary and detail view option. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section with an additional level of account information; it does not provide any drill-down or hide capabilities. Sample Report.

The Income Statement by Fiscal Period report displays the actual General Ledger information for up to twelve (12) months by Fiscal Period. Also, this report has the capability to show Account Budgets for the Income Statement accounts by Fiscal Period for the same 12 months range.

The displayed account structure is based on the selected Account Map. The report includes a summary and detail view option. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section with an additional level of account information; it does not provide any drill-down or hide capabilities. Sample Report.

The Intercompany Bill report (also known as an intercompany invoice) itemizes work performed by one company (working) on another company's (owning) project and the sum due for that work. The billing calculations are controlled by the intercompany settings terms established for those companies.

The bill report has a general structure of a cover page section and a backup section. The cover page section contains high-level information, which includes company information (name and billing address), project and invoice information, and a summary of billing charges, billing adjustments (e.g. surcharges, retainage and taxes) and net amount due. The backup contains detail of the billing charges. The structure of the backup is defined in the bill format.

The Journals report is a list of all of the transactions or activity against accounts. All information is selected and grouped by document number.

The report includes a summary and detail view option. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section expanded; it does not provide any drill-down or hide capabilities. Sample Report.

The Labor Audit report is a list of an employee's labor transactions and adjustments from timesheets, billing transfers, and labor adjustments. In addition, the report displays the status (Signed, Unsigned, Accepted, and Pending) of the included transactions. Sample Report.

The Payment report generates a paper or EFT check for distribution to vendors and / or employees. Report order is the sequence designated in the Payment Request. The paper report is designed for use on a pre-printed check form and is appropriate to the country in which the forms are being generated. The Payment Report – United States check form has a stub at the top and the check in the middle. The Payment Report – Canadian check form has the check at the top followed by two stubs and follows the guidelines outlined by the Canadian Payment Association (www.cdnpay.ca).

For a compilation of sample formats and payments, see Payment (Report).

The Payment Attachment is a check addendum (expanded check stub) that is generated when the maximum stub lines are exceeded on a payment. The attachment is only generated for payments where that condition is met, and presents all of the detail of what that payment covers. Report order is the sequence designated in the Payment Request. The report contains cash account; payment number and date; vendor invoice number and date; and voucher number and amount.

This report is generated and attached to the originating Payment Generation document as part of the payment generation process. Because of this functionality, no summary level information is available. Further, no restrictions or sorts may be applied and a banner page will not be generated. Sample Report.

The Payment Register report provides a list of all payments included in a payment run. Report order is by the payment number. The report contains cash account; payment number and date; Employee/Vendor/Client type, code and name; voucher number; vendor invoice number and date; discount amount; and net amount.

This report is generated and attached to the originating Payment Generation document as part of the payment generation process. Because of this functionality, no summary level information is available. Further, no restrictions or sorts may be applied and a banner page will not be generated. Sample Report.

The Purchase Order report is used to create a Purchase Order statement for either current purchase orders or a revised version of a purchase order. The report will provide vendor, ship/ bill to, delivery, shipment and line item detail information along with purchase terms. Sample Report.

The Realized Gain / Loss report displays the gain or loss resulting from the currency revaluation process of 'finalized' transactions. Such transactions are payables and receivables (and, optionally, work in progress) documents that have a zero balance in document currency, but, due to currency fluctuations, have a balance in company or base currency. The report is organized by company, organization and account with a summary by Employee/Vendor/Client Type, Code, Name and Document Number.

This report is generated as part of the Realized Gain/Loss process. Because of this functionality, no summary level information is available. Further, no restrictions or sorts may be applied and a banner page will not be generated. Sample Report.

The Receivable Aging report is used to monitor outstanding receivables (A/R) transactions. The report includes a list of transactions with a list of their aged balances, which includes multiple aging categories. The report includes three levels of information, which include project, bill term, and document levels of information.

The report includes a summary and detail view. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section expanded; it does not provide any drill-down or hide capabilities. Sample Report.

The Receivable Statement report is a listing of unpaid bills selected and organized by Project or Client. A Receivable Statement report is generated as follows:

• Client: when the Receivable Statement field is selected for a client (Client - Bill Routings).
• Project: when the Receivable Statement field is selected for a client (Client - Bill Routings) and when the Receivable Statement field is selected for a project (Project - Bill Terms).

The report includes a list of bills with outstanding balances, the potential financial charges, the total amount due, and an aging analysis of the outstanding invoice amounts. Additional remittance information can also be included on the report; For more information, see Bill Remit Routing. - Sample Report.

The System Audit report is a list of the prior audit balance, current activity, new audit balance (for transaction documents), and discrepancy amount for select tables in the system. It is used to detect potential data problems. This report should be run daily. Sample Report.

The Timesheet report is a report view of employee timesheets. Sample Report.

The Trial Balance report is a summary of account values organized in classic accounting style by the account type, which includes Assets, Liabilities, Revenue, and Expense. The report displays the balance forward, current debits, current credits and current balance.

The report includes a summary and detail view option. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section expanded; it does not provide any drill-down or hide capabilities.

The report is primarily used to ensure that there are no unbalanced journal entries (the total of all debits equals the total of all credits) in preparation to generate accurate financial statements. Sample Report.

The Unit Entry - Backup Report allows users to define backup criteria needed for a bill on the Bill Backup Style. Sample Report.

The Unrealized Gain / Loss report displays the gain or loss resulting from the currency revaluation process of 'unsettled' transactions. The currency revaluation process restates the company and base currencies values of Balance Sheet accounts for a specific period using the rates stored in the currency revaluation documents. The report is organized by company, and organization.

This report is generated as part of Unrealized Gain/Loss process. Because of this functionality, no summary level information is available. Further, no restrictions or sorts may be applied and a banner page will not be generated. This report can be attached to the Unrealized Gain/Loss Criteria document as a PDF for anyone with access to view. Sample Report.