Fix the PRODA Payment Details CSV File Before Upload
1. Open the original PRODA payment details CSV file in Excel.
2. Save it as a new file. This becomes your working CSV file.
Note: The “working CSV file” refers to the new file you save and modify. This is the file you will upload into CareVision. The original PRODA file should remain unchanged.
3. In the working CSV file, find:
- Payment Determination column (27th column / Column AA)
- Final Determination column (28th column / Column AB)
4. In the Final Determination column (Column AB), confirm that all values are zero due to the PRODA file issue.
5. Copy all values from the Payment Determination column (Column AA / 27th column).
6. Paste these values into the Final Determination column (Column AB / 28th column) in the same working CSV file.
7. Save the working CSV file.
8. Upload the working CSV file into CareVision.
Verify Data Using PRODA and Excel
1. Go to the claim details page in the PRODA / Services Australia Portal.
2. Select the data from the top of the table to the bottom, then copy it.
3. Paste the data into Excel (this is a separate file used for validation).
4. Identify the Payment Determination column and Final Determination column.
5. Add a formula to calculate the difference between these two columns.
6. Check if there are any differences.
If There Are Differences
1. Use the Excel validation file to identify the correct values.
2. In the working CSV file, copy the correct values from the Payment Determination column.
3. Paste them into the Final Determination column.
4. Make any required adjustments manually in the working CSV file.
This is a temporary solution to allow you to continue processing while the department works on a solution for the PRODA payment details CSV file issues caused by additional columns. For more information, contact the CareVision Support Team.