Client accounting
Using Xero lock dates with InTouch
A lock date in Xero stops anyone changing transactions dated on or before it. Once a period is closed, for example after a VAT return has been filed or the year-end accounts are done, a lock date keeps the figures you reported from changing. That includes changes made from InTouch, because InTouch posts invoices, payments, credit notes, supplier bills and ledger transactions to Xero. A payment entered under the wrong date or an invoice voided by mistake can’t reach the closed period.
Which dates to lock, and when, is for your firm and its accountant to decide. This article covers what a lock date means for your work in InTouch.
Setting a lock date
Section titled “Setting a lock date”Lock dates are set in Xero, not InTouch. See Xero’s guide to setting up and working with lock dates. There’s nothing to set up in InTouch: Xero applies the lock date when InTouch posts to it.
Before you lock a period
Section titled “Before you lock a period”Tidy up the matters in the period first, while you can still change them:
- Approve or void draft invoices that belong in the period. Once it’s locked, a draft can’t be approved with a date inside it.
- Void anything that shouldn’t have been raised. See correcting a mistake on a matter’s accounts for the order to undo things in.
- Record payments, supplier bills and ledger transactions that belong in the period.
- If you use Payment Sync, select Sync Xero Payments Now so payments made in Xero are brought in first.
To find client invoices dated in the period:
- Go to Settings > Ledgers and Accounts, and under Reports select Invoices.
- Set Status to Outstanding, or Draft.
- Set Date Range to Approved between, or Created between for drafts, and choose the dates of the period.
- Optional: narrow it by Matters, Team or Fee Earner, or export it to CSV or PDF.
What a lock date stops in InTouch
Section titled “What a lock date stops in InTouch”Xero refuses anything InTouch would post to it on or before the lock date. InTouch shows the reason Xero gives, after “Response from Xero:”, and doesn’t save the change.
This covers new entries dated on or before the lock date:
- Payments on invoices and supplier bills
- Credit notes against an invoice or supplier bill
- Supplier bills
- Ledger transactions, such as depositing or withdrawing client money, or a transfer from office to client
If Xero refuses an invoice when you approve it, the invoice goes back to Draft and the matter’s history records why.
An anticipated client money entry isn’t posted to Xero, so the lock date doesn’t stop it. It’s posted when you post the entry from the ledger, using the date you give it then.
The lock date also covers changes to an entry already dated on or before it, because Xero changes it on its original date:
- Voiding an invoice, credit note or supplier bill
- Deleting a payment or credit note from an invoice or supplier bill
- Voiding a ledger transaction
Working with a period that’s locked
Section titled “Working with a period that’s locked”For a new entry, choose a date after the lock date. Payments, credit notes against an invoice or supplier bill, supplier bills and ledger transactions each have a date field. A credit note raised on its own is always dated today.
To correct an entry that’s locked:
- Ask whoever manages your Xero to move the lock date back, or remove it.
- Make the correction in InTouch. If InTouch asks you to do something in Xero first, such as removing a credit note’s allocation or unreconciling a payment, do that in Xero, then carry on in InTouch.
- Ask for the lock date to be set again.
Don’t make the correction itself in Xero: InTouch won’t know about it, and the two will no longer match. If a correction fails partway through, check the item in both before trying again.
With Payment Sync turned on, a payment made in Xero against a supplier bill is still brought into InTouch, which then posts its own entry for it to Xero. If the payment is dated on or before the lock date, Xero refuses that entry. InTouch emails your ledger and accounts notifications address, if you’ve set one, and keeps doing so until the payment is dealt with.