Invoices/Bills - Separate field for posting date and invoice date
Ability to have separate fields for posting date and invoice date.
Purpose: To make users can ensure the expense is recorded in the appropriate month (posting date), and the due date is properly calculated (invoice date).
Hi community, we appreciate this idea has collected a fair amount of interest which has all been shared with and reviewed by the product team.
While this isn't currently being worked on there are other ideas this team are working on right now, including a bulk void feature and highlighting rows when selected. Although these features are still under development process and we don't have confirmed release dates yet.
With regards to having a separate field for the posting date and invoice date, our team is interested in better understanding this idea as it may be something they look to develop down the track. They really appreciate and encourage you to continue to share your experiences, pain points and insights. This will help them understand how this feature can benefit you and other customers, as well as gauge demand for it.
As always, if there's any change we will let you know via this idea.
-
Sumit Khapli commented
From my point of view, we need a placeholder for date so that we can add-subtract and provide a range in the invoice for the servicing period.
Example : Weekly invoices need a placeholder in the description saying for which week this is being invoiced for. Giving a week number is fruitless as no one in the payment team will understand this. They need a range like 04 Nov 2024 to 08 Nov 2024 or 04/11/2024 - 8/11/2024 or 4-8 Nov 2024 -
John Fallon commented
Critical feature - I will be moving 40+ Xero subscriptions to another accounting system if Xero doesn't improve on basic features like this. Xero - listen to your customers. Adapt of be left behind.
-
Ingrid Crozier commented
This is a requirement when it comes to accrual-basis accounting and prevents the ability to do any sort of month-end or quarter-end close process, as using the invoice date would backdate transactions into "closed" periods. If the posting date is entered into the invoice date field, then you have incorrect invoice details in Xero that do not match the invoice itself. This is absolutely a critical requirement and I am very surprised this feature does not already or exist, or is even being worked on at the moment.
-
Glenda De Marinis commented
This is a business critical feature for basic month end closing if you are running a business with accrual accounting as your basis.
-
Kayleigh Collins commented
This is absolutely vital for business's which have a hard close at the end of every month. Without this feature we have to enter the posting date as the invoice date which means aged payable reports are inaccurate.
-
Stephen Cockshott commented
As an SME with no bookkeeper, this has recently caused me a few (!) problems.
The current date field has no legend associated with it. I, wrongly, assumed that this must be provided for the invoice date. Well, surely the system knows when the bill was paid and imported to Xero, so why would there be a changeable date field if it wasn't for the invoice date - the 'unknown' missing bit of vital information associated with an invoice!!
I was stunned to discover that it was for the posting date. This has to be fixed, but I see that it was first raised over 2 years ago!
I'm not an accountant, but recording the invoice date is surely accounting 101. Yes, there are lengthy workarounds for this - but this isn't what I would call beautiful business.
-
Adriana Salazar commented
@Hannah G and Xero Admin Team,
The why we need this separate field is related with the ability to close each month and don't need to open again when invoices come on a later date. Currently you need to either open again and post with the document date or post it in the current month with the current date and ignore the real date on the invoice/receipt.
The first option is not ideal as all the month reporting will change after posting an invoice. The second option creates confusion as the date used to post is not the real date on the invoice/receipt, it isn't ideal for audit trail.
I have seen the two fields in many other accounting softwares, so I am not 100% sure why Xero does not have it. I will be vary valuable if an Accountant is part of the admin team, because the Accountant will know why this is important and will be able to help the rest of the team understand.Thanks in advance
Adriana -
Delta Cavanaugh commented
This would make month end go smoother. It should be a standard feature.
-
Julia Kember commented
This would be an incredibly good resource to have. It should be standard!
-
Victoria Ellis commented
Please feel free to get in touch with our team and we will assist in any way we can
-
Hannah Cooke commented
The number of comments below show how important this feature is for any accounting function. This is standard across all other accounting software. The lack of this feature is creating additional work arounds for the team and duplication of costs. Please add this functionality as a matter of urgency or we will have to consider looking at alternative providers.
-
Michelle Wennen commented
This should be a standard feature...as it is in practically every other accounting system!
The inability to include both the legal invoice date and a separate posting / transaction / accounting date is my biggest frustration with Xero.
-
Alice Green commented
This is an essential feature for accrual accounting. I think where the frustration is coming from is that this feels like a very simple change.
The current 'date' field is operating as the 'posting date' and is linked to the lock dates feature.
The additional feature required is a 'document date' field so that if an invoice is dated December but not received until January (very common) it will still be 'posted' into January but with a 'document date' of December - we could then filter by document date to identify expenses captured following the lock period.
The metadata will already be there - if I enter an invoice in January but date it December then somewhere there will be a record of the January entry date.
Possibly muddying the water a little is many users requesting a billing period feature to effectively automate accrual and prepayment journals - whilst this would certainly be a neat feature - I can understand that this would need further development.
The fundamental need here is an extra field to record the invoice date - this will then be used for accurate creditor aging and enable accurate accounting.
-
Chris Milner commented
We need this so badly but with an amend: not just posted date, but a Billing Period?
Then a quarterly bill could be set as being across three months, and all we would need the system to do is auto-create journals to make the full invoice cost spread across the three months in question.
All I think people are asking for is that the system can create the journal for you on creation of the invoice, to speed up the process. It should be possible to have a journal created to put an invoice cost in a previous period, so then its no different to create 3 or 12 journals.
Could have drop down options for last month, last quarter, this quarter, this year or manually select.
It would mean that the Xero P&L would actually be useful, instead of always wrong.
-
Callum Mallett commented
This would make month end process so much simpler. I would say this basic "feature" as mentioned, a critical feature of any accounting system. Manipulating invoice dates makes the accrual process so much more clunky and only delays financial reporting. As suggested a posting date/period field, and then maybe if you'd like to really compete having the ability to lock these periods by AP/AR/GL
-
Clair Chapman commented
Recently moved from sage to xero but didn't ask if this would be a feature - because of course it would. Am now trying to figure out best way to deal with having invoices posted with incorrect dates as they can't be posted with the actual month of the invoice if received after month end has closed. Just wrong, especially with the VAT implications at quarter end
-
Marie Clothier commented
It can be quite common for an invoice to 'miss' the reporting period as the invoice isn't received by the Accounts Department by month end close off (where we have reporting deadlines and have to close the month for posting a few days after EOM date). As such, in Xero, you can't record the actual invoice date anywhere as that period has been closed, meaning a 'fictitious' invoice date is used (ie. 1st of the next month) to ensure it is posted in an open period. This is misleading and requires you to actually open the invoice to see the real date. Please add a field for this.
-
James Lownie commented
You have had this requirement for 2 years and still you are prioritising useless stuff like bulk void features when your standard invoice does not have the basics.
Really Xero all this "beautiful" nonsense is a waste of your developers time.
Look at your competitors and get the basics right.
Xero is clunky and shows its DOS origins -
Farzana Mughal commented
Very important so as we know how old the invoice is, and how long we have had them for if in a dispute
-
Lu Fan commented
The addition of an accounting period feature on Xero will be an essential enhancement that significantly elevates the usability of the platform. it will allow users to enter invoices dated in the previous month into the current period without changing the invoice date, eliminating the time spent on solving queries from suppliers. Please do something about it!