Schema CPA

Xero Receipt Capture: Getting Receipts into Xero

By Schema CPAPublished Updated

Xero receipt capture brings a receipt in by email to the organisation's Xero address, by drag and drop in a browser, or by a photo in the Xero app. Xero reads the date and amount and keeps the original image with the record, which ends up as a bill, a spend money entry or an expense claim.

How can clients and firms upload receipts to Xero?

Clients and firms can upload receipts to Xero by email, by browser upload and by phone. Xero's product page Smart Document Capture Software | Xero US describes all three: forward receipts to the Xero email address, drag and drop files on the web, or photograph a paper receipt with the Xero Accounting app.

Email to the Xero address

Each Xero organisation has an email address that receives documents. Xero's Files API specification describes it as "the email address used to email files to the inbox," and says only the inbox folder has one. Email suits receipts that already arrive as attachments, such as software subscriptions and online orders. The post on the Xero files inbox and how documents arrive there covers the inbox itself.

Drag and drop in a browser

A browser upload suits a batch the firm already holds, such as a folder of scans a client dropped off. The Smart Document Capture page lists the formats Xero stores as including "JPG, PNG, PDFs, and Word documents." Xero's pages fetched for this post do not state a file size limit, so check the upload message in the organisation before sending large files.

A photo in the app

The Xero Accounting app photographs a paper receipt, and the Smart Document Capture page says Xero "captures the amount, date, and other details automatically." It also says you can see the original document next to the data entry screen to double-check the figures.

That side-by-side check only works when the photo is readable. Give clients three instructions: photograph one receipt per image, lay it flat in good light, and include the whole slip from the vendor name at the top to the total and card digits at the bottom. A photo cropped above the total, or a faded thermal slip shot at an angle, leaves the reviewer guessing at the one figure that matters. For long restaurant or hardware receipts, two overlapping photos sent as one PDF beat one blurry photo of the full length.

Who does the uploading

A client who uses Xero day to day can forward or photograph receipts themselves. A client who never opens Xero sends receipts to the firm, and a firm user with access to the organisation uploads them. Either way, agree one channel per client, because receipts that arrive by email, by app and by a shared folder at the same time are the usual source of duplicates.

Should a Xero receipt become a bill, a spend money entry or an expense claim?

A Xero receipt becomes one of three records, depending on how the purchase was paid. A bill records an amount the business owes and pays later. A spend money entry records money that has already left a business bank account. An expense claim records a purchase an employee paid personally and expects to have reimbursed.

The three records are distinct in Xero's own data model. Xero's Accounting API specification lists bills as invoices of type ACCPAY, lists SPEND as a bank transaction type, and has a separate expense claim object. Xero's page Pay Bills on Time With Xero Accounts Payable Software | Xero US says Xero "extracts the key details to create draft bills ready for approval." Xero's page Expense Software for Small Businesses | Xero US says employees submit claims through the Xero Me app, an approver reviews them, and "the approved claim becomes a bill you pay like any other." The same page says Xero Expenses is included on the Established plan.

A decision table for a receipt's destination

The table describes which record matches which payment situation, with one fictional example each. Which account a purchase is coded to remains the firm's judgement and the client's facts.

How the purchase was paidRecord in XeroExample (fictional)
Not yet paid; the vendor sent an invoice with termsBillExample Print Shop invoice INV-2207 for $412.50, due in 30 days
Already paid from a business bank or card accountSpend moneyExample Office Supply receipt for $86.40, paid on the card ending XXXX-4821
Paid by an employee with a personal card or cashExpense claimEmployee Dana Example's taxi receipt for $38.00, paid personally

What goes wrong at this step

The common error is recording one purchase twice: once as a bill from the emailed invoice and again as spend money from the receipt the client photographed at the counter. Before creating a record, check whether the same vendor and amount already sit in draft bills. A second common error is creating spend money for a purchase an employee made personally, which leaves the employee unreimbursed in the books.

Matching captured receipts to Xero bank statement lines

Matching captured receipts to Xero bank statement lines means pairing each record with the bank line that paid it. Xero's page Bank Reconciliation Software | Account Reconciliation | Xero US says a match happens when "a bank transaction matches an existing Xero record," and that Xero suggests matches you can accept, challenge or reject.

How suggestions work

The reconciliation page says that when a new statement line imports, Xero tries to reconcile it by one of four methods, including a match to an existing record and a bank rule. "If there's any doubt," the page says, Xero "suggests a match but leaves you to have the final say." It also says suggestions can draw on your own transaction history and on how other Xero users reconciled similar transactions. The page describes no published amount or date tolerance, so a reviewer should treat each suggestion as a proposal.

Where receipts meet the line

A bill or expense claim created from a receipt is an existing record when the payment line arrives, so the line can be matched to it. A spend money entry created ahead of the statement does the same job. The reconciliation page also says you can "find receipts and add relevant documents" in the Reconcile tab and attach source documents to the Reconciled transactions screen, so a receipt that arrives late can still be filed with its line.

Review checks before accepting

These checks are an example a reviewer can run on every suggested match:

  1. The vendor on the receipt is the payee on the statement line, or a known trading name for it.
  2. The amount on the line equals the receipt total, including any tip or delivery charge.
  3. The line date falls a few days after the receipt date, not weeks before it.
  4. The account the line came from is the card or bank account printed on the receipt.
  5. The record is not already matched to a different line.

When one check fails, leave the line unreconciled and add a note. A line left open is visible on the dashboard count of lines to reconcile; a wrong match hides the problem.

Mistakes that make matching harder

Three habits cause most matching trouble. The first is creating records from receipts long after the statement lines arrive, so the reviewer reconciles lines against nothing and creates new entries, and the receipt later becomes a second record for the same spend. The second is accepting a suggestion because the amount is right, when two purchases of the same amount fall in the same week. The third is editing a receipt's figures to make it fit a line. When the receipt and the line disagree, the receipt is evidence of what was bought and the line is evidence of what was paid; both should stay as they are, with a note explaining the gap.

A steady monthly order avoids most of this. Collect the month's receipts by a fixed date, create the bills, spend money entries and claims, and only then reconcile the month's statement lines. Lines that still have no record after that pass become the list of questions for the client.

Xero receipt capture edge cases: foreign currency and split receipts

Xero receipt capture edge cases are receipts whose figures do not line up with a single bank line. Foreign currency receipts show one amount in the vendor's currency and another on the statement. Split receipts cover more than one payment or more than one kind of purchase, so the total on paper never equals one line.

Foreign currency receipts

Xero's page Expand Your Reach With Xero Multi-Currency Accounting | Xero US says you can "receive bills and make payments to international suppliers in their local currency," that "multi-currency is available on Xero's Established plan (US)," and that "you can override the rate on any individual invoice, bill, or payment." In this example a fictional client pays a London vendor £120.00 on the card ending XXXX-4821, and the statement shows $158.62 after conversion and a card fee. The receipt and the line disagree by design. The reviewer confirms the vendor and date, then notes the converted amount the card issuer charged, rather than editing the receipt.

Split receipts

A split receipt comes in two common forms. In the first, one receipt is paid two ways: a $250.00 equipment purchase paid $200.00 on the business card and $50.00 in cash. The card line shows $200.00, so no record for $250.00 will match it. In the second, one receipt covers purchases the books treat differently, such as office supplies and a client gift on the same till slip. In both cases, record what the receipt shows, note how it was paid, and ask the client when the split is unclear. Coding the parts is a decision for the firm.

Duplicates across channels

A receipt that arrives by email and again as an app photo becomes two records unless someone spots it. Schema CPA catches this before keying starts: email attachments and phone photos land in one client file, the second copy is flagged, and the receipts it reads export to Excel or CSV. It has no Xero connection, so the records are still created in Xero. The hours calculator on the homepage estimates what manual entry costs your team today.

Moving receipt data out as a file

Some firms keep a spreadsheet of receipts alongside Xero for review. The post on Excel export for accounting data, XLSX or CSV covers what Excel does to dates, account numbers and payee names on the way. The receipts and invoices category has more on reading receipts before they reach any system.

All posts in QuickBooks, Xero and Excel export