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