Goal: Move card transactions from Qashio into a Xero bank account (via CSV) so you can reconcile alongside the live Qashio→Xero feed.
Who is this for?
Finance teams using Qashio cards who also want historical/backfill entries or to fix gaps alongside the built-in Qashio→Xero sync.
What you’ll do
Create a Qashio export template tailored for Xero
Export the transactions using that template
Add a Xero-friendly Date column to the CSV
Import the CSV into the correct Xero bank account and reconcile
Prerequisites
Qashio access to Transactions and Export
Xero org access to import bank statements
The target Xero bank account (e.g., “Qashio Visa” clearing/settlement)
⚠️ Avoid duplicates: Export only the dates that are not already in Xero, especially if your Qashio→Xero feed is active.
Step 1 — Create a Qashio export template for Xero
Video: 1 Template Creation and Transactions Export.mov
In Qashio → Transactions, open Export → Manage Templates → New Template.
Add these columns (recommended minimal set for Xero import):
Xero field (CSV) | Suggested Qashio field | Notes |
Amount | Transaction Amount | One column only. Income = positive, Expense = negative. No currency symbols/commas. |
Payee | Merchant Name | Optional but helpful for reconciling. |
Description | Memo / Notes | Optional details (category, cardholder, etc.). |
Reference | Transaction ID | Useful for traceability. |
(raw date/time) | Transaction Date / Created At | Keep as-is; we’ll add a clean Date column in Step 3. |
3. Save as “Xero Bank Import – Minimal.”
Step 2 — Export transactions from Qashio
Video: 2 Date Format modification.mov
In Transactions, filter the exact date range you need.
Export → choose your Xero template → CSV.
Download the file.
Step 3 — Add a Xero-friendly Date column
Xero accepts DD/MM/YYYY, MM/DD/YYYY, or YYYY/MM/DD. To avoid regional confusion, we recommend YYYY/MM/DD.
Excel (example)
Open the CSV. Insert a new first column, name it Date.
If your raw timestamp is in column H (e.g.,
2025-09-22T13:45:00Z) and begins at H2, in A2 enter and Fill Down:=TEXT(DATEVALUE(LEFT($H2,10)),"yyyy/-mm-dd")
Ensure Amount is a single numeric column: expenses negative, income positive.
If you exported Debit/Credit separately, combine them into Amount and multiply Debits by -1.
Remove currency symbols (e.g., AED) and thousands separators.
Save as CSV (Comma delimited).
Google Sheets (example)
Date:
=TEXT(DATEVALUE(LEFT(H2,10)),"yyyy-mm-dd")Amount (if combining):
=IF(LEN(D2),-1*D2,E2)Download as CSV.
✅ Keep it minimal for import: Date, Amount, Payee, Description, Reference.
Step 4 — Import the CSV into Xero & reconcile
Video: 3 Import into Xero.mov
In Xero: Accounting → Bank accounts → [Your bank] → Manage account → Import a statement.
Upload your CSV and confirm the date format (e.g.,
YYYY-MM-DD).Map columns:
Transaction Date → Date
Amount → Amount
Payee → Payee (optional)
Description → Description (optional)
Reference → Reference (optional)
Review the preview, import, then Reconcile the new statement lines.
Troubleshooting
Date won’t validate
Ensure the Date column has no time component (just a date) and uses an accepted format. Cells should be true dates (not text with stray spaces).Amounts reversed
Expenses must be negative. If an expense shows as “received,” flip the sign in your CSV and re-import.Cannot map columns
Strip the file to the essentials: Date and Amount are the only required fields. Add Payee/Description/Reference only if helpful.
Best practices
Export/import non-overlapping periods to prevent duplicates with the live feed.
Set Reference = Qashio Transaction ID for quick trace-back.
Use a consistent date format (we recommend YYYY-MM-DD).
Keep Amount numeric only (dot as decimal separator, no commas/symbols).
FAQ
Which date formats does Xero accept in CSV imports?
DD/MM/YYYY, MM/DD/YYYY, or YYYY-MM-DD. We suggest YYYY-MM-DD.
How should the Amount column look?
Single column. Positive for money in, negative for money out. No currency symbols or thousands separators.
Where do I import in Xero?
Accounting → Bank accounts → Manage account → Import a statement on the specific bank account.