Controllers Toolbox – Special Transaction Reports
Payments Transactions
Payments Transactions
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
Receiving Transaction Detail
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
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