Model Summary
The QQube Vehicle Mileage Data Model calculates IRS mileage values and monitors vehicle use. It is available as a standalone model and is also included in the Job Cost Details Data Model.
| Model Type | Vehicle mileage and reimbursement analysis |
|---|---|
| Record Coverage | QuickBooks Vehicle Mileage records |
| Available Fields | More than 250 |
| Primary Calendar | Trip End Date |
| Primary Use | Analyze mileage, billable status, reimbursement values, and vehicle use |
Best Used For
- Reviewing mileage by vehicle.
- Calculating reimbursement values.
- Comparing billed, unbilled, and actual mileage amounts.
- Analyzing mileage by job, representative, or class.
- Using vehicle mileage with Fixed Assets reporting.
Key Capabilities
- Separates billable, billed, unbilled, and non-billable mileage.
- Includes billable and IRS mileage rates.
- Calculates billable and IRS mileage values.
- Supports vehicle, job, customer, class, and representative analysis.
- Provides prepared DAX measures for Power BI and Excel Power Pivot.
Date Analysis
Use Trip End Date for time-period analysis.
Trip End Date is the preferred calendar for analyzing Vehicle Mileage records across days, weeks, months, quarters, and years.
Mileage, Rate, and Value Fields
Native fields come from QuickBooks Vehicle Mileage data. QQube field extensions separate mileage by billable status and calculate related billable and IRS values.
Native Fields (3)
| Mileage Fields | Rate Fields | Value Fields |
|---|---|---|
|
|
QQube Field Extensions (12)
| Field Name |
|---|
| Total Miles (Not Billable) |
| Total Billable Miles |
| Total Billable Miles (Billed) |
| Total Billable Miles (Unbilled) |
| Billable Miles Value |
| Billable Miles Value (Billed) |
| Billable Miles Value (Unbilled) |
| IRS Mileage Value for Miles (Any Status) |
| IRS Mileage Value for Miles (Not Billable) |
| IRS Mileage Value for Billable Miles |
| IRS Mileage Value for Billable Miles (Billed) |
| IRS Mileage Value for Billable Miles (Unbilled) |
Power BI and Excel Power Pivot Measures
The prepared Vehicle Mileage examples include 122 visible DAX measures in seven display folders. Hidden measures are not included.
| Measure Folder | Visible Measures |
|---|---|
| .Base Measures | 17 |
| Calendar Pattern Measures | 43 |
| Miles Billable Measures | 21 |
| Miles Billed Measures | 14 |
| Miles Not Billable Measures | 7 |
| Miles Total Measures | 16 |
| Miles Unbilled Measures | 4 |
Included Dimensions
Calendars
| Trip End Date | Trip Start Date | Job End Date |
| Job Projected End Date | Job Start Date | Calendar Overview |
Document
| Document Attributes | Line Attributes |
Lists
| Class | Company | Customer |
| Customer Rep | Job | Job Rep |
| Service Item | Vehicle |
Technical Details
| Model Structure | One Vehicle Mileage FACT table with related dimensions and relationships already included |
|---|---|
| Standalone Availability | Available as a standalone model and within Job Cost Details |
| Primary Calendar | Trip End Date |
| DAX Availability | Power BI and Excel Power Pivot examples |
Expected Result
Open the prepared example and analyze mileage by vehicle, job, representative, class, billable status, rate, or value.
The FACT table, dimensions, relationships, fields, QQube extensions, and measures are already included.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article