If you're having trouble reconciling Shopify gateways in QuickBooks and you find discrepancies, follow these steps. We'll use "Acima Finance" as an example.
View the QuickBooks Balance Sheet. In QuickBooks, go to Reports, then Balance Sheet.
Select the gateway you want to reconcile (in this example, Acima Finance). Set the date range from your last reconciliation date to today to see ConnectBooks invoices and bank deposits.
Group transactions by type. Use the dropdown to group transactions by "Transaction Type". This separates ConnectBooks invoices from bank deposits. In this example, ConnectBooks invoices total $11,734.92.
Check Shopify Analytics. Log in to Shopify and go to Analytics, then Reports, then Summary. Look for Acima Payments. In this example, Shopify shows a total of $11,734.92 across the 2 "Acima Payment" gateways.
Check ConnectBooks. On the Accounting Export page, select the same date range. Use the Select Gateway dropdown and choose the gateway. Compare the "Fund Transfer" total for each settlement.
Find the discrepancy. Check that the totals add up and match the amount in QuickBooks.
If ConnectBooks matches Shopify, the discrepancy is with the gateway or in QuickBooks. To look into it further, log in to the gateway itself, such as Acima Finance, and troubleshoot from there.
Frequently asked questions
Which QuickBooks report do I use?
The Balance Sheet. Open the gateway's account and set the date range from your last reconciliation date to today.
How do I see only 1 gateway in ConnectBooks?
On the Accounting Export page, use the Select Gateway dropdown and choose the gateway.
ConnectBooks matches Shopify, but QuickBooks doesn't. What now?
The difference is with the gateway or in QuickBooks. Log in to the gateway and check its records.