Verify Workbench revenue transaction totals:
- Print a Batch List for all revenue 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 revenue type batches - AR Invoices, AR Credits, AR Internals to ensure all cost batches for the period are selected.
Print the 'Batch List' report for the displayed batches
- Print an 'Invoice Status Report'.
- The total revenue on these two reports and on any of the job reports should reconcile.
Verify the GL Postings for Workbench revenue transactions
- Print the 'Job Revenue Reconciliation by Batch and GL Code Summary' report from the Job Report Selection screen. This lists Workbench revenue 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 Revenue Reconciliation by GL Code and Batch Summary' report from the Job Report Selection screen. This lists Workbench revenue 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