Shopify sends sales receipts from ebay sales. The bank transaction for the sales is less. How do I match?

Hi there, chartley-chucks.

Thank you for visiting again the QuickBooks Community. I'll be sharing some details to ensure you're able to match your transactions accurately.

QuickBooks will automatically match your transactions once it detects entries with similar amounts and details. With this, if the sales receipt has bank fees, you'll have to record each individual transaction to ensure everything will equal n QuickBooks Online. I suggest recording the sales amount in full on the Receive payment page. Then, create an expense to record the fee. This is to ensure you can seamlessly match the downloaded transaction.

Here’s how:

1. In your company, tap the New menu in the upper left and select Expense under Vendors.
2. On the Expense page, fill in the field boxes.
3. In the Category details section, go to the Category column and choose your Shopify fee.
4. Then, type a negative figure in the Amount column.
5. Click Save and close.

If you’re unable to set up the account for your fee, follow the steps in this link. You may want to check with an accountant for the specific category to use to keep your records correct.

Now that you've added the fee, you can start matching the downloaded data to the ones in QBO. Here’s how:

1. Go to the Banking menu on the left panel to select Banking.
2. From the list, choose the account you’re working on.
3. Choose the For review tab and choose the entry and hit the Find Match radio button.
4. On the Match transactions page, tick the boxes for the invoices/sales and expenses.
5. Press the Save menu.

Check out this guide for more insights into this process: Categorise and match online bank transactions in QuickBooks Online.

However, if the bank item amount (payments/bank fees) still doesn't quite match the transaction you entered in QuickBooks, you can use the Resolve difference feature to match them and fix the payment differences until it equals zero.

Follow these steps:

1. Go to the Banking menu and choose the For Review tab.
2. Find the said transactions. Then, select the Find match button to open the Match transactions window.
3. Look for and select the invoice payments to match. You can also use the filters to narrow down your search.
4. Scroll to the bottom of the table and click the Resolve Difference button.
5. Enter the processing fee details. Make sure the total is zero.
6. Click Save when you're ready.

In case you run into some problems when reconciling your accounts, you can refer to this handy article to resolve them: Learn the reconcile workflow in QuickBooks.

You can get back to me anytime if you have questions about handling your transactions. I'm still around to help you.