Forum Discussion

Deanne001's avatar
Deanne001
Experienced Cover User
11 months ago

Importing bank statements

Hello,

I'm after instructions on importing bank statements into AR for a period before bank feeds started.

A current link/article would be greatly appreciated.

TIA :)

  • Hi Deanne001,

     

    Thanks for your post.

     

    My apologies for the late response. Here are the steps to import bank statements into AccountRight before bank feeds start:

     

    • Download the bank statement from your internet banking website. Save the bank statement as a QIF file. If you have a choice of date formats, choose dd/mm/yy. For instructions on how to download bank statements from your bank, refer to the help on your online banking website.
    • Nominate a bank account: From within AE/AO, navigate to your client's Client Accounting > Trial Balance (or Workpapers) tab. Click Settings, and from the drop-down menu, choose Account List. Click on the bank account you wish to import the bank statement to and select the bank account checkbox.
    • Import bank transactions: Click Banking, and from the drop-down menu, choose Import bank statement. Select the bank or credit card account to import transactions to. Click the Import button. A file window appears.
    • If the import is successful, the View and match transactions page appears, displaying the status of the import and the imported transactions. Allocate these transactions to the appropriate account.

    For more detailed instructions, you can refer to this article: Importing a Bank Statement into the MYOB Ledger.

     

    Please note that the process might vary slightly depending on your specific version of AccountRight and your bank's procedures. If you encounter any issues, feel free to reply.

     

     

     

    Kind regards,

    Shella

  • Shella_A's avatar
    Shella_A
    MYOB Moderator

    Hi Deanne001,

     

    Thanks for your post.

     

    My apologies for the late response. Here are the steps to import bank statements into AccountRight before bank feeds start:

     

    • Download the bank statement from your internet banking website. Save the bank statement as a QIF file. If you have a choice of date formats, choose dd/mm/yy. For instructions on how to download bank statements from your bank, refer to the help on your online banking website.
    • Nominate a bank account: From within AE/AO, navigate to your client's Client Accounting > Trial Balance (or Workpapers) tab. Click Settings, and from the drop-down menu, choose Account List. Click on the bank account you wish to import the bank statement to and select the bank account checkbox.
    • Import bank transactions: Click Banking, and from the drop-down menu, choose Import bank statement. Select the bank or credit card account to import transactions to. Click the Import button. A file window appears.
    • If the import is successful, the View and match transactions page appears, displaying the status of the import and the imported transactions. Allocate these transactions to the appropriate account.

    For more detailed instructions, you can refer to this article: Importing a Bank Statement into the MYOB Ledger.

     

    Please note that the process might vary slightly depending on your specific version of AccountRight and your bank's procedures. If you encounter any issues, feel free to reply.

     

     

     

    Kind regards,

    Shella

    • Shella_A's avatar
      Shella_A
      MYOB Moderator

      Hi Deanne001,

       

      I hope this message finds you well today. I just wanted to follow up on whether you still require assistance with importing your bank statements, as we’re not able to receive any response. If you encounter any further issues, please feel free to reply. I will be happy to assist you.

       

       

      Kind regards,

      Shella

      • Shella_A's avatar
        Shella_A
        MYOB Moderator

        Hi Deanne001,

         

        I hope this message finds you well today. We have recently asked for updates if you're in need of further assistance importing your bank statements, but we have not received any response. We will be closing this thread now. If you encounter any further issues, please feel free to start a post again, and one of our moderators will attend to it.

         

        Kind regards,

        Shella

  • RacingTragic's avatar
    RacingTragic
    Contributing User

    Hello

    I am needing to go back to 2021 financial year and redo forwards for a client, really need a PDF converter into QIF.

    Any suggestions?

    As a lot of banks only going back 120 days now....

    Thanks

    Jodie

    • Mazzii1's avatar
      Mazzii1
      Contributing User

      Probably a stupid question but have you tried (or your client) tried contacting the bank and asking them for a statement in QIF format? They might charge a fee but it's probably the easiest way.

      Otherwise try a 30-day free trial with Adobe and see if you can convert it that way?

      Goodluck!

      Marisa

      • Genreve_S's avatar
        Genreve_S
        MYOB Moderator

        Hi RacingTragic

         

        I understand you need to upload a PDF file as a bank statement. Currently, MYOB doesn't own or recommend a PDF to QIF file converter. You'll need to look for third-party options online.

         

        You can check out this forum thread for more information.

         

        Feel free to create a new thread if you require any other assistance.

         

        Thanks,
        Genreve