{"id":2363,"date":"2020-07-22T17:19:15","date_gmt":"2020-07-22T17:19:15","guid":{"rendered":"https:\/\/www.quickbooksupport.net\/blog\/?p=2363"},"modified":"2020-07-22T17:19:15","modified_gmt":"2020-07-22T17:19:15","slug":"call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop","status":"publish","type":"post","link":"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/","title":{"rendered":"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop"},"content":{"rendered":"<p style=\"text-align: justify;\">On this article you will learn how to move your vendors, customers, products, services, and accounts from QuickBooks Online to QuickBooks Desktop. To know more, contact QuickBooks Support USA.<\/p>\n<p style=\"text-align: justify;\">We\u2019re here to help you if you need a hand moving from QuickBooks Online to Desktop. If you want to spend less time on data entry, here\u2019s how to move your lists and balances to your new desktop file. The open balances of vendors, customers, and accounts to your desktop file can be transferred;\u00a0 and we will help you with this.<\/p>\n<p style=\"text-align: justify;\">Do not worry if you have already canceled your QuickBooks Online. For a year you still have access to your data and that is plenty of time to move everything you require.<\/p>\n<p style=\"text-align: justify;\">Please Note: Reach out to your accountant before you start. Please ensure that this change is right for you. We can help you find one if you don&#8217;t have an accountant.<\/p>\n<p style=\"text-align: justify;\">Now, you need move your vendors, accounts, customers, and opening balances<\/p>\n<p style=\"text-align: justify;\">This won\u2019t bring over transactions associated with your customers, vendors, or accounts but will only bring their current open balances in QuickBooks Online. Export all of your data if you want to move your transactions too.<\/p>\n<p style=\"text-align: justify;\"><strong>Step 1: Exporting your account, customer, and vendor list reports to Excel<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">As an admin, sign in to QuickBooks Online<\/li>\n<li style=\"text-align: justify;\">In the Reports menu, look for and open an Account List, Customer Contact List, or Vendor Contact List.<\/li>\n<li style=\"text-align: justify;\">Select Customize on the report.<\/li>\n<li style=\"text-align: justify;\">Click on Rows and Columns and then select Change columns.<\/li>\n<li style=\"text-align: justify;\">Click and then reorder columns. To learn what columns to select and their correct order you can refer to the tables.<\/li>\n<li style=\"text-align: justify;\">Select Run report when you&#8217;re done. To export the report, and save it in a folder that can be accessed quickly, follow the steps.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 2: Adding your customer and vendor open balances<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">\u00a0In the Sales menu and select the Customers tab. In the Expenses menu, select the Vendors tab.<\/li>\n<li style=\"text-align: justify;\">Click on the Export to Excel icon. In a folder you can access quickly, save the Excel file.<\/li>\n<li style=\"text-align: justify;\">Open the Excel file that you have just saved to get the open balances, and then you need to copy the Open Balance column.<\/li>\n<li style=\"text-align: justify;\">Now, you need to open the Excel file of customers or vendors that was saved in Step 1.<\/li>\n<li style=\"text-align: justify;\">Make sure you remove them from the worksheet as you don\u2019t need the first 4 rows.<\/li>\n<li style=\"text-align: justify;\">Add the Open Balance column that you have copied, and then save the changes you have made.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 3: Mapping your QuickBooks fields and import<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">As an admin, sign in to your company file in QuickBooks Desktop.<\/li>\n<li style=\"text-align: justify;\">Select Utilities and the Import from the File menu.<\/li>\n<li style=\"text-align: justify;\">Click on Excel Files. Select No. on the window that appears.<\/li>\n<li style=\"text-align: justify;\">Click on Advanced Import.<\/li>\n<li style=\"text-align: justify;\">Click on Browse.\u00a0 Now, go to the Excel file of account, customer, or vendor list that you have to import.<\/li>\n<li style=\"text-align: justify;\">Click on the Choose a mapping drop-down, and then select Add New.<\/li>\n<li style=\"text-align: justify;\">Depending on the list you&#8217;re importing add a mapping name. For instance, add &#8220;Account List.&#8221;<\/li>\n<li style=\"text-align: justify;\">Choose an import type, and then with your worksheet headers start matching QuickBooks fields. Once you\u2019re done, select save. Please Note: Check this mapping sample for customer list to map the billing address details correctly.<\/li>\n<li style=\"text-align: justify;\">To ensure that there are no mapping errors, click on Preview.<\/li>\n<li style=\"text-align: justify;\">Select what you\u2019d like to happen if QuickBooks finds errors in the error handling section:<\/li>\n<li style=\"text-align: justify;\">Now, import rows having errors and then leave error fields blank<\/li>\n<li style=\"text-align: justify;\">Please note: On should not import rows with errors<\/li>\n<li style=\"text-align: justify;\">Click on OK. Select Import once you&#8217;re ready.<\/li>\n<li style=\"text-align: justify;\">If the import is successful or there\u2019s any error, QuickBooks will let you know automatically.<\/li>\n<li style=\"text-align: justify;\">Save the error log if QuickBooks finds an error. How to fix the errors can be seen be opening it again.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>QuickBooks will let you choose what you want to happen with the duplicates, if you receive a \u201cDuplicate Record Found\u201d error. You can perform the following:<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\">You can keep existing data and discard the data that is imported.<\/li>\n<li style=\"text-align: justify;\">Ignoring blank fields, replace existing data with import data.<\/li>\n<li style=\"text-align: justify;\">Including blank fields, replace existing data with import data.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">To know more on learn how to move your vendors, customers, products, services, and accounts from QuickBooks Online to QuickBooks Desktop, call us on our <a href=\"https:\/\/www.quickbooksupport.net\/\"><strong>QuickBooks Support USA<\/strong><\/a>. You can also write to us at <strong><a href=\"mailto:support@quickbooksupport.net\">support@quickbooksupport.net<\/a><\/strong> . For more information visit &#8211;\u00a0<strong><a href=\"http:\/\/www.quickbooksupport.net\">www.quickbooksupport.net<\/a><\/strong> .<\/p>\n","protected":false},"excerpt":{"rendered":"<p>On this article you will learn how to move your vendors, customers, products, services, and accounts from QuickBooks Online to QuickBooks Desktop. To know more, contact QuickBooks Support USA. We\u2019re here to help you if you need a hand moving from QuickBooks Online to Desktop. If you want to spend less time on data entry, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2364,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[57,117,42,18,13,52],"class_list":["post-2363","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-quickbooks-support-2","tag-quickbooks-help","tag-quickbooks-helpline-number","tag-quickbooks-phone-number","tag-quickbooks-support","tag-quickbooks-support-number","tag-quickbooks-support-usa"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.10 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop - Call Quickbooks Support<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop - Call Quickbooks Support\" \/>\n<meta property=\"og:description\" content=\"On this article you will learn how to move your vendors, customers, products, services, and accounts from QuickBooks Online to QuickBooks Desktop. To know more, contact QuickBooks Support USA. We\u2019re here to help you if you need a hand moving from QuickBooks Online to Desktop. If you want to spend less time on data entry, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"Call Quickbooks Support\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-22T17:19:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.quickbooksupport.net\/blog\/wp-content\/uploads\/2020\/07\/5-5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1366\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/\",\"url\":\"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/\",\"name\":\"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop - Call Quickbooks Support\",\"isPartOf\":{\"@id\":\"https:\/\/www.quickbooksupport.net\/blog\/#website\"},\"datePublished\":\"2020-07-22T17:19:15+00:00\",\"dateModified\":\"2020-07-22T17:19:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.quickbooksupport.net\/blog\/#\/schema\/person\/a97a7a0118de9977e357ce39be1e2ea7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.quickbooksupport.net\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.quickbooksupport.net\/blog\/#website\",\"url\":\"https:\/\/www.quickbooksupport.net\/blog\/\",\"name\":\"Call Quickbooks Support\",\"description\":\"Quickbook Support by Certified Technicians\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.quickbooksupport.net\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.quickbooksupport.net\/blog\/#\/schema\/person\/a97a7a0118de9977e357ce39be1e2ea7\",\"name\":\"admin\",\"url\":\"https:\/\/www.quickbooksupport.net\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop - Call Quickbooks Support","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop - Call Quickbooks Support","og_description":"On this article you will learn how to move your vendors, customers, products, services, and accounts from QuickBooks Online to QuickBooks Desktop. To know more, contact QuickBooks Support USA. We\u2019re here to help you if you need a hand moving from QuickBooks Online to Desktop. If you want to spend less time on data entry, [&hellip;]","og_url":"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/","og_site_name":"Call Quickbooks Support","article_published_time":"2020-07-22T17:19:15+00:00","og_image":[{"width":1366,"height":768,"url":"https:\/\/www.quickbooksupport.net\/blog\/wp-content\/uploads\/2020\/07\/5-5.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/","url":"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/","name":"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop - Call Quickbooks Support","isPartOf":{"@id":"https:\/\/www.quickbooksupport.net\/blog\/#website"},"datePublished":"2020-07-22T17:19:15+00:00","dateModified":"2020-07-22T17:19:15+00:00","author":{"@id":"https:\/\/www.quickbooksupport.net\/blog\/#\/schema\/person\/a97a7a0118de9977e357ce39be1e2ea7"},"breadcrumb":{"@id":"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.quickbooksupport.net\/blog\/2020\/07\/22\/call-quickbooks-support-usa-and-know-how-to-data-from-quickbooks-online-to-quickbooks-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.quickbooksupport.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Call QuickBooks Support USA and know how to data from QuickBooks Online to QuickBooks Desktop"}]},{"@type":"WebSite","@id":"https:\/\/www.quickbooksupport.net\/blog\/#website","url":"https:\/\/www.quickbooksupport.net\/blog\/","name":"Call Quickbooks Support","description":"Quickbook Support by Certified Technicians","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.quickbooksupport.net\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.quickbooksupport.net\/blog\/#\/schema\/person\/a97a7a0118de9977e357ce39be1e2ea7","name":"admin","url":"https:\/\/www.quickbooksupport.net\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/posts\/2363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/comments?post=2363"}],"version-history":[{"count":0,"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/posts\/2363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/media\/2364"}],"wp:attachment":[{"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/media?parent=2363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/categories?post=2363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.quickbooksupport.net\/blog\/wp-json\/wp\/v2\/tags?post=2363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}