Lock Dates - Allocate Overpayments to Bills before a Lock Date
when doing allocation between an overpayment and a bill, if the invoice is dated within a locked period you are unable to do the allocation, it would be good if you could just do the allocation without having to open the period.
-
Helen Aked
commented
I know Xero have commented on this before that they don't want to allow the journal entries for the allocation in a locked period as it risks changing the P&L and BS but it's worse that we have to reopen the period to complete the allocation. Also anyone with any basic accounting knowledge will tell you that the journal entries to match a credit v an invoice/bill have no impact on any of the reporting.
-
Sara Whelton
commented
I have the same issue - I want to allocate a credit note from 2024 to an invoice from 2026. Lock dates are preventing this. But if the allocation date is this year, shouldn't that be OK?
-
Joshua McConaghy
commented
I agree. Payments and credit allocations shouldn’t have a material impact on the accounts, but giving everyone the ability to lock and unlock periods is likely to cause issues.
We use an automated billing system that submits to Xero once invoices are approved. If a lock date is in place, it simply posts to the next available period, which works perfectly. However, each time we unlock a period we increase the risk of a late purchase invoice being posted into a previously locked period, which can create unnecessary complications at the following month end.
This actually happened last month. Because the transactions didn’t have reference numbers, I spent around four hours investigating a £17k variance in a period that had already been closed. It turned out that three invoices had slipped into the period while it was temporarily unlocked so that payments could be allocated.
-
Iris Ann Fernando
commented
Hi, Please can we have the ability to allocate past years overpayments to invoices outstanding after the accounts are closed. These accounts do not form part of the main ledgers, being personal accounts, therefore the allocations should be made possible, as they were in Microsoft MOA. This would tidy up much of the personal accounts for customers and suppliers.
I look forward to a favourable response.Supplier Accounts - Also, are you looking at being made available, statement histories for the suppliers as asked for several years ago and Xero said they were working on it? This is very much needed to mirror supplier's own statements to us.
Thank you for your kind attention to these important matters.
-
Matt Tyler
commented
100% agree. We can't be going back and changing comparatives in prior periods when the accounts have already been completed
-
Michele Furlong
commented
Totally agree! Having to open periods that are locked changes the integrity of the accounts as the published numbers will change. A differetiation needs to be made between the document date, and the posting / allocation date. This needs to apply to allocating credit notes to invoices or bills and processing invoices received after a period is closed.
-
Jenny Draper
commented
OMG!! HOW in goodness name is this function not available !!!!!!!!!!!!!
Not all transactions happen within a neat month, and it is NON-COMPLIANT to make transaction in a closed period, when the TRANSACTION DID NOT HAPPEN .
A Credit needs to be able to be applied to a bill at ANY time after a credit / overpayment is raised.
Soooooo many times the client doe **** get confirmation form the supplier, or visa-versa - for the transaction to apply within the month.
I will NOT just change an historic account, and make the report INCORRECT just because Xero (again) does not have the correct accounting process to do it!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
-
Cristina Pacioga
commented
Hi, I am facing same issue and would like to support Sara's idea. It is inconvenient unlocking the accounts.
Thanks,
Cristina