Controller’s Toolbox – The Core Four

Export Work Orders

Export Work Order Details

Export Work Order Details

Export Work Order Details

Work Order Options

Export Work Order Details

Work Order Transaction Summary

The Columns

  • Detailed View
    • Work Order Number
    • Part Number
    • Description
    • Date Posted to QuickBooks
    • Transaction Date
    • Qty Target (Quantity Required per the Work Order )
    • Qty Used (Quantity Actually Charged to the Work Order)
    • Unit of Measure
    • Bill of Material Number
    • QuickBooks Reference Number (JE number)
    • QuickBooks Account
    • Debit
    • Credit
  • Summary View
    • Account
    • Debit
    • Credit

The Filters

  • Bill of Material Number
  • Class
  • Work Order Number
  • Part Number

 

Date Filters

  • Date Posted
  • Transaction Date

 

The Display Options

  • Detailed
  • Summary
  • Formatted for Export

$150.00

Export Inventory Adjustments

Export Work Order Details

Export Inventory Adjustments – Options

Export Work Order Details

Export Inventory Adjustments Report

Export Work Order Details

Work Order Transaction Summary

The Export Inventory Adjustment Report is a Essential Member of our Controller’s  Toolbox Core Four .

The Core Four are the essential reports that can be used to roll-Inventory balances forward or back.  It is also an essential component if you need to revalue transactions or identify backdated transactions.

The Columns

  • Part Number
  • Description
  • Quantity
  • UOM
  • Amount
  • Location Group
  • Beginning Location
  • Ending Location
  • Date Adjusted
  • Date Created
  • Date Posted to QuickBooks
  • Adjustment Type (Cycle Count, Scrap, Cost Change, Add Initial Inventory)
  • Adjustment Notes
  • QuickBooks Account
  • Debit
  • Credit
  • Net

The Filters

  • Adjustment type
    • Add Initial Inventory
    • Cost Change
    • Cycle Count
    • Scrap
  • Show Not Posted
  • Part Number

 

The Date Filters

  • Transaction Date
  • Adjustment Date
  • Date Posted

 

Display Choices

  • Detailed
  • Summary

$150.00

Export Purchase Transactions

Export Work Order Details

Export Purchases Summary Report

Export Work Order Details

Export Purchases Detail Report

Export Work Order Details

Export Purchases Options

The Columns

  • Purchase Order Number
  • Part Number
  • QB Reference Number
  • Bill Date
  • Transaction Date
  • Quantity
  • Unit of Measure
  • Vendor
  • Type (Purchase, Credit Return, Outsourced)
  • QuickBooks Account
  • Debit
  • Credit

The Filters

  • Class
  • PO Number
  • Vendor
  • Part Number

 

The Dates

  • Bill Date
  • Posted Date

 

The Display

  • Detailed   
  • Summary

$150.00

Export Sales Transactions

Export Work Order Details

Export Sales Transactions Detail

Export Work Order Details

Export Sales Transactions Options

Export Work Order Details

Export Sales Transaction Summary

The Columns

  • Detailed Format
    • Sales Order Number
    • Product Number
    • Product Description
    • Date Posted
    • Transaction Date
    • Qty
    • Sold Unit of Measure
    • QuickBooks Invoice Number
    • Customer Name
    • So Item Type ( Sale, Credit Return, Drop Ship)
    • QuickBooks Account
    • Debit
    • Credit
  • Summary Format
    • QuickBooks Account
    • Debit
    • Credit

The Filters

  • Class
  • Product
  • Sales Order

 

The Date Range

  • Transaction Date
  • Posted Date

 

The Display

  • Detail
  • Summary
  • With/Without Sales Tax
  • Format for Exporting

$150.00

Get all of these reports  by purchasing the entire Controller's Toolbox collection of reports.

$1,095.00

Shopping cart0
There are no products in the cart!
Continue shopping