Skip to main content
T
TheEarlyShow
November 8, 2024
Question

Inventory transactions

  • November 8, 2024
  • 1 reply
  • 0 views

In 2025 I'm wanting to start working on some reports to start seeing bottlenecks

 

Is there a way, hopefully without going through OBDC where I can get a transaction journal of all inventory items regardless of part number? Mainly wanting to see when something was bought in relation to something was built, age of ingredient it was built, cost basis on a category grouping, etc.

 

So, I figure if I had a date ranged list, where I can see where it's purchased, for how much, added to inventory, removed for build, etc. I could build on top of it.

 

I'm not an accountant, but kind of like audit trail for inventory?

 

1 reply

A
AdonL
November 8, 2024

Thanks for posting here, TheEarlyShow. I'll share details to help you generate a transaction journal for all inventory items without navigating the Open Database Connectivity (ODBC) driver in QuickBooks Desktop (QBDT).

 

Although ODBC offers excellent options for generating reports, we can leverage some of the built-in reporting features in QBDT and combine these reports to achieve your goal.

 

To begin with, here are some reports you can generate that provide a comprehensive overview of your inventory items:

 

  1. Inventory Valuation Summary
  2. Inventory Stock Status by Item

 

Run these reports and customize them to modify various settings such as purchase date, build date, and cost basis. You can also set filters to include all items regardless of part number and filter by item type (e.g., inventory, non-inventory) to include all relevant items. If you need to, you can save this current customization of your inventory reports for future reference.

 

Next, export your reports to a new Excel worksheet. Here's how:

 

  1. Go to Reports, then Reports Center.
  2. Find and double-click the report you want to export.
  3. Select the Excel dropdown, then Create New Worksheet. (NOTE: If you see a message that says your report has too many columns, choose Advanced, then uncheck the Space between columns checkbox.)
  4. Hit OK to export.

 

Once done, manually combine the two reports and save the workbook.

 

Furthermore, you can bookmark this article containing details that will help you understand how QuickBooks tracks and handles inventory assets: Understand inventory assets and cost of goods sold tracking.

 

Having in-depth knowledge of your inventory processes and their financial implications can help you better align resources and enhance productivity. If you need further assistance with QuickBooks, please don't hesitate to comment below. Have a great day ahead.

Terms & ConditionsAccessibility statement