Join Plans Profile Help Contact Us Privacy Close

Questions about should, formatting, account, import, amounts, spre ...

Questions and Answers for free and easy small business accounting.

Items selected where Item is 30
Browse All Questions

Q: I am really looking forward to the BAS-I.C program and have already done the .csv file from BOQ but it is in a different order to that required?

A: BAS-I.C can import bank account csv files in standard format / order of Date, Amount, Account. See bas-i.com.au details. 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). Alternatively send me a copy of your csv file as an email attachment and I can have a look for you.