EDI Viewer - Reconciling the BC GL Upload and the Invoice

The GL Upload reports will reconcile to the Invoice, but you need to understand what data the reports are using so you can reconcile your numbers.

It is important to reconcile that all BC08 invoices be imported from the first date of March 2006 to the current date because EDI Viewer uses all this information to find the previous entries when creating amendments or reversals.

1. Reconciling the Royalty Payable to the Invoice Summary

The GL Upload always creates a Royalty Payable entry amount for every invoice you create a GL Upload file for.

This Royalty Payable amount should balance to the total Difference column on the BC Crown Invoice Summary report
(which is the report on the Invoice Summary tab).

If these 2 numbers do not agree, then we need to find out why.
The reasons they may not agree is:

• There are BC08 invoices which have not been imported.
• There are UWI's without Cost Centers. UWI's without Cost Centers are not included when the GL Upload file is created.
• There could be GL accounts which are not setup for all account types.
• Not all UWI's or new UWI's are not in the Cost Center table.
  ( To make sure all UWI's are in the Cost Center table, open the Cost Center Maintenance window, choose a Company at the top left of the window, and click the Retrieve button.This will add any missing UWI's, but you need to add the cost centers for these UWI's.)