Forum Discussion

tomfinch's avatar
2 months ago
Solved

Reconcile account linked to credit card

Hi all

 

I'm still a novice when it comes to MYOB, so please be kind! I've had a look online but not had much luck trying to resolve the following query:

 

Most of my business transactions are via a credit card, rather than a bank account. How can I allocate transactions (that have been entered, such as receipts) to my credit card feed?

 

See the screenshot attached. When I attempt to reconcile, most of these transactions aren't identified as a potential match for transactions I know I've entered. 

 

Any help is much appreciated, thank you. 

 

  • Hi tomfinch,

     

    Thanks for reaching out and welcome to the Community Forum! As someone new to the platform, it's completely normal to have questions, and we're here to help.

     

    It's possible the transactions aren't matching because they're recorded on different dates or under different categories. I recommend checking if the transaction dates and categories align with your credit card records.

     

    Here's a link to guide you in matching these transactions.

     

    Regards,

    Sai 

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator

    Hi tomfinch,

     

    Thanks for reaching out and welcome to the Community Forum! As someone new to the platform, it's completely normal to have questions, and we're here to help.

     

    It's possible the transactions aren't matching because they're recorded on different dates or under different categories. I recommend checking if the transaction dates and categories align with your credit card records.

     

    Here's a link to guide you in matching these transactions.

     

    Regards,

    Sai 

  • Hi tomfinch,

    Check which "bank account" you have selected as the pay from account when recording your payments. If you have used a different account than your credit card "bank account" the transactions will not be able to be matched. Hope this helps.

  • Thank you Julia_Berkhout and Isaiah_C for the above responses.

    It turns out, after checking, I was logging my paid bills/receipts/invoices with my bank account and not my credit card account. 

    What is the best way to recategorise all of these payments from my bank account to my credit card? It looks like it's going to be very messy to do this. 

    • Princess_R's avatar
      Princess_R
      MYOB Moderator

      Hi tomfinch,

       

      That does sound like a bit of a mess, especially with a lot of transactions to correct. You've got a couple of ways to sort it out. You can either delete or reverse the transactions and then reenter them with the correct account. Alternatively, you can use the categorise option, which might be particularly helpful in your situation.

       

      Cheers,

      Princess

  • This is unfortunately pretty overwhelming. What's the best way for me to manually go through all my purchases and change the method of payment from bank account to my credit card? I can click through accounting -> general journals -> change source journal to 'purchases' -> then select an entry -> click on a bill -> scroll down to the payment number -> open the payment number -> then change it from 'business bank account to credit card -> then save. 

    Surely there has to be a better way? 


    Also, when creating a bill from a document I've uploaded, how can I choose the credit card account as the method of payment? The screenshot suggests I can't choose a credit card function when entering the amount that's already been paid. 

     

    • Princess_R's avatar
      Princess_R
      MYOB Moderator

      Hi tomfinch,

       

      The only way to fix this is to manually change the account from the transaction itself or use the option I mentioned earlier. When picking a credit card as the payment method for uploaded documents, you'll see a field for the category code. Just click on this field and select the setup category code for the credit card account you want to use for the payment. For more info, check out this link.

       

      If you need more help, you can reach out to our support team on live chat via the virtual assistant MOCA or submit a support ticket via MyAccount.

       

      Cheers,

      Princess

    • Julia_Berkhout's avatar
      Julia_Berkhout
      Super Cover User

      Hi Tomfinch,

      Unfortunately not an easier way and no way to change default bank account for bill payments that I know of.

       

      In future I would recommend creating bill from the purchases area and then linking document, and from their there is a direct link to record supplier payment straight after where you can select the pay from account.

      Or if you don't need to enter transactions as bills, ie don't need it for account tracking or reports purposes, I would save yourself more time and enter all COD transactions as spend money transactions as this allows you to select the pay from "bank account" also and categorise to the expense account all in the one transaction.

      or from uploads area create spend money transaction option.

      Hope all this helps. ;-)