Forum Discussion

kriegfrj's avatar
kriegfrj
2 months ago

Bank<->invoice allocation report

Dear team,   I pray that you are well.   I have a question - I apologise if it's already been answered somewhere, but I haven't managed to find the answer.   We are using Account Right (mostly ...
  • kriegfrj's avatar
    kriegfrj
    2 months ago

    Dear Princess,

     

    Thank you for taking the time to respond.

     

    So the short answer is: there is no report that contains payment allocations. You can get a report of payments from a customer, and you can get a report of invoices raised against a customer, but you cannot get a report that shows the linkage between the two.

     

    Customer Transaction Report by logging into your AccountRight file online.

     

    As I noted above, this report lists the payments and invoices for each customer, but does not show which payments were applied to which invoices.

     

    Another option is to export some reports to Excel and use formulas to create a custom report that links transactions by common identifiers like dates and amounts.

     

    Thank you for this suggestion, but this would not be very helpful. I want to be able to see how my bookkeeper actually allocated the payments to invoices within MYOB. The above suggestion amounts to trying to re-create the allocation of payments to invoices externally from scratch in Excel - there is no guarantee that this re-creation will be identical to what is actually recorded in my MYOB file. This is especially the case in our business as we have lots of recurrent transactions with clients and amounts that only differ by date, and customers do not always pay them regularly nor in order.

    I will make a suggestion in the ideas section.

kriegfrj's avatar
kriegfrj

I just discovered the Transaction Journal export, where you can export Receipts.

This is part of the way there. It looks like the Allocation Memo field in the CR entry for the payment in many cases contains a ;-separated list of invoices numbers. However, it appears that this is not consistent. I suspect that this field is being populated manually by the bookkeeper doing the reconciliation.

Genreve_S's avatar
Genreve_S
MYOB Moderator
2 months ago

Hi kriegfrj, 

 

From what I understand, there isn't a single report that meets the criteria that you mentioned. The closest option would be to use the Account Transactions report and include both the bank account and the trade debtors account. However, this won't show the details of individual sales transactions.

 

Hopefully, other users in the forum might have some workarounds. Feel free to post again if you need any other help.

 

Thanks,
Genreve

  • kriegfrj's avatar
    kriegfrj
    2 months ago

    Thank you Genreve, I appreciate you making the effort to help.

    I don't necessarily need a single report - if it's two reports, that's ok, I just need some kind of identifier to be able to link the lines on one report to the corresponding lines on the other. Eg, if the receive payment report included the invoice number(s) to which it was allocated, or if the sales report included the receipt number(s) for the payments that were allocated to it.

    I looked at the Account Transactions report as you suggested, and yes it contains all of the allocations and the bank deposits, but again it doesn't contain anything to link one to the other.

    Blessings,

    Fr Jeremy Krieg

    • Princess_R's avatar
      Princess_R
      MYOB Moderator
      2 months ago

      Hi kriegfrj,

       

      While there's no specific report that gives you exactly what you're after, you can check out the Customer Transaction Report by logging into your AccountRight file online. Another option is to export some reports to Excel and use formulas to create a custom report that links transactions by common identifiers like dates and amounts. If these options don't quite meet your needs, you're welcome to share your suggestion on our Ideas board to help us improve our Banking reports.

       

      Cheers,

      Princess

      • kriegfrj's avatar
        kriegfrj
        2 months ago

        Dear Princess,

         

        Thank you for taking the time to respond.

         

        So the short answer is: there is no report that contains payment allocations. You can get a report of payments from a customer, and you can get a report of invoices raised against a customer, but you cannot get a report that shows the linkage between the two.

         

        Customer Transaction Report by logging into your AccountRight file online.

         

        As I noted above, this report lists the payments and invoices for each customer, but does not show which payments were applied to which invoices.

         

        Another option is to export some reports to Excel and use formulas to create a custom report that links transactions by common identifiers like dates and amounts.

         

        Thank you for this suggestion, but this would not be very helpful. I want to be able to see how my bookkeeper actually allocated the payments to invoices within MYOB. The above suggestion amounts to trying to re-create the allocation of payments to invoices externally from scratch in Excel - there is no guarantee that this re-creation will be identical to what is actually recorded in my MYOB file. This is especially the case in our business as we have lots of recurrent transactions with clients and amounts that only differ by date, and customers do not always pay them regularly nor in order.

        I will make a suggestion in the ideas section.

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.