Matching deposits and orders can take several hours. If orders are missing or the totals are incorrect, it be almost impossible to determine the issue. Cloud Cart can find matching orders and log missing transactions.
How does it work?
Once a day, Cloud Cart pulls a list of transactions that match your deposit. Cloud Cart finds matching orders and creates a deposit. If the report contains fees, Cloud Cart will add them. In QB, go to transactions and click banking. You must add your bank account, so QB 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. Cloud Cart does that for you.
How can I tell if orders are missing?
Log into Cloud Cart Connector. Hover over the gear and click transaction log.
Can the settlement report be downloaded automatically?
For these providers, Cloud Cart can automatically download the report:
- PayPal (coming soon!)
- Shopify Payments
Other payment processors might make their reports available for automatic download. Please contact us about adding them.
Cloud Cart has a scheduled task the runs at 4 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 Cloud Cart add merchant fees?
Cloud Cart 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, Cloud Cart 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 Cloud Cart. Under advanced fee settings, enter the fees. Cloud Cart will add the fees to each order. There is no need to add fees to the deposit.
How does Cloud Cart 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 Cloud Cart 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 Cloud Cart 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 QB.
What does the deposit look like?
Here is an example with the fees.
Cloud Cart matches the QB reference number or order number field to the transaction ID. In Stripe, the ID look like ch_19ld6GAFqXjzdyohHDJVDrfK. For Shopify and WooCommerce customers using Stripe, this field is automatically applied:
If you use another payment processor, please contact us.
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. Cloud Cart offers no way, at this time, to determine whether an order has been deposited. Here is an example deposited order: