Telecom expense audit: a monthly checklist for carrier invoices

A telecom expense audit works when it is a monthly routine instead of a yearly project. Each month, when the carrier invoices arrive, you check the lines against last month and against your disconnect list, write up what is wrong, and record what happened to last month's findings. The routine below takes the same steps every time, so it gets faster.

This is a checklist you can copy into a ticket or a spreadsheet. It is the monthly version of the line checks in the telecom invoice audit guide.

What should a monthly telecom expense audit include?

Five things, in this order: get every invoice in, read the lines, run the checks, send the disputes, and close out last month. Skipping the first step is the usual failure, since a carrier whose invoice never arrived cannot be audited that month.

What is the monthly checklist?

Before you start

• Every carrier account has an invoice for the month. Make a list of accounts and tick each off; note any that is missing.
• Each invoice is a line-item export (CSV or Excel) or a text PDF, not a scan.
• The disconnect list has every cancellation since last month: service ID, date, carrier.

Read the lines

• Each line has a service ID, description, charge type, period, quantity, rate and amount.
• If the invoice prints a total, the lines add up to it, within a dollar. If not, a line is missing or misread.
• Service IDs are cleaned the same way on every sheet (uppercase, no spaces, dots or dashes).

Run the checks

• After disconnect: recurring lines on the disconnect list whose period runs past the date. For a partial period, count the days after.
• Rate change: same service ID and description as last month at a different rate, over the threshold you set. A sensible rule is to require both a percentage and a dollar amount, so a 12% rise on a $3 line is not worth an email, while a $40 rise is.
• Duplicate: same service ID, description, period and amount twice.
• Repeated one-time charge: same service ID and amount in two consecutive months.
• New recurring line: a service ID that was not on last month's bill. Confirm you ordered it.

Send and track

• One dispute note per carrier: account, invoice number, service ID, line, amount, reason.
• Each finding is marked disputed, credited (with the amount) or dismissed (with a note).
• Last month's disputed findings: did the credit arrive on this bill? If not, follow up.

How do you set the threshold for rate changes?

Pick a percentage and a dollar amount and flag a change only when it exceeds both. For example, a threshold of 10% and $5 a month means a $200 circuit that rises by $25 is flagged and a $4 feature charge that doubles is not. The point is to keep the list short enough that you act on it. Adjust the numbers after a couple of months, once you see how many you are skipping.

Why does the first month look different?

The first month for a carrier has no earlier bill, so there is nothing to compare rates with. Only the disconnect and duplicate checks can run, and the rate-change check starts from the second month. Plan for it: upload last month's invoice as well if you still have it.

What do you do about a finding you decide is fine?

Mark it dismissed with a note, and record the rate you accepted. If the same line comes back at the same rate next month, do not flag it again. If it changes again, flag it, because that is a new change.

How do you keep it from becoming a chore?

• Fix the date. Audit within a few days of the invoices arriving, so disputes land while a charge is recent.
• Keep the disconnect list current at the moment of cancellation, not at audit time. That is the single input you cannot recover afterwards.
• Let a script do the reading. The checks are mechanical, so the time is better spent on the disputes than on scanning rows.

How Carrier Bill Check runs the monthly audit

Carrier Bill Check follows this checklist for you. You upload the month's invoices (PDF, Excel or CSV) for up to ten carrier accounts, review the lines it read, and it runs the five checks against your disconnect list and last month's approved invoices. Findings are grouped by carrier and type with dollars, each one can be marked disputed, credited or dismissed, and a dismissed rate is not flagged again at that rate. It emails a monthly digest on day 10 by default, naming a carrier that had an approved invoice last month and none this month. It does not contact carriers or read contracts.

Run the free sample to see the findings from two months of invoices, or read the telecom cost reduction guide for what those findings can add up to.

Frequently asked questions

How long does a monthly telecom expense audit take?

By hand it depends on how many lines you have. ITG Group's guide to telecom expense management puts disciplined spreadsheet review at 4-6 hours a month for a smaller company. The reading is the slow part, and it is the part a script can do.

Do I need a disconnect list?

For the after-disconnect check, yes: the invoice cannot tell you what you meant to cancel. Without it you can still compare rates and look for duplicates.

Should AP or IT run the audit?

Whoever knows what was disconnected. That is usually IT or the telecom or operations manager, not accounts payable, who see the amount but not the history behind a circuit.