The TfNSW report includes any trip records with a Future or Verified status, of funding type CHS, CTP and HRT. Please note that the report specifically picks up only trips with those funding types, so you're unable to for example split up your CHS funding into multiple streams and have it all included.


The TfNSW report includes any trip records with a Future or Verified status, of funding type CHS, CTP and HRT. Please note that the report specifically picks up only trips with those funding types, so you're unable to for example split up your CHS funding into multiple streams and have it all included.

It requires a high level of data accuracy and completion, making this a potentially time consuming task especially if running this for the first time. The report can (and will generally need to) be run multiple times to get an error- free export, so its recommended to start running this as early as possible in order to meet submission deadlines. 


## **Running the Export**

To run the export, in Trips go the **Data** tab. From here, press the **ComT Export** button. ![](https://s3-ap-southeast-2.amazonaws.com/aus-cdn.freshdesk.com/data/helpdesk/attachments/production/51018346761/original/OAHg4pOelk3_NvPA0TqjdOlX4U45TPoFQg.png?1622502668)


In the popup, select select a date range by either using the Month options on the left, or manually specifying a date range on the right. Click **OK** ![](https://s3-ap-southeast-2.amazonaws.com/aus-cdn.freshdesk.com/data/helpdesk/attachments/production/51018347142/original/gvkF0UF_hLCXLNX7ozSq5L4XK_VwWb0qKA.png?1622502894)


The report will take a few moments to process, and will let you know when its complete. Click **Save As**, and select a location you'd like it to save it to, make sure that this is somewhere accessible from your own computer.  ![](https://s3-ap-southeast-2.amazonaws.com/aus-cdn.freshdesk.com/data/helpdesk/attachments/production/51018347435/original/N2CU4T4d0kGTpgpLCqnyZfAkCZF2IVnhYA.png?1622503038)


After being saved you'll be asked if you want to open the file - depending on how Trips has been installed for your organisation you will likely need to select **No**. 


Navigate to where you saved the files, you'll notice that there are 2 files here that will appear similar to what's shown below. All of your TfNSW events will be in either the first file if there are no errors, or the INVALID file if there were. If you haven't already, copy both of these files over to your own computer.

 ![](https://s3-ap-southeast-2.amazonaws.com/aus-cdn.freshdesk.com/data/helpdesk/attachments/production/51018348024/original/SZZmfLlT5exOG86IndhFR1Z0tTDkylN6dA.png?1622503361)


## **Checking for errors**

Open the INVALID file in Excel. 


This file contains a single transport record on each row, with the reason(s) it could not be included successfully in the report. The error message lets you know the reason(s) why that transport event wasn't included in the report. Fix up any issues in Trips, then rerun the export. The INVALID report isn't submitted, so you can filter/edit/change or do whatever you'd like to help you get through the error list. 


If wanting to look at a transport record from the export in Trips, there are a couple of ways to find this. Every client, journey and trip have a unique ID within Trips, these are included on the export

* K Pickup Date - this is the date the transport took place. The column will likely need to be widened in Excel
* AK CUSTOMER_INTERNAL_ID - This will appear in the format of 'TRIPS1234' with 1234 being the client's number in Trips. If you search for this number in the Clients section of Trips, the client with that ID will appear in the list. From here, you can click on the 'Transport' button on the top right to see all of their transport events. 
* AD RUN_ID - This refers to the journey number, or journey ID. This is shown in the trip list on the client page, and on the Journeys page in Trips
* D Trip_ID: The unique ID of the trip itself.
  
  Depending on the error being resolved, there's also other useful identifying information such as destination addresses or vehicle registration. 


## **Error messages**

You'll notice that some trip records have multiple error messages on them, this just means that there was more than one thing stopping the trip from coming through. This seems tricky initially to find all records with a particular error, but you can use the Excel filtering options on the first column to (for example) find all records with a 'drop_off_time missing' error, regardless of any other errors they have. 

* **Country of Birth Code missing:** This means that the client record doesn't have a Country of Birth listed. Go into their record in Client Central, and add a Country. The client IDs are different between Client Central and Trips, so you will need to find the client name in Trips using their ID in column AK, and then search for that client in Client Central.
  
  If you have a large amount of clients with this information missing [support@tmasoftware.com.au](mailto:support@tmasoftware.com.au) can add this in for you, but we can only add the same country for every client that doesn't have one, eg add Australia for all clients with a missing country.
* **Destination/Origin Latitude/Longitude missing:** This is likely because the Destination doesn't have a Verified location. In Trips, go the Data tab, then click on 'Places'. The 'Verify All' button at the bottom will go through all Destinations and Verify what it can, its recommended to give this a go if you haven't before.
  
  You will then likely still have a few that couldn't be verified because of invalid or incomplete information. Find the destination using the filter up the top, if its Verified it will have a green tick next to it. If it isn't Verified, double click on it to open it. Adjust/enter information as needed, and click the Verify button. If it can't verify the address, look for the address using the Google Maps to see if the postcode or other information is incorrect.
  
  When saving an edited Destination, you will be asked if you want to update all Future bookings/trips - select Yes. Fixing this up for one destination record will resolve the issues for any trips in the export using this destination.
* **Drop Off time missing:** Adjustments are still being made to this export to make things easier here, but for now contact [support@tmasoftware.com.au](mailto:support@tmasoftware.com.au) to assist here. We can assist by copying over any OBV information regarding drop offs where there is any, and/or using a combination of the pickup time and estimated travel time to fill in missing information here.
* **Customer Preferred Language missing:** This means that there isn't a main/preferred language entered for this client. You can enter this information into Trips, find the client record by searching for the TripID in the export and select a language from the Details tab of the record.
  
  If you have a large amount of clients with this information missing, [support@tmasoftware.com.au](mailto:support@tmasoftware.com.au) can add this in for you, However we can only add the same language for every client that doesn't have one, eg add English for all clients missing information here.
* **Dead Running kms:** A new Trips app that we are working on will gather this information much more than it does currently, but for now this information is generally not captured in Trips and therefore cannot be reported on. Contact [support@tmasoftware.com.au](mailto:support@tmasoftware.com.au) to more easily add missing information here, eg add 0 for any records missing this information.
* **Customer Birthdate:** A date of birth needs to be entered in for the client. This can be entered in from the client record within Trips.
* **Type of Transport missing:** Each transport event is either a DIRECT or INDIRECT type. This information is gathered from the journey when verifying a trip, its likely that the journey hasn't been verified. Go to the Register/Verify page in Trips, select the date that you can see from the PICKUP DATE column in the export, and look for a journey that isn't verified. Verify it from this page by double clicking on it, going to the Costings tab, and using the Verify button there.
* **Trip Distance kms 0 or missing:** Contact [support@tmasoftware.com.au](mailto:support@tmasoftware.com.au) for assistance here. We have a process that goes through Trips and adds in kms based on estimated travel distance and destination coordinates, but this is resource intensive and best done out of hours. To help this process along, its recommended that you resolve errors regarding missing latitude or longitude information first as this will then assist with resolving missing kms data. 


After fixing errors, repeat the steps above to run the Export from Trips and check again for any errors. Its no problem to delete the previous exports and just use the most recent ones. Ideally you will end up with no transport records in the INVALID file, meaning that all of your transport events will have successfully made it over to the other file. Its this file that can be submitted to TfNSW.

Guide to running TfNSW export from Trips

How to bulk manage Trips?

FAQs

Clients

Main Tab

Main Menu Breakdown

Control Settings

Bookings

New Journeys

Vouchers

Places

Help Tab

Crew

Trips Reports

Data Tab

Shortcut Keys

Allocations

Dashboard Tab

Welcome to Trips

User Guides

TRIPS Desktop

User Guide: Client App - Participant & Family Guide

User Guide: Client App - Provider Guide

Client App

What is my app PIN?

User Guide: Worker App Guide for Workers

Case Notes within the App

How to Clear App Cache & Data for Android?

User Guide: Worker App Guide for Admins

Why can I not see Participant documents on the Worker App?

Worker App

CareMaster Mobile Apps

CareMaster Data Export

How to Request CareMaster Training

How to send emails from a different email address?

How to request a CareMaster Software Update?

Understanding CareMaster Licences

How to Clear Google Chrome Browser Cache?

Feature Request Form Update

General

Actions for CareMaster Aged-Care Providers Transitioning from Home Care Packages (HCP) to Support at Home (SaH)

Step 1: NDIS Service Import

Step 2: CareMaster Configuration & Rostering

Xero Integration, Payroll & Invoicing

MYOB Integration, Payroll & Invoicing

KeyPay Integration, Payroll

Reckon Integration, Payroll & Invoicing

Step 3: Financial Integration

Step 4: NDIS Export Process (Registered NDIS Providers)

Advanced Rostering - SIL Houses (Optional)

Coordination of Support (Optional)

Guided Onboarding

Passwords reset and activation emails

Error - Support start time must be before end time

Updating a shift to overnight/active overnight

Why am I missing timesheets?

Why am I getting kicked out of CareMaster desktop?

Why are kilometers missing from a timesheet?

How to stop a service showing on the roster or being included in roster emailed to the participant.

Why does the support on the Worker app not allow me to add kilometers?

CSRF token mismatch

How to Contact the Customer Care Team for Support

Top Troubleshooting FAQ's

Company Message Centre

How to submit a feature request

Home Page

Logging In

How To Reset A Password?

Home

How to hide certain alerts?

Alerts User Guide

Alerts

User Guide: Bulk Assigning and Unassigning of Participants and Workers

How to check over reported DEX data? 

How to create a new client record from a My Aged Care client record snapshot?

What is the CHSP reporting process?

CHSP service List and Mandatory Reporting Required from 1 July 2025

CHSP Participant Guides

How to create new Agencies

NDIS Splitting Participant funding into different Budgets

User Guide: Recording Medication Usage for Participants

How to change what shows on the Participant List page?

Participant/Client Leave Requests

How to Send SMS/Email Reminders to Clients?

The Participant Profile User Guide

How to Manage Participant Funding Limits

Service Agreements

How to email a HCP statement to a client?

Adding HCP Km's to a Support and a HCP Statement

How to generate a HCP statement for a client?

How to regenerate a HCP statement after adjustments?

How to add an adjustment to a generated HCP statement?

Understanding your HCP Statement

HCP Subsidy Increase 01.10.2025

How can I add HCP leave for a client?

User Guide: HCP Funded Participants Setup Guide

HCP Participant Guides

How to create a new participant or client

How to use case notes

Participants

Service Organisation Roster view

How to Email Rosters to Participant?

How to Email Rosters to Workers?

Unassigned Supports - Coordinators and Vehicles rosters views

How to customise the Roster view

Roster Page User Guide

Using The Roster Optimiser - Single Support

Using The Roster Optimiser - Bulk Optimise

Participant Data Setup

Locations & Destinations

Worker Data Setup

Checklist

Roster Optimiser

How to resolve email authentication errors when emailing?

Roster

Changes to Worker's Emails and Password Reset

How to Create Worker Timesheets

What access does each user level have?

Working With Children Checks

How to Send SMS/Email Notifications to Workers?

How to deactivate user accounts 

User Guide: Staff/Volunteers

How do I add a new Worker?

How to change what shows on the Staff/Volunteers List page?

How to exit workers in CareMaster

Staff/Volunteers

How do I Cancel a Support/Shift

How to create Service Organisations

How do I bill for NDIS transport?

How To Limit Support Services to Approved Services Only

Creating Supports for a different Time Zone

How to restore a deleted support?

How to create Provider Travel supports to invoice participants and generate worker timesheets.

Creating and editing a Recurring Booking

How to Use the Manage Button to Change Supports?

How to Claim / Invoice Cancelled Services?

Grouped Supports

How to use 'Quick Save' on the Supports Page

Creating Therapy Supports with 50% Travel change.

Supports Menu User Guide

User Guide: How to create supports

User Guide: Provider Travel and Transport - Rostering Scenario Guide

User Guide: Supported Independent Living (SIL) Setup, Rostering and Claiming process

User Guide: Short Term Accommodation (STA) Setup, Rostering and Claiming process

Transaction List Export

How to advertise / broadcast available shifts to workers?

NDIS Non Face to Face Supports

Support Display - App Data Tab

Supports

Create SaH Supports including Wraparounds & Transport

Support at Home – Release Update 30th October

Participant Statements to be ready by end of February

Support At Home - Implementation Updates

Connect to PRODA and Register / Activate your Device

Syncing Services and Service Organisations

Creating additional Service Organisations & Services for SaH

Sync your Participants

Review the Participants Budget Dashboard

Understanding Programs, Budget Items & Funding Sources

Bulk Exporting for Services Australia for Invoicing & Claiming

Payment Statement Upload / Reconciliation

Upload the Claims file back into CareMaster

SAH Participant Statements

Invoicing for Xero, MYOB & Export Reports

Re-Activate your Device - Expires every 6 months

Support At Home (Aged Care)

Vehicles User Guide

Vehicles

Properties User Guide

Properties

Worker Summary Hours Report

What do the Staff/Volunteer reports show?

How do I change the fields on the worker list report?

Worker Reports

What do the Participant reports show?

Participant Reports

What do the account reports show?

What do the voucher reports show?

What do the property reports show?

Worker Run Sheet Report

Reporting User Guide

Custom Reports for Participants and Staff/Volunteers

What do the supports reports show?

Dashboard Reports - Where do the target figures come from?

Admin Reports

Reporting

User Guide: Documents

Documents

Custom Incident Forms

Incidents User Guide

User Guide to Printing Incidents

Incidents

News Items

CareMaster News

Voucher User Guide

Voucher

How to hide unpublished rosters using Confirmed status

User Guide: How to Automatically provide workers access to clients for scheduled supports

Settings Overview User Guide

Settings

CareMaster

Guide to running TfNSW export from Trips

Share

Share

Guide to running TfNSW export from Trips

Share

Share