This guide provides a comprehensive overview of how to manage client credit balances specifically within Xero, our central accounting system. Understanding and correctly applying these credits is crucial for maintaining accurate financial reporting, managing cash flow effectively, and preventing incorrect payment reminders from being sent to clients. Prompt and precise credit management enhances both your internal financial operations and client satisfaction.
This guide does not cover how to apply Lightspeed 'store credit'. This is a separate process managed through Lightspeed, you can find more information here.
Overview
Xero is where comprehensive financial records, including client account balances and invoices, are managed. It's important to understand the distinctions between different types of client credits and how they interact with other systems within the Evolution Platform.
Prerequisites:
- Access to Xero with appropriate permissions to manage invoices and credit notes.
- Access to Lightspeed with appropriate permissions to modify sales and create non-inventory items.
- Understanding of your current Xero reporting practices.
- Overpayment or Prepayment: In Xero, an Overpayment or Prepayment occurs when a client pays you more than the amount due on an invoice, or makes a prepayment for goods and services before an invoice has been created.
- Credit Note: A Credit Note is a deliberate financial adjustment issued to reduce the amount a client owes or to provide a refund for a previously paid invoice. Common scenarios include Write off bad debt, Clearing small debit balances on customer accounts, or Adding credit to a customers account as a goodwill gesture (e.g., when items are not returned to stock). Unapplied credits migrated from NetSuite may also appear in Xero.
Overpayment/Prepayment Application
When an Overpayment/Prepayment is applied to an invoice in Xero, this action automatically updates the invoice in Lightspeed. The invoice status in Vital will update to 'paid' if no outstanding balance remains.
Credit Note Application
When a Credit Note is applied to an invoice in Xero, it does not automatically update the invoice in Lightspeed (and therefore Vital). A manual adjustment in Lightspeed is required to ensure the invoice balance aligns with Xero and hat the invoice status updates correctly in Vital.
One Poolwerx Way Policy
Always void incorrect invoices in all three systems (Vital, LightSpeed, and Xero). Do not create credit notes for incorrectly created invoices. This policy is vital for ensuring inventory is returned to stock and all systems are in alignment, preventing reconciliation issues, errors with franchise fee calculations and data discrepancies.
- Prompt Application - Apply credits promptly to ensure your accounts receivable balance accurately reflect true outstanding debts, aiding in accurate financial reporting, budgeting, forecasting, and better cash flow management. This also reduces the risk of sending incorrect automated payment reminders.
- Regular Review - Review any credit balances on a daily or weekly basis, depending on your business' size, to ensure accuracy. Utlisie your Aged Receivables detail report frequently to catch and apply any unapplied credits. This proactive approach prevents reconciliation headaches and ensures your financial reports are always accurate.
- Adhere to steps - Always follow the outlined steps precisely to maintain data integrity across Xero, Lightspeed, and Vital. Deviations can lead to time-consuming discrepancies.
- Clear Communications - Ensure all staff members, particularly those involved in invoicing, payments, and client communication, are aware of the differing nature and management of Xero and LightSpeed credits.
- "One Poolwerx Way" for Credit Application - Establish a clear protocol for who is responsible for applying Xero credits in Xero and how the field team is notified.
Step-by-step instructions
This process is straightforward as applying an Overpayment or Prepayment in Xero automatically updates the corresponding invoice in LightSpeed, and the invoice status in Vital will update to 'paid' if no outstanding balance remains.
- In Xero, locate the relevant overpayment or prepayment. You can do this from your your Aged receivable detail report, or directly from the customer's account details.
- In the top right-hand corner of the overpayment transaction, click on Overpayment options.
- From the dropdown menu, select Allocate Credit
- A list of open invoices on the customer's account will appear. Enter the credit amount to apply to each invoice.
- Click Allocate Credit.
Expected Outcome: The Overpayment / Prepayment will auto-update the invoice in Lightspeed and will appear in the payment section referenced as a 'Xero credit note'. If no further balance is outstanding, the invoice status in Vital will show as 'paid'.
When a Xero Credit Note is applied to an invoice, it does not automatically update Lightspeed. A manual adjustment in Lightspeed is required.
Step 1: Create and Apply Credit in Xero
- Log into Xero and navigate to the dashboard.
- Click on the Business tab and select Invoices.
- On the Invoices page, find the invoice you want to credit and open it.
- Once on the invoice, click on the three ellipses (...) and select Create and apply credit.
- Expected outcome: This will create and automatically apply the credit to the selected invoice in Xero. You can also send an email copy to your client directly from Xero.
- Alternatively, you can create an stand alone Credit Note and apply it to an invoice later. To do this:
- Log into Xero and navigate to the dashboard.
- Click on the Business tab and select Invoices.
- Click on New Credit Note
- Enter the details for the credit note. You can also email the credit note to the client directly from Xero
- Once approved, you can apply the credit note to an outstanding invoice.
- Go to the invoice and under credit Notes section, apply the credit note to reduce the amount due.
Conditional logic: If you've created the credit but have not yet created the invoice, wait until the invoice is created, then apply it.
Step 2: Manual Adjustment in LightSpeed
This process is essential to mark the sale as 'completed' in Lightspeed so that the status of the invoice will update to 'paid' in Vital.
- Create Non-tracked inventory product (if applicable):
- In LightSpeed, create an non-tracked inventory product called 'Xero credit note' . Alternatively if the credit note relates to a bad debt write off, we recommend creating a product labelled 'bad debt write-off".
- Optional: add a tag "Xero credit note" or "Bad debt" for better seachability.
- Navigate to the invoice via the Sales History. Ensure you are logged in to the correct register. If not, switch registers.
- Click Continue sale. If you cannot click Continue Sale, you are most likely not in the correct register.
- Add the Xero Credit note item to the sale
- Enter quantity of Negative 1 (-1).
- the total value of the credit or write-off. Note: The outstanding amount should be equal to the amount in Xero.
- Click the Pay button.
- Select Cash.
- Select Complete Sale.
Manual Tracking (Google Sheet)
Maintain a live, shared Google Sheet for all clients with Xero credit balances. This sheet serves as a centralised, accessible record for staff who do not have direct Xero access. For detailed instructions and a template see: Client Credit Tracking Sheet.
Tagging and Notes in the Field Management System
To ensure field technicians and schedulers are aware of Xero credit balances, apply relevant tags (e.g., "credit balance" or "Has credits" to the client's profile in Vital.
Add detailed notes to the client's profile outlining the credit balance, its origin, and any specific instructions for application. This practice is crucial for preventing double-charging or miscommunication during service visits.
Troubleshooting / FAQ's
The LightSpeed invoice balance is not updating after applying a credit note in Xero, why?
When a credit note is applied to an invoice in Xero, it does not automatically update the invoice in Lightspeed. You must manually adjust the invoice in Lightspeed as outlined in the "Apply Xero Credit Note to a invoice" section of this guide. This is a current system limitation.
I've already created a credit note for an invoice that should have been voided, what should I do?
If invoices have been created incorrectly in Vital or Lightspeed, they should always be voided in all three systems: Vital (delete), Lightspeed, and Xero. This will return the stock to your inventory and ensure your sales are aligned across the platform.
If you accidently created the credit note in Xero, you need to delete or void the credit note first, and then procced to void the original invoice across all systems.
Related Guides & Next Steps
What's Next: Once credits are applied, you can proceed with your daily financial reconciliations.
Deep Dive: