Pay Tracker

Data Sync

Verifying Admin Access...

Please wait while we authenticate your session.

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

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

Automatic

Provider

Patient

Visit Date

Billed CPT Code

Pay Calculation

Base Rate (CPT)	$0.00 $
Travel Pay	$
Bonus	$
Adjustment	$
Total Pay	$0.00

Pay Date

Notes

Status:

Loading visit details...

Import from Pay Tracker Excel

Import pay entries from 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 entries (same provider + date + patient) will be updated
New entries will be created for non-matching rows

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 row for details)

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

CPT Code	Description	Default	Rate

Period

Visits

Total Pay

$0.00

Paid

$0.00

0 selected

	Date	Patient	CPT	Pay Rate	Travel	Total	Status

0

Entries

0.00

Total Hours

$0.00

Total Pay

Date	Start	End	Hours	Rate	Total	Description	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...

Import

Pay Tracker Excel

Staff Time Tracker

Export

Pay Entries

Filters

Filters

Select Pay Period

Select Date

Add Procedure

Edit Procedure

Procedure 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 row for details)

Sample Entries: -

Clear Excel Imports

Export Data

Add Pay Date

Edit Pay Date

- CPT Rates

Edit Rate -

Edit CPT Code

Select CPT Code

Select Pay Date

Contractor

Provider

Pay Date Details

0

$0.00

open

-

Staff Time Entries

0

0.00

$0.00

Add Time Entry

Add Staff Rate

Import Time Entries from Excel

Map Sheets to Users

Import Results

Load Default Data