Forum Discussion

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
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.

Genreve_S

MYOB Moderator

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

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
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
  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.
  - Mike_James
    Ultimate Cover User
    2 months ago
    Hi kriegfrj , sometimes the core program just doesn't have the exact report you need. I've added a script to our custom report writer to produce the attached file of customer payments. If you want this report, visit our website (datawise.co.nz), program details and our contact emails are on the home page.