Accounting Reports

To help you manage your enterprise's financial information, you can produce various reports based on the data in your general ledger and subledger accounts. Some of these reports, such as the Balance Sheet, are standard accounting reports. Others provide DPS-specific information.

Taken together, these reports help you track and monitor your enterprise's financial performance for selected accounting periods and over time.

General Ledger Reports

• Account Analysis: This report provides a detailed view of all general ledger activity during the current accounting period and acts as an audit trail of this activity. It displays account names and numbers, opening and closing balances for each account, and all transaction detail for each account. If the Account Analysis is detailed by organization or profit center, it includes an opening balance, transaction detail, and a closing balance for each organization for which there is information.
• Balance Sheet: This standard accounting report shows the distribution of your enterprise’s assets, liabilities, and net worth as of the current date. The Balance Sheet includes totals for assets, liabilities, and net worth, as well as a total for liabilities plus net worth. Total assets should equal total liabilities plus net worth. If these totals do not agree, the bottom of the report includes a tolerance line, showing the amount of the discrepancy. If you are using the Organization Reporting feature, you can maintain separate Balance Sheets by organization.
• Income Statement: This report provides a detailed statement of your revenue and expense account balances for the current period and year-to-date. DPS uses these balances to calculate your enterprise’s current period and year-to-date operating profit/loss, which displays at the bottom of the report.
• Profit Planning Monitor: This report lets you monitor corporate budgets. It lists each of your enterprise's revenue and expense accounts. For each account, it shows the budgeted and actual amounts for the current period and year-to-date. It also shows totals for actual and budgeted revenue and expense and calculates actual and budgeted profit/loss.
• Trial Balance: This report shows the opening and closing balances for each of your general ledger accounts, as well as the total debits and credits for the accounts. Use this report to verify that your debits equal your credits.

Accounting Reports

• Accounting List: This report lists all accounts, or any sub-group of accounts, from your chart of accounts.
• Cash Flow Forecast: Generally, cash flow consists of the inflow of revenue through accounts receivable and other income, and the outflow of funds through accounts payable generated from overhead, debt, and taxes. Use this report to analyze the inflow and outflow of cash to monitor changes in cash during an accounting period. Also use this report to determine whether sufficient funds are available from financing activities, to show funds generated from all sources, and to show how these funds are applied.
• Cash Journal: This report lists every cash receipt and disbursement posted, during the current accounting period or year-to-date, for each bank code selected.
• Payment Register: This report lists all payments processed during the current period. It shows payments created through cash disbursements, payroll (if your enterprise uses the DPS Payroll application), employee advance and expense processing, accounts payable disbursements, and accounts payable payment processing.
• Labor Cross Charge: This report is part of the Organization Reporting application. It tracks labor swaps between organizations, showing each labor transaction that results when an employee from one organization works on another organization's project.
• Overhead Allocation: This report shows the allocation of overhead to all regular projects as of the last time the overhead allocation process was run. The amount in the Year-to-date Overhead column on this report should match the total indirect expenses amount on your Income Statement.
• Sales List: This report shows all sales and associated taxes that occurred during a specific period, a range of periods, a range of dates, or on a year-to-date basis.
• Tax Analysis: This report shows purchases, sales, and associated taxes. You can also use it to review tax-related entries for employee expenses. You can list transactions that occurred during a specific period, a range of periods, a range of dates, or year-to-date.

Accounts Payable Reports

• Cash Requirements: This report shows all outstanding accounts payable vouchers and their balances.
• Cash Requirements Bank Summary: This report shows a total amount for all vouchers for each bank code that has amounts posted during the current period.

  Use the Cash Requirements or Cash Requirements Bank Summary report to review cash requirements prior to Accounts Payable Payment Processing to determine the amounts scheduled for payment and the effect that making these payments will have on your cash accounts.

• Vendor Summary: This report provides detailed information for each of your vendors, including the vendor's name, number, and address information; 1099 requirements; billed and paid amounts for the current period, year-to-date, and vendor-to-date; and accounting information, such as the vendor's payment terms and discount codes.
• Voucher Ledger: This report provides you with historical information on all vouchers, including payments, adjustments, and voids for each voucher.
• Voucher Schedule: This report provides a projected payment schedule for outstanding vouchers. It shows each of your outstanding vouchers, when the voucher is scheduled for payment, and how long it will remain unpaid. It compares the aging date to the invoice date, payment date, or voucher date to determine the aging time frame. The amounts on this report should match the amounts in liability accounts on your Balance Sheet. Use this report to respond to inquiries from vendors and to monitor your cash flow.

Accounts Receivable Reports

• AR Aged: This report shows, project by project, the total receivables due, the length of time receivables have been outstanding, and the date on which the last cash receipt was posted. You can also include a detail line for each invoice sent for the project. Use this report to determine when a client is delinquent in paying and to monitor your cash flow.
• AR Comments: This report lists comments entered for outstanding invoices.
• AR Ledger: This report lets you review your enterprise’s billing history. For each project, phase, or task, the report shows each invoice generated and all payments received. It also shows you the average collection period for all paid invoices.
• AR Statement: This report is the statement that you send to a client. You determine the aging periods to display in the statement, as well as the statement date and grace period. You can also display a comment on the statement.
• Invoice Register: Use this report to view the invoices posted during the current period through Invoice transaction entry or through the DPS Billing application.