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 desktop). I would like to export all bank transactions (in a given date range) together with the invoice number the transaction was allocated to (if any) in the reconciliation. A single report would be nice, but failing that two reports (one that lists all bank transaction details, and another that lists the allocation of bank transaction to invoice) would also work. Thus far I have not been able to find anything that does this. What I have found:The Bank activity report gives a list all transactions in bulk, but to see the allocation information requires that you click through to individual transactions. There is no way to see or export the allocations in bulk for all transactions from this window.The Customer transactions report shows invoices and payments together, per-customer, but just gives you a running balance without showing which payments are allocated to which invoices.The Coding report under Banking (online) is empty.I've also noticed that in the desktop app, there is an Import option for Receive payments but no corresponding Export option (according to the Import/Export documentation online, it seems this is a known limitation). This is unfortunate because I believe that an export of the Receive payments is the missing piece of the puzzle.Does anyone have any tips on whether/how this is possible? Thank you!

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.

Forum Discussion

kriegfrj

8 months ago

Solved

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

I would like to export all bank transactions (in a given date range) together with the invoice number the transaction was allocated to (if any) in the reconciliation.

A single report would be nice, but failing that two reports (one that lists all bank transaction details, and another that lists the allocation of bank transaction to invoice) would also work.

Thus far I have not been able to find anything that does this. What I have found:

The Bank activity report gives a list all transactions in bulk, but to see the allocation information requires that you click through to individual transactions. There is no way to see or export the allocations in bulk for all transactions from this window.
The Customer transactions report shows invoices and payments together, per-customer, but just gives you a running balance without showing which payments are allocated to which invoices.
The Coding report under Banking (online) is empty.

I've also noticed that in the desktop app, there is an Import option for Receive payments but no corresponding Export option (according to the Import/Export documentation online, it seems this is a known limitation). This is unfortunate because I believe that an export of the Receive payments is the missing piece of the puzzle.

Does anyone have any tips on whether/how this is possible? Thank you!

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

6 Replies

Mike_James
Ultimate Cover User
8 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.
kriegfrj
8 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.
Princess_R
MYOB Moderator
8 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
8 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
Genreve_S
MYOB Moderator
8 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
8 months ago
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.