Manager is exporting with a date format or dd.m.yyyy.
Date Description Contact Bank account Amount Status
10.5.2017. CARD PAYMENT TO PAYPAL *PREMIEREHEA,430.00 GBP ON 08-05-2017 , 430.00 CURRENT 6239 -430.00 Cleared
19.12.2016. CARD PAYMENT TO PAYPAL *CLARITYINFO,60.00 GBP ON 16-12-2016 , 60.00 CLARITYINFO CURRENT 6239 -60.00 Cleared
2.11.2016. DIRECT DEBIT PAYMENT TO PAYPAL PAYMENT REF 482J2226KB64C, MANDATE NO 0005 , 24.58 CURRENT 6239 -24.58 Cleared
2.11.2016. DIRECT DEBIT PAYMENT TO PAYPAL PAYMENT REF 482J2226KB64C, MANDATE NO 0005 , 16.49 CURRENT 6239 -16.49 Cleared
may be a good idea to have the same format as CSV import as the yyyy. is not recognised by any spreadsheet program I have.
This occurs for two reasons:
- Manager offers more date format options than the spreadsheet program.
- Manager exports what you see, which is text. So even if the format was one the spreadsheet recognized, you could still need to format the relevant column of the spreadsheet as dates. Otherwise the spreadsheet might interpret it as text. This will depend the spreadsheet and your preference settings for it.
The solution is to temporarily change your date preference to something your spreadsheet recognizes prior to an export. If the spreadsheet doesn’t recognize the import as dates, reformat the column in the spreadsheet so it will. You can accomplish similar results with global find & replace functions. But in your case, removing decimal points and substituting other characters would corrupt your numbers.
I thought that my default date format was dd/mm/yyyy, but when I just
checked it was dd.m.yyyy. explaining the ‘odd’ export format. Never seen
this used before esp the yyyy. component and assumed an export error.