Join Plans Profile Help Contact Us Privacy Close

Questions about formatting, should, backwards, chrome, different, ...

Questions and Answers for free and easy small business accounting.

Items selected where Item is 47
Browse All Questions

Q: I'm having difficulty importing my csv files from Jan-Mar 2015. I'm doing exactly the same thing I did for April-June 2015. It worked perfectly before. I'm using chrome if that helps any. Please tell me I can work backwards?

A: Something must be different? Chrome is good so not sure what the issue is. Have a look at bas-i.com.au for instructions making sure csv files are in standard format / order of Date, Amount, Account. If your csv files have the same structure you should be able to import. If not you can edit your csv file in your spreadsheet. Date should be dd/mm/yyyy and amounts should just be numbers (no $ sign). You can set this with Excel formatting to remove the $ formatting and then when you save the file as a csv file save it as a csv without any formatting (Excel will usually ask). If it work previously and not know maybe your csv file is different? Not sure what you mean by work backwards?