How to Import Credit Card Statement

Creation date: 7/30/2025 1:17 AM Updated: 9/5/2025 4:06 PM credit card

📥 Summary

The Credit Card Import feature in Workflow Modules Modern enables clients to seamlessly upload credit card transactions from a .CSV file. Once imported, these transactions can be reviewed, add attachments and be converted into API documents and routed through a predefined workflow for review and 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. (most cases its the card holder and in some case it may be an administrative assistant or AP person)
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 *(IMPORTANT the number enter here must match the transaction account ID column in the CSV file.)*
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 a default distribution code if 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). (

📌NOTE: if you do not own the Bank Feed Module, you can continue to import the Credit Card Statement by navigating to Requisition/Purchase Order Menu>Import Documents and click the Credit Card button)

Steps to create an import temple if you do not have one available:

Use the Import button found on the Bank Feed page toolbar then select "Create Template for Import Data" and click the Import button at the bottom of the windows to generate and download the template file.
Download the template and format your credit card file using the same columns found in the Template File. Order of the columns are not important, but the title of the column headers is important. Additional columns will be ignored.
CSV file can contain multiple accounts also known as batch processing or single account.

➡️ The system will read the CSV and import the transactions based on the setup defined in Step 1.

🔄 Step 3: Process Imported Transactions

For each imported transaction:

Review, edit, and code the transaction appropriately.
Attach credit card receipts or any required supporting documentation.
Use the process button to create a Microix Invoice Document
Navigate to My Document List to find the Invoice and submit for approval.

📌 Notes & Best Practices

Ensure the CSV file is formatted according to the expected structure defined in by the Microix template. Order of column is insignificant but the name of the column must match.
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.