Skip to main content
S
SoniaMB
November 14, 2023
Solved

Shopify quick books integration

  • November 14, 2023
  • 1 reply
  • 0 views

Hello,

I am using Shopify as my POS for my bricks and mortar shop. Figured out how to transfer my sales from Shopify onto QB using the sync thingy. However, I have noticed that one transaction is showing the full amount, part of that transaction was refunded to the customer. The order in Shopify shows the refund, but the sales transaction in QB shows the full amount. Do I need to add the refund to QB manually? Or am I looking in the wrong place? Thanks in advance.

Best answer by SirielJeaB

I have the information you need and will assist you in recording your transaction, SoniaMB.

 

You may not have set up the options for refund transactions before the integration process, which may be why QuickBooks only shows the total amount of the sales transaction.

 

To ensure proper mapping of refund transactions in QuickBooks, select the option to Create Credit Notes and Refunded or Partially Refunded status on the order filter. Then, map a Fallback account and input a Refund Number Prefix.

 

Check out this article for detailed information: Shopify and QuickBooks Online Integration Guide.

 

In the meantime, let's address your concern by adding the refund transaction manually. Here's how:

 

  1. Click on +New.
  2. Select Credit Note.
  3. Fill in the necessary details.
  4. Tap on Save and Close.

 

You can also personalise the data of your sales forms within the program. Please read this reference: Customise invoices, estimates, and sales receipts in QuickBooks Online.

 

Let me know if you have other concerns regarding your sales transactions. Just a few clicks, and I'll be there to assist you again.

1 reply

S
SirielJeaBAnswer
November 14, 2023

I have the information you need and will assist you in recording your transaction, SoniaMB.

 

You may not have set up the options for refund transactions before the integration process, which may be why QuickBooks only shows the total amount of the sales transaction.

 

To ensure proper mapping of refund transactions in QuickBooks, select the option to Create Credit Notes and Refunded or Partially Refunded status on the order filter. Then, map a Fallback account and input a Refund Number Prefix.

 

Check out this article for detailed information: Shopify and QuickBooks Online Integration Guide.

 

In the meantime, let's address your concern by adding the refund transaction manually. Here's how:

 

  1. Click on +New.
  2. Select Credit Note.
  3. Fill in the necessary details.
  4. Tap on Save and Close.

 

You can also personalise the data of your sales forms within the program. Please read this reference: Customise invoices, estimates, and sales receipts in QuickBooks Online.

 

Let me know if you have other concerns regarding your sales transactions. Just a few clicks, and I'll be there to assist you again.

    S
    SoniaMBAuthor
    November 15, 2023

    Hi, thanks for this. I've made a credit note for that item that was refunded. It was asking for a customer email so I put my own, as it was an instore transaction and I don't ask for customer email addresses - my online shop is not up and running time, I only have a bricks and mortar store.

    I don't understand this bit here - 

    To ensure proper mapping of refund transactions in QuickBooks, select the option to Create Credit Notes and Refunded or Partially Refunded status on the order filter. Then, map a Fallback account and input a Refund Number Prefix.

     

    I don't know where this option to create credit notes is.

    I am a complete novice and didn't do the initial set up but I am trying to learn! 

     

    Bryan_M
    Bryan_M
    November 15, 2023

    Thanks for coming back to this thread, @SoniaMB.

     

    We see your eagerness to learn the functionality of credit notes after integrating QBO and Shopify. Let me share insights about mapping refund transactions in QBO and locate the option to create credit notes.

     

    After connecting Shopify to QBO, ensure to configure it. This will present various options on how integration of both systems works.

     

    Just like my colleague stated, you have the option to Create Credit Notes in QBO. In this workflow, you'll be asked to map a Fallback account from which the payment is refunded. 

     

    Furthermore, you'll be prompted to input your preferred Refund Number Prefix which will be appended before the refund receipt number.

     

    Select the Refunded and Partially Refunded status on the order filter if you wish to sync credit notes to your accounting app.

     

     

    Moreover, to sync fees in QBO, the payments section, and the payment method accounts should be configured according to the following:

    • QuickBooks US and CA: Credit cards or checking bank accounts.
    • QuickBooks AU and UK: Cash accounts.
    • Other regions: Configure any account.

     

     

    For detailed info, feel free to read this article: Shopify and QuickBooks Online Integration Guide.

     

    You might want to give delayed credit to customers, feel free to read this article: Create and apply credit notes or delayed credits in QuickBooks Online.

     

    If you have additional questions about managing the integration of QBO and Shopify, don't hesitate to come back here. I'll be happy to help. Take care always.

     

    Terms & ConditionsAccessibility statement