Paste 1,000+ transactions from Excel and save the information all at once.

Enter transactions in batch on a screen designed for power data entry.

With Batch Enter Transactions feature you can:

New for 2014! Invoices and Credit Memos.

Use Batch Enter Transactions for adding the following transaction types to a QuickBooks data file: This feature is included with QuickBooks Accountant 2014 and all editions of QuickBooks Enterprise Solutions 14.0 software. It also is good for companies using QuickBooks Enterprise Solutions 14.0 and want to quickly add data to their QuickBooks file.

You can also access FAQ's for selling inventory on BoxFox.The improved Batch Enter Transactions’ feature in QuickBooks ® Accountant 2014 is designed for accounting professionals who want to work more efficiently and profitably when providing write-up services for their clients. To help format your inventory data for BoxFox, you can download a template spreadsheet here. Before you do, please make sure your UPC's display properly within the spreadsheet. You can now delete your original UPC column, leaving only the new one.ġ0) You can save your inventory list as a. Once you've copied the entire column, click 'Paste Values' and paste as 'Text'.

Hit 'enter' and watch the leading zero get removed.Ĩ) Double click the bottom right corner of the cell - this will apply the formula to all cells in the column.ĩ) Highlight the entire new UPC column you just made and click 'copy'. Click in the cell to the right of your first UPC and type ' =RIGHT(D2, LEN(D2)-1)'. You can quickly remove this with an Excel forumula. From there, you'll be prompted to export your inventory data.ħ) By default, Quickbooks adds an extra 0 as the first digit in your UPC. When you've selected these corresponding fields, click 'Save'. Please make sure the UPC's you export are from the manufacturer (not your own store codes). You don't need to include other columns that don't apply. Fields like brand, price, and cost are helpful as well. For BoxFox to properly recognize your items, you need to include UPC, title, quantity, and size (if applicable).

To select items in bulk, use the search bar or create a filter.ģ) Select 'I Want to.' and click 'Export to Excel'.Ĥ) You can export your entire inventory list or only the specific items you selected.Ħ) Use the checkboxes to customize the fields to be exported. To narrow down specific items you'd like to export, press and hold the 'Shift' key while clicking on your items. Here's how to export an inventory list from Quickbooks that can be used to upload inventory to BoxFox:ġ) Within your Quickbooks dashboard, hover over 'Inventory', then select 'Item List'.Ģ) You'll see a listing of the inventory you currently have within Quickbooks.

Youtube quickbooks tutorial