Hey there, I am trying to reconcile my bank account using the csv template you provided. And I formatted according to your instruvtions, but its still saying things like EUR 70.00 is not a monetary amount / Money Out is missing. But I can;t seem to work out what I am doing wrong. Shall I upload the csv file to you?

Hey there, I am trying to reconcile my bank account using the csv template you provided. And I formatted according to your instruvtions, but its still saying things like EUR 70.00 is not a monetary amount / Money Out is missing. But I can;t seem to work out what I am doing wrong. Shall I upload the csv file to you?

1 answer

Peter Connor Staff August 14, 2016
Public

Sure, load it up.

#answer-3790
  1. Peter Connor August 14, 2016
    What bank account is it from?
  2. trishutchinson22 August 14, 2016
    It says EUR there, but I play around with the different € values and none of them seem to work. Thanks!
  3. Peter Connor August 14, 2016
    That's the file PTSB.csv?
  4. Peter Connor August 14, 2016
    I take it is Permanent TSB
  5. trishutchinson22 August 14, 2016
    Yep!
  6. Peter Connor August 14, 2016
    Cool, have it working. I'll show you what I did. 2 Sec's.
  7. Peter Connor August 14, 2016
    Hey,
    I've attached your corrected file and made a video of how you can do it in the future. http://recordit.co/jii2x0Lxkj
    Bank Rec's are a pain the ass with Irish Banks. The EU brought in a rule about a year ago so you should see a change soon.
    In the US we can just suck in the data automatically, so the minute an invoice is paid we can mark is a paid.
    The banking systems are worse there than the Irish systems, there's just more demand and therefore money in compans fixing the problem.
    Hope that helps.
    Pete
    Pete

Please login or Register to Submit Answer