I’m having a problem importing a statement this is the error I’m getting but the file has the headings as far as I can see. I’ve deleted them and typed them again but no luck I’m afraid. I’ve attached the file I’m importing too.

Vote Up
0
Vote Down

I’m having a problem importing a statement this is the error I’m getting but the file has the headings as far as I can see. I’ve deleted them and typed them again but no luck I’m afraid. I’ve attached the file I’m importing too.

1 answer

Vote Up
0
Vote Down
Peter Connor ⋅ Staff October 9, 2015
Public

When you import the xls files sometimes they capture data you can’t see. So, try and delete all the column

#answer-1921
  1. Emma W October 9, 2015
    I tried that and copying just the few lines that I have into another excel file and saved it as CSV still no luck
  2. Peter Connor October 9, 2015
    Cool, send it over to me here and I'll have a lookski for you. God damn Excel rage
  3. Emma W October 9, 2015
    God dame BOI's crap business website !!!
  4. Peter Connor October 9, 2015
    Ha, GOD DAMN THE BLOODY LOT. I blame the water charges. Give me 5 to have a lookski.
  5. Peter Connor October 9, 2015
    Hi Emma,
    Ok so you weren't putting the data into the different columns. If yo download the example file (you'll see it in that screenshot) you'll see what I mean.
    Here a video of me fixing it all for you.
    I've also attached a working example of that file.
    Hope that helps.
    Pete
  6. Emma W October 9, 2015
    That's weird because when I look at the sample everything is in the one column which I thought was strange and the file I sent you on my screen everything is in separate columns. Could we share screen?
  7. Emma W October 9, 2015
    Actually just did a bit of goggling I think this might be a windows 10 issue I'm going to go back to 8.1 and see if that fixes it.
  8. Peter Connor October 9, 2015
    Coolio
  9. Emma W October 9, 2015
    Hi Peter, going back to 8.1 solved the problem
  10. Peter Connor October 9, 2015
    God daMN YOU BILL :)
  11. Emma W October 9, 2015
    Yeah I kinda like it too
  12. Peter Connor October 9, 2015
    You using excel windows 8/10
  13. Emma W October 9, 2015
    Excel 2013 with window 8.1 it doesn't work properly with windows 10
  14. Peter Connor October 9, 2015
    Ah. They'll get it working soon it's pretty new.
  15. Emma W October 9, 2015
    I'm sure they will now to do some reconciling
  16. Emma W October 9, 2015
    Just one more cheek thing an "approve and next" button on the top of the screen would be handy
  17. Peter Connor October 9, 2015
    Yep, we'll be redesigning the the bank rec to make it easier - to many screens at the moment.
  18. Emma W October 9, 2015
    great thanks

Please login or Register to Submit Answer