QuickBooks Tips & Tricks

Do you need to track your inventory by location or site? QuickBooks now has this feature available in the Enterprise version. If you store inventory at different warehouses, consignment locations or different areas in one warehouse QuickBooks Enterprise will track this for you by location and keep the total average cost of your inventory. On all your purchase and sales forms, you will be able to specify by location for transactions. This Advanced Inventory feature will track drop ship orders too. QuickBooks added six new reports to provide inventory information by location such as Quantity on Hand by Site, Inventory Valuation Summary by Site and Inventory Stock Status by Site.


Do you want QuickBooks payroll detail that allows you to sort, filter and has a summary report which includes all payroll items? You can export the payroll information for quarterly and annual reports to Excel. The option is on the grey menu bar at Employees>Payroll Tax Forms & W2s>Tax Form Worksheets in Excel. This option will export the payroll information for the date range you specify. The Excel workbook that is created will have two tabs: one for the return you specified such as the 941 and another tab with all the payroll data by individual employee that you can sort and filter as needed.

Please call any of our QuickBooks ProAdvisors at (850) 435-8300 if you would like more detail on these tips or if you have any QuickBooks questions.