Reconciliation Trouble Shooting

Common issues with Workbench / financials reconciliation

• Timesheet transactions not batched

• Accounts Receivable invoices / credits not batched

• Batches have not been exported

• Batch Edit List totals for each export have not been verified and do not reconcile with data in financials

• Opening position from previous period has changed

• Job reports being reconciled with exclude some jobs either through [profit centre Group of the logged in user not having access to all jobs or some filtering criteria have been applied to the report in Job Report Selection

• Incorrect From and To Year / Periods have been selected in running reports

• Transactions which have been entered directly into the financials are being included in reconciliation totals

• Costs resulting from Internal Sales invoices are not appearing on jobs because the invoices have not been batched

• An Activity Code does not have a valid / correct / any DR GL Account and costs cannot integrate correctly to the financials

• A Sales Code does not have a valid / correct / any GL Account and revenue cannot integrate correctly to the financials

• A Profit Centre does not have a valid / correct / any GL Prefix and revenue / costs cannot integrate correctly to the financials