web analytics
Close this search box.


How to Import Inventory items in QuickBooks Point of Sale?


QuickBooks Point of Sale is a bookkeeping program that tracks your independent venture’s stock and deals. Not at all like Microsoft Excel, which empowers you to make any budgetary following framework starting with no outside help, Intuit QuickBooks is devoted programming that plans to supplant the money enlist. In the event that you have recorded stock or client data beforehand utilizing Excel, QuickBooks Point of Sale can import this information into its own documents. The program applies the Excel information to its own standard fields, making another spreadsheet from the one in the Excel exercise manual. With a specific end goal to do this effectively, one must follow layouts and arrangements to counteract mistakes when refreshing or exchanging an information record. Few things you need to remember before import inventory into QuickBooks Point of Sale.

Procedure to Import in QuickBooks Point of Sale

  • Scan quickly the whole worksheet before mapping – search for oddities, abnormal information, and so forth.
  • Duplicate/paste any document that gives you inconvenience into a crisp worksheet utilizing paste special>values.
  • Duplicate/glue to the Default Template sent out from POS.
  • Break substantial records into little segments (worksheets).
  • Stop the headers of the spreadsheet to look down while seeing headers.
  • Use Page Up and Page Down keys as opposed to using a mouse.
  • The Function of excel CTRL-End: paging down to the base of the excel spreadsheet.
  • The Function of excel CTRL-Home: returning to the start of the excel spreadsheet information.
  • No dashes in what is a vacant field.
  • No equations, hyperlinks and extraordinary characters i.e.: @,#,$,%,&,*.
  • Evacuate void lines, and segments.
  • Select all worksheets and erase shrouded sections.
  • Rather than erasing data independently utilize “clear content”.
  • Utilize the Vendor>Catalog import in POS when the client is bringing in a merchant record.
  • You can import up to 65,000 lines at any given row in excel.
  • You can change over .csv records to exceed expectations in Save as.
  • Open .csv spreadsheet in scratchpad to see inconsistencies.

Also Read: FreshBooks vs QuickBooks: A Comparison

Steps to import data

Note: If you don’t have a current layout accessible for import, you may need to download another format record or reproduce starting with no outside help.

  • Close QuickBooks Desktop Point of Sale.
  • Right-tap the Windows Logo Button and click File Explorer.
  • Explore the left window to the area: C:\Users\Public\Public Documents\Intuit\QuickBooks Point of Sale (x.0).
  • To explore, tap the bolt image alongside every organizer recorded.
  • Right-click QB POS Import Template.xls and pick Delete. Affirm the cancellation.

Set up and import data to Point of Sale

  • Open QuickBooks Desktop Point of Sale, go to File > Utilities > Import.
  • Under the Data Import Wizard, click Next.
  • Select the sort of information to import. Snap Next.
  • Select the Default layout on how you need to import the information and open the Import Template.
Get our expert Quickbooks ProAdvisor on call
to resolve your query in no-time.

In case you had an alternate record layout for import:

  • Select a Custom document and click Next.
  • Find your spared layout. Ensure to choose the right worksheet tab and what pushes the information began.
  • To coordinate the segments from the import format to the Point of offer fields, you may need to delineate information physically. Select Choose File Mapping > Add or Select Mapping > Manage Mappings.
  • Subsequent to mapping is finished, click Save.
  • Select Next to begin the import.
  • Select Next.
  • After the import wizard checked the import record, click Import.
  • After it finishes, click Close.

Note: To check for any mistakes, go to File > Utilities > View Data Import Log

If facing any issue during import inventory into QuickBooks then dial our QuickBooks POS Support number and get tech assistance of Intuit certified QuickBooks Pro Advisors.

About The Author

Editorial Team

Editorial Team

At QAsolved, we are a team of skilled professionals dedicated to delivering unparalleled accounting and bookkeeping services. With backgrounds in finance and technology, our collaborative efforts focus on providing practical solutions and guidance. Our services are tailored for a range of businesses, covering advisory, CFO services, bookkeeping, and financial systems consulting. QAsolved is an award-winning consulting firm and Intuit’s #1 QuickBooks Reseller Partner. We offer comprehensive QuickBooks services, including consulting, integration, migration, maintenance, data conversion, training, and support, among other services. Over the years, we have assisted over 30K customers across various industries with their Intuit products.

Recent Articles

Report An Issue?

We are here to help

Request A Free Consultation