Pay Tracker

Patient	Visit Type	Billed CPT	Pay Date	Total	Notes
Loading...

Date	Contractor	Reason	Amount	Status	Check #	Notes
Loading...

0 entries

Total: $0.00

	Pay Date	Date Range	Paid	Total Pay	Status
Loading...

Provider CPT Rates

Staff	Date	Start	End	Hours	Rate	Total	Description	Status
Loading...

0 entries Total: 0.00 hrs / $0.00

Code	Title	Description	Category

Global Filters

Show entries from pay date:

Hides all entries from earlier pay periods across all tabs

Import

Pay Tracker Excel

Import pay entries from Pay_Tracker Excel file

Staff Time Tracker

Import staff time entries from Excel (one sheet per staff member)

Export

Pay Entries

Export pay tracker entries to CSV or Excel

CPT-Based Custom (Meetings, etc.)

Provider *

Date *

Patient *

Visit Type *

CPT Code *

Notes

Provider

Visit Date

Patient

CPT Codes

Total Pay $0.00

Pay Date

Status

Notes

Import from Pay Tracker Excel

Upload Excel File (optional) Upload your own Excel file, or leave empty to use the default file

Using default: Pay_Tracker-10.22.23-km.xlsx

What will happen:

All provider sheets will be processed (excluding utility sheets)
Pay periods will be created based on pay dates in the Excel
Existing Excel imports will be deleted before importing new data
New entries will be created for each row

No import results available.
Run an import to see results here.

0

Created

0

Updated

0

Matched

0

Unmatched

0

Skipped

Per-Sheet Details (click count to see entries)

Sheet	Provider	Status	Rows	Created	Updated	Matched	Unmatched	Name Fixes	Date Fixes	Skipped

Clear Excel Imports

Remove all pay tracker entries that were imported from Excel.

Warning: This will permanently delete:

All pay tracker entries marked as Excel imports
Any pay periods that become empty after deletion

Merge Duplicate Entries

Merge entries that show the same visit twice.

What this fixes:

Appointments without CPT data (from appointment sync)
Excel imports without appointment links (with CPT data)
Same visit showing twice with different info

Period

Visits

Total Pay

$0.00

Paid

$0.00

0 selected

	Date	Patient	CPT	Pay Rate	Travel	Total	Notes	Status

Period

Entries

Hours

0.00

Total Pay

$0.00

0 selected

	Date	Start	End	Hours	Rate	Total	Notes	Status
Loading...

Expected format: Excel file with one sheet per staff member.
Required columns: Day, Time-In, Time-Out

Select from Server

- or -

Upload File

Verifying Admin Access...

Global Filters

Import

Pay Tracker Excel

Staff Time Tracker

Export

Pay Entries

0/0

0

0

0

0

0

0

0

0

Verifying Admin Access...

Global Filters

Import

Pay Tracker Excel

Staff Time Tracker

Export

Pay Entries

Filters

Filters

Filters

Filters

Select Pay Period

Select Date

Add Procedure

Edit Procedure

Procedure Details

Visit Details

Add Contractor Payment

Edit Contractor Payment

Import from Excel

Excel Import

Import from Pay Tracker Excel

Import in Progress

0/0

0

0

0

0

0

0

0

0

Per-Sheet Details (click count to see entries)

-

Clear Excel Imports

Merge Duplicate Entries

Merge Complete

Export Pay Tracker

Add Pay Date

Edit Pay Date

Delete Pay Date

- CPT Rates

Edit CPT Code

Select CPT Code

Select Pay Date

Contractor

Provider

Pay Date Details

0

$0.00

open

-

Staff Time Entries

Add Time Entry

Add Staff Rate

Import Time Entries from Excel

Map Sheets to Users

Import Results

Load Default Data