Purpose

Reconcile the Stocked Trade Clearing General Ledger in your accounting package to what Blackpurl indicates the balance should be

How often should you do this reconciliation


It is recommended that you perform this reconciliation every month

The more frequently you perform these reconciliations the easier it is to investigate and resolve any possible variances that may occur


Understanding what Stocked Trade Clearing General Ledger actually is


The value of all “stocked in” trade-ins on open customer order deals in Blackpurl should always match the balance of the Stocked Trade Clearing General Ledger 



When trade-ins are “stocked in” prior to invoicing a Customer Order Unit Deal that trade-ins' effect on the unit Inventory General Ledger is offset to the Stocked Trade Clearing General Ledger which is later cleared when the Unit Deal is then subsequently invoiced 


Important information


Remember that this is a Blackpurl Control Account and is being managed by Blackpurl


To prevent reconciliation issues you should never post entries manually/directly into the accounting package which affects the Stocked Trade Clearing General Ledger account


Also as part of what should be your standard practices in your accounting package, you should never modify or delete a transaction or journal entry that was generated by the integration


If you need to change something that the Blackpurl integration posted into your accounting package, make the correction in Blackpurl instead


What you need to reconcile


Blackpurl 


Run Reporting > Reports > Reconciliations - Stocked Trade Clearing Account 


This is the relevant article - Reporting - Reconciliations - Stocked Trade Clearing Account




The total you are looking for is Stocked Trades - see above 



Tip:
Why not setup scheduled reporting - that way you can schedule the relevant Blackpurl report to automatically run at a specific date / time and email direct to a Blackpurl User 

This article will explain how to do it - Reporting - Scheduled Reporting



Accounting Package - Xero or QuickBooks Online 


At the same time run a Balance Sheet from your Accounting Package as of the “reconcile date” which will give you the balance of the Stocked Trade Clearing General Ledger account



Compare


Then simply compare the totals from Blackpurl Report that you just generated to your Balance Sheet Stocked Trade Clearing General Ledger 


What if there is a variance between Blackpurl and the Stocked Trade Clearing General Ledger 


If you find only small or insignificant variances you should just post a journal entry to bring them back in line with each other.  Your time is probably more valuable than a few cent variance you would be chasing after. 


This is the only situation where it’s ok to post a journal entry against the Stocked Trade Clearing General Ledger  account that is managed by Blackpurl.


For larger variances, you should review the account transactions report for the Stocked Trade Clearing General Ledger account for the time period since your last successful reconciliation and look for entries that were not generated by the Blackpurl integration as these will probably be the cause.  If you still cannot find the cause then it might be possible for the Blackpurl team to look at their daily logs and tell you which individual days reported a change in variance