QuickBooks Run Expense Report? How to Do It
- Average speed
- km/h
- Result
- Finish time
- 50 min
- You entered
- Distance
- 10 km
- You entered
Yes, QuickBooks can run expense reports, and the exact steps depend on which version you use. In QuickBooks Online, you can pull a Profit and Loss report filtered by expense accounts, or use the built-in “Expenses by Vendor Summary” report. In QuickBooks Desktop, the equivalent is the “Expenses by Vendor Summary” or “Profit and Loss by Class” report. This guide covers both, plus how to customize, export, and troubleshoot the most common issues.
Formula
The calculator above computes your average pace and speed for a run. The formulas are:
- Average pace = Finish time (minutes) ÷ Distance (km), expressed in minutes per kilometer.
- Average speed = Distance (km) ÷ (Finish time (minutes) ÷ 60), expressed in kilometers per hour.
Variables:
- t = finish time in minutes (e.g., 50 minutes).
- d = distance in kilometers (e.g., 10 km).
If you measure distance in miles, convert to kilometers by multiplying by 1.60934. If you want pace per mile, divide time by distance in miles instead.
Worked Example
Using the default values: finish time = 50 minutes, distance = 10 km.
- Average pace = 50 ÷ 10 = 5.0 min/km.
- Average speed = 10 ÷ (50 ÷ 60) = 10 ÷ 0.8333 = 12.0 km/h.
So a 50-minute 10K run gives a pace of 5:00 per kilometer and an average speed of 12 km/h. The calculator rounds to two decimals, so you see 5.00 min/km and 12.00 km/h.
When to Use This Calculator
Use this tool to track your running performance, plan training paces, or compare runs of different distances. Runners often use pace to set target times for races. For example, if you want to run a half marathon (21.1 km) in 2 hours, your required pace is 120 minutes ÷ 21.1 km = 5.69 min/km (about 5:41 per km). The speed output is useful for treadmill settings or for comparing with cycling or other activities.
How to Read the Results
The pace result is shown as minutes per kilometer (or per mile if you convert). A lower pace number means faster running. The speed result is in kilometers per hour (or miles per hour if you convert). For reference, a casual jog is often 6–8 km/h, a moderate run 8–10 km/h, and a fast run over 12 km/h. These are general ranges, not strict categories.
Common Mistakes
- Mixing units: Entering distance in miles but using the km formula gives a wrong pace. Convert miles to km (multiply by 1.60934) or use miles directly in the formula.
- Using seconds incorrectly: If your finish time is 50 minutes and 30 seconds, convert to 50.5 minutes, not 50.30.
- Rounding too early: Round only the final answer, not intermediate steps, to avoid small errors.
- Confusing pace and speed: Pace is time per distance (min/km), speed is distance per time (km/h). They are inversely related.
Limitations of the Formula
This calculator assumes a constant speed throughout the run. Real runs have hills, stops, and varying effort, so your actual pace may differ. It also ignores factors like wind resistance, terrain, and fatigue. For training, use it as a rough guide, not a precise measurement. GPS watches and apps provide more accurate real-time data.
Frequently Asked Questions
How do I convert my pace to miles per hour?
Take the speed in km/h and divide by 1.60934 to get miles per hour. For example, 12 km/h ÷ 1.60934 = 7.46 mph. Alternatively, if you have pace in min/km, convert to min/mile by multiplying by 1.60934.
What is a good running pace for a beginner?
A comfortable conversational pace for a beginner is often around 7–8 min/km (about 8–9 km/h). This varies widely by age, fitness, and experience. The best pace is one you can maintain while still speaking in short sentences.
Can I use this for walking?
Yes, the same formulas apply. A typical walking pace is 10–12 min/km (5–6 km/h). Enter your walking time and distance to get your average pace and speed.
How do I calculate pace for a marathon?
Marathon distance is 42.195 km. Divide your target finish time (in minutes) by 42.195 to get min/km. For example, a 4-hour marathon (240 minutes) gives 240 ÷ 42.195 = 5.69 min/km, which is about 5:41 per km.
Why does my GPS watch show a different pace?
GPS watches calculate pace based on real-time position data, which can be affected by satellite accuracy, tall buildings, and trees. They also account for stops and elevation changes. The calculator gives an average for the entire run, so small differences are normal.
Related
Formula used
in t | Finish time | min | 50 | 0 in d | Distance | km | 10 | 0 out pace | Average pace | min/km | t / d | 2 out speed | Average speed | km/h | d / (t / 60) | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.