Skip to main content

Payment Accounting Method Conversion

Learn how the new payment accounting method works in Blackpurl and how to enable it for your dealership.

The Payment Accounting Method Conversion changes how Blackpurl records payments and deposits in your accounting package. This article explains what the new method does, what problems it solves, and how to enable it — including the GL accounts you will need to create before starting.

Important: Existing dealerships do not have to switch to the new method. However, if you choose to convert, there is no going back. Before proceeding, make sure you fully understand the new method and that it is right for your dealership. If you need to discuss this with the Blackpurl team, reach out to Blackpurl Support before making any changes.

What the New Method Is Designed to Do

The new Payment Accounting Method was introduced to address several problems with the original approach. Its goals are to:

  • Drastically reduce the volume of journal entries hitting the Customer Deposits General Ledger (GL), so that only actual customer deposits on Customer Orders post to that account

  • Allow the Customer Deposits GL to be classified as a liability account

  • Reduce the volume of journal entries in the Undeposited Funds GL, making banking entry reconciliation much easier

  • Generate cash reconciliation journal entries that include entries for cash over/short amounts

Problems the New Method Addresses

The main issue with the original method is the high volume of journal entries posting to the Customer Deposits and Undeposited Funds GL accounts. Under the original approach, every payment and deposit is recorded as an individual journal entry to both accounts. When Customer Order (CO) invoices are finalized and posted to QuickBooks or Xero, additional entries are also generated in the Customer Deposits GL to pay those invoices.

This creates several problems:

  • The Customer Deposits GL becomes very difficult to reconcile when variances have existed for a period of time

  • The high volume of entries in the Undeposited Funds GL makes it very difficult to reconcile banking entries against individual postings

  • Restrictions imposed by QuickBooks have forced the Customer Deposits GL to always be an asset account, because it is used for making payments against sales receipts — many dealerships want it to be a liability account instead

  • The Cash Reconciliation tool allows users to reconcile payments processed in Blackpurl against actual funds received, but does not account for that reconciliation in the accounting package — particularly for cash over/short amounts

What Will Change: The Four GL Accounts

Instead of routing every payment and deposit through just two GL accounts, the new method uses four distinct GL accounts. Two of these already exist in your chart of accounts; two are new and must be created.

Customer Deposits GL (existing)

The Customer Deposits GL is your existing GL account. Under the new method, the only entries that post to this account are deposits recorded in the deposits section of Customer Orders.

  • Credits are recorded when a deposit is added to a CO

  • Debits are recorded when a deposit is refunded, with the offset posting to the Cash Reconciliation Clearing GL

  • When a deposit is used in checkout, the offset posts to the Checkout Clearing GL instead

The balance of this GL will reflect the current total of deposits held on Customer Orders.

A table showing journal entries for Customer Deposits Account with three scenarios: $100 deposit added to CO (credit $10


Checkout Clearing GL (new)

The Checkout Clearing GL is a new account you will need to add to your chart of accounts. The only entries that post here are those recorded in checkout:

  • Credits when payments are recorded in checkout or when deposits are used in checkout

  • Debits when refunds are recorded in checkout

With the exception of deposits used in checkout, all offsetting entries post to the Cash Reconciliation Clearing GL. The balance of this account at the end of any day should be zero, unless a payment is added in checkout without the user finalizing that checkout.

A table showing journal entries for checkout operations with four scenarios: $100 payment added in checkout (debit $100.


Cash Reconciliation Clearing GL (new)

The Cash Reconciliation Clearing GL is a new account you will need to add to your chart of accounts. It acts as the offset GL for all entries posted to both the Customer Deposits GL and the Checkout Clearing GL — similar to how the Undeposited Funds GL worked under the original method.

Entries are cleared out of this account by new journal entries generated when you close and finalize a day in the updated Cash Reconciliation tool. The balance of this GL at any point reflects total payments and CO deposits for days where Cash Reconciliation has not yet been closed and finalized.

When a day is reconciled and closed, the Cash Reconciliation tool generates a summary journal entry. All cash and credit payment methods are summarized at their actual values as entered in the reconciliation tool, the Cash Reconciliation Clearing GL is offset for the total amount of all payments recorded in Blackpurl, and any cash over/short variance is posted to its own GL account.

A detailed GL account report showing multiple entries for January 24, 2024, with columns for GL Account, Memo/Descriptio


Undeposited Funds GL (existing)

The Undeposited Funds GL is your existing GL account. Under the new method, entries only reach this account through the Cash Reconciliation tool when a day is closed and finalized. Because the volume of entries is greatly reduced and each entry represents a summarized daily total, this GL is much easier to reconcile against your bank account.

A simple table showing entries that would appear for one day, with Memo Description and Debit/Credit columns. Shows entr


Cash Reconciliation Tool Updates

Once the new method is enabled, the Cash Reconciliation tool posts a journal entry as part of the Reconcile day action. This journal entry clears the day's entries out of the Cash Reconciliation Clearing GL and posts one or more entries to the Undeposited Funds GL.

The journal entry contains a minimum of two line items, but may include more depending on the payment and deposit activity for the day. Some values use the amounts processed in Blackpurl; others use the actual values entered by the user in the reconciliation tool.

For each cash or credit payment method that has an actual value entered for the day, a line item is included recording that actual value. Any cash over/short amount is also included as its own line item.

Main cash drawer reconciliation screen showing payment types in an 'Unreconciled' status. Left column shows payment meth
A GL account report showing reconciled cash payments with entries all dated 2024-01-24. Shows Undeposited Funds GL entri
A reconciliation summary table showing GL accounts with their debit amounts and memo descriptions dated 2024-01-15. List


The final line item in the cash reconciliation journal entry offsets the Cash Reconciliation Clearing GL for all payments received in Blackpurl for the date reconciled.

Extended GL account report showing the same entries as previous image but with an additional line: '1020.bp - Cash Rec C


Reopening a Reconciliation

Because the Cash Reconciliation tool now posts journal entries when a date is reconciled and closed, Blackpurl has added a reopen action — similar to the one available for CO invoices, Vendor Orders (VOs), and Vendor Receipts (VRs). This allows you to reopen a reconciliation to make corrections if needed.

As part of the reopen process, Blackpurl first checks that the original cash reconciliation journal entry is still intact in your accounting package and that none of its line items have been reconciled. This confirms the journal entry can be safely removed from the accounting package before the reconciliation is reopened.

How to Enable the New Payment Accounting Method

Work through the following steps in order. The conversion does not take effect immediately — it runs overnight and is in place at the start of your next business day.

Part 1: Create the New GL Accounts in Your Accounting Package

Before making any changes in Blackpurl, create the following GL accounts in your accounting package (QuickBooks, Xero, or equivalent):

  • BP Cash Reconciliation Clearing — must be an Asset type GL

  • BP Checkout Clearing — must be an Asset type GL

  • BP Cash Over / Shorts — can be an Expense or Cost of Goods (COGS) type GL

  • BP Gift Card Liability — must be a Liability type GL. You may already have this account; if so, no action is needed here.

Part 2: Sync Your Chart of Accounts in Blackpurl

1. In the Blackpurl header, click Settings (the gear icon), then select System Settings.

2. From the System Settings dashboard, select Accounting Integration.

System settings dashboard page showing 'Hi BP' greeting and 'You can manage NEW AUS UAT settings here' text. The page di


3. In the Accounting Integration section, click through to step 2. Chart of Accounts.

4. Click Sync Now to pull your updated chart of accounts — including the new GL accounts you just created — into Blackpurl.

Accounting setup screen showing Chart of Accounts section. Left side shows 'SYNC NOW' button (highlighted with red borde


5. Wait for Blackpurl to confirm the sync is complete before continuing.

Part 3: Set Up and Schedule the Conversion

1. From System Settings > Accounting Integration, open the Accounting Provider section. You will see a new section called Payment accounting method conversion.

Accounting Provider setup screen showing QuickBooks Online connection with 'SKIP CONNECTION' and 'TEST CONNECTION' butto


2. Click Conversion setup and scheduling to open the conversion screen.

Payment accounting method conversion dialog showing two notification banners at top. Blue info banner states conversion


3. Review the notifications and warnings at the top of the conversion screen. Note that the conversion will not happen immediately — it runs overnight and takes effect at the start of your next business day.

4. Work through the conversion form and map each new GL account field to the corresponding GL account you created in your accounting package.

Long conversion form showing multiple GL account mapping fields. At top are the same blue info and orange warning banner


5. Check all required checkboxes to confirm you understand and accept the following:

  • Once the new payment accounting method is enabled, it cannot be turned off

  • Going forward, the only entries posted to your Undeposited Funds GL will come from reconciled cash reconciliations

  • Any previously reconciled cash reconciliations cannot be reopened

  • Any unreconciled cash reconciliations for dates prior to the conversion will not generate a journal entry when reconciled

6. Once all GL accounts are mapped and all checkboxes are checked, click Schedule the Conversion to queue the overnight conversion.

Continuation of the conversion form showing the same GL account mapping fields: Customer Deposits Account, Undeposited F


At the start of the next business day, the conversion will be complete and the new Payment Accounting Method will be active for your dealership.

Did this answer your question?