Invoice Reporting (Payables) - Ability to include Planned Date as a separate column
In the new reports you can run a report, by supplier, of invoices that are due and planned to be paid, which is great. There is a differentiation between due and planned in both screen detail and reporting. The schuduled/planning option enables users or managers to plan which invoices they wish to pay either by viewing on Xero or running in a report. However, the reporting option puts the two together by adding in an invoice wiht the same due date, if a planned date has not been entered. This means that invoices not scheduled/planned to be paid are included in the report. It is possible to filter to include a due date if you filter wihtout it, it is still included
As a bookkeeping practice managing sizeable purchase ledgers,this defeats the whole ability given to scheudle paymetns and run a corresponding report to issue to clients to pay their suppliers. Directors dont look in Xero and rely on their accounts teams to produce reports for them. There are 'get-arounds', we've worked with them for over 10 years.
This funtion is SO close, the only thing lacking is the report, run by planned, date, filtered by planned date, to please not include an invoice that happens to have the same due date unless the request to include that filter has been selected
PLEASE can we have this report
Many thanks, a broken record to the reporting team but still asking
Sarah
-
Koki Teshima commented
Personally, I prefer control separatelly Planned date and Due date.
In our company, Due date enter by Sales and Purchasing team or pulled automatically from contact.
Then, Finance team enter Planned date to confirm payment date and genearate Payable invoice report to checking.If planned date is blank, no need to pull the due date automatically instead.
Said report have each column and able to sort indivdually.In case of below, if we specify planned date, pick up only B.
A Due date: 27.Dec Planned date: Blank
B Due date 27.Dec Planned date: 27.Dec -
Claire Taylor commented
Re Aged Payable Report and Ages Payable Summary Reports
Can there be an option under 'Ageing by' for 'Planned Date' and when searching in Business section
I import alot of invoices into Xero and dont use the due date.
When balancing my monthly statements I allocate planned dates they are due