Verify Workbench cost transaction totals:
- Print a Batch List for all cost batch types for the period being reconciled.
- In batch Control, select the period required, select Open, Closed, Unexported and Exported, and select checkboxes for the cost type batches (i.e. excluding AR Invoices, AR Credits, AR Internals and AR Receipts) to ensure all cost batches for the period are selected
- Print the Batch List report
- The total costs on this report should reconcile with the total costs for the period on any of the job reports
Verify the GL Postings for Workbench cost transactions
- Print the 'Job Costs Reconciliation by Batch and GL Code Summary' report from the Job Report Selection screen. This lists Workbench costs for the period by Batch Number by General Ledger DR posting account. This will highlight any transactions which have a blank batch number i.e. have not been batched
- Print the 'Job Costs Reconciliation by GL Code and Batch Summary' report from the Job Report Selection screen. This lists Workbench costs for the period by General Ledger DR posting account by Batch Number. This will provide the expected totals in the General Ledger for transactions posted from Workbench in the current period.
- Reconcile these values with the appropriate General ledger reports from your financials
- If analysis of the detailed supporting transactions is required, run the 'Job Costs Reconciliation by GL Code and Batch Detail' report from the Job Report Selection screen. This report should be previewed to screen as it will be a large report.