Skip to main content
Under Review

Quickbooks Online integration

Related products:Stores, Carriers, and Other Integrations
  • October 31, 2017
  • 9 replies
  • 16 views

When importing orders into Quickbooks Online it sets the Sales Receipt date to the day I import them. Why not set the date to the shipping date? Please fix this. It makes no sense to use the import date and at least the shipping date would be more accurate as to when the order occured. Imagine importing 300 orders from August and then having to go back and fix the date on each one because you imported them in October.

9 replies

  • November 1, 2017
Thanks so much for adding this idea! We'll keep this in mind for the future but we'd like to see some more user interest before we move forward on implementing a change. If you know any other users that are interested please send them here!

  • March 16, 2018
Totally agree! This is a HUGE flaw in the export. The sad part is when we went back to fix the date on the orders QBO ended up making the order $0. So the orders were messed up and the accounting is messed up because Shipstation does not import with the correct date.

  • February 1, 2019
I am here to support this change!

  • January 19, 2020
Also interested in this. US GAAP accounting standards generally say that you recognize revenue when you deliver a product to a customer (and the most common proxy for that is the ship date). Since Quickbooks recognizes revenue on the sales receipt date or invoice date, setting that to the ship date would be in keeping with US GAAP standards.

  • April 1, 2020
I would like to see this also. I'm surprised that is not the default way it works to be honest. Setting the order date in Quickbooks to the date the order was imported makes no sense. It should use the actual order date or the ship date.

  • December 14, 2020
When the Quickbooks online integration creates a sales receipt or invoice in QBO, it should include the country in the "Shipping to" field. When you don't do this, it screws up how Quickbooks automatically tries to calculate sales tax (it assumes if it can't find the state, that the order should have your default sales tax settings applied, when for international orders it should usually not have any sales tax applied at all). So now I have to go manually edit each order to add the country to the shipping address which is a gigantic waste of time for something that could have been done automatically by Shipstation.

Marker8gear

ABSOLUTELY NEED TO have the shipments transfer to QBO as of the SHIP DATE! or give us the option!!

 


PAMCORP
  • February 8, 2023

Why hasn't this been addressed. This is a no brainer and it ruins the import function. The ship date should be the date recorded in quickbooks. PLEASE FIX THIS.

-Brandon


jjjschmidt
  • Employee
  • February 23, 2024
The Quickbooks integration is quite troublesome.  
 
I have to tell SS to send orders to QB manually.  I have to give SS a date that the orders were placed to send them to QB.  SS then checks to see if any orders placed on that date were shipped and, if they were, SS sends those shipped orders to QB.  The sales receipt created in QB dated the day that it gets sent to QB, NOT the date the order was created.  
 
So - If I have 10 orders placed on a certain date - and each of those orders is shipped on a separate day - then I have to tell SS to process orders from that date 10 separate times to get all the orders to QB.   AND - each of the 10 orders from that one date will be posted on a different date in QB.  That is so sloppy and makes record keeping a nightmare.  

This thread was started in 2017.  It's now 2024.  I'm just getting started with SS and QB and this issue has not been resolved.  Not only that, but I don't see any comment in this thread from SS?  

I reached out to support about this and here is the solution they proposed:

ShipStation will only send over information to Quickbooks for orders that are in shipped status, so if you create your labels for your orders the day your orders import into ShipStation, the transaction date within Quickbooks should be correct.

It's not a solution.  They are just telling me that I can get the dates correct in QB if I process and ship all orders on they dates they are placed.  So I guess I have to come in on weekends and holidays now...  

 

 


Yini
  • Employee
  • April 24, 2026

Hello Product Team,

We recently transitioned to ShipStation primarily due to its direct integration with QuickBooks Online (QBO). While the integration is active, we are encountering a critical issue with invoice creation.

When invoices are pushed to QBO, the system automatically generates a new invoice number instead of using our order number. This is causing significant disruption to our workflow, as we require the order number to be used as the invoice number for tracking and reconciliation purposes.

Currently, mapping the order number to the memo field is not a viable solution, as it does not resolve the core issue of invoice numbering.

We request one of the following:

  1. Allow us to map the order number directly to the invoice number field, or

  2. Modify the existing hardcoded behavior to use the order number as the invoice number

If neither option is possible, please provide an alternative solution that ensures consistency in our invoicing process.

This issue has halted our operations for several weeks, so we would appreciate your urgent attention and clear guidance on how to proceed.

Thank you,
Xia Home Fashions