Telstra & Optus Business Bill PDF to Excel for Tax Apportionment

Australian sole traders with bundled Telstra, Optus, TPG, or Vodafone Business bills should convert each PDF into one spreadsheet row per service - mobile number, fixed line, or internet service - then apply the substantiated work-use percentage to each row. The record supports the percentage; the bill supports the cost.

The phone and internet expenses fact sheet says records are needed for a four-week representative period for claims over $50; for itemised bills, the work-use percentage over that period can be applied to the whole year, and bundled phone and internet plans should be apportioned by work use for each service. That rule sets the boundary: the diary supports the percentage, while the spreadsheet must preserve the bill cost for each service.

The destination spreadsheet has eight columns, one row per service per bill:

• Service identifier: mobile number, fixed-line ID, internet account, or service-account number
• Service description: a label specific enough to identify the service without reopening the PDF
• Issue date: repeated on every row from that bill
• Line charge: the per-service charge before bundle-level credits
• Discount or credit allocation: the service's share of header-level adjustments
• Net cost: line charge less allocated discount or credit
• Work-use percentage: populated from the diary or representative-period record
• Claimable amount: net cost multiplied by work-use percentage

This article produces the spreadsheet. It does not create the diary or decide the correct work-use percentage; the taxpayer and, where relevant, their tax agent must be able to defend that percentage.

What the ATO Actually Expects from a Bundled-Bill Claim

Where one bill carries several services, the work-use percentage applies to each service on its own substantiated cost. A dedicated work mobile might be 100% business use. Home internet shared with the household might be 30%. A secondary mobile might sit somewhere between. A single bundle-wide percentage would either overclaim the shared service or underclaim the dedicated work service.

Two pieces of evidence support the claim. The bill substantiates cost: service charge, credits, discounts, GST where relevant, and net amount. The diary substantiates use: work calls, work data, or other reasonable work-use measure over the representative period. Neither evidence replaces the other. The bill alone shows what was spent but not what proportion was work-related; the diary alone shows the proportion but not the amount.

This matters most when the business plan mixes genuinely different use patterns. A consultant might have a dedicated work mobile, a backup mobile used by a family member, and a home internet service on one monthly account. If the bundle costs $180, the claim is not simply "$180 x business percentage". It is the dedicated mobile's net cost x its percentage, plus the backup mobile's net cost x its percentage, plus the internet service's net cost x its percentage. The total claim is the sum of those rows.

That is why the spreadsheet must keep the service line intact. The service identifier connects the bill cost to the diary percentage and to the final claimable amount. If the PDF is converted only to bundle totals, the evidence chain breaks at the exact point the apportionment has to be defended.

Anatomy of a Telstra Business and Optus Business Bill PDF

A Telstra Business bill usually has three useful layers. The front-page Account Summary gives the total due, payment date, account-level credits, and bundle-level adjustments. The Service Summary lists each mobile number, fixed line, or internet service with a subtotal. The detailed charge blocks then show plan fees, call charges, data charges, credits, and service-specific adjustments.

Optus Business bills use different labels but the same structure. The front page gives the account-level total. The Charges by Service section is the equivalent of Telstra's Service Summary. Detailed charge blocks follow underneath or on later pages. TPG Business bills often use a Services and Charges table, while Vodafone Business bills usually group mobile services by number, with layout differences across plan generations.

The practical rule across carriers is the same: ignore the account summary as the calculation source and find the per-service block. The Account Summary is useful for paying the bill and reconciling the PDF total. It is not enough for tax apportionment because it sits at bundle level.

Do still keep the Account Summary in the extraction context. It is where carrier-wide credits, direct-debit discounts, late-payment fees, and plan-level adjustments often appear. Those values do not replace the service rows, but they must be allocated back to those rows if they change the cost paid for the month. The per-service block gives the row structure; the account summary explains why the service subtotals may not equal the amount paid.

The Bundle Decomposition Problem - and How to Solve It in One Prompt

Bundled plans often apply discounts and credits at the header level. A primary mobile, a secondary mobile, and home internet may each have a service charge, but a single account credit reduces the total bill. To produce a defensible per-service cost, allocate header-level adjustments back to the service rows using a documented basis.

Proportional allocation by line charge is the usual default. If the primary mobile is 60% of the line charges before discounts, it receives 60% of the bundle credit. If plan documents tie a credit to one service, allocate it to that service instead. The important point is consistency: choose the basis, document it, and apply it the same way across the income year.

For example, if three services have pre-credit charges of $80, $40, and $30, the total service charge is $150. A $15 bundle credit allocated proportionally gives $8 to the first service, $4 to the second, and $3 to the third. Their net costs become $72, $36, and $27 before work-use percentages are applied. A 100% work mobile claims $72; a 30% home internet service claims $10.80; a 50% shared mobile claims $13.50.

A single extraction prompt can express the whole job:

"Extract one row per service identifier from each Telstra, Optus, TPG, or Vodafone Business bill. Repeat the issue date on every row. Use a service-specific description such as 'Mobile - [number]' or 'Home Internet - [account]'. Allocate any header-level credits or discounts proportionally across service lines based on each line's share of total line charges unless the bill clearly ties the credit to one service. Output Excel columns for service identifier, service description, issue date, line charge, discount allocation, net cost, work-use percentage, and claimable amount."

That turns the workflow into a batch extraction job rather than twelve monthly retyping exercises. Upload the year's bills, apply the saved prompt, and download one spreadsheet with the same columns across the year through the AI-powered bill and invoice data extraction workflow.

For the next tax year, save the same prompt and reuse it against the new bill batch. The value is consistency: service identifier, issue date, net cost, work-use percentage, and claimable amount stay comparable across years.

The Per-Service-Line Schema, Column by Column

Each column has a source and a job.

Service identifier. The mobile number, fixed-line ID, or service account printed next to the service. This is the join key between bill, diary, and deduction worksheet.

Service description. A plain label that survives outside the PDF, such as Mobile - 04XX XXX XXX, Home Internet - Account 12345, or Fixed Line - 02 XXXX XXXX.

Issue date. The bill issue date, repeated on every row from that bill. Repetition makes sorting, quarterly filtering, and year-end grouping work without blank rows.

Line charge. The per-service charge before account-level credits. This should come from the service block, not from the bundle total.

Discount or credit allocation. The share of account-level credits assigned to the service. If there are no header adjustments, the value is zero.

Net cost. Line charge minus allocated credit. This is the substantiated monthly cost to which the work-use percentage applies.

Work-use percentage. The percentage from the diary for that service identifier. A mobile, a home internet service, and a fixed line can each carry different percentages.

Claimable amount. Net cost multiplied by work-use percentage, calculated per row. Sum this column across the income year, grouped by service identifier or service category, to get the figures used in the return. Pivot tables make the review simple: service identifier in rows, claimable amount in values, and issue date as a month or quarter filter.

This schema is a tax-apportionment version of the broader phone bill to Excel workflow. The difference is the service identifier's role: here it is not just a label. It is the field that connects the bill row to the diary percentage and to the final deduction.

One common adaptation is GST. A sole trader registered for GST who is claiming input tax credits on the work-use portion can split line charge into GST and net-of-GST columns before applying the work-use percentage. Keep the GST column separate from the income-tax deduction column so the BAS figure and the income-tax expense figure can be reviewed independently. The downstream GST handover is similar to other spreadsheet-to-BAS workflows, such as feeding extracted records into Xero BAS preparation.

Another adaptation is client or project coding. If the work mobile is used for multiple clients, keep that allocation outside the phone-bill extraction unless the bill itself carries client-level evidence. The bill can support the service cost. The diary or job records support the work-use and client split. Mixing those two evidence layers in the source extraction makes the spreadsheet harder to defend.

Audit Readiness - Pairing the Spreadsheet with the Diary

An audit-ready phone-and-internet claim has three linked records: the retained bill PDFs, the per-service spreadsheet, and the diary or representative-period record. The service identifier connects all three. An auditor should be able to start from one claimable amount, trace it to a specific service row, open the matching bill page, and find the diary percentage used for that service.

Use this checklist:

• Keep the bill PDFs for the statutory record-keeping period, typically five years from lodgement.
• Preserve the spreadsheet in a format that shows formulas, not pasted values only.
• Store the diary with the spreadsheet, or reference it clearly enough for a tax agent to locate.
• Document the allocation basis for header-level credits.
• Reuse the same extraction prompt year over year so the column structure stays comparable.

Name files so the chain is obvious: 2025-07 Telstra bill.pdf, 2025-phone-internet-apportionment.xlsx, and 2025-phone-diary.pdf is easier to review than a downloads folder full of generic carrier filenames. Keep the prompt or allocation note with the spreadsheet, especially if bundle credits were split proportionally. The audit question is not whether the spreadsheet looks tidy; it is whether each number can be traced back to a bill, a diary percentage, and a documented allocation method.

For the broader evidence-chain view, preparing apportionment records for an ATO tax audit covers the record organisation that applies across deduction categories.