Cashflow Management Grid Definitions
- Stephanie Pepper (e-manage|ONE)
Column Name | Definition |
# Days in Status | How many days the Project has been in the current Status |
AcknowledgedUnbilledCost | The sum of all POs that have been acknowledged but not billed by the vendor |
Acknowledgments | Acknowledgment information pulled from Acknowledgments and Costing module |
Aging | The days since the invoice was due (InvoiceDueDate in Invoice Module) IF the balance has not yet been paid |
All Prod Rec | Checkbox indicating if all product for this order has been received in the Receiving module |
All Prod Rec Date | The date on which all product for this order was received in the Receiving module |
Applied Deposits | Deposits that have been paid and have been applied through batch entry |
Available Deposits | Deposits that have not yet been paid and have been applied through batch entry |
Backlog | The dollar amount of this order that has not yet been invoiced. Can be seen in the Invoice window in the specific project |
Backlog % | The % of this order that has not yet been invoiced |
Bill To Company | Where you are sending the Billing Invoice to |
BookingCredit | Booking credit from the Order Entry screen on the specified order |
Comm Cost | The sum of Cost (based on order entry) where the items are marked as a commissionable product type and are marked commissionable in the BOM |
Comm Income | The sum of OrderSalePrice where the items are marked as a commissionable product type and in the BOM |
CorporateDivisionID | The corporate division (or location) that made this sale/order |
CustomerPO | The Customer PO pulls from the CustomerPO textbox in the Order Entry |
DaysOverDue | The number of days past the invoice due date |
DepositDate | The date on which a deposit was received (Set in the Order Entry under Add Deposit) |
Discounts | The sum of discounts applied on all invoices in the Invoice Module per specific order |
End User Company | End User is where the Product is being delivered to / installed at |
Est Comm Margin | The sum of profit in the BOM Module for the specific order/options that is commissionable |
Est Comm Profit | The sum of profit in the BOM Module for the specific order/options that is commissionable |
Est Commission | The sum of Commission based on the BOM |
Est GP | The GP for the order based on the BOM |
Est PO Total | The sum of current POs on the specified order |
Estimated Cost | The sum of cost in the BOM Module for the specific order/options |
Estimated Labor Cost | The cost in the BOM where the product type is a Labor Product Type for the specific order. Labor Product Types can be configured in Tools > Configure Labor Product Types |
Estimated Margin | The margin % for the order based on the BOM |
Estimated PO Tax | The sum of tax on current POs on the specified order |
Estimated Sale | The sum of sale in the BOM Module for the specific order/options |
EstimatedUseableCash | (Backlog + Outstanding Receivables) - (Unbilled Cost +Estimated Labor Cost Remaining) |
Expected Complete | The Date you expect to completed the Order. This Date can be very useful and is a Best Practices. You should include the update of this Date in your workflow as Completion Tasks on Action Items. You can run reports based on Expected Completion Date to provide cashflow forecasts. |
FirstSched Install Day | The first day the order has been scheduled on the Implementation Calendar |
Hot Job | An indication the job has a deficiency. Can be seen on the dayplanner under Hot Jobs. Can be set within a project by going to Actions > Mark as Hot Job. |
Implementation Completed On | The last day on the Implementation Calendar for the particular order installation |
Internal Labor Cost (Est) | Sum of Labor Cost in the BOM where the vendor is set to a company which as the "POs Created are Internal Cost Only" checkbox selected AND Product type is a labor product type, set in Tools > Configure Labor Product Types |
Internal Labor Sale (Est) | Sum of Labor Sale in the BOM where the vendor is set to a company which as the "POs Created are Internal Cost Only" checkbox selected AND Product type is a labor product type, set in Tools > Configure Labor Product Types |
InternalLaborCostToDate | The sum of actual cost on all time sheets entered (Based on hours in Time Clock, and Actual Pay Rate setup in HR Module) |
InventoryCost | Cost of Inventory applied to the order |
Invoices | The Sum all invoices on a particular order |
Job # | Job # - If blank than the project has not been booked |
Journal Costs | The cost applied via batch entry to the order as a Journal Cost |
Labor Cost To Date | The sum of Internal Labor Cost and Sub Labor Cost to Date (Both also in CashFlowManagementGrid) |
Labor Sale (Est) | The sell in the BOM where the product type is a Labor Product Type for the specific order (Labor Product Types can be configured in Tools > Configure Labor Product Types) |
Last Sched Install Day | The last day the order has been scheduled on the Implementation Calendar |
Last Status Change | The last time the Project Status was changed |
Next Appointment | Set through Actions > Add a Follow Up on the project |
Next Touch Date | A date set in the Project Information module as a reminder of when to contact the client next |
Next Touch Type | The way to contact the client on the Next Touch Date - i.e. email, phone call, in person meeting (Set in the Project Information module) |
Non-Comm Cost | The sum of cost (based on order entry) where the items are not marked as a commissionable product type and are not marked commissionable in the BOM |
Non-Comm Income | The sum of OrderSalePrice where the items are not marked as a commissionable product type and are not marked commissionable in the BOM |
On Hold | An indication the job is currently on hold (This can be set within a project by going to Actions > Mark as On Hold) |
Order Book Date | The Date the ORDER is Booked, not the Date the Project is Necessarily Booked |
Order Complete | A checkbox in the Order Entry module, on each order (Indicates the order has been completed) |
Order Completed On | The date on which the Order Complete checkbox was checked in the Order Entry module |
Order Name | Name of the Order (Best Practice is to name the Order with the Quote # and the Quote Name attached to the Order) |
Order Sale Price | The Order Sales Price is the combination of the Commissionable and Non-Commissionable Sales $ from the Project Order Entry (You have to either Process the BOM or Enter a Line Item in the Order Entry for a Sale to be registered) |
Order Status | The Status of the order. This is a manual and an automated change. You can and should have the status change based on Workflow, Action Items being checked out and completed. You can include the manual update of the status in your workflow as Completion Tasks on Action Items. This will help you better manage where an order is in the process. |
Order Type | The type of Order (I.E Deficiency) set in the Order Entry Module |
OrderInvoiceDate | The date in which the last invoice was created for this order |
OrderSaleWithTax | The Order Sales amount including the Tax |
Outstanding AR | The outstanding balance (sum) on all invoices on the specific order (has not yet been applied) |
Paid Bills | The amount (sum) on all POs that has payment applied in the PO Module or through Batch Entry |
Payments | The sum of all payments on the specific order - Calculated based on payments applied in batch entry or in the Invoice Module |
ProductCost | The sum of all paid POs related to a specific order |
Project # | Project # |
Project Manager | The project manager on the project - set up in the Project Information module |
Project Name | Name of the Project (Best practice is to put the Company name plus Project Name i.e. Bank of Texas / Global Task Chairs for Office 101) |
Project Status | The Status of the project. This is a manual and an automated change. You can and should have the status change based on Workflow , Action Items being checked out and completed. You can include the manual update of the status in your workflow as Completion Tasks. |
Project Type | The type of Project assigned (The project Type defines workflow (Action Items)) |
ProjectCreatedOn | The creation date of the project as a whole, not just the specific order |
Projected Margin | Project GP divided by Order Sale Price (%) |
ProjectedGP | OrderSalePrice - Total Cost (Journal costs + Labor Costs + Unpaid Bills + Paid Bills + Inventory Cost + Unbilled Cost) |
Requested Complete | The date that the order installation is requested to be completed on (Set in the Order Entry module) |
Requested Install Start | The date that the order installation is requested to be started on (Set in the Order Entry module) |
Requested Ship | The date that should be requested of the vendor for when product should be shipped (Set in the Order Entry Module to carry over to the Purchase Order(s)) |
Requires Installation | A checkbox in the Project Information module: Indicates whether the project needs to be scheduled for installation, and controls if it will show on the "To be Scheduled" grid in the implementation calendar |
Salesperson | Sales Person assigned to the project in the Project Information Window |
Sub Labor Cost (Est) | The sum of labor cost where the vendor is a subcontractor (marked as one in the company setup), based on the BOM |
Sub Labor Sale (Est) | The sum of labor sale where the vendor is a subcontractor (marked as one in the company setup), based on the BOM |
SubLaborCostToDate | The sum of the POs from vendors that are marked as Sub Contractor in the Company Setup |
SubUnbilledCost | The amount that has not yet been billed by the sub-contractor, based on bills applied to PO's |
Total Cost To Date | The sum of Paid Bills, Internal Labor Cost and Sub Labor Cost to Date |
UnAcknowledgedUnbilledCost | Cost for which POs have been created but have not been acknowledged or billed by the vendor yet |
Un-Billed Cost | Cost for which POs have been made and acknowledged, but the vendor has not yet been billed for (This can be viewed in the View/Modify Purchase Orders module) |
Un-Paid Bills | The outstanding balance (sum) on all POs that have not yet been paid but have been billed by vendor |
UseTax | The Sum of UseTax in the Order Entry Module |
Variance | The difference between Project Margin and Estimated Margin (Project Margin - Estimated Margin) |