Controllers Toolbox – Special Transaction Reports

Payments Transactions

Export Work Order Details

Payments Transactions

Export Work Order Details

Costing Layers with Transaction Source Options

If you have chosen the module option to hold payments until the order is fulfilled – this report is a must.

This report Displays the following Columns:

  • Sales Order Number
  • Payment Transaction Date
  • Sales Order Fulfillment Date
  • Customer Name
  • Payment Method
  • Payment type
  • Mapped Account
  • Amount

 

Date Filters

  • Payment Date – Fishbowl
  • SO Fulfillment Date – Fishbowl

 

 

This report can be filtered by

  • Payment Method
  • Payment Type
  • Payment Account
  • Individual SO
  • Show Posted
  • Show Not Posted

 

Display Options

  • Detail
  • Summary

$150.00

Receiving Transaction Detail

Export Work Order Details

Receiving Transaction Detail

Export Work Order Details

Receiving Transaction Options

The Sorting Options without exporting to excel

  • Date Received
  • Date Reconciled
  • Date Billed
  • Order Number
  • Part Number

The Columns

  • Order Type ( Can be PO,  SO or TO)
  • Order Number
  • Status – Received or Reconciled
  • Part type see part type chart
  • Part Number
  • Part Description
  • Vendor
  • Date Received
  • Date Billed
  • Qty Received
  • Purchase Order Unit Cost
  • Extended Purchase Order Cost
  • Billed Unit Cost
  • Extended Billed Cost
  • Landed Unit Cost
  • Extended Landed Cost
  • General Ledger Account

The Filters

  • Date Filer – Date received, Date Created, Date Billed
  • Transfer Order Number
  • Purchase Order Number
  • Sales Order Number
  • Location Group
  • Part Number
  • Date Range
  • Vendor

Fishbowl does not have a report showing individual receipts against the Purchase Order and the receiving screen in standard Fishbowl shows the cumulative status of the receipts against the Purchase Order, not the individual detail.

  • Date Reconciled
  • Date Billed
  • Order Number
  • Part Number

 

The Columns

  • Order Type ( Can be PO,  SO or TO)
  • Order Number
  • Status – Received or Reconciled
  • Part type see part type chart
  • Part Number
  • Part Description
  • Vendor
  • Date Received
  • Date Billed
  • Qty Received
  • Purchase Order Unit Cost
  • Extended Purchase Order Cost
  • Billed Unit Cost
  • Extended Billed Cost
  • Landed Unit Cost
  • Extended Landed Cost
  • General Ledger Account

The Filters

  • Date Filer – Date received, Date Created, Date Billed
  • Transfer Order Number
  • Purchase Order Number
  • Sales Order Number
  • Location Group
  • Part Number
  • Date Range
  • Vendor

 

Primary purpose was to check if Bills were dated on the receiving Date

Secondary purpose I should be able to use it to accrue the date differences

Used to research individual parts

$150.00

Unbilled Receipts Report

Export Work Order Details

Valuation by Location Group Report

The columns

  • PO Number
  • Vendor
  • Part Number
  • Part Description
  • Date Received
  • Quantity Received
  • Unit of Measure
  • PO Unit Cost
  • PO Extended Cost

 

Intended Purpose of the report

This report was developed to easily reconcile the balance in  the QuickBooks Online “Holding” account.

It can also be used as a month end listing of Vendors who need encouragement to send their bills.

$150.00

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

$795.00

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