Forum Discussion

LMRAccountants's avatar
3 years ago

Deleting bank feed transactions and CSV import.

Myob, I'm setting up a clients MYOB. 

 

First MYOB fail. , MYOB doesn't accept CSV bank statement imports. What a pain to get QIF statements. The bank only allowed a download of CSV and PDF. The client had to have the PDFs converted to QIF.

 

Second MYOB fail. The client export dates overlap the bank feed dates by a few days. MYOB doesn't allow me to delete these duplicaitons. Now I either fudge them OR annoy the client to re export the PDFs (see above) convert to QIF and now import again.

 

All this mucking around had done highlight my previous advice to client, to go with Xero. 

MYOB, please make your software more flexible and user friendly.

 

 

 

  • Hi LMRAccountants 

     

    Thanks for your post. Most banks allow you to download bank statements in the .QIF file format. Refer to the help in their internet banking site to learn how to download or export the bank statements, or check with the bank.

     

    To delete the double transactions you should delete the imported statements (if that is how you imported the bank transactions): Deleting imported bank statements and upload the statement with the correct dates so there is no overlap.

     

    Alternatively we could remove the bankfeed transactions for you. We can only delete Bankfeeds for specified accounts for a date range. We don't delete specific bank transactions from within a bankfeed file, nor delete manually imported QIF files and we cannot make the distinction between Allocated & Unallocated transactions; we can only delete all Bankfeeds in the date range provided.

     

    If you want to go ahead with this, the owner of the file should send me a Private Message with the following information:

    • Your MYOB Serial number. You can find this by clicking on your company name in the top right-hand corner of your MYOB file. 
    • The details for the bank account that has the transactions come through from. (BSB Account Number or Last four Digits of the CC Number along with the Account Holder Name)
    • The date range of these transactions that you are trying to remove. (entire day(s) will be removed, - From Date and To Date)
  • snakebyte's avatar
    snakebyte
    Contributing User

    I know how to convert PDF's and import them into MYOB