What is the import format to record sales from eCommerce sites?

You can import bulk sales data from eCommerce sites into QuickBooks using a CSV format, Bonnie.

QuickBooks lets you import transactions like invoices, expenses, or deposits using Excel CSV files. Keep in mind that only certain fields, like Date, Item Quantity, Item Rate, and Item Amount, will be imported. Fees or shipping costs won’t be added automatically.

To make sure the process goes smoothly, check that your file columns match QBO requirements or download a sample file for reference.

Here's how:

1. Select Import Data from the Gear icon.                                                                                        
2. Click the drop down arrow on the record type and select the Data you want to import.                                                                              
3. Once located, click the Next option below and enter the Date format correctly. Then, choose Next.
4. Follow the on-screen instructions to upload and map your file, then select Continue to complete the import.

Alternatively, you can consider using a third-party application that can automatically import your sales transactions from eCommerce into QBO.

You can refer to these following articles for more guidance in importing data in QuickBooks Online:

• Import multiple invoices at once in QuickBooks Online.
• How to import sales receipts.

Also, to enhance your QuickBooks experience, our QuickBooks Live Expert Assisted team is here to help with bookkeeping, navigation, and all your business needs.

For any additional queries regarding data import in QuickBooks Online, kindly utilize the comment section below.