Reconciling data

After importing and loading the data, you need to reconcile it to make sure it enters the system correctly before starting the budget process. We recommend that you perform these actions on a biweekly and monthly bases.

The following topics provide instructions on running the required reconciliation reports. These are the same reports you will run to create and reconcile your monthly reports.

IMPORTANT: You must load and reconcile data before you start building and processing plan files.

Run these imports and utilities in the following order to load your data into the system:

1. Reconcile Income Statement - Use this report to review the Income Statement totals by FSDetail category for the current period and year-to-date compared to budget and prior year.
2. Reconcile GL to GL Transactions - If you load sub-ledger detail, such as Accounts Payable (AP), Accrued Receipts (AR), Materials Management (MM), and Journal Entries (JE), we have a reconciliation utility that ties the sub-ledger data back to the General Ledger data (ACT20XX). This report confirms that the data loaded to the GL matches the data loaded to the Journal Entry (JE) detail. It also compares the JE detail to AP, MM, and AR transactions to make sure the data balances.
3. Reconcile GL to RevUsage - Use this report to reconcile GL revenue data in the Financial tables to the Revenue and Usage data imported into the database on a monthly and year-to-date basis. The desired result for this report is to show a zero variance.
4. Monthly RevUsage Reconciliations (For CDM template licensed users only) - After all revenue and usage data is loaded, run the Monthly RevUsage Reconciliation. This report shows the IPVolume, IPRevenue, OPVolume, and OPRvenue by department for each month.
5. Biweekly Payroll Reconciliation - Run this report after loading the biweekly payroll data to validate totals for the dollars, hours, and statistics from the import file.