Home› Accounting› Accounting Technical Support
Options

CSV Import Format Incorrect

John2312341324John2312341324 Member Posts: 3

My bank uses words, rather than - or + symbols (in Dutch) to communicate if a transaction is a positive or negative one. How do I use Excel/Google Sheets to change it to the desired format? All imports are seen as additions.

Tagged:
in Accounting Technical Support

Comments

  • Options
    JamieDJamieD Administrator Posts: 1,156 admin

    Hey @John2312341324. I wasn't really able to find anything directly from searching on Google on how to adjust the Excel/Google Sheet to the desired format you are looking for -- however, my suggestion is potentially reaching out to one of the support team members at Google as they should be able to assist you with this particular situation.

  • Options
    MikegMikeg Member Posts: 995 ✭✭✭

    John2312341324,
    There are varying ways in excel to re-format your import file. For instance, using a true/false formula. Example: @if(b1=positive,-b1,0) What the formula is saying is, If cell b1 is the word positive then enter the negative value of b1, if not (false) then enter 0. Play around with it. Plenty of help on the net and samples.
    Mike G, CPA

Sign In or Register to comment.