PGHAutomation

Processes

Pick a process to run

Each process takes the files it needs, shows you exactly what it decided, and hands back a workbook you can drop straight into your reporting.

MAPReady

Assigning MAP Codes

Reads itemized charges, matches each product against the lookup sheet, and fills the account title column — colour-coded and annotated for review.

Needs
Excel workbook with an itemized charges sheet and a lookup sheet
Gives
Reviewed preview of every row · Annotated workbook download
Open process
TAGReady

Tagging of Patients

Reconciles the CAF line list, the voucher register and the charges sheet into one list of beneficiaries, tagging every row Pending, With voucher or Submitted — and flagging vouchers used outside the month they were claimed.

Needs
ALL PATIENTS line list (PDF or Excel) · WITH VOUCHERS workbook · SUBMITTED workbook · Any number of previous months' registers, for reference
Gives
Reviewed preview of every row · Tagged list of beneficiaries with a status dropdown · A Claimed And used column flagging vouchers used outside the month they were claimed
Open process

More processes go here

Add an entry to src/lib/processes.ts and drop a page under src/app/processes.