How to Import Credit Card Statement

Creation date: 7/30/2025 1:17 AM Updated: 1/27/2026 3:01 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.

Important: This process assumes staff are required to import their credit card statements, review charges, attach receipts, and submit the statements for approval.

Upon final review, Accounts Payable transfers each cardholder document into MIP as an AP invoice, using the Microix Document Number appended with the statement period (e.g., AP-1001-AMX-2026-01) as the invoice number.

When selecting invoices for payment, filter for documents ending in the applicable statement period (e.g., 2026-01) to ensure they align with the correct statement period and total payment amount.

If processing this group of invoices would cause delays in payments to the vendor, it is recommended to use a Contra Cash account. The vendor may be paid upon receipt of the statement by debiting Contra Cash and crediting Accounts Payable.

Later, once individual cardholder statements are received and verified, each transaction is transferred into MIP as a Cash Disbursement, debiting the appropriate expense accounts and crediting the Contra Cash account.

The Contra Cash account can later be reconciled to the cash account using MIP’s Bank Reconciliation module.

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
Administrator	The person who is responsible for importing the CSV file. (most cases it's the card holder and in some cases, it may be an administrative assistant or AP person)
Bank Common Name	Enter the name of the credit card provider (e.g., Bank of America).
Card No (ONLY last 5)	Default to `00000` (used for record-keeping only) If you must enter, ONLY ENTER LAST 5 numbers
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.) If it does not match, no data will be imported*
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.