How does the Connex Match Deposit Tool work?
Matching deposits and orders can take several hours. If orders are missing or the totals are incorrect, it is almost impossible to determine the issue. Connex can find matching orders and log missing transactions.
How do I enable the feature?
To get started with the Connex Match Deposit Tool, login to Connex. Next, from the dashboard, on the left-hand side click Orders > Match deposits to begin.
- For in depth help getting started with the Connex Match Deposit Tool, please click here.
- IMPORTANT: The Connex Match Deposit Tool requires a Pro subscription or higher.
In the match deposits form, what is the function of each field?
When you set-up the auto matching of deposits, you will see these fields:
|Begin Date for Search||If you wanted deposits from June 1 to June 3, this value is June 1.|
|End Date for Search||If you wanted deposits from June 1 to June 3, this value is June 3.|
|Deposit Account To||The bank account in QuickBooks that is connected to your live bank account. The account type must be bank in QuickBooks.|
|Fee Deposit Account To||Connex will add your merchant fees on the deposit. This account tracks the merchant fees. This account is of type expense.|
|Received From for Fees||A customer or vendor vendor in QuickBooks.|
When deposits are matched, there is a line item at the end for fees and the amount is negative. Here is how the fee deposit account and received from fees map:
How does Connex match the orders?
Connex matches the orders by transaction ID and order date. Next, Connex places the transaction ID or payment reference ID into the sales receipt or for an invoice, the payment memo field. Connex will pull all payments or sales receipts within seven days of the deposit. If there is a match between the memo and payment reference numbers, then Connex will locate the sale and build the deposit.
For Amazon and Shopify, Connex matches sales by the Shopify order number.
Is there a way to manually upload the settlement report and run the deposit manually?
From the Connex dashboard, click Orders > Match Deposits. The form will ask for the settlement report, deposit account and to enable adding fees. If your payment processor is missing, upload a CSV spreadsheet file with a field called order number. Ensure that field matches the order number from QuickBooks.
Can I see a preview of what Connex will match?
Sure can. From the Match Deposit set-up page, click the preview button:
What does the deposit look like?
Here is an example from QuickBooks Online, using payment gateway Stripe: