Remittance advice to Xero: PDF, Excel and email formats compared

A remittance advice tells you which invoices a payment covers. In theory it is the answer key for your reconciliation. In practice it arrives in whatever format the payer's system spat out, and the format decides how much of your morning it costs. Here is how the common ones behave when you sit down to reconcile them into Xero.

PDF: readable to humans, hostile to reconciliation

The most common format is also the most awkward. A PDF remittance is designed to be printed and read, not parsed. The data is there, invoice numbers, amounts, a total, but it is locked in a layout. To use it you either read it line by line against Xero or copy it out, and copying out of a PDF is where transposed digits and dropped lines are born.

• Native PDFs (generated from software) can sometimes be selected and pasted, but columns rarely survive the paste.
• Scanned or image PDFs carry no text at all and need OCR, which introduces its own errors on exactly the digits you care about.
• Multi-page PDFs hide the running total on the last page, so it is easy to reconcile page one and forget the rest.

Excel and CSV: the good case

When a payer sends a spreadsheet, your life improves. Columns are columns, amounts are numbers, and you can sort, sum and cross-check against a Xero invoice export. This is the format to ask for if you have any influence over the payer, because it turns matching from transcription into a lookup.

The caveats are real but manageable: header rows and footer totals need trimming, amounts sometimes arrive as text and refuse to sum until cleaned, and every payer lays their columns out differently, so a process built for one payer's Excel breaks on another's. Still, a messy spreadsheet beats a tidy PDF every time.

Email body: convenient to send, painful to use

Some payers, and many NDIS plan managers, put the remittance in the body of an email or attach it inline. It feels convenient because it is already in your inbox, but the data is unstructured text wrapped in a mail client's formatting. Pasting it anywhere useful means fighting line breaks and inconsistent spacing, and forwarded chains bury the actual figures under quoted replies.

A format-by-format reconciliation approach

• PDF: reconcile line by line against Xero if short; for long PDFs, get the underlying data rather than retyping it.
• Excel or CSV: clean the headers and totals, confirm amounts are numeric, then match against a Xero invoice export by reference.
• Email body: extract the figures into a spreadsheet first; do not attempt to reconcile from the email itself.
• Every format: finish by confirming your allocations sum to the payment total before you post anything.

The format should not decide your accuracy

The uncomfortable truth is that the payer chooses the format, and their choice sets your error rate. A tool that reads PDF, Excel, CSV and forwarded email alike, and normalises them into one structured set of lines, removes the format as a variable. You review the same clean matched report whether the payer sent a pristine spreadsheet or a scanned fax, and the reconciliation stops being a lottery decided by someone else's export settings.