Introduction
If you have connected your company's cards to Sage Expense Management's real-time feed with Visa or Mastercard, transactions from the cards will instantaneously flow into Sage Expense Management whenever they are made.
To learn more about Visa real-time feed, read: Managing transactions through Visa real-time feed
To learn more about Mastercard real-time feed, read: Managing transactions through Mastercard real-time feed
In rare cases, the real-time feed might not capture a transaction. Sage Expense Management offers the ability to easily validate that all transactions are present in Sage Expense Management, and import any transactions if missing.
Using statement upload to reconcile transactions
Download your credit card statement from your bank portal in CSV, XLS, or XLSX format from your bank portal.
On the Tasks page, attach the statement file by clicking on Upload.
Verify the bank name and statement period automatically extracted by Sage Expense Management Make any changes required.
Choose the correct debit/credit convention for your statement.
Review the mappings created by Sage Expense Management for each column on your statement. Make any changes required.
Refer to the preview of the statement to ensure that the mappings are correct.
Based on the mapping, a summary is shown. This includes the % of transactions which are already present in Sage Expense Management (usually 100%). In case any transactions are not present in Sage Expense Management, they will be highlighted.
In case any such transactions are present, click on Import. This will successfully add the missing transactions to Sage Expense Management
Best practices
We recommend you upload the entire statement received from your bank. Sage Expense Management will automatically identify the missing transactions (if any) and only import them.
While uploading the statement, ensure that all cards present in the statement are connected on Sage Expense Management already. If you have the cards that aren't present on Sage Expense Management yet, please upload a statement separately for those cards that are not connected to Sage Expense Management You can read more about this here: Add cards & transactions using statement upload
By default, the value of the Preferred Reconciliation Date is set to Post Date. Based on that date, Sage Expense Management searches for matching transactions. You can change this to Transaction Date from the Mapping screen.