This section provides a list of all the core live data reports in Q360 and description for each report.
| Category | Report Name | Description |
|---|---|---|
| Accounting | Check Register By Vendor | Lists all payments made through a check to a specific vendor during the specified period. The report also details which account the payment was made from, the date of payment, amount, which company used (in case of multi-company environments), the type of currency used to make the payment, and vendor details. |
| Accounting | Customer Profitability | Displays the revenues and costs earned per customer on projects, calls, and service contracts. This report can be fine tuned by department, branch or customer groups for a specified period. The total profitability is shown but you can open records within the grid to view finer details for the details for projects, calls, and service contract that comprise the total. |
| Accounting | Fixed Asset Reconciliation | This is the report used to verify the GL balance for fixed assets and depreciation. This is an “as of” report and can be selected by branch and status of the fixed assets defined, if user does use the fixed assets in Q360. |
| Accounting | Inventory Value By Location | The valuation of a particular master can be determined on a branch by branch basis showing the quantity on hand and its value as of today. |
| Accounting | Journal Reconciliation Detail | Displays the costs recognized and revenue earned per GL account. The call, project number, GL account, and associated amounts are listed to gauge the income statement in a detailed manner. |
| Accounting | Master Valuation VS Account Bal | Used when completing the month end process for inventory reconciliation of GL to sub-ledger. This displays the overall balances and can be used to identify on which particular day, the inventory valuation went out of balance. |
| Accounting | Pre-Paid Expense Journal Entries | Displays all prepaid expense entries where entry type is PREPAYMENT. This reports also displays lists the date of the transactions, the master number it is linked to, and any comments linked to that entry. |
| Accounting | Pre-Paid Expense Listing | List all the prepaid expenses and the details of the expense, including vendor, company, branch and voucher details, as well as the begin and end dates of the prepayment term. |
| Accounting | Project Revenue/Cost Forecast | Similar to a Project WIP report. Use the Project WIP report instead. |
| Accounting | Project WIP | Displays all project information required to track profitability, cash flow and any projection issues. This report is typically utilized for high level insights required by Project Managers, management, and other key decision makers. |
| Accounting | Service Call Journal Entries | Lists all entries where GL entries are linked to a particular service call, displaying the date of the transactions, linked master numbers, and comments. |
| Accounting | Service Contract Invoicing Projection | Lists all service contracts that have remaining invoicing to be done. Also provides useful details for service contracts such as start and end dates, and a projection of expected invoicing. |
| Accounting | Service Contract Profitability | Displays the profit tab of the service contract and provides key details of the service contract. The report can be filtered by branch, department or customer type for any given date range. |
| Accounting | Service Contract Revenue Projection | Lists all service contracts that have revenues left to be recognized on them and gives certain useful details of service contracts such as details of the customer. This provides a projection of expected revenue that will be recognized in the future PROVIDED the end date is set to the future date until when the projection is required. |
| BI Data | Closed Project WIP | Displays project WIP reports for closed projects. Can be used to track historical data for projects. |
| BI Data | Employee Utilization By Labor Type | Employee Utilization By Labor Type |
| BI Data | Project Delta | Tracks the value of changes over the selected period by Project. This shows all values incurred in the same month as the “As of Date” in which the report is ran. i.e., if the report is ran with an “As of Date” equal to “2022-01-31”, the report reflects revenues, cost, hours, and invoicing activity during the month of January. |
| BI Data | Project WIP | Tracks value of shipped inventory items ahead of costing them such as posting project COGS. Also provides easy checks to ensure at month end the GL is $0, and all project COGS/revenue is posted. |
| Data Integrity | Data Integrity – Inventory Subledger | All data integrity reports are all available and should be referenced in Accounting > Month End > Month End Reconciliation. The individual reports are pulled up when investigating reconciling differences. |
| Data Integrity | Data Integrity – Reconcile Master Qty | All data integrity reports are all available and should be referenced in Accounting > Month End > Month End Reconciliation. The individual reports are pulled up when investigating reconciling differences. |
| Data Integrity | Data Integrity – Stray Project Suspense | All data integrity reports are all available and should be referenced in Accounting > Month End > Month End Reconciliation. The individual reports are pulled up when investigating reconciling differences. |
| Data Integrity | Data Integrity – Voucher Postings to Inventory | All data integrity reports are all available and should be referenced in Accounting > Month End > Month End Reconciliation. The individual reports are pulled up when investigating reconciling differences. |
| Data Integrity | Sub-Ledger – Project Over/Under | All data integrity reports are all available and should be referenced in Accounting > Month End > Month End Reconciliation. The individual reports are pulled up when investigating reconciling differences. |
| Data Integrity | Sub-Ledger – Un-Vouchered AP | All data integrity reports are all available and should be referenced in Accounting > Month End > Month End Reconciliation. The individual reports are pulled up when investigating reconciling differences. |
| Month End | Inventory Clearing Reconciliation | Deprecated and merged into the Month End Reconciliation report. |
| Month End | Inventory Suspense | Deprecated and merged into the Month End Reconciliation report. |
| Month End | Month End Reconciliation | Check and maintain balances of various high level GL accounts in the system, in order to validate transactions and close out months. |
| Month End | Project Deferred Revenue Reconciliation | Deprecated and merged into the Month End Reconciliation report. |
| Month End | Project WIP Reconciliation | Used to reconcile items shipped and not invoiced (COGS postings) on projects where project WIP account and inventory clearing account are different. These accounts are setup in the Accounting > Admin > Company Setup > Asset tab. |
| Month End | Sales Clearing Reconciliation | Deprecated and merged into the Month End Reconciliation report. |
| Month End | Trial Balance Check | Deprecated and merged into the Month End Reconciliation report. |
| Month End | Month End AP Data Integrity | Deprecated and merged into the Month End Reconciliation report. |
| Projects | Budgeted vs. Actual Hours | Displays budgeted hours versus actual time billed on projects. This report can also be viewed from the Project WIP report under BI Data > Project WIP. |
| Projects | Profitability – Completed Projects | Used for measuring historical profitability of projects. This report can also be viewed from BI Data > Closed Project WIP. |
| Projects | Project Backlog Projection | Displays the forecast revenue to be earned in the future. The Accounting > Revenue/ Cost Forecast report can also be used instead. |
| Projects | Project Basic WIP | This report is deprecated. Use the Project WIP report instead. |
| Projects | Project GP Backlog Projection | Displays the forecast profit to be earned in the future. The Accounting > Revenue/ Cost Forecast report can also be used. |
| Projects | Project Gross Profit Change | Displays the forecast profit to be earned in the future. The Accounting > Revenue/ Cost Forecast report can also be used. |
| Projects | Project Inventory Detail | N/A |
| Sales | Manufacturer Sales Forecast | N/A |
| Sales | Sales Leads By Sales Rep and Status | Use the Sales Booking report located in Sales > Quick View instead. |
| Service | Technician Scheduled vs. Actual | Details technicians that were scheduled for a call / task against when they actually started. This can be used to analyze and manage technician scheduling. |
| Time Billing | Time Billing By State | Details technicians that were scheduled for a call / task against when they actually started. This can be used to analyze and manage technician scheduling. |
| Year End | Year End Unrecognized Liabilities | Reports all unrecognized liabilities for the specified date. |