Quickbooks Payment Reconciliation

Overview:  When using the Quickbooks Online (QBO) integration with Ski Club Pro all orders and payments are recorded into QBO within minutes of the actual transactions.  On a daily basis, our payment processor, Deluxe Payment Platform (DPP) will deposit the full amount on the next business day for credit card payment and ACH transactions, with some exceptions like holidays and weekends.   Both Credit card and ACH batches are deposited in your bank account separately.  

For reconciling the payments to the deposits made in your bank account, follow these steps below.  NOTE:  You may want to meet with your own accountant to make sure this process works for them in case they have different ways of doing this.

1) Go to MANAGE > REVENUE > DELUXE BANK REPORTS Dashlet

2) Click on Credit Card Batch Summary

This will be a list of all batch deposits made into your bank account with a link to the batch details with the specific orders and payments.

3) On BATCH DETAILS page, you see the specific payments and orders related to that bank deposit.  This report is easily exportable into CSV or EXCEL formats.  Also, both the PAYMENT ID and ORDER ID are linked back to their orders in case you want to review specifics.

4a) Go to QBO > ACCOUNTING > BANK TRANSACTIONS.   If you have your bank connected to QBO then you will automatically see the bank transactions in your account and can MATCH the Pending payments related to a specific deposit.  

4b) Find the specific deposit from the batch report in SCP and click the MATCH button on the Pending Bank Transaction list.

5) On the MATCH page, you will select ONLY the PAYMENT IDs from the list that were in the specific batch.  If you do so correctly, the selected payments will match exactly with bank deposit.  Click MATCH to complete.

6)  Now Payments will be connected and posted to the QBO bank deposit.  Now you just do that for each bank deposit.

That's it!