I’m new to the program and forum, but thought I’d lend a hand.
I struggled for numerous hours today to get Manager to import my CSV bank statement, but it just wouldn’t work, it kept giving me a “CSV file is missing “Date” column” error, but eventually I figured it out.
I’ll start with the basics:
You can compile your data in Excel if you like but make sure you have the following columns only, Manager won’t read other data:
Date
Payee
Reference
Description
Amount
2: Manager will recognize negative amounts as amounts deducted
3: be sure to remove extra data from the sheet, only keep data that pertains to those 5 columns, if you only have 3 columns worth of data, like amount, date and description its fine to delete the other columns
4: Ensure that the date format in your data is the same as the date format in your programs preferences
5: save your csv in excel as an MSDOS csv
6: then open your CSV in notepad
7: Here’s the important part that made the difference for me, make sure there aren’t any semicolons in your data. notepad has a function whereby you can replace items. replace all the semicolons with comma’s. save the file and import it.
Why are you transferring the file to Notepad? If you have saved the Excel spreadsheet as a CSV file, you should be able to import that directly. If you need to edit, you can edit the spreadsheet before saving. In fact, if your bank exports in CSV format, the only reason for using Excel is to edit unnecessary content your bank may stuff in that Manager won’t recognize.
It is also worth noting that CSV is the least preferred format for imports and causes the most problems. So if you bank offers any of the other formats listed in this Guide, try them.
No. You need to post responses on the forum, not reply to email. Other forum users have no ability to see messages or their attachments you send in response to email versions of forum posts.
See above.
You only joined the forum 3 hours ago, and I posted my response only 2 hours ago. Forum members, including moderators, are scattered around the world and may be many time zones apart.
Also, please do not post personal information in the forum. That violates rules of the forum: FAQ - Manager Forum. I’ve edited your post to remove prohibited material.
When I said I struggled for hours, I obviously, as a courteous forum user, first searched through all the forum entries prior to emailing the admins about it. That’s basic forum etiquette.
Within Excel you can use the “search & replace” feature for converting the semi-colons to commas, then your notepad step is not required. I think you will find it under the “Edit” heading, it may be called “find & replace”.
Proper action depends on exactly what really happened. Usually debits and credits are reflected oppositely in your and the bank’s records. The real question is whether an expenditure reduced or increased your bank balance in Manager. If your bank balance moves in the correct direction, forget how transactions are labeled. If it moves in the wrong direction, you will have to edit the statement file before importing to change signs.