INVOICE GUIDES
Turn Timesheet Hours into Invoice Quantities Without Decimal Errors
A timesheet can be accurate while the invoice made from it is wrong. The usual trap is treating minutes as decimal digits: 1 hour 30 minutes becomes 1.30 instead of 1.5 hours. Other problems appear when entries use different rates or rounding occurs at an unintended stage.
This guide shows the arithmetic before you enter quantities in the ToolNivo Invoice Generator. The tool does not import timers or decide which time is billable.
Convert minutes using sixty, not one hundred
Use decimal hours = whole hours + minutes ÷ 60. For a total recorded in minutes, divide the entire total by 60. Fifteen minutes is 0.25 hours, thirty minutes is 0.5, and forty-five minutes is 0.75.
| Recorded duration | Calculation | Decimal hours |
|---|---|---|
| 1 hour 30 minutes | 1 + 30 ÷ 60 | 1.5 |
| 2 hours 15 minutes | 2 + 15 ÷ 60 | 2.25 |
| 3 hours 45 minutes | 3 + 45 ÷ 60 | 3.75 |
Typing 1.30 into a numeric quantity field means 1.3 hours, which is 78 minutes. It does not mean ninety minutes. Put the unit “hours” in the item description so the number has an unambiguous meaning.
Reconcile breaks, overlaps and client allocation first
Before conversion, check the underlying start and finish times. Subtract nonbillable breaks according to the agreed arrangement and remove duplicate or overlapping entries. Do not automatically count the same period twice because two task timers were running.
For example, 09:10 to 12:40 is 210 minutes. With a 20-minute nonbillable break, the chargeable duration is 190 minutes. Keep the original times and break record so the duration can be checked. If the agreement uses minimum blocks or another billing increment, document and apply that agreed rule rather than silently rounding upward.
Worked example: reconcile the total in minutes
This example uses an invented rate of USD 42.00 per hour and excludes tax. Three approved entries are 1 hour 20 minutes, 45 minutes and 2 hours 10 minutes.
- Convert to minutes: 80 + 45 + 130 = 255.
- Convert the grouped total: 255 ÷ 60 = 4.25 hours.
- Calculate the amount: 4.25 × 42.00 = 178.50.
Grouping these entries is appropriate here because they share the same client, billing period, rate and agreed treatment. If one entry uses a different rate, keep it separate. Save the three-entry breakdown even when the invoice presents a single summarized row.
Decide where rounding belongs
ToolNivo accepts quantities to four decimal places and rounds monetary amounts according to the selected currency. Some minute conversions repeat indefinitely, so a displayed decimal quantity is an approximation. Reconcile the result rather than assuming every method of grouping produces the same pennies.
For example, ten separate one-minute entries at an illustrative USD 10.00 per hour each round to 0.17 when calculated and rounded per line, totaling 1.70. Grouping the ten minutes gives approximately 0.1667 hours; multiplying by 10.00 rounds to 1.67. The three-cent difference comes from rounding order. Use the agreed billing method consistently and do not change grouping merely to increase the charge.
Keep rate units and quantity units matched
An hourly rate needs hours, a day rate needs the agreed definition of a day, and a fixed session fee needs sessions. Do not multiply a daily price by hourly quantities. For mixed work, name each unit in its row and check the rate against the agreement.
The editor also rounds a unit price to currency precision before multiplication. This usually fits ordinary hourly prices, but unusual fractional prices deserve an independent check. For package work, the time log may support delivery without determining the fee; see the retainer guide before treating included hours as additional charges.
Run a final quantity-to-amount check
- Reconcile the approved minutes with the original log.
- Separate groups with different rates or billing rules.
- Convert quantities and check the line amounts independently.
- Compare the sum of invoice lines with the intended rounding method.
- Save the invoice PDF and the supporting timesheet together.
If the client needs detailed evidence, reference the timesheet in Notes and send it separately. Do not copy unnecessary private task content into the bill. The virtual assistant invoice guide shows how task groups can summarize a busy log while keeping the supporting detail available.
Frequently asked questions
Is 2.30 the right quantity for two hours and thirty minutes?
No. Two hours and thirty minutes is 2.5 hours. The decimal 2.30 equals 2.3 hours, or two hours and eighteen minutes.
Should I round each entry or the total?
Follow the agreed billing method. Rounding individual monetary lines can differ from grouping the same minutes, so keep the method consistent and explain it when needed.
Can ToolNivo turn my timesheet into an invoice automatically?
No. Review and convert the time yourself, then enter the quantities and rates. Keep the source timesheet outside the tool.