Why I built it
Waiting for a DVA claim to be processed can be frustrating, particularly when it is difficult to know exactly where the claim is in the process.
I originally developed this spreadsheet to keep track of my own DVA claims. I wanted one place where I could record what had happened, when it happened and how long each claim had been waiting.
Over time it developed into a more comprehensive claim tracking tool, including automatic business-day calculations, claim status tracking, correspondence records and regular email reporting.
When you ring DVA they have all the information in front of them and can refer to it very quickly. I hope this enables you to have the relevant information in front of you when you ring them.
What can it do?
📋 Keep a record
Record important dates, reference numbers, claim types and activity associated with each claim.
⏱ Track waiting time
Automatically calculate business and calendar waiting time for each claim.
🔎 Track claim status
See where each claim is in the process and what happened most recently.
📄 Keep correspondence
Record letters, emails, reports and other correspondence associated with your claims.
✈️ Track travel claims
Record DVA-related travel, refunds and outstanding travel claims.
💳 Track MEPI
Record privately incurred medical expenses and reimbursement outcomes.
📧 Regular reports
Generate a summary of your claims and receive it by email.
See the tracker
Here is a quick look at the main tracker. The detailed User Guide contains larger screenshots and explanations of each part of the workbook.
Home
Travel Claims
MEPI
Correspondence
Want to see how it works?
The User Guide goes into the detail — each workbook tab, buttons, reports, importing data, authorisation, colour coding and using the tracker on iPhone or iPad.
Open the DVA Case Tracker User Guide Download the User Guide (PDF)What can it help you with?
- Keep track of multiple claims at the same time.
- Record important dates and claim activity.
- See how many business days a claim has been waiting.
- Identify claims that have been sitting without activity.
- Keep a history of your interactions with DVA.
- Receive a regular summary without opening the spreadsheet.
It does not change the DVA claims process and does not provide legal, medical or advocacy advice. It simply provides a way of keeping your own records.
Why Google Sheets?
The tracker is deliberately developed in Google Sheets so the spreadsheet, Google Drive storage and Apps Script automation can work together. This allows one live copy to be accessed across devices and enables automated claim calculations and reports.
Using the Tracker on a Phone or Tablet
The Google Sheets tracker works on iPhone and iPad for viewing and editing. The custom buttons currently require Google Sheets on a desktop computer.
Scheduled reports continue to operate automatically.
Download the DVA Case Tracker
The current community release is:
Released 9 September 2026
The link creates your own copy of the tracker in Google Drive. Your information remains in your own Google account.
Previous Versions
Released 4 September 2026
Important information
This spreadsheet is an independently developed personal tracking tool. It is not produced, endorsed or supported by the Department of Veterans' Affairs.
It is intended to help veterans keep their own records and monitor the progress of their claims. It does not provide legal, medical or advocacy advice.