{"id":27770,"date":"2019-07-15T12:01:23","date_gmt":"2019-07-15T16:01:23","guid":{"rendered":"https:\/\/onpremise.inflowinventory.com\/support\/?p=27770"},"modified":"2024-06-21T09:34:08","modified_gmt":"2024-06-21T13:34:08","slug":"how-do-i-get-my-inflow-on-premise-information-into-quickbooks-online","status":"publish","type":"post","link":"https:\/\/onpremise.inflowinventory.com\/support\/article\/27770\/how-do-i-get-my-inflow-on-premise-information-into-quickbooks-online\/","title":{"rendered":"How do I get my inFlow On-Premise information into QuickBooks Online?"},"content":{"rendered":"

Note: inFlow On-Premise doesn’t have a built-in integration with QuickBooks Online, but check out inFlow Cloud’s integration with QuickBooks Online<\/a>.<\/em><\/h4>\n
\n

Even though inFlow On-Premise doesn\u2019t have an integration, QuickBooks Online allows you to map the fields that are included in Excel files so that you can import information easily. This can be done for Customers, Suppliers, Products and Accounts (the inFlow equivalent is Customers, Vendors, and Products, however please keep in mind that inFlow does not have Accounts information).<\/span><\/p>\n

Before we start, please have a look at these articles for \u201c<\/span>importing data to QuickBooks Online<\/span><\/a>\u201d and \u201c<\/span>exporting data from inFlow<\/span><\/a>\u201d . To import an Excel file for any of the above into Quickbooks first start the program then go to Options > Import Data (as seen below)<\/span><\/p>\n<\/div>\n

\n

\"\"<\/div><\/p>\n

This will open a new window in which you may choose the data to be imported into QuickBooks Online:<\/span><\/p>\n

\"\"<\/div><\/p>\n

Please see below how each category of QuickBooks Online imports work with the inFlow exports. <\/span><\/p>\n

Import Customers<\/strong>
\n<\/span>Start by exporting customer details from inFlow<\/span>.<\/span>
\n<\/span>
\n<\/span>Click on the import in QuickBooks Online for customers. \u00a0Now you can map the fields. You will see QuickBooks Online field names on the left and you will be able to choose the correlated inFlow column header from the drop down list on the right.<\/span><\/p>\n

\"\"<\/div><\/p>\n

Import Suppliers<\/strong>
\n<\/span>Start by exporting vendor details from inFlow<\/span>.<\/span>
\n<\/span>
\n<\/span>Click on the import in QuickBooks Online for suppliers. \u00a0Now you can map the fields. You will see QuickBooks Online field names on the left and you will be able to choose the correlated inFlow column header from the drop down list on the right.

\"\"<\/div><\/span><\/p>\n<\/div>\n

Import Product and Services<\/strong>
\n<\/span>Start by exporting product details from inFlow<\/span>.<\/span>
\n<\/span>
\n<\/span>Click on the import in QuickBooks Online for product and services. \u00a0Now you can map the fields. You will see QuickBooks Online field names on the left and you will be able to choose the correlated inFlow column header from the drop down list on the right.<\/span>
\n<\/span>
\n<\/span>Note:<\/span><\/i> If your product name was the SKU in inFlow, change the fields around so \u201cName\u201d is in the QuickBooks Online SKU Field.<\/span><\/p>\n

\"\"<\/div><\/span><\/p>\n

When you\u2019re happy with the information you\u2019ve selected simply click \u201cnext\u201d that will bring you to confirm your details. If you like how the details look click \u201cimport\u201d to complete the import process.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Note: inFlow On-Premise doesn’t have a built-in integration with QuickBooks Online, but check out inFlow Cloud’s integration with QuickBooks Online. Even though inFlow On-Premise doesn\u2019t have an integration, QuickBooks Online allows you to map the fields that are included in Excel files so that you can import information easily. This can be done for Customers, […]<\/p>\n","protected":false},"author":34,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_et_pb_use_builder":"","_et_pb_old_content":""},"categories":[20,27],"tags":[],"_links":{"self":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/27770"}],"collection":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/comments?post=27770"}],"version-history":[{"count":4,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/27770\/revisions"}],"predecessor-version":[{"id":30042,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/posts\/27770\/revisions\/30042"}],"wp:attachment":[{"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/media?parent=27770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/categories?post=27770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onpremise.inflowinventory.com\/support\/wp-json\/wp\/v2\/tags?post=27770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}