HSBC Bank feed withdrawals showing up as deposits

pippaq
1 Post
User

1Posts

0Kudos

0Solutions

HSBC Bank feed withdrawals showing up as deposits

Recently HSBC finally started offering a qif, csv and txt format for statement downloads.  Only problem is that after uploading a qif into myob all the withdrawls show up as deposits. I've tried various conversion tools (Mac only) and still MYOB doesn't like the conversions.  We've spent countless hours on the phone to MYOB multiple who told me at first I was doing it wrongly - had the wrong file, wasn't downloading it properly etc etc.  But then conceded there was an issue.  Anyone having the same problems?

4 REPLIES 4
MYOB Moderator Steven_M
32,927 Posts
MYOB Moderator
New Zealand
MYOB Moderator

32,927Posts

4,404Kudos

4,780Solutions

Re: HSBC Bank feed withdrawals showing up as deposits

Hi @pippaq 

 

I would be looking at the import file that you are using to import those transactions. Generally, with QIF files the format will be:

!Type: Bank
D<<Date of transaction>>

T<<Amount of transaction>>

P<<Payee of transaction>>
^

D<<Date of transaction>>

T<<Amount of transaction>>

P<<Payee of transaction>>
^

 

Note:<< xx of transaction>> is populated data from the transaction

 

With a withdrawal transaction, the T value will have a negative in front of it i.e. -250.00 would be a withdrawal of that bank account for $250. If you don't have negative value it will be treated as a deposit thus the value will show as a deposit once imported.

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Rockydickyhorro
2 Posts
User

2Posts

0Kudos

0Solutions

Re: HSBC Bank feed withdrawals showing up as deposits

New to myob.  Having the same problem with my hsbc feed.  How do I fix?   How do I read a wig file and save it again as a qif?

Rockydickyhorro
2 Posts
User

2Posts

0Kudos

0Solutions

Re: HSBC Bank feed withdrawals showing up as deposits

New to myob. Having the same problem with my hsbc feed. How do I fix? How do I read a wig file and save it again as a qif?

Highlighted
MYOB Moderator Steven_M
32,927 Posts
MYOB Moderator
New Zealand
MYOB Moderator

32,927Posts

4,404Kudos

4,780Solutions

Re: HSBC Bank feed withdrawals showing up as deposits

Hi @Rockydickyhorro 

 

MYOB Essentials allows for the user to import bank statements (transactions) with a QIF file. Typically, you can save a QIF file from your Bank -refer to your Bank for your documentation for that.

 

If that is not possible, you could look into seeing if there are any third party converters online that allow for a file that you can download into a QIF file. Alternatively, manipulate the current file into a QIF file, using the above post on this thread as a general guide.

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post