To turn a phone bill PDF to Excel, extract the charges summary as one row per phone line and charge: line number, charge type, description and amount. Keep account-level taxes, fees and credits as rows of their own, skip the call and data detail pages unless you need usage, and check that the rows sum to the amount due.
Phone bill charges per line number
A phone bill for more than one line lists charges under each phone number: the plan, a device installment, add-ons and one-off charges. In Excel, give every charge its own row with a Line column holding the phone number. Then a pivot table shows the cost of each line, which a family or a small business usually wants most.
Columns to keep
- Bill month, the period the bill covers.
- Line, the phone number or a name for it, stored as text so it keeps its format.
- Charge type, such as plan, device, add-on, one-time, tax and fee, or credit.
- Description, as printed.
- Amount, with credits negative.
Prorated charges
A plan change in the middle of a cycle often shows as a partial credit for the old plan and a partial charge for the new one. Keep both rows. Netting them by hand hides why one month cost more than usual.
Call and data detail pages in a phone bill PDF
Many phone bills attach usage detail pages after the summary, listing each call, text or data session with a date, time, number and duration. For a cost sheet, skip them: any charges they explain already appear in the summary. Extract them only when you need usage, such as roaming charges or calls to bill to a client.
When the detail is worth it
Usage detail is a long list with one row per event, which is the same shape as other event logs. Getting one row per trade from a trade confirmation PDF uses a similar approach for a very different document. For a phone bill, keep the time and duration as separate columns, because a duration printed as 1:05 can become a time of day in Excel.
Splitting the work
Extract the summary pages and the detail pages into separate sheets. The summary feeds the monthly total. The detail sheet can be filtered and summed on its own, by line or by number called, without touching the cost figures.
Where do phone bill taxes and fees go?
Taxes, regulatory fees and surcharges on a phone bill are often printed once for the whole account rather than per line. Keep them as rows with the Line set to "Account". Do the same for account-wide credits, such as an autopay discount. Spreading them across lines is optional, and a separate row keeps the printed figure intact.
Spreading account charges, if you must
If each line's cost needs to include its share of taxes, divide the account rows by the number of lines in a helper column, or by each line's share of plan charges. Keep the original account rows, and check that the spread amounts add back to the printed figure.
Fees that look like plan charges
Some fees print inside a line's section with a name close to a plan charge. Read the description, not the position. A Charge type column filled from a small lookup of descriptions keeps them consistent month to month.
Does each month's phone bill total tie and compare?
Each month's phone bill rows should sum to the printed amount due for the current period, before any past-due balance. Check that first. Then stack each month's rows under the last, and a pivot with Bill month as columns and Line as rows shows how each line's cost changed.
Worked example: one bill as rows
The bill below is an example, with three lines and an amount due of 157.35.
| Line | Charge type | Description | Amount |
|---|---|---|---|
| 555-0101 | plan | Unlimited plan | 45.00 |
| 555-0101 | device | Phone installment 14 of 24 | 22.50 |
| 555-0102 | plan | Unlimited plan | 45.00 |
| 555-0102 | add-on | International calling | 10.00 |
| 555-0103 | plan | Basic plan | 30.00 |
| Account | tax and fee | Taxes, surcharges and fees | 14.85 |
| Account | credit | Autopay discount | -10.00 |
The rows sum to 157.35, the printed amount due. Per line, before account rows: 67.50, 55.00 and 30.00.
Separating the past balance
If the bill shows a previous balance, a payment received and a new total, keep those three in a small summary table, not in the charge rows. The charge rows cover only this period, which keeps month-to-month comparisons honest. The same header-versus-lines split appears in extracting invoice line items with header fields to Excel.
Automating the monthly import
If you convert the same carrier's bill every month, a macro can append each month's rows. What a VBA macro can and cannot read from a PDF explains the limits before you build one. The payment itself shows on your bank statement, and FastBankConvert is being built to turn those statement PDFs into Excel or CSV; it is getting ready to open, and you can join on the get-started page.