Skip to main content

Import card transactions

Goal​

Bring company card transactions into Business Central, ready for card holders to attach receipts. Use this when there is no automatic feed, or to handle transactions manually.

When an automatic feed is configured (AirPlus, Nordea First Card), transactions arrive on their own and are matched to expenses automatically. This page covers the manual and file-import paths. See Company card settings.

Enter a transaction by hand​

Go to Manual Company Card Transactions (TEM), select New, and fill in the employee, card number, date, description, and amounts.

Manual company card transaction

Transaction Amount vs Billing Amount - the Transaction Amount is the amount in the currency where the purchase was made (which may be a foreign currency). The Billing Amount is the same purchase converted to your company's local currency, as billed by the card provider. For a domestic purchase the two are equal.

Click Create transactions to send them to the card holders. Each employee receives a notification in the app to attach a receipt.

Import from a file​

From Manual Company Card Transactions (TEM), select Import file. You have three options, depending on the format set on the Company Card Agreement:

Import file

  1. Import an Excel or CSV file
  2. Import from a bank statement
  3. Import from a bank reconciliation