Forum Discussion

Deanne001's avatar
Deanne001
Experienced Cover User
10 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 :)
  • Shella_A's avatar
    Shella_A
    10 months ago

    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 Staff
10 months ago

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 Staff
    9 months ago

    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 Staff
      9 months ago

      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

      • Mazzii1's avatar
        Mazzii1
        Contributing User
        8 months ago

        Hi Shella_A ,

         

        Sorry to jump in on this post, but I do have some questions regarding importing bank transactions. 

         

        I am running AR Plus AU desktop version 2024.2.0

         

        I had to import a bank statement for the first half July last year. I couldn't finish it at the time I started and thought the transactions I entered and matched at the time would still be there when I came back to it. However, I can see that the transactions have been entered when I search them through the "Find Transactions" tab. But When re-important the statement, I can't find these same transactions to match them with. 

         

        Would I have to delete all those transactions and re-enter them again when I import the statement? Or If i continue on from the date I last entered a transaction, and import the satement without all the transactions being matched in that screen, will I be able to match the transactions when I go to the bank feed/reconcile section?

         

        Thanks in advance.

         

        Marisa

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.