New Excel Formatting Updates(coming soon)
- Lane Kealey
We have made several changes to the excel formats of fields in our billing exports, payroll exports, and appointment list reports.
Export | Changes Made |
|---|---|
Billing Export Updates | The following fields are now formatted as “number” and rounded to two decimal places:
The following fields are now formatted as “time” and in HH:MM AM/PM format:
The following fields are now formatted as “date/ time”, and in MM/DD/YYYY format.
|
Payroll Export Updates (Timesheet and Non Payable Tab) | The following value is now formatted as “date”, and in MM/DD/YYYY format:
The following fields are now formatted as “number” and rounded to the second decimal place:
The following field is now formatted as a “number” and rounded to the third decimal place::
The following fields are now formatted as “time” and in HH:MM AM/PM format.
The following fields are now formatted as “date/time”, and in MM/DD/YYYY format:
The following fields are now in “text” format:
|
Payroll Export Updates (Summary and Paycode details tabs) | The following field is now in “date” format:
|
Appointment List Export Updates | The following field is now in number format:
The following field is now in text format:
The following fields are now in as “date”, and in MM/DD/YYYY format:
|