Preparing your credit card statement for upload
Sage Expense Management only accepts statements in Excel/CSV format. You can download your statement from your bank portal in Excel/CSV format.
Ensure that the statement includes transactions from the date period for which you want to add the transactions in Sage Expense Management
The statement can include transactions from one or more cards. There's no limitation on the number of cards that can be included in a single statement.
Ensure that the name of the file includes the overall details:
Bank name
Statement period
Ensure that the statement includes the following columns for each transaction:
Transaction ID
A unique ID for identifying each transaction.
Card number
Ensure that at least last 4 digits of the card are present for each transaction.
Note: Do not include all 16 digits of the card in any statement. Such a statement will automatically be rejected by Sage Expense Management to protect your confidential data.Amount
Merchant
Transaction Date
Post Date
Uploading your credit card statement
From your admin account, navigate to Corporate Cards > Statements. Click on Add New Statement.
Attach the statement file in Excel/CSV format.
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.
Click on Import Statement. This will successfully upload your statement to Sage Expense Management
In case your statement contains cards that already exist on Sage Expense Management, the transactions will be imported to the existing cards.
In case you statement contains any new card that does not already exist on Sage Expense Management, a new card will be created and the corresponding transactions will be imported to it. You will get an option to choose the assignee for any such new card.
Auto-detection of duplicate credit card statements by Sage Expense Management
When you upload a statement, Sage Expense Management identifies in case you have uploaded any statement twice. You will see one of the following warning messages in this case:
Similar statement found: In case you have uploaded the exact same statement again, you will see this message. You can cancel the upload or proceed with it anyway (this might result in duplicate transactions).
Duplicate transactions found: In case you have uploaded a statement which contains some transactions which already exist in Sage Expense Management, you will see this message. You can proceed to upload only non-duplicates or proceed with the full upload anyway (this might result in duplicate transactions).