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
- 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
- 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