Match Deposits in QuickBooks against orders using a Spreadsheet


Connex can match a list of QuickBooks order numbers to a deposit. If you use Shopify, you can upload your payout spreadsheet into Connex. Our tool will locate matching sales, add fees, and match the deposit. If you use another integration, you can upload this spreadsheet. 

How should the spreadsheet appear?

We recommend using this payout from Shopify as an example. Here is a list of fields:

Field Description
Transaction Date Date of Sale
Type Enter charge for a sale or adjustment for a refund
Order Enter the order number in QuickBooks or the reference number
Amount Total of sale before fees
Fee Credit card fees
Net Amount after fees

How does it work?

Here are the steps:

  1. Login to Connex .
  2. Click manage.
  3. On the left, click match deposits.
  4. Enter a deposit date.
  5. Upload the spreadsheet.
  6. Enter a deposit account.
  7. Enter a fee account.
  8. Click submit:
  9. If you use Connex for QuickBooks Desktop, run the web connector.

Connex  will save these details to the database and match the deposit in the background. If sales are missing, click log on the top right of the Connex interface.

Was this article helpful?
0 out of 0 found this helpful



Article is closed for comments.