Step 4 - Control Accounts - Customer Deposits


The purpose of this General Ledger account is to maintain the value of deposits which have been added to Customer Orders in Blackpurl


  • The deposit amounts will be held in that General Ledger Account until the Customer Deposit is used to finalise a Customer Order within Blackpurl or the deposit is refunded to the Customer within Blackpurl

This General Ledger should be a clearing account, nothing more and will show as a negative asset (which is the same as a liability) 

  • This General Ledger Account Type needs to be set up as a:
  • QuickBooks Aus / NZ 

Account Type: Cash or equivalent- cash on hand 

  • QuickBooks USA / CDN

Account Type: Bank- Cash on hand 

  • Xero 

    Account Type: Current asset 

This is a restriction of QuickBooks / Xero that all integrated payments must be a specific Account Type

By setting up the General Ledger with the above mentioned Account Types is the only way QuickBooks / Xero will accept the integration transaction


  • For Xero you need to ensure that this General Ledger account has "Enable payments to this account" ticked.


  • When receiving a Customer Deposit on a Customer Order in Blackpurl, the integrated transaction will be:


Debit - Undeposited Funds GL (based on the payment method if you have more than 1 Undeposited funds GL set up)

Credit - Customer Deposit 


The transaction will show as a CODN-********* if the amount is processed as deposit on the Customer order in Blackpurl


Screen shot of QuickBooks Transaction:



Screen shot of Xero Transaction:



  • When the Customer Deposit is used or refunded, the integrated transaction will be:


Debit - Customer Deposit GL 

Credit - Undeposited Funds GL (based on the payment method if you have more than 1 Undeposited funds GL set up)


This transaction will show as a COIP-********** if the sale is finalised in Customer Order > Checkout section of Blackpurl

OR

if the Deposit is refunded then it will show as a CODN-********* on the Customer Order > Deposit section of Blackpurl


  • The COIP or CODN identifiers in Blackpurl can be cut and pasted from the Cash Reconciliation or from the relevant Customer Order to QuickBooks or Xero search functionality, if you are searching for the transaction in your accounting package 



Restrictions

Accounting transactions  to this General Ledger account should never be made directly from the accounting application other than for the purpose of entering opening balances. This account is basically a clearing/holding account account for transactions from Blackpurl 


Reconciling Customer Deposit General Ledger to Blackpurl 

The amount in the Customer Deposits General Ledger account should equal to the deposits held in Blackpurl

To check this you can 

  1. Run a All Customer Orders report and note the Deposit column balance - this article can assist you in running the report - Reporting - Customer Deposits  OR from the Blackpurl Homepage, the amount indicated as Deposits 
  2. Then compare the Customer Deposit total from Blackpurl to your Customer Deposit General Ledger in your accounting package - taking into consideration any manual entries you may have mad in your accounting package