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:
|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:
- Login to Connex .
- Click manage.
- On the left, click match deposits.
- Enter a deposit date.
- Upload the spreadsheet.
- Enter a deposit account.
- Enter a fee account.
- Click submit:
- 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.