If you’re a Shopify merchant who uses QuickBooks for your accounting, you may be wondering how to reconcile your Shopify payments in QuickBooks. Here’s a step-by-step guide to help you out.
First, log in to your Shopify account and go to Settings > Payments. Under the “Accept Credit Cards” section, you’ll see a list of all the payment providers that you’ve used to process payments on your store. Find the one that says “Shopify Payments” and click on the “Manage” button next to it.
On the next page, you’ll see all of the details about your Shopify Payments account, including your account number. Make a note of this account number, as you’ll need it in QuickBooks.
Next, log in to QuickBooks and go to the “Banking” menu. Under the “Bank Accounts” section, click on the “Add Account” button.
On the next page, select “Shopify Payments” from the list of banks and enter your Shopify Payments account number in the field provided. Then click on the “Continue” button.
QuickBooks will now bring up all of your recent transactions from Shopify Payments. You can use the filters at the top of the page to select which transactions you want to import into QuickBooks. Once you’ve made your selections, click on the “Import Selected” button.
You’ll now see all of your imported transactions in QuickBooks. To reconcile them, simply follow the reconciliation process for any other bank account in QuickBooks.
Conclusion:
Reconciling your Shopify payments in QuickBooks is a simple process. Just follow the steps outlined above and you’ll be done in no time.
