--- title: QuickBooks Online Export description: Knowledge Base --- [Skip to content](https://help.artcloud.com/knowledge/quickbooks-online-export#main-content) English - United States Show submenu for translations [Submit a Support Ticket](https://help.artcloud.com/knowledge/kb-tickets/new?hsLang=en-us) [![ArtCloud Full Combo Logo-4](https://help.artcloud.com/hs-fs/hubfs/ArtCloud%20Full%20Combo%20Logo-4.png?width=250&height=75&name=ArtCloud%20Full%20Combo%20Logo-4.png)](https://www.artcloud.com) Open main navigation Close main navigation - English - United States Show submenu for translations - [Submit a Support Ticket](https://help.artcloud.com/knowledge/kb-tickets/new) - [Login](https://hello.artcloud.com/login) [Login](https://hello.artcloud.com/login) How can we help you? - There are no suggestions because the search field is empty. 1. [ArtCloud Knowledge Base](https://help.artcloud.com/knowledge?hsLang=en-us) 2. [ArtCloud Manager - Analytics](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us) 3. [Sales Over Time](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#sales-over-time) July 15, 2026 # QuickBooks Online Export ## Our new QBO Export from the Sales Over Time report allows export of ArtCloud invoices that can be imported from a .CSV file to QuickBooks Online. To access the QuickBooks Online Export, first go to the Sales Over Time report under the Analytics Section.  ![](https://help.artcloud.com/hubfs/Knowledge%20Base%20Import/Screen%20Shot%202021-03-29%20at%205-16-28%20PM-png.png) You'll first select the appropriate date range at top right for the Sales you'd like included in this export. TIP: The Sales Over Time report brings in sales based on your Accounting Method selected in Account Settings \> Configuration \> Accounting Method. The Cash method will filter dates based on the Invoice Closed Date (and not include open invoices). The Accrual Method will filter dates based on when the Invoice Create Date. Then click the Actions Drop Down \> Export \> QuickBooks Online  ![Screen Shot 2021-05-27 at 11.17.08 AM](https://help.artcloud.com/hs-fs/hubfs/Knowledge%20Base%20Import/Screen%20Shot%202021-05-27%20at%2011_17_08%20AM.png?width=670&name=Screen%20Shot%202021-05-27%20at%2011_17_08%20AM.png) Field Mapping We have mapped the data in ArtCloud over to QBO invoice fields in a simple and broadly applicable way to the many ways galleries can use QBO. You may need to tweak the invoice level data once inside QBO.  | **QBO Export Column** | **ArtCloud Invoice Data** | | --- | --- | | InvoiceNo | Invoice # | | \*Customer | Contact | | \*InvoiceDate | Date | | \*DueDate | Date | | Terms | n/a | | Location | Location | | Memo | Invoice Comments | | Item(Product/Service) | n/a  \[see note below\] | | ItemDescription | Combined: \[Title\], \[Edition\], \[Year\] by \[Artist\] If Discounted then "Price: \[Price\]" and "Discount: \[Discount\]" will also appear here. | | ItemQuantity | Quantity | | ItemRate | Line Item Subtotal per quantity (after applied discount), see note below | | \*ItemAmount | Line Item Subtotal (after applied discount), see note below | | Taxable | Y or N based on Line Item Tax applied | | TaxRate | Tax Rate that corresponds to Line Item Tax selected | | ServiceDate | n/a | | ShippingAddress | Shipping Address or Billing Address if no Shipping Address | | ShippingCharge | Shipping | | Email | contact email | | Price | full inventory line item price, (not imported to QBO) | | Applied Discount | applied discount to line item price, (not imported to QBO) | Some important notes when you import this file into QuickBooks Online (QBO):  - The export is at the **invoice line item level**. If an invoice has multiple line items, the .csv file will have multiple lines with the invoice number repeated for each line item. - **Item(Product/Service).** QBO requires that the Product/Service field match *exactly* or the import will fail. Because each gallery uses different taxonomies for Product/Service within QBO, we leave this field blank in our export. You can choose to leave them blank and map them (or not) once the invoices are imported into QBO or if you match them exactly you can add them to the CSV prior to import. - **Invoice numbers.** To use the ArtCloud Invoice numbers, you'll need to make sure in your QBO Account that you turn on "Custom transaction numbers" in Accounts and Settings or your invoice numbers will be replaced by standard QuickBooks invoice numbers. - **Discounts.** QBO doesn't have a way to import discounts or negative amounts through their standard importer. To work around this, our export .csv does the following as it relates to discounts: - The column *Price* is the full price of the inventory item sold -- this is not imported into QBO but for your information only. - The column *Applied Discount* is the dollar amount of discount applied to the line item. If a percentage discount was applied to the ArtCloud invoice, this is calculated to the appropriate dollar amount. If an invoice-level discount (percentage or dollar) was applied to the ArtCloud invoice, the discount is distributed proportionately across the line items. - The column *Item Amount* is the net amount of *Price - Applied Discount*. This is what is imported as the Invoice Line Item Amount on the Quickbooks Invoice. - To add more clarity to the final invoice in Quickbooks, for items that are discounted, we echo out the full price and the applied discount inside the Item Description (on new lines). - The resulting QBO line items with discounts will look like this: ![](https://help.artcloud.com/hubfs/Knowledge%20Base%20Import/Screen%20Shot%202021-03-29%20at%205-46-06%20PM-png.png)   The QBO importer does not allow for payment information / invoice status as part of their import. You will need to go into each invoice and update invoice status accordingly after import.  #### Importing your Invoices into Quickbooks Online Once you've exported your QBO .CSV file, you can upload it into your QBO account via Sales \> Invoices: ![](https://help.artcloud.com/hubfs/Knowledge%20Base%20Import/Screen%20Shot%202021-11-16%20at%209-13-46%20AM-png.png) Next, using the drop down arrow next to 'Create invoice', select **Import Invoices**. ![](https://help.artcloud.com/hubfs/Knowledge%20Base%20Import/Screen%20Shot%202021-11-16%20at%209-14-18%20AM-png.png) You'll then see the Importer pop-up to upload your .CSV file you downloaded from ArtCloud. ![](https://help.artcloud.com/hubfs/Knowledge%20Base%20Import/Screen%20Shot%202021-11-16%20at%209-20-55%20AM-png.png) - [Welcome to ArtCloud](https://help.artcloud.com/knowledge/welcome-to-artcloud?hsLang=en-us#main-content) - [Subscription](https://help.artcloud.com/knowledge/welcome-to-artcloud?hsLang=en-us#subscription) - [Navigation](https://help.artcloud.com/knowledge/welcome-to-artcloud?hsLang=en-us#navigation) - [Records](https://help.artcloud.com/knowledge/welcome-to-artcloud?hsLang=en-us#records) - [Extras](https://help.artcloud.com/knowledge/welcome-to-artcloud?hsLang=en-us#extras) - [Getting Started Series](https://help.artcloud.com/knowledge/getting-started-series?hsLang=en-us#main-content) - [Manager](https://help.artcloud.com/knowledge/getting-started-series?hsLang=en-us#manager) - [Website Builder](https://help.artcloud.com/knowledge/getting-started-series?hsLang=en-us#website-builder) - [ArtCloud for Artists](https://help.artcloud.com/knowledge/artcloud-for-artists?hsLang=en-us#main-content) - [Gallery Connections and Consignments](https://help.artcloud.com/knowledge/artcloud-for-artists?hsLang=en-us#gallery-connections-and-consignments) - [Data Import](https://help.artcloud.com/knowledge/artcloud-for-artists?hsLang=en-us#data-import) - [Account Settings](https://help.artcloud.com/knowledge/artcloud-for-artists?hsLang=en-us#account-settings) - [Account Settings](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#main-content) - [Profile](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#profile) - [Billing & Subscription](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#billing-subscription) - [Locations](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#locations) - [Configuration](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#configuration) - [Email Templates](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#email-templates) - [Collateral Style](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#collateral-style) - [Stripe Integration](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#stripe-integration) - [Other Integrations](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#other-integrations) - [User Management](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#user-management) - [Data Import](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#data-import) - [Tag Management](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#tag-management) - [Batches](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#batches) - [Merge Contacts](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#merge-contacts) - [Blocked Emails](https://help.artcloud.com/knowledge/account-settings?hsLang=en-us#blocked-emails) - [ArtCloud Website Builder](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#main-content) - [Understanding the Website Builder](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#understanding-the-website-builder) - [Design](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#design) - [Pages](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#pages) - [Blocks / Snippets](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#blocks-snippets) - [Resource Templates - Artist Profile](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#resource-templates-artist-profile) - [Resource Templates - Inventory Detail](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#resource-templates-inventory-detail) - [Resource Templates - Exhibition Detail](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#resource-templates-exhibition-detail) - [Resource Templates - Header](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#resource-templates-header) - [Resource Templates - Footer](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#resource-templates-footer) - [Other Resource Templates](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#other-resource-templates) - [Inventory Block Configuration](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#inventory-block-configuration) - [Artist Block Configuration](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#artist-block-configuration) - [Exhibition Block Configuration](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#exhibition-block-configuration) - [Blog](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#blog) - [Media](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#media) - [Settings](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#settings) - [Navigation](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#navigation) - [Domains](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#domains) - [Tips and Tricks](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#tips-and-tricks) - [Extras](https://help.artcloud.com/knowledge/artcloud-website-builder?hsLang=en-us#extras) - [ArtCloud Manager - Dashboard](https://help.artcloud.com/knowledge/artcloud-manager-dashboard?hsLang=en-us#main-content) - [Messages](https://help.artcloud.com/knowledge/artcloud-manager-dashboard?hsLang=en-us#messages) - [New Arrivals](https://help.artcloud.com/knowledge/artcloud-manager-dashboard?hsLang=en-us#new-arrivals) - [ArtCloud Manager - Inventory](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#main-content) - [Inventory Dashboard](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#inventory-dashboard) - [Inventory Record Overview](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#inventory-record-overview) - [Inventory Record - Financial](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#inventory-record-financial) - [Inventory Record - Uploads](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#inventory-record-uploads) - [Inventory Record - Marketplace/Website](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#inventory-record-marketplace-website) - [Inventory Record - History](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#inventory-record-history) - [Editions](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#editions) - [Exhibitions](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#exhibitions) - [Quicklists](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#quicklists) - [Consignment](https://help.artcloud.com/knowledge/artcloud-manager-inventory?hsLang=en-us#consignment) - [ArtCloud Manager - Artists](https://help.artcloud.com/knowledge/artcloud-manager-artists?hsLang=en-us#main-content) - [Artists Dashboard](https://help.artcloud.com/knowledge/artcloud-manager-artists?hsLang=en-us#artists-dashboard) - [Artist Record - Profile](https://help.artcloud.com/knowledge/artcloud-manager-artists?hsLang=en-us#artist-record-profile) - [Artist Record - Contact](https://help.artcloud.com/knowledge/artcloud-manager-artists?hsLang=en-us#artist-record-contact) - [Artist Record - Consignment](https://help.artcloud.com/knowledge/artcloud-manager-artists?hsLang=en-us#artist-record-consignment) - [Artist Record - Payments](https://help.artcloud.com/knowledge/artcloud-manager-artists?hsLang=en-us#artist-record-payments) - [Artist Record - Marketplace/Website](https://help.artcloud.com/knowledge/artcloud-manager-artists?hsLang=en-us#artist-record-marketplace-website) - [ArtCloud Manager - Invoices](https://help.artcloud.com/knowledge/artcloud-manager-invoices?hsLang=en-us#main-content) - [Invoices Dashboard](https://help.artcloud.com/knowledge/artcloud-manager-invoices?hsLang=en-us#invoices-dashboard) - [Invoice Record - Invoice](https://help.artcloud.com/knowledge/artcloud-manager-invoices?hsLang=en-us#invoice-record-invoice) - [Invoice Record - Payments](https://help.artcloud.com/knowledge/artcloud-manager-invoices?hsLang=en-us#invoice-record-payments) - [Logistics and Purchase Orders](https://help.artcloud.com/knowledge/artcloud-manager-invoices?hsLang=en-us#logistics-and-purchase-orders) - [ArtCloud Manager - Contacts](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#main-content) - [Contacts Dashboard](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#contacts-dashboard) - [Contact Records](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#contact-records) - [Contact Record - Interests](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#contact-record-interests) - [Contact Record - Opportunities](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#contact-record-opportunities) - [Contact Record - Activities](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#contact-record-activities) - [Contact Record - Purchase History](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#contact-record-purchase-history) - [Contact Record - Financial](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#contact-record-financial) - [Audiences - ArtCloud Marketing](https://help.artcloud.com/knowledge/artcloud-manager-contacts?hsLang=en-us#audiences-artcloud-marketing) - [ArtCloud Manager - Sales & Marketing](https://help.artcloud.com/knowledge/artcloud-manager-sales-marketing?hsLang=en-us#main-content) - [Private Views](https://help.artcloud.com/knowledge/artcloud-manager-sales-marketing?hsLang=en-us#private-views) - [To-Dos](https://help.artcloud.com/knowledge/artcloud-manager-sales-marketing?hsLang=en-us#to-dos) - [Campaigns - ArtCloud Marketing](https://help.artcloud.com/knowledge/artcloud-manager-sales-marketing?hsLang=en-us#campaigns-artcloud-marketing) - [Promo Codes](https://help.artcloud.com/knowledge/artcloud-manager-sales-marketing?hsLang=en-us#promo-codes) - [Opportunities - ArtCloud Sales](https://help.artcloud.com/knowledge/artcloud-manager-sales-marketing?hsLang=en-us#opportunities-artcloud-sales) - [ArtCloud Manager - Analytics](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#main-content) - [Analytics Overview](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#analytics-overview) - [Sales Over Time](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#sales-over-time) - [Payments](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#payments) - [Taxes](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#taxes) - [Artist/Consigner Payments](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#artist-consigner-payments) - [Commission](https://help.artcloud.com/knowledge/artcloud-manager-analytics?hsLang=en-us#commission) - [The ArtCloud Marketplace](https://help.artcloud.com/knowledge/the-artcloud-marketplace?hsLang=en-us#main-content) - [Marketplace](https://help.artcloud.com/knowledge/the-artcloud-marketplace?hsLang=en-us#marketplace) - [Privacy and Terms](https://help.artcloud.com/knowledge/privacy-and-terms?hsLang=en-us) - [ArtCloud Announcements](https://help.artcloud.com/knowledge/artcloud-announcements?hsLang=en-us) [![Logo\_Signifer\_Graphite\_CMYK](https://help.artcloud.com/hs-fs/hubfs/Logo_Signifer_Graphite_CMYK.png?width=63&height=73&name=Logo_Signifer_Graphite_CMYK.png "Logo_Signifer_Graphite_CMYK")](https://www.artcloud.com) Copyright © 2026, Artlogic Media Limited