Forum Discussion

marple's avatar
marple
Contributing User
6 months ago
Solved

Matching Contra Transactions with Bank Feed

We have a Supplier who is also a Customer so have created a Contra Account to process their Bills/Payments.

I'm having a problem with matching the transfers between the Contra account and our normal Bank account with the Bank feed amount due of 206.86.

 

I Created Invoices and Bills. 2x Invoices and4x Bills.

Invoices total: 192.05

Bills total:        398.91

Payment Due 206.86

 

I have Taken Payments for Invoices by using "Create Invoice Payment" and used Contra as bank acount.

Then used Banking -  "Transfer Money" to transfer amount from the Contra to the Bank Account.

 

I Paid Bills by using "Create Supplier Payment" and using Contra as the bank account.

Then used Banking - "Transfer Money" to transfer amount from the Bank Account to the Contra.

 

I processed each of the Bills and Invoice payments and transfers individually to and from the Contra (6 transactions).

The Contra account balance is now 0.00.

 

Now when I try to Match the transactions to the Bank feed amount due of 206.86 I'm not sure how to do it.

 

Thank you for your help.

  • Genreve_S's avatar
    Genreve_S
    6 months ago

    Hi marple,

     

    Thanks for posting your concern in the forum. 

     

    I'm sorry to hear about your difficulties matching your bank feeds. In my understanding, it's better to process both payments for invoices and bills into the Contra account and create a Transfer Money transaction from the Contra account to the Bank Account with the amount of 206.86. But I recommend speaking to an accountant or financial advisor to make sure you record this properly. 

     

    Let us know if you require any other assistance. 

     

    Thanks,
    Genreve

     

3 Replies

Sort By
  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    6 months ago

    Hi marple,

     

    Thanks for posting your concern in the forum. 

     

    I'm sorry to hear about your difficulties matching your bank feeds. In my understanding, it's better to process both payments for invoices and bills into the Contra account and create a Transfer Money transaction from the Contra account to the Bank Account with the amount of 206.86. But I recommend speaking to an accountant or financial advisor to make sure you record this properly. 

     

    Let us know if you require any other assistance. 

     

    Thanks,
    Genreve

     

    • marple's avatar
      marple
      Contributing User
      6 months ago

      Thanks so much for your help Genreve.

       

      You clarified where I had gone wrong.

       

      Instead of creating Transfer Money for each bill/invoice I cancelled them and created one Transfer Money just for the Balance on the Statement (which matched the balance of the Contra Account).

      The only difference for this case was I needed to Transfer From the Bank Account To the Contra not the other way around as you had suggested.

       

      It worked perfectly.

      • Genreve_S's avatar
        Genreve_S
        MYOB Moderator
        6 months ago

        Hi marple, 

         

        Thanks for the update. 

         

        I'm glad you managed to fix your accounting issue. 

         

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

         

        Thanks,
        Genreve