This article explains how to reconcile the total value of Unit Inventory records in Blackpurl against the relevant Unit Inventory General Ledger (GL) accounts in your accounting package (Xero or QuickBooks Online). Performing this reconciliation regularly helps you confirm your GL accounts are correct and catch any issues early.
​

It is recommended that you perform this reconciliation every month. When done regularly, your dealership can confirm that each Unit Inventory General Ledger account is correct — and if any issues arise, they can be identified and corrected straight away.
​

Each unit record in Blackpurl is associated with a Unit Inventory General Ledger account based on the Unit Category assigned to that record.
​

The Unit Category assigned to a unit record determines which Inventory General Ledger account is linked to it.
​

This Inventory General Ledger account is what you are reconciling. Keep in mind that Blackpurl allows you to define multiple Unit Categories — some can share the same Inventory GL account, while others use different Unit Inventory General Ledger accounts.
​

Before proceeding, you should have a clear understanding of the Unit Categories defined in Blackpurl and which Unit Inventory General Ledger accounts they are associated with. These are the GL accounts you need to reconcile.
​

The Unit Inventory General Ledger accounts are Blackpurl Control Accounts, managed by Blackpurl. To prevent reconciliation issues, follow these rules:

Run the Unit Inventory Accounts Report in Blackpurl. For instructions, see Blackpurl - Unit Inventory Accounts (no longer available).
​

The report groups results by Category automatically, because unit records are related to a Unit Inventory GL account via the Category assigned to them. From this report, you need the totals from two columns for each category:

The grand totals of those two columns are the figures you will reconcile against the relevant General Ledger account in your accounting package.
​

At the same time, run a Balance Sheet in Xero or QuickBooks Online as of the reconciliation date. This gives you the balance of the relevant Unit Inventory General Ledger account.
​

Compare the totals from the Blackpurl Unit Inventory Accounts Report against the Balance Sheet for the relevant Unit Inventory General Ledger accounts. The two figures should match.
​

If you find a variance between Blackpurl and your Unit Inventory General Ledger, the steps below outline how to handle it depending on the size of the discrepancy.
​

For small or insignificant variances, post a journal entry to bring the accounts back in line. Your time is likely more valuable than chasing a few cents of difference. This is the only situation where it is acceptable to post a journal entry directly against a General Ledger account managed by Blackpurl.
​

For larger variances, review the account transactions report for the relevant Unit Inventory General Ledger account, covering the period since your last successful reconciliation. Look for:

These are the most likely causes of the discrepancy.
​

If you are unable to identify the source of the variance, the Blackpurl Support team may be able to review the daily logs in your Blackpurl backend to identify which specific days reported a change in variance. This gives you a date range to focus your investigation.