AccountingShopifyXero

Shopify & Xero – Invoice Reconciliation

Lots of folks out there (even I was also one of them) really get confused when it comes to reconciling the sales invoice payments received or processed through Shopify.

Some merchants may consider integrating a Shopify Fraud Prevention App into the store so as to ensure that only genuine transactions are processed, and any high-risk’ orders are canceled once confirmed by the merchant. This method can be a boon for a Shopify store owner, as you will only have to process and reconcile transactions that are 100% genuine. Once the transactions are checked for fraud, the business can ship off the products to specific clients with the help of shipping service.

However, some may have a small-scale e-commerce business and maybe even employ resources like dropshipping (learn more about dropshipping online and how it can benefit your business) to fulfill client orders. Such businesses could have doubts about using Shopify fraud prevention and accounting services. They might think that they can manage all the finances and transactions by themselves, and they could, but it can be beneficial for small businesses to automate their finances. That can save a business owner a lot of time and resources, which they might spend on hiring a person for an accounting job.

But, accounting software too can get a little confusing.

Don’t get me wrong. Xero has done its best in simplifying accounting process and I love to use this software.

In fact, the integration process is also straightforward. What I meant is that things get a bit dodgy when a business wants to account for the Shopify Fee, an amount which Shopify deducts as a charge to process payments which we will refer to as, “Merchant Charges” throughout this article, coming in from Shopify.

Invoices that Shopify transfers into Xero are gross merchant charges but at the same time, it also sends in merchant charges which you can see in the “Account Transactions” tab of your main bank account in which you receive payments (or pay out of it). However, you will have to create a merchant bank account for all the payments to go through. You can contact your personal bank to discuss the terms of the merchant account for that, but you may face an issue if you have a low credit score, for which you can do research on your part (for instance, look for articles explaining how you can still get a merchant account with bad credit).

About getting payments through Xero, there’s one catch. As said above, the invoice we receive is gross of Merchant Charges, whereas the reconciliation line shows the net amount. The amount which is actually received in the account. Secondly, the merchant charges, though in “Un-reconciled” status in the “Account Transactions” tab (please see image below) never show up in the reconciliation tab.

All of this makes the whole process a bit convoluted.

The screen which I’m talking about is this:
Xero - Account Transactions Window

As you can see the first two transactions starting with Shopify Payments have been updated in Xero. If you go a bit right, you will see the amounts under the “Spend Money” column as well. In our case, they are 1.65 and 1.10.

Let’s just talk about the very first payment which is 1.65.

The current status of this transaction is “Un-Reconciled” as shopify posts them as such. Just to confirm if these transactions have indeed been carried forward from shopify, we need to check out the history of them.

All you have to do is click this transaction and then scroll below to read its history.

The text message would be saying something like this:

Here’s what I’m talking about.

Xero Invoice History

Now, one thing is clear. This payment is in fact coming via shopify. So how do we know if it’s a merchant charge?

That’s fairly simple. Click “Go to Shopify Xero Inte…” button. This will take you to the Shopify’s website.

Here’s the image for your convenience:

Shopify Integration

This will take you to the Shopify’s website where you may need to enter your login credentials after entering which you will land on this page below:

Shopify Order

You can click the Order number to dig in deeper.

Once, we’ve settled that this amount of USD 1.65 is indeed the merchant charge for order number 1380, we now know with which invoice to reconcile it. We’ve configured the invoice number to be the same as the order number which is also 1380 in our case.

Shopify transfers all the invoices in Xero with the status of “Paid”. So all you have to do is find the corresponding amount less the merchant charges in the reconciliation tab. In our case, it will be:

51.9 – 1.65 = 50.25

Now, how to tag the merchant charges with this as well when it will never show up in the reconciliation tab.

For this, you will have to use the “Find & Match” feature that you can find on the upper right side of every reconciliation line:

Xero Find and Match

A list of un-reconciled items will appear in front of you. First, find the invoice against which you want to reconcile the transaction.

Once found, don’t forget to check mark that invoice in order to select it.

Show Spent Items

Now, in order to look for the merchant charges, click the “Show Spent Items” checkbox and enter the amount in the “Search By Amount” field and then click “Go”.

Note that selecting “Show Spent Items” checkbox is necessary as the merchant charges have already been spent.

After selecting both transactions, you will see that the total of the selected transactions is matching with the amount in the reconciliation line. Click the “Reconcile” button to reconcile the transactions and that’s it.

In order to confirm if the transactions have actually been reconciled, we can look up both these transactions in the Account Transactions window.

Do let me know if that worked through the comments section.

4 thoughts on “Shopify & Xero – Invoice Reconciliation

  • Does Shopify cost much to run? I am a WooCommerce user myself, but they have really irritated me lately. I just got hit with a $10k bill for a few plugins I own (completely out of the blue). They have doubled their prices by 50 on all annual renewals – without notifying their beloved customers! Seems pretty weird. Nevertheless, I am looking to jump ship and not sure which shopping cart platform to use with our store.

    • Hi @the Woo Refugee,

      Thanks for the question.

      To be honest, I never compared the two but after your comment, I surfed the web to compare woocommerce and Shopify and I found a link that you will find helpful : https://ecommerce-platforms.com/compare/shopify-vs-woocommerce-comparison

      As far as my opinion is concerned, my vote will be a little inclined towards Shopify as you don’t have to keeping taking out your credit card for every plugin and besides that, all of my clients use Shopify so I believe they trust Shopify more than woocommerce.

      However, that’s my opinion. As a matter of fact, I’ve never used either of the platforms as a store owner, so I believe that my verdict shouldn’t weight a lot.

      Take care. 🙂

  • This is great, but you only talk about the fees from Shopify Payments. Many Shopify users have two or three merchant accounts (PayPal, Stripe, etc.). The theory is the same, but this makes it trickier.

    • Hi Patti,

      Thanks for reading the article.

      Yes, I have only talked about Shopify because I want to keep it restricted it to Shopify and Xero only. Thanks for the feedback though. 🙂

Comments are closed.