{"id":20263,"date":"2023-07-27T13:10:14","date_gmt":"2023-07-27T17:10:14","guid":{"rendered":"https:\/\/certek.com\/kb4\/?post_type=ht_kb&p=20263"},"modified":"2026-02-06T17:14:04","modified_gmt":"2026-02-06T22:14:04","slug":"export-data-from-quickbooks-pos","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/export-data-from-quickbooks-pos\/","title":{"rendered":"Export Data from QuickBooks POS"},"content":{"rendered":"\n

In order to retrieve information from QuickBooks POS to import into Artisan, you\u2019ll need to run some reports. The following steps are shown using the \u201cItem List Report,<\/strong>\u201d but are similar for most reports.<\/p>\n\n\n\n

CerTek Support Staff: For a list of files to be collected for each QB Export, click here<\/a><\/strong>.<\/p>\n\n\n\n

Be aware of the following areas when exporting and importing data:<\/em>

a)<\/strong> If exporting more than one file type from QuickBooks POS to Artisan, make sure you change the file name. Otherwise, QuickBooks POS will think you are trying to overwrite your previously exported file.

b)<\/strong> Extra or duplicate vendor records can be caused by manufacturer records.

c)<\/strong> If a vendor is deleted on the QB vendor list but an item still has that vendor listed as its vendor on file, Artisan will create a record for that vendor. However, you can identify which vendors need to be deleted since these records will not display any address details.<\/p>\n\n\n\n

Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission.<\/p>\n\n\n\n

Export Data from QuickBooks POS<\/h3>\n

Click on the “Reports<\/strong>” tab,\u00a0then select “Report Center<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Determine which report you want to run.\u00a0<\/p>\n

Item List Report<\/strong><\/p>\n

This report is especially useful for grabbing data about item records.\u00a0<\/p>\n

Once you select a report, you’ll see the “Modify a Report<\/strong>” screen. Select “Add or Remove Columns<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

In most cases, you’ll want to check off every field to ensure that you’re retrieving all the data you need. Press “Save<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Next, select “Filter Data<\/strong>” on the “Modify a Report<\/strong>” screen.<\/p>\n

If there are any filters applied, select “Clear All<\/strong>” to remove them. You’ll need to scroll down the list to ensure you don’t miss any filters. When you reach the “1 Qty<\/strong>” field, change its value to -10000<\/strong> to 10000<\/strong> instead of 0. Remove any filters that say “Exclude<\/strong>.” Press “Save<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Next, select “Change Report Appearance<\/strong>” on the “Modify a Report<\/strong>” screen.<\/p>\n

Make sure the “Report Orientation<\/strong>” is set to “Landscape<\/strong>.” Check off all fields under “Show Header Information<\/strong>” (ex. Company Name, Report title, etc.).<\/p>\n

Uncheck “Page number<\/strong>.” Press “Save<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

On the “Modify a Report<\/strong>” screen, check off “Print Full Descriptions<\/strong>.” Run the report.<\/p>\n

\"\"<\/a><\/p>\n

Once the report has loaded, click on “Excel<\/strong>.” This will create an Excel document of the report.<\/p>\n

\"\"<\/a><\/p>\n

<\/a>Files to Collect for Each QB POS Export Customer<\/strong><\/h3>\n

Notes for CerTek Support staff – run these reports to gather the following files for each QB Export customer:<\/p>\n

\"\"<\/a><\/p>\n\n\n","protected":false},"excerpt":{"rendered":"

Intuit and QuickBooks are registered trademarks of Intuit Inc. Used with permission. Export Data from QuickBooks POS Click on the “Reports” tab,\u00a0then select “Report Center.” Determine which report you want to run.\u00a0 Item List Report This report is especially useful for grabbing data about item records.\u00a0 Once you select a…<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[410,353],"ht-kb-tag":[],"class_list":["post-20263","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-external-accounting","ht_kb_category-import-or-export-data"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/20263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=20263"}],"version-history":[{"count":13,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/20263\/revisions"}],"predecessor-version":[{"id":23000,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/20263\/revisions\/23000"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=20263"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=20263"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=20263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}