Can I match Shopify payouts to a QuickBooks Deposit?

Introduction

Connex  can locate orders matching a deposit and add the total fees as a line item on the deposit. If you have not already, login to Connex and click manage. Expand refunds. Check create check. Connex will add the checks as a refund and associate them with the deposit.

How do I insert the orders into QuickBooks?

Once complete, you must sync all orders associated with the deposit:

  1. Login to Connex.
  2. Select your connection.
  3. Click manage.
  4. Expand the first area.
  5. Change the sync dates.
  6. Click save.
  7. If you use Connex for QuickBooks Desktop, run your web connector.

Once you upload the orders into QuickBooks, upload the payout:

  1. Log into Shopify.
  2. On the right, click view payouts.
  3. Download the payout that you wish to match.
  4. Click export and save it as a plain CSV file.
  5. Go back to Connex.
  6. When in your settings, on left, click match deposits
  7. Upload the spreadsheet to Connex by clicking select payout.
  8. Find your saved CSV file. 

How does the UI appear in Connex?

Once you upload the sheet, follow these steps:

  1. Add the date of the deposit into your bank account.
  2. To add merchant fees in bulk, enter the account to use. If you leave this field blank, then no fees are added. This is ideal if your orders already have fees added by Connex.
  3. Enter the bank account to make the deposit.
  4. Click submit Form

How does a deposit appear?

Here is a screenshot.

What if I am missing sales in QuickBooks?

Connex will log errors about missing sales, if the deposit matching tool fails to find orders. The access the log, click log on the top right of your screen. Here is an example error:

Connex cannot find a sales receipt or payment with the memo 1075. System will skip adding this order the deposit.

If too many sales are missing, the merchant fees exceed the total sales. The deposit becomes negative and you will see this error:

There was an error when saving a Deposit. QuickBooks error message: The deposit subtotal cannot be negative. Please enter a smaller deposit line amount.

To solve this error, resync orders to QuickBooks. Check the log for sync failures. Upload the payout.

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

Comments

0 comments

Please sign in to leave a comment.