Reporting: Aged Payable/Receivable Reports - Add payment dates and details
Adding payment dates and details in the Aged Payable/Receivable report.
Purpose: It is useful to see any outstanding invoices.
-
Todd Styles
commented
Having to manually click through each individual invoice to confirm the paid date as part of an audit can be very time consuming. Having the option to add a paid date column would be very beneficial.
-
Silvia Cojman
commented
Would be really helpful in order to avoid questioning clients that are doing their own bookkeeping and as bookkeepers we need to review only.
-
Marjana Malaj
commented
Would make it much easier to determine whether receivables are recoverable when preparing management accounts
-
Emma Green
commented
Yes would make our assessment of bad debts and credit note provisions required for clients much easier (to know if its been paid or credit noted)
-
Emma Reynolds
commented
Would make it much easier to determine whether receivables are recoverable when preparing year end accounts or as part of an audit
-
Frazer Hanifan
commented
makes reconciliations easier yes pls
-
Lisa Costello
commented
@Derrick you can do that by running the Aged Payables/Receivables report as at one date and using the Filter option to include only Bills/Invoices up to a previous date.
-
Derrick Rendall
commented
This would be a massive help. Even better would be if the aged payables report can be taken off with whatever date you need it (end of last month, for example) but showing only the current outstanding balances from that date (just as you can do in Sage). I haven't found a way of taking this report off Xero, but maybe it's already possible.
-
Lisa Costello
commented
On the Aged Receivables and Aged Payables reports can we add a field showing Paid date if the bill has subsequently been paid following the date of the report.
-
Rebekah Scott
commented
I'm using the "Aged Receivables Detail" and "Aged Payables Detail" reports for helping with accruals and prepayments and it would be extremely handy if you could add "payment date" to the report. Currently this isn't available so I'm having to use the report to identify potential accruals/prepayments and then manually go into each transaction to see when it was paid to then decide if it's an accrual or prepayment.. If the paid date was available in the report, this would save so much time.
-
Amy Hickton
commented
On Aged payable and aged receivables report to add a column that show the date when paid after date as an accountant perspective would help to see if paid after date, help to highlight bad debts.
-
Chris Curlett
commented
This would be a huge help to manage receivables. It could be an option under "more".
-
Ray McLaren
commented
On the aged receivables report can a column be added to show the last payment received. Our 20 year old software showed this which is very helpful when clients are paying off a debt. Feel like we have gone backwards with Xero.
-
Louise MacSweeney
commented
I find it really annoying that Paid invoices appear on an aged payable report WITHOUT the option to show the payment status. It doesn't serve the purpose of showing what's due for payment. I have repurposed the payable invoice report, exported to Excel and run a formula which SUM totals by contact to get around this. It's such a pain. The way this report is in its current status is a list of invoices received. I can see that info elsewhere.
-
Jing Accounts
commented
I appreciate it if you can add the Invoice Due date to the Age Receivable Summary Report.
-
Chris Curlett
commented
Last Payment Date on the Accounts Receivable Report. Have the "Turn on/off" this so the user can see when a Customer last paid. It would be very helpful to see this, especially with recalcitrant Customers.
-
Nicole du Plooy
commented
Hey no to show the last date of receipt/payment was made by the customer
-
Xero Subs
commented
A report that shows the total amount of an invoice and then the amount owing at a certain date.
-
Linzi Kilby
commented
There used to be a report like this that i loved using in sage. There was an option to produce an aged payables/ receivables list that included later payments to make possible bad debts more visible when preparing YE accounts
-
Paula McGourty
commented
So strange that you would take away yet another critical element that helps with looking at accounts (as well as the monthly movements on the TB report, which I cannot understand why you would remove that critical feature). Please bring back the historical age receivables reports, so you can see all history on a client or supplier, and when invoices were paid. Why would you remove all these critical features?