What it reads
Paste lines from any true-up workbook or order export, or upload a CSV. Columns can be in any order.
The checker matches each column by its header name and by what the cells hold: dates, part numbers, money and small whole numbers. When quantity x price x months equals the amount on most lines, that confirms which column is which.
If it cannot tell which column holds the quantity, unit price or amount, it asks you before checking anything. Every choice is listed under Review columns, and you can change any of them.
Two kinds of findings
Proven by the row's own numbers or by your price sheet.
- The amount does not match quantity x price x months
- The months charged contradict the coverage dates
- The price differs from your contract price
- A line repeated with the same order or reservation number
Needs your judgment before anyone changes anything.
- Same part at different prices, with no price sheet
- A possible unit mixup
- Same-day reservations for the same part, with no order number
- Same order number, but different dates or price
Only likely errors change the total after likely errors. Lines to review stay in the total until you decide.
Arithmetic
Quantity x unit price x months should equal the amount on the same line. A gap of more than one unit of currency is a likely error. If unit prices are annual, the months are divided by 12.
Example15 x $8.00 x 8 months = $960.00, but the line says $1,080.00.
How months are counted
Microsoft charges a partial month as a full month. The checker counts every calendar month the coverage touches, from the start month to the end month, both included. A line that charges a different number of months than its own dates is a likely error.
ExampleCoverage from March 18 to November 30 is 9 months, March through November. A line that charges 10 months is flagged.
When the dates reach into an extra month by only a day or two, the line is listed to review instead.
Prices against your price sheet
Paste your contract price sheet, part number and price, and every line is compared with it. A different price is a likely error, and the line is worked out again at your contract price.
A price 10, 100 or 1000 times your contract price usually means the wrong unit was used. With your price sheet to prove it, that is a likely error too. Parts that are not on your price sheet are listed to review.
ExampleYour contract price is $0.20 per GB and the line charges $20.00 per GB, 100 times as much.
Same part, different prices
Without a price sheet, the checker compares lines for the same part with each other. A line that differs from the most common price is listed to review. Your price sheet would settle which price is right.
Possible unit mixups
When one line's price is 10, 100 or 1000 times another line's price for the same part, it is listed to review as a possible unit mixup. Add your price sheet and it can be proven either way.
Reservation-based workbooks and repeats
In a reservation-based true-up, each reservation is its own row. Two rows for the same part, quantity and day are often separate adds, not a mistake. So repeats only count as errors when the order or reservation number matches.
- Same order number, same everything: likely error. One of the two should come out.
- Same order number, different dates or price: to review.
- Different order numbers: separate reservations, not flagged.
- No order or reservation number column: same part, quantity, price and day are listed to review.
What it cannot check
- Whether each reservation was actually made, or whether one is missing. Tie the lines to your own reservation log for that.
- Whether a price is right, without your price sheet. It can only compare lines with each other.
Privacy
The checker runs entirely in your browser. Your lines are not uploaded, saved or sent anywhere. Close the tab and they are gone. You can also download the page and run it on your own computer.
We check it against your contract and reservation history.