Card expenses sync to Microsoft Business Central as Purchase Invoices. There is currently one sync configuration available.
When do card expenses sync?
Card expenses are synced in one of two ways:
- Automatically, upon final approval: sync is triggered in real time and should appear in Business Central within seconds.
- Individually or in bulk by any admin: admins may use the Accounting hub to bulk sync transactions or use the individual "Sync" button on an expense. These expenses may be synced again later if additional information is added.
Expenses that are still pending when approved will only begin syncing once the transaction settles.
How do fields sync to Business Central?
Airwallex card expenses sync as Purchase Invoices. You may find specific field mappings below.
| Airwallex | Business Central Purchase Invoice |
| Entity / Organisation | Business Central Company (resolved automatically) |
| Merchant | Vendor (vendorId and payToVendorId). If a linked merchant resolves to an imported Business Central vendor, that vendor is used. Otherwise, defaults to a shared vendor called "Airwallex Expenses". |
| Expense ID | Vendor Invoice Number (format: AWX-EXP-...) |
| Transaction Date | Invoice Date |
| Transaction Currency | Currency Code |
| Prices Include Tax | Set to true for non-US companies; unset for US companies |
| Expense-level Tracking Categories | Purchase Invoice header-level Dimensions |
| Line item Tracking Categories | Purchase Invoice line-level Dimensions (falls back to expense-level values if unset) |
| Expense Category (Account) | Purchase Invoice Line Account (falls back to expense-level account if unset on a line item) |
| Line item Description | Purchase Invoice Line Description (falls back to expense description, then to "Airwallex Expenses") |
| Line item Amount | Purchase Invoice Line Unit Cost (quantity = 1, discount = 0). If the expense has no line items, the transaction amount is used. |
| Tax Code | Purchase Invoice Line Tax Code (falls back to expense-level tax code if unset on a line item) |
| Notes | Purchase Invoice Comments (note timestamp is used as the comment date) |
| Receipts | Purchase Invoice document attachments |