# Fields recognised in Bank CSV import

**URL:** <https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909>\
**Category:** Uncategorized\
**Created:** [November 20, 2023, 3:17am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909 "2023-11-20T03:17:29Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [November 20, 2023, 3:17am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/1 "2023-11-20T03:17:29Z")

</div>

Does anyone have a list of the fields recognised by bank import?

Looking at old forum posts the best I could find was

From Sep 2018

> [@Import Bank Statement Reference Import Failure](https://forum.manager.io/t/import-bank-statement-reference-import-failure/17747/2):
>
> Therefore CSV import understands following columns only:
> 
> - `Date`
> - `Payee`
> - `Description`
> - `Amount`

From October 2021

> [@Import bank statements as .csv file not working](https://forum.manager.io/t/import-bank-statements-as-csv-file-not-working/49457/3):
>
> CSV can have many different columns. Manager does support a lot of variations of CSV file

From October 2022

> [@Error on Bank import](https://forum.manager.io/t/error-on-bank-import/43731/1):
>
> ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/c/2c62dc115721e7ceb9ce8362844519eb430931b5.png)
> 
> … I get this error

> [@Error on Bank import](https://forum.manager.io/t/error-on-bank-import/43731/6):
>
> My new approach to CSV import is to support as many bank variations as possible rather than asking users to edit CSV files before import

So it appears cvs recognises

- `Date` or `Transaction Date`
- `Description` or `Extended Text`
- `Amount` or `Credit` or `Credit Amount` or `Net`

I’m particularly looking for `Quantity` and / or `Unit price` to stream line importing investment transactions

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64196_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [November 20, 2023, 3:37am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/2 "2023-11-20T03:37:36Z")

</div>

> [@Patch](#):
>
> I’m particularly looking for `Quantity` and / or `Unit price`

The import is related to bank statements that usually do not have line item details such as these.

---

<div class="post-metadata">

**Author:** ![Mark](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mark](https://forum.manager.io/u/Mark)\
**Post date:** [November 20, 2023, 9:27am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/3 "2023-11-20T09:27:33Z")

</div>

I use: Date, Description, Reference, Amount

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [November 20, 2023, 11:26am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/4 "2023-11-20T11:26:51Z")

</div>

The work around is

- put the quantity and unit price in the description
- Perform a bank import into Manager
- instead of using bank rules, manually copy the quantity and unit price and each transaction (to total providing a built in check)

Importing the quantity would enable bank rules to be used but not a disaster without.

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64196_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [November 20, 2023, 12:19pm UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/5 "2023-11-20T12:19:07Z")

</div>

The bank statement importation is not a real issue but you need to realize that the debits and credits are summary amounts of what could contain one to many line items. The bank statement itself does not tell us any of these details and at best gives some understandable reference number that you can match with a manually created payment or receipt with details of one or more line items such as QTY.

We use separate POS systems and only import the bank statements into Manager and assign them to summary income and expense accounts. As we deposit the cash in bank we also have those summaries but not details available. Auditors have access during audits to both systems and get guidance/answers where needed for both so they match. I am not sure what others do but I do not think there is an easy or quick fix as illustrated by @Patch’s work around, where before importing you need to put the required line items in the description (banks do not allow long description fields) and then per receipt and payment manually split them with the required line items.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [November 22, 2023, 6:25am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/6 "2023-11-22T06:25:00Z")

</div>

> [@Patch](#):
>
> I’m particularly looking for `Quantity` and / or `Unit price` to stream line importing investment transactions

If you send me sample CSV file to `lubos@manager.io`, I will incorporate that.

---

<div class="post-metadata">

**Author:** ![Wornout](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/wornout/32/19913_2.png) [@Wornout](https://forum.manager.io/u/Wornout)\
**Post date:** [November 22, 2023, 10:23pm UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/7 "2023-11-22T22:23:03Z")

</div>

I would be happy if it could recognize debit and credit column headings amounts instead of me manually putting a - sign in front and then putting them all in the one amount column,

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [November 22, 2023, 10:26pm UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/8 "2023-11-22T22:26:14Z")

</div>

@Wornout send me sample CSV file to `lubos@manager.io`

---

<div class="post-metadata">

**Author:** ![gsavaliya92](https://avatars.discourse-cdn.com/v4/letter/g/6f9a4e/32.png) [@gsavaliya92](https://forum.manager.io/u/gsavaliya92)\
**Post date:** [August 11, 2024, 5:09am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/9 "2024-08-11T05:09:31Z")

</div>

@lubos - is above specified column still same while importing statement? Or we have any update in last 9 month?

How we are managing assigning Account for Expanse/Income or Bank transfer?

Currently, all are falling under Suspense account, let me know if there are any tricks for this.

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [August 11, 2024, 7:23am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/10 "2024-08-11T07:23:37Z")

</div>

> [@gsavaliya92](#):
>
> Currently, all are falling under Suspense account

After a bank import it is normal for all imported transactions to be in suspense. This is because more information is required such as which account in Manager.

Bank rules can help with that task.

---

<div class="post-metadata">

**Author:** ![manager-jman](https://avatars.discourse-cdn.com/v4/letter/m/c0e974/32.png) [@manager-jman](https://forum.manager.io/u/manager-jman)\
**Post date:** [October 29, 2025, 5:50pm UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/11 "2025-10-29T17:50:20Z")

</div>

Jumping in a little late here but but this is exactly where I am experiencing an issue, specifically the bank rules don’t run when importing the statements. To be fair, I am running tests using a .csv file. That said, the import runs fine, but the rule/s are not applied. Also, is there a way to apply rules against the Suspense coded transactions after they are import (similar to an email client filter)?

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [November 24, 2025, 2:10am UTC](https://forum.manager.io/t/fields-recognised-in-bank-csv-import/49909/12 "2025-11-24T02:10:43Z")

</div>

It’s a two step process

1. Bank import
2. Use bank rules to process regular transactions, and manually edit rare transactions to classify them as appropriate
