Uploading bank statement

1

Good day,

I am having challenge with uploading bank statement, there is a message that says the csv is missing the ‘‘Date’’ column. I have changed the preferences but the message remains. Is there anything I am missing, it used to work perfect previously.

2

First, if your bank offers any other statement format besides CSV, try that. As this Guide says, CSV is the most problematic: Manager Cloud.

Second, you say you changed preferences, but were not specific. Did you change your date preference to exactly match the format in the bank statement? Manager assumes the imported statement is matching your preference. So it cannot interpret anything else. This means exact similarity of separator characters, number of digits, and order of days, months, and years.

Third, when you say it used to work, when was this? Did you update your software since the last time you used it?

3

Thanks for your reply,

First my bank statement comes in PDF, i convert to excel then csv.

Secondly, I changed the preferences as per the guides, all format in terms of date and all.

Thirdly, the last time was in two weeks, yes I did update my software.

4

The problem may be with the format of the date cells in the Excel spreadsheet. I’m not sure exactly what Manager expects. But it might be looking for text strings that it converts to dates itself. The dates from Excel could be in Excels serial date format (that’s how Excel stores dates, starting at day 1 sometime in the past.) Excel converts those to the formats you see on your display, but may be exporting something different.

So experiment with different formats for the date cells.

5

Morning,

i got it right, thanks

6

What was the solution?