First Bank Feed (From File – CSV) – Best Practices & Common Pitfalls

Hi,

I am implementing my first Bank Feed using the “From File” (CSV) option for a corporate credit card.

The objective is to:

• Generate Expense Receipts

• Ensure proper bank reconciliation

• Maintain clean matching between the corporate card and the cash account

Since this is my first implementation, I would appreciate guidance on best practices and common pitfalls.

1️⃣ Transactions to Include in the File (For Expense Receipts + Reconciliation)

I need to code my parser

To ensure proper reconciliation, should the CSV file include:

• Only purchase transactions?

• Or both purchases and payments?

• What about interest charges, fees, or adjustments?

Example of the file structure I am working with:

If the goal is:

• Automatic Expense Receipt creation

• Proper Cash Account reconciliation

Is it considered best practice to:

• Include all transactions (purchases, payments, fees) for reconciliation accuracy?

• Or split logic between expense-related transactions and payment-related transactions?

2️⃣ Account Name Mapping (Cash Account vs Corporate Card vs File)

From my understanding, the Bank Account Name in the file must match exactly the Account Name configured in Acumatica. 

Additionally, if we check “Create Expense Receipt”, does this mean the following must be identical?

• CASH ACCOUNT → Account Name

• CORPORATE CARD → Account Name

• FILE → Bank Account Name column

In other words:

If the Corporate Card account in Acumatica is named:

VISA – CORPORATE 000208

Should:

• The Cash Account name

• The Corporate Card Account name

• The Bank Account Name in the CSV

All match exactly?

Or is there a best practice mapping structure recommended instead of relying on exact naming?

3️⃣ First-Time Setup – Validation Process

Is this the correct approach?

1. Load the file using Load Transactions in Test Mode

2. Check how Acumatica reads the Bank Account Name

3. Adjust Cash Account / Corporate Card naming if necessary

4. Reload using Load File Manually

Did I understand the correct process?

4️⃣ Common Pitfalls

For those who have already implemented a CSV-based corporate card bank feed:

• What are the most common configuration mistakes?

• Anything specific to enabling Create Expense Receipt?

• Any reconciliation issues to watch for?

Thank you in advance for your help — I want to structure this properly from the beginning.

ref