Nurse Shift & Pay Reconciler

Unzip the download and read START-HERE.txt. In Google Drive choose New > File upload and select Nurse-Shift-Pay-Reconciler.xlsx. Open it with Google Sheets and choose File > Save as Google Sheets if shown. Work in the converted copy and keep an untouched blank backup. The PDF walks through the exact cells for a fictional first shift.

The supplied file is XLSX. Its converted desktop Google Sheets workflow was tested in Chrome, including live calculations, blocking checks, bottom-tab navigation, grouping and focused printing. Excel and mobile compatibility are not advertised. Google Sheets conversion may not retain worksheet protection; edit only peach inputs and keep backups.

Gross is pay before tax and other deductions. Enter payslip gross, not the net amount deposited into your bank. The workbook does not calculate tax, deductions or take-home pay.

The employer's recurring seven-day workweek determines the supported weekly rate. A payslip may cover different dates or several weeks. Review every complete workweek touching that payslip, including days outside its dates. Each shift segment is linked to both a Week ID and a Period ID.

No. You enter applicable overtime hours and ordinary eligible differential hours and rates. Overtime hours are already part of total worked hours. The workbook calculates the additional half-rate premium from the complete week's supported regular rate; it does not decide legal eligibility or premium-window rules.

Unknown rules, salary, 8-and-80, daily/double-time arrangements, premium credits, bonuses, paid leave or other nonworked pay, on-call and other unsupported components block this calculation. Do not omit them from actual payslip gross or select No to hide them. Ask your payroll team which arrangement applies before relying on the estimate.

Read the Check column and Dashboard Affected workweeks. Finish required inputs and review each entire workweek. Enter reviewed hours, straight-time earnings and overtime totals as values, confirm no unsupported components and mark complete only when true. Changed reviewed totals withhold the comparison until reviewed again.

Yes, within the supported calculation. Enter full local start and end dates and times. Split a shift at either a workweek or payslip boundary and allocate hours and breaks once. Local times do not detect clock changes automatically; use employer-confirmed worked paid hours after breaks and an explanatory note when needed.

No. It compares the entered actual gross with an estimate from your recorded inputs under this limited model. Check records, rates, allocations, missing components and employer rules. A zero difference is not independent payroll approval, and no recovery of money is promised.

The prepared workbook has 60 workweeks, 60 payslip periods, 600 shift segments and 200 review entries. A boundary split consumes another segment, so 600 segments does not mean 600 complete shifts.

Private testing observed a compact one-page Dashboard and a selected final Review Log row with repeated headers in converted Google Sheets. Use current-sheet/fit-to-page or select populated review cells; results depend on settings and content. The files are for one user's personal use, with no resale, redistribution or sharing.

Email contact@kourchal.com for product-fit, setup or file questions. Do not send patient information, passwords, bank details or unredacted payslips. Keep sensitive evidence securely elsewhere and put references in the Review Log.