Skip to main content

Exporting Expenses from Pemo to Xero

Once your Pemo-Xero integration is connected, you can export purchases, refunds, cashback, chargebacks, top-ups, and withdrawals. Pemo sends key details, including receipts, to Xero.

What's required for export

Before exporting a card transaction expense, add a Chart of accounts and a Vendor. Without these fields, the expense shows Missing accounting fields and can't be exported.

Before you start

  • You need to be a Super Admin, Admin or Accountant (Internal or External). Web only.

How to export purchase transactions without fees

  1. Select Accounting export in the left sidebar and open the Transactions tab.

  2. Select the transactions you want to export.

  3. Choose Mark as ready.

  4. Select Export at the top right.

Each transaction must have a Chart of accounts and Vendor.

Local currency (AED)

Expenses are exported in AED with the actual paid amount and attached receipt. No additional conversion is applied.

Foreign currency

Pemo exports the actual amount or payable amount in AED. No exchange rate is sent from Pemo.

If you use Xero Premium with multi-currency enabled, Xero handles the conversion into the original currency.

How to export purchase transactions with fees

Some purchases include transaction or processing fees. Pemo splits these into two entries: the main expense and the fee.

Before exporting, set your Fees Account: select Accounting export in the left sidebar, select Settings above the table, then Default accounts.

  1. Select Accounting export in the left sidebar and open the Transactions tab.

  2. Select the fee-based transactions you want to export.

  3. Choose Mark as ready.

  4. Select Export at the top right.

The main expense and fee expense share the same Pemo Export ID. Attachments are sent only with the main expense, while fees are posted to your default fee account. Multiple fee types are exported as line items.

How to export refunds from Pemo to Xero

Refunds, cashback, and chargebacks appear in Xero as Receive money transactions.

  1. Select Accounting export in the left sidebar and open the Transactions tab.

  2. Apply the Transaction Type = Refunds / Cashback / Chargebacks filter.

  3. Select the transactions you want to export.

  4. Choose Mark as ready.

  5. Select Export at the top right.

This records refunds against your wallet instead of recording them as separate expenses.

How to export top-ups and withdrawals from Pemo to Xero

Top-ups and withdrawals reflect wallet movements. They are exported to Xero as Transfers if the cash ledger is enabled.

  1. Select Accounting export in the left sidebar and open the Wallet movements tab.

  2. Select the top-ups or withdrawals you want to export.

  3. Choose Mark as ready.

  4. Select Export at the top right.

Data exported from Pemo to Xero

Each export to Xero includes the expense details and accounting fields below.

Expense details

Expense details include the Expense Date, Expense ID, VAT type with Inclusive as the default, quantity of 1, actual amount in AED, and attached files or receipts.

Accounting fields

Accounting fields include Chart of accounts, Vendors, Payment Account, VAT Rate, Tracking Categories, and Memo.

Where to find export history

Every expense exported to Xero is stored in Export History as a CSV backup. You can use it for audits, reconciliations, external reviews, and reporting outside Xero.

  1. Select Accounting export in the left sidebar, then select the clock-shaped History button next to Download.

  2. Select the exported file you want to download as a CSV file.

This gives you a parallel record of what was sent to Xero.

Did this answer your question?