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!

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bank<->invoice allocation report

kriegfrj

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!

Find more posts tagged with

Accepted answers

kriegfrj

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.

All comments

Genreve_S

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

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.