How services connect to your accounting software
Each service in Visualcare has two distinct code fields:- Accounting Code - links the service to a Xero inventory item. Visualcare uses this when building invoice lines, and it also carries the charge rate
- Payroll Code - links the service to a Xero pay item for a specific pay level. Visualcare uses this when exporting timesheet hours
Visualcare exports charge rates for invoicing (because rates vary by participant location and support ratio), but sends hours only for payroll. The rate on a Xero pay item determines what workers are paid, not the rate field in Visualcare.
Syncing items from your accounting software
Before configuring services, pull your Xero inventory items and pay items into Visualcare. This populates the drop-downs you’ll use when setting codes on services.1
Open Data Export settings
Go to Settings → Data Export → XERO.
2
Run all syncs
Click each of the sync buttons on this page:
- Sync Xero Invoice Items - pulls your Xero inventory item catalogue into Visualcare (used for accounting codes on services and clients)
- Sync Xero Pay Items - pulls your Xero pay items into Visualcare (used for payroll codes on services)
- Sync Employees and Sync Contacts - used for worker and client mapping respectively
Bulk uploading the template to Xero
Bulk uploading the template to Xero
- Open the template in Excel or Google Sheets and check the Sales Account column - the template assumes your sales account is 200. If yours is different, update all rows before uploading (check an existing inventory item in Xero if you’re unsure)
- In Xero, go to Sales → Products and Services and click Import → Items
- Choose the CSV, click Continue, and review the import preview
- Click Import
Setting accounting codes on services
The accounting code on a service tells Visualcare which Xero inventory item to use on invoice line items for that service.1
Open Services
Go to Maintenance → Services.
2
Select a service
Click on a service to open it.
3
Set the accounting code
Locate the Accounting Code field and select the matching Xero inventory item from the drop-down.If your Visualcare service codes match your Xero inventory item codes (for example, both use
01_015_0107_1_1), Visualcare auto-populates this field when you sync invoice items. Check the field is populated rather than assuming it is.If the codes don’t match (for example, one uses underscores and the other uses hyphens), select the correct inventory item manually.4
Save
Click Save. Repeat for every service you invoice clients for.
You only need accounting codes on services you actually provide, not every service in the NDIS catalogue.
Setting payroll codes on services
Each service needs a payroll code for every pay level your organisation uses. This is the intersection that tells Visualcare: “when a worker at this pay level delivers this service, export those hours to this Xero pay item.” The number of mappings required equals the number of services you provide multiplied by the number of pay levels you use. For example, 20 services across 4 pay levels means 80 mappings.1
Open Services
Go to Maintenance → Services and click on a service.
2
Review the pay level rows
You’ll see a row for each pay level label configured in Settings → Finance → Pay Levels. Each row represents a different worker classification tier.
3
Select payroll codes
For each pay level row, select the matching Xero pay item from the payroll code drop-down.For example, for a Weekday Daytime service:
- SCHADS Level 1 Casual row → select “SCHADS L1 Casual Day”
- SCHADS Level 2 Casual row → select “SCHADS L2 Casual Day”
- And so on for each level
4
Save
Click Save after completing each service.
Payroll code drop-downs are populated from Xero pay items. If the drop-downs are empty, go to Settings → Data Export → XERO and click Sync Xero Pay Items before returning to this step.
Mapping services in bulk
If you have a large number of services, a bulk spreadsheet method lets you map payroll codes in Excel and upload them all at once. This is faster than clicking through each service individually, particularly if you use most of the NDIS catalogue.1
Export the services spreadsheet
Go to Maintenance → Services and click All Services (top left), then click Export CSV (top right). Save the file to your computer.
2
Prepare the spreadsheet
Open the CSV in Excel. Select the header row and go to Data → Sort & Filter → Add Filter to enable drop-down filtering on each column. This is important when you’re working across hundreds of rows.
3
Map payroll codes by shift type
The most efficient approach is to filter by shift type and fill all services of that type at once:
- Click the drop-down arrow on the Service Name column
- Filter to a shift type (for example, “Sunday”)
- For each pay level column, enter the matching payroll code for all visible rows
- Drag or paste the code down the column
- Repeat for each shift type: weekday daytime, weekday evening, Saturday, Sunday, public holiday, and sleepover if applicable
4
Upload the updated spreadsheet
Save the file as a CSV. In Visualcare, go to Maintenance → Services → All Services and click Import CSV. Select your file, click Upload, then click Save.
Running into issues?
See Finance troubleshooting for common errors and fixes. If services are missing accounting or payroll codes, see Xero export troubleshooting.Related articles
Service management
Create and configure services in Visualcare
Invoicing sync
How invoice data flows to your accounting software
Payroll sync
How payroll data flows to your accounting software
Xero integration
Full Xero setup including connection and sync
