logo
logo
Sign in

QuickBooks POS: Import Inventory Using Excel

avatar
Real Accounting Support
QuickBooks POS: Import Inventory Using Excel

Quickbooks Point of Sale is a bookkeeping program that tracks your independent company's stock and deals. In contrast to Microsoft Excel, which empowers you to make any monetary global positioning framework without any preparation, Intuit Quickbooks is devoted programming that intends to supplant the sales register. On the off chance that you have recorded stock or client data beforehand utilizing Excel, Quickbooks can bring this information into its documents. The program applies the Excel information to its standard fields, making another accounting page from the one in the Excel exercise manual. This is additionally exceptionally helpful if you have traded clients, thing records, or other basic information from your past Quickbooks Point Of Sale framework or bookkeeping program. 

 

Here, we will utilize a Vendor Item rundown and import it into QuickBooks POS: 

 

Stage 1 

 

  • Snap "Document" from the Quickbooks menu bar. 
  • Snap "Utilities" starting from the drop menu. 
  • Snap "Import" to dispatch the Data Import Wizard 

 

Stage 2 

 

  • Snap "Next" 
  • Snap the alternative catch that compares with the sort of information on the Excel accounting page. The three decisions are "Stock Items," "Sellers" and "Clients" For this model, we will choose "Stock Items." 
  • Snap "Next" 

 

Stage 3 

 

  • Snap the alternative catch named "Custom document" This choice expands your adaptability while interpreting accounting page headers to Quickbooks fields. 
  • Snap "Next" 

 

Stage 7 

 

  • Snap "Peruse" 
  • Explore and select your Excel exercise manual. 

 

Stage 8 

 

  • Snap the drop-down box named "Information is on sheet:" and select the sheet that you need to import. 
  • Enter a number in the container named "Information begins online." If your Excel sheet's first line contains section headers, type "2." 

 

Stage 10 

 

Snap the drop-down box named "Pick document planning:" and select "<Add new>" to open the Mappings exchange box. This container records possible fields for the Quickbooks Point Of Sale accounting page and requests that you pick the comparing fields from the Excel bookkeeping page. 

 

Stage 11 

 

Snap the drop-down confines the "Import Data:" segment to choose fields from the Excel accounting page. For instance, Quickbook's "Thing Description" field might relate with your Excel sheet's ".ItemID" field, for example, in my dominate sheet. The Item Name and the Price are presumably generally significant. It is ideal to have the UPC and other data too. 

 

Stage 12 

 

Give this planning a name, then, at that point click "Save" to close the Mappings discourse box. Snap "Next" twice to open the wizard's last screen. 

 

Stage 13 

 

  • Snap "Import." 
  • Presently it will ask you to reinforce your document. Do as such.
collect
0
avatar
Real Accounting Support
guide
Zupyak is the world’s largest content marketing community, with over 400 000 members and 3 million articles. Explore and get your content discovered.
Read more