# Import bank statement - "Reference" field no longer recognized

**URL:** <https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406>\
**Category:** Uncategorized\
**Created:** [May 7, 2024, 4:19am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406 "2024-05-07T04:19:24Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![shobhit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shobhit/32/21847_2.png) [@shobhit](https://forum.manager.io/u/shobhit)\
**Post date:** [May 7, 2024, 4:19am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/1 "2024-05-07T04:19:24Z")

</div>

I have been importing bank statement using csv files for a few years now with these 4 simple headers:

- Reference
- Date
- Description
- Amount

This definitely used to work upto version 24.4.17.1441.  
After I updated to version 24.5.6.1516, the “Reference” field does not get populated, instead its value gets prefixed to the “Description” field. I believe this to be a bug introduced in last few releases.

Attached a test business & test csv file to import to that business.

Steps to replicate:

1. Import the business.
2. Go to the “Bank and Cash Accounts” tab and use the “Import bank statement” button at the bottom.
3. Select the available “Bank account” and choose the attached csv file.
4. Click “Next”, then click “Import”, then go to the “Payments” tab.
5. You should see that the “Reference” column is empty and instead the “Description” column has prefixed values (screenshot below)  
 ![Screenshot 2024-05-07 at 9.46.14 AM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/0/c00008e2dbb0938f57e15ffa2f75c03f6b7c218a.png)

Sample csv (unable to upload here as .csv are now allowed, please save this content in a test.csv file):

```auto
Reference,Date,Description,Amount
HDFC-1-1,02/04/2024,DESCRIPTION 1,64625
HDFC-1-2,03/04/2024,DESCRIPTION 2,-7.15
HDFC-1-3,05/04/2024,DESCRIPTION 3,1
HDFC-1-4,05/04/2024,DESCRIPTION 4,10800
HDFC-1-5,06/04/2024,DESCRIPTION 5,32399
HDFC-1-6,08/04/2024,DESCRIPTION 6,5760.76
HDFC-1-7,08/04/2024,DESCRIPTION 7,8100
HDFC-1-8,08/04/2024,DESCRIPTION 8,-6733
HDFC-1-9,08/04/2024,DESCRIPTION 9,-2600
HDFC-1-10,08/04/2024,DESCRIPTION 10,-5800

```

Attachments:  
[Test.manager](https://forum.manager.io/uploads/short-url/suwzU5dAS7pbYU7pynrvz5PYusM.manager) (108 KB)

---

<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:** [May 7, 2024, 5:24am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/2 "2024-05-07T05:24:58Z")

</div>

This is by design.

I think if anything, reference number should import into different field, e.g. bank reference, external reference or something like that.

Some banks have obnoxiously long references while Manager expects references to be short because they are shown at other places. For example in invoices when payments matched to the invoice are being shown.

---

<div class="post-metadata">

**Author:** ![shobhit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shobhit/32/21847_2.png) [@shobhit](https://forum.manager.io/u/shobhit)\
**Post date:** [May 7, 2024, 5:29am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/3 "2024-05-07T05:29:13Z")

</div>

If this is intended, then we need to solve for these issues:

1. The value under “Reference” field should not get merged into the “Description” field value.
2. How to add a value to the “Reference” field? If we cannot upload it, then how to add it in bulk? Doing a bulk update after uploading makes this a 2 step process which hinders productivity.
3. How to import into a different field - “Bank Reference” using the csv upload?

---

<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:** [May 7, 2024, 5:46am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/4 "2024-05-07T05:46:39Z")

</div>

What are you using bank reference for?

---

<div class="post-metadata">

**Author:** ![shobhit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shobhit/32/21847_2.png) [@shobhit](https://forum.manager.io/u/shobhit)\
**Post date:** [May 7, 2024, 6:03am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/5 "2024-05-07T06:03:27Z")

</div>

Its for keeping track and reconciliation. Solves these purposes:

1. Since I upload these csv files on regular intervals, I don’t know which rows have been uploaded before. The bank reference helps in identifying the ones which have already been uploaded.
2. Whenever there is a discrepancy with a seller / customer on a particular payment status, sharing the bank reference number helps solve them.

---

<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:** [May 7, 2024, 6:09am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/6 "2024-05-07T06:09:08Z")

</div>

> [@lubos](#):
>
> I think if anything, reference number should import into different field, e.g. bank reference

Sound sensible. User could then select to show or not show it via form defaults.

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64189_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [May 7, 2024, 6:29am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/7 "2024-05-07T06:29:44Z")

</div>

> [@lubos](#):
>
> What are you using bank reference for?

One of our banks, but also some Fintech’s do not include the description in the statements but only gives date, reference number, debit and credit and amount. Their reference number is gibberish as you describe but the only thing we can use and reference.

I agree with @Patch and @shobhit and like this implemented:

> [@lubos](#):
>
> I think if anything, reference number should import into different field, e.g. bank reference, external reference or something like that.

---

<div class="post-metadata">

**Author:** ![Frankie](https://avatars.discourse-cdn.com/v4/letter/f/258eb7/32.png) [@Frankie](https://forum.manager.io/u/Frankie)\
**Post date:** [May 7, 2024, 6:45am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/8 "2024-05-07T06:45:49Z")

</div>

I have a similar problem, will you please look into it,

> [@CAMT.053 not imported correctly](https://forum.manager.io/t/camt-053-not-imported-correctly/53319):
>
> Hello @Lubos, my bank (Regiobank) will soon stop using MT.940 and switch to CAMT.053. I can import this file into Manager, but the account number of my customer is not displayed. You understand that it’s difficult to create bank rules like this. Can I email you a test file?

 ![xml](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/9/09aa37f7e5530864299041284ab24ad2e4825647.png)

---

<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:** [May 7, 2024, 6:46am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/9 "2024-05-07T06:46:40Z")

</div>

In time maybe “Fee”, and “Quantity” could be treated similarly, or at least the interface structure could be designed to support later enhancements.

---

<div class="post-metadata">

**Author:** ![shobhit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shobhit/32/21847_2.png) [@shobhit](https://forum.manager.io/u/shobhit)\
**Post date:** [May 20, 2024, 5:30am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/10 "2024-05-20T05:30:25Z")

</div>

Need some clarity on the original issue raised here. Importing bank statements is getting cumbersome now that reference column of the csv is not honored and there is no work around for it. Simplicity and ease-of-use are the most important differentiators of manager, but this change definitely makes things complex and difficult. Please suggest a workaround or revert the changes.

---

<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:** [May 20, 2024, 5:50am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/11 "2024-05-20T05:50:43Z")

</div>

> [@shobhit](#):
>
> Importing bank statements … csv

For cvs I recommend

1. construct spreadsheet template file which concatanated the feilds you want in description

2. importing your bank CVS into the template file

3. copy output required to another sheet

4. Save that sheet as a CVS

5. import into Manager your edited cvs

---

<div class="post-metadata">

**Author:** ![shobhit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shobhit/32/21847_2.png) [@shobhit](https://forum.manager.io/u/shobhit)\
**Post date:** [May 20, 2024, 6:31am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/12 "2024-05-20T06:31:49Z")

</div>

I am already doing this. The problem is that the manager is no longer honoring the “Reference” column of the csv file.

---

<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:** [May 20, 2024, 9:00am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/13 "2024-05-20T09:00:00Z")

</div>

> [@Patch](#):
>
> template file which concatenates the fields you want in description

> [@shobhit](#):
>
> I am already doing this.

Almost but not there yet.  
Add the external reference to the description field.

Note Manager can NOT put it in the internal reference field as that must now be unique within your Manager businesses

---

<div class="post-metadata">

**Author:** ![shobhit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shobhit/32/21847_2.png) [@shobhit](https://forum.manager.io/u/shobhit)\
**Post date:** [May 20, 2024, 9:18am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/14 "2024-05-20T09:18:38Z")

</div>

It seems that the decision to not allow import of the internal reference field is final.  
In that case, can we have another external reference / bank reference field to solve this please?

Overloading the description field is not the correct solution, it creates other problems.

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64189_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [May 20, 2024, 9:20am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/15 "2024-05-20T09:20:15Z")

</div>

> [@shobhit](#):
>
> In that case, can we have another external reference / bank reference field to solve this please?

This is what in an earlier post @Lubos wrote about it.

> [@lubos](#):
>
> I think if anything, reference number should import into different field, e.g. bank reference, external reference or something like that.

---

<div class="post-metadata">

**Author:** ![shobhit](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shobhit/32/21847_2.png) [@shobhit](https://forum.manager.io/u/shobhit)\
**Post date:** [May 20, 2024, 9:52am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/16 "2024-05-20T09:52:19Z")

</div>

Great. If adding the external reference field is decided, then will wait for it to go live.

Had restarted the discussion because the comment from lubos did not seem like a final decision on first read.

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64189_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [May 20, 2024, 10:03am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/17 "2024-05-20T10:03:21Z")

</div>

> [@shobhit](#):
>
> did not seem like a final decision on first read.

It is not, the topic is not even in ideas yet and do not think it will get any priority, so better to use the workaround than nothing.

---

<div class="post-metadata">

**Author:** ![Asghar\_Ramzan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/asghar_ramzan/32/44648_2.png) [@Asghar\_Ramzan](https://forum.manager.io/u/Asghar_Ramzan)\
**Post date:** [December 11, 2024, 6:38pm UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/18 "2024-12-11T18:38:15Z")

</div>

I am using Reference column for our cheque no. and invoice no when receiving payments, Reference no column was very important for us,

---

<div class="post-metadata">

**Author:** ![eko](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/eko/32/64189_2.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [December 12, 2024, 6:18am UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/19 "2024-12-12T06:18:59Z")

</div>

> [@Asghar\_Ramzan](#):
>
> I am using Reference column for our cheque no. and invoice no

The reference column is still there for manual entry including batch actions. This is about the import of bank statements where the reference number is an external reference the banks make up and as explained in second post in this topic:

> [@lubos](#):
>
> Some banks have obnoxiously long references while Manager expects references to be short because they are shown at other places. For example in invoices when payments matched to the invoice are being shown.

---

<div class="post-metadata">

**Author:** ![jfaleiro](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@jfaleiro](https://forum.manager.io/u/jfaleiro)\
**Post date:** [September 1, 2026, 8:45pm UTC](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406/20 "2026-09-01T20:45:49Z")

</div>

Bringing this back up, +1 here on any column to hold a reference, apart from description (which is shown in many reports) - any decision on implementing this?

[Next page](https://forum.manager.io/t/import-bank-statement-reference-field-no-longer-recognized/53406.md?page=2)
