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 does Connex find matching orders?
If you use Stripe, each Stripe transaction has an auto-generated ID beginning with ch. Connex maps this ID to the QuickBooks reference number and the private notes field. Our tool asks QuickBooks for orders where the first twenty-one characters of the reference number equals the first twenty-one characters of the Stripe transaction ID. If there is more than one match, Connex will use the private notes field. Since QuickBooks credit memos and refunds have no reference number field, Connex searches for refunds in the last seven days. Then, Connex checks the private notes field.
How does it work?
Once a day, Connex pulls a list of transactions that match your deposit. Connex finds matching orders and creates a deposit. If the report contains fees, Connex will add them. In QuickBooks, go to transactions and click banking. You must add your bank account, so QuickBooks will download the transactions from your bank. You will be asked to match deposits and the bank transactions. Next to PayPal, here is the end result:
Without our software, you need to click match and find the orders. Then, add fees. Connex does that for you.
How can I tell if orders are missing?
Log into Connex . Hover over the gear and click transaction log.
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 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:
Can the settlement report be downloaded automatically?
Right now, Stripe is the only compatible payment processor.
Connex has a scheduled task the runs at 5 am EST. The tool will download the settlement report, add the fees to the deposit, find matching orders, and deposit them. Please contact us to enable the task and to discuss pricing. Here is the form:
Can Connex add merchant fees?
Connex can add the fees to the deposit or on each individual order. To add fees per order, please read this guide. If you had one of these providers, Connex can add the fees to the deposit:
For Amazon, you need to run the task every two weeks. Please contact us to enable the auto-run. For Shopify Payments, click the advanced tab on Connex . Under advanced fee settings, enter the fees. Connex will add the fees to each order. There is no need to add fees to the deposit.
How does Connex match the orders?
The settlement report has a field called invoice number, order number, or source. If that number, trimmed to twenty-one characters, matches an order Connex will deposit it. If you use the next number from QuickBooks or a different numbering scheme, please contact us.
Is there a way to manually upload the settlement report and run the deposit manually?
At the Connex configure page, click 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 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?
On the deposit page, click the link above the date range. Enter the dates to preview. Here is an example.
What does the deposit look like?
Here is an example with the fees.
What if my refunds exceeded my sales?
If your merchant processor removes funds from your account, your deposit would be negative. QuickBooks allows no negative deposits. Connex can match the refunds and sales, then add a positive number to bring the deposit to zero. Here is an example.
In QuickBooks, go to transactions and click banking on the left. Find the withdrawal. Assign it to an expense account. Here is an example.
Connex matches the QuickBooks reference number or order number field to the transaction ID. In Stripe, the ID looks like ch_19ld6GAFqXjzdyohHDJVDrfK. For Shopify and WooCommerce customers using Stripe, this field is automatically applied:
If you use another payment processor, please contact us.
What if my deposit is off?
Connex can create a line item to subtract or add money to the deposit, so it matches your bank register. On the deposit configure page in Connex, select an account under refund and negative deposit account. Here is an example of Connex matching the deposit.
The transaction cannot be applied to Deposit. Either Referenced Transactions Account is incorrect or the Transaction has already been applied to another Deposit
In your list of orders to reconcile, one of the orders has been already deposited. Connex offers no way, at this time, to determine whether an order has been deposited. Here is an example deposited order: