Forum Discussion

Avisha23's avatar
Avisha23
Member
1 day ago

Trouble with categorizing Bank Transactions

I am hoping someone can help me with a few issues i am experiencing in MYOB

 

I am relatively new to importing bank transactions using QIF file. Previously i would process everything through the receive payments and pay bills functions, so this workflow is new to me.

 

When i make one payment to a supplier paying for multiple bills, the payment appears on my bank statement as a single lump sum payment amount, however when i go to categorize the debits in MYOB, it shows as each bill separate amount instead of the total payment amount that appears on my bank statement.

 

This makes it difficult to match the transaction to the bank statement.

 

Is there a way to have MYOB display the supplier payment as one lump sum amount rather than listing the individual amounts? or is there another way to make the matching process easier?

 

I also have a few additional questions:

The chq numbers aren't appearing in the bank register instead shows payment, and doesn't even show supplier name.

For customer receipts the receipt numbers don't appear and customer names also don't appear

I am not sure if this is standard MYOB Behaviors or if i have overlooked some settings

is there any way around this?

 

Some guidance would be highly appreciated 

 

1 Reply

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    1 day ago

    Hi Avisha23

     

    Thanks for explaining the pain point of your setup. This is usually due to how the payment was recorded.

     

    If the bills were paid through Pay Bills, MYOB records each bill payment separately, so it won’t normally show as one lump sum for matching.

     

    If you want one bank transaction to match one MYOB transaction, the easiest option is usually to use Electronic Payments and then Prepare Electronic Payments. That groups the payments into one total, which is much easier to match to the amount on your bank statement.

     

    For the cheque and receipt numbers, it can also be normal for the Bank Register to show a general label like “Payment” instead of the supplier or customer name, depending on how the transaction was entered.

     

    You can also check these help articles:

    Paying bills

    Matching a bank feed to multiple transactions

     

     

    Regards,
    Genreve