Scenario
User wants to CSV import a customer payment and set the Account as internal ID but it didn't work. After importing, user noticed that "Undeposited Funds" is still the one selected on the transaction instead of the Account set on the import file. User wants to set the Account from the CSV file and the status should be "Deposited".
Solution
In order to fill up the Account, you need to add an additional column for Undeposited Funds and set it to F on the excel file. As per SAID 9965 - "If you import customer payment records with a value of False for the Undep. Funds field, you must supply an account for each of these records."
Here's a screenshot of the sample CSV file:
Here's the result of the imported transaction:
As you can see, the Account has been set and the status is now Deposited.
-----
If you find this information useful, let us know by reacting or commenting on this post!