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 …

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 …

If this is intended, then we need to solve for these issues: The value under “Reference” field should not get merged into the “Description” field value. 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…

What are you using bank reference for?

Its for keeping track and reconciliation. Solves these purposes: 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. Whenever there is a discrepancy with a seller …

[image] 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.

[image] 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 us…

I have a similar problem, will you please look into it, [image] CAMT.053 not imported correctly 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 display…

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

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 …

[image] shobhit: Importing bank statements … csv For cvs I recommend construct spreadsheet template file which concatanated the feilds you want in description importing your bank CVS into the template file copy output required to another sheet Save that sheet as a CVS import i…

Import bank statement - "Reference" field no longer recognized

Frankie May 7, 2024, 6:45am 8

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

Topic		Replies	Views
Import Bank Statement Reference Import Failure	15	1309	September 5, 2018
Importing bank statement	5	224	August 22, 2024
Reference” field does not get populated	0	36	January 16, 2026
Description when importing CSV	6	227	September 24, 2024
Importing bank statements .csv template?	54	21582	July 24, 2017

Import bank statement - "Reference" field no longer recognized

Related topics