Why doesn't my Trial Balance report balances agree to my ERP balances?

Discusses common reasons why Occupier's Trial Balance report does not reconcile to your ERP balances.

We recommend reconciling your Trial Balance report with your ERP on a monthly basis. This will ensure any reconciliation variances are identified and corrected timely. 

There are a few common reasons why your Trial Balance may not reconcile to your ERP:

1. Lease Changes
   1. If there was a change to a previously "Completed" lease, this will require a true up entry to be recorded. For instance, this may happen if you realized the incorrect discount rate was utilized and therefore, you deleted the measurement and remeasured the lease with the correct discount rate. In order for these to reconcile, you will need to record an entry the captures the difference in what should have been recorded (with the new discount rate in this example) and what you did record in your ERP. Occupier does not record adjusting entries.

1. Complete Lease Population
   1. If your team filters the journal entry report, it is possible not leases were captured in your journal entries. When populating journal entries, we recommend using the complete lease population. You can do this by ensuring there are no filters in your journal entry exports. 
2. Inconsistent Periods
   1. You want to ensure the periods you are comparing are consistent from your ERP and Occupier.  
3. ASC 840 Balances
   1. Within the lease wizard, Occupier asks for ASC 840 balances, like deferred rent. This is used to generate your ASC 842 implementation journal entry. In your ERP, this entry will eliminate the ASC 840 balances. However, these balances still populate within the Trial Balance as Occupier only captures this balance within the implementation journal entry (therefore, not eliminating it to zero like the ERP). 
      
      
4. Income Statement Accounts
   1. Occupier's trial balance currently captures inception to date activity. Therefore, the income statement related accounts may not reconcile as your ERP will capture the activity in the period versus Occupier will populate the activity from lease inception through the selected trial balance date. 

For more information on how to export your Trial Balances report, refer to this article.