How to Import Credit Card Statement
How to import a credit card statement using a csv file that was obtained by your bank. Once imported, these transactions can then be reviewed, attach receipts and process into a Microix Invoice, code to the correct expense category and submit for approval.
Note: This article is intended for Microix Administrator or Finance team.
π§Ύ Step 1: Credit Card Setup
Navigation Path:
Req/Purchase Order β Setup β Credit Card Assignment
Complete the following fields:
| Field | Description |
|---|---|
| Employee Name | Requester that is responsible for importing the CSV file. |
| Financial Organization Name | Enter the name of the credit card provider (e.g., Bank of America). |
| Last 5 Digits | Default to 00000 (used for record-keeping only) DO NOT ENTER CREDIT CARD NUMBER. |
| Account ID | Enter the last 4 digits of the credit card number. DO NOT ENTER CARD NUMBER. |
| Vendor ID | Select the vendor associated with the credit card provider. |
| Workflow | Choose the workflow to route imported transactions for approval. (This value is a default, user can select another workflow during processing |
| Distribution Code(optional) | Select if a default distribution code is required. |
| Period From / To | Enter the statement period. |
β
Click Save to complete the setup.
π Step 2: Import Credit Card Transactions
Navigation Path:
Bank Transactions β Bank Feed β Click Import (top right)
Import Instructions:
-
Ensure the option *"Import data from .csv" is selected.
-
Click the file icon to select and upload the appropriate
.CSVfile. -
Click
Process(bottom right) to initiate the import.
β‘οΈ The system will read the CSV and create individual documents based on the setup defined in Step 1.
π Step 3: Process Imported Transactions
Navigation Path:
Req/Purchase Order β My Documents
For each imported transaction:
-
Locate and open the document.
-
Review, edit, and code the transaction appropriately.
-
Attach credit card receipts or any required supporting documentation.
-
Submit the transaction for workflow approval (based on the assigned routing).
π Notes & Best Practices
-
Ensure the CSV file is formatted according to the expected structure (consult M25 support or documentation if unsure).
-
Transactions will not route correctly if required setup fields (like Workflow or Vendor) are missing.
-
Itβs recommended to reconcile statements monthly and keep receipts digitally attached for auditing.