Payroll Tool

💼 PNL&Co. Payroll Transformation EngineV2

Direct Deposit + Cash Payroll Processing for Cathy & Leona

📋 What You'll Need

Before you upload, download these two files from Zenoti:

• Zenoti Payroll Export — Go to Employee → Payroll → click the current pay period → Download. Save as CSV.
• Attendance Log — The daily check-in/check-out report (NOT the "Attendance Summary"). Save as CSV.

⚠️ Important: Always pick CSV when Zenoti asks for a format — not Excel. The tool reads CSV cleanly; Excel files sometimes don't open right.

🗓 How to Run Payroll (Wednesdays)

1. Upload your two files in Step 1 below.
2. If a Discrepancy Review section appears (Step 2), correct flagged employee hours.
3. Review Cash Payroll auto-fills (Step 3). Edit anything that's wrong.
4. Enter Front Desk hours if anyone covered the desk (Step 4). Skip if nobody did.
5. Check both verification boxes (Step 5).
6. Click "Process Payroll".
7. Send to Cathy using Excel download, copy-to-clipboard, or email button. See "Sending Payroll" further down.
8. On Saturday, pay cash people using the Venmo/CashApp buttons in the Cash Payroll Details section.

📤 Step 1: Upload Files

Zenoti Payroll Export (Excel/CSV) *

Attendance Log (CSV)

Used to count cash employee days and flag missed checkouts.

⚠️ Step 2: Hours Discrepancy Review

Employees below had missed checkouts or suspiciously short shifts in the attendance log. Zenoti's reported hours may be incorrect. Enter corrected hours to override.

💵 Step 3: Cash Payroll

Days worked are auto-counted from the attendance log. Commissions pulled from Zenoti. Edit any field if needed.

🖥️ Step 4: Front Desk Hours

Jennifer, Heather, and Judith are your regular FD fill-ins (pinned at top). Enter hours below for anyone who worked the front desk this pay period.

✅ Step 5: Pre-Submit Validations

I have calculated lunch clock-outs for all team members (30 min deducted for any shift over 8 hrs)

I have verified the Check-In/Out Log

🚀 Process Payroll

📊 Processing Results

📧 Cathy's Report (Payroll Vault)

Three ways to send Cathy the hours & commission breakdown:

📥 Download Excel for Cathy 📋 Copy Summary to Clipboard ✉️ Email Cathy

📘 Leona's Full Report

Complete payroll data with FD notes, commissions, and corrections — for internal records.

📥 Download Excel for Leona

💰 Cash Payroll Details

📥 Download Cash Payroll PDF

📨 Sending Payroll

To Cathy (Direct Deposit) — pick any one:

• Download Excel for Cathy — Saves a clean spreadsheet you can attach to an email.
• Copy Summary to Clipboard — Copies the formatted text (e.g. "Angel $1498.26 / 48.18hrs"). Paste it into a text, Slack, or email.
• Email Cathy — Opens a pre-filled email to cathy.carroll@payrollvault.com with the summary already in the body. Just click Send.

💡 If the "Email Cathy" button doesn't open Gmail the way you want, use "Copy Summary to Clipboard" instead and paste into a new Gmail message.

Cash Payroll (Saturday distribution)

• Look at the "Cash Payroll Details" section above (only appears after you click Process).
• Each person has a Venmo button (and María also has a CashApp button).
• Click their payment button → it opens their payment page in a new tab → pay them.
• For a printed record, click "Download Cash Payroll PDF" and save it for your files.

🛠 If Something Looks Wrong

If you see this…	Here's what to do
Names aren't showing up	You probably uploaded the wrong attendance file. Make sure it's the daily check-in/check-out log, NOT the "Attendance Summary". Both files must be CSV.
Cash days show 0 for everyone	The attendance file didn't load. Re-upload as CSV. If a person legitimately worked 0 days, that's fine — leave at 0.
Hours look way too low for someone	Zenoti might have missed their checkout. Check the Discrepancy Review section at the top — fix their hours there.
Someone is missing entirely	Check if they're in Zenoti's payroll export. If they're not in Zenoti, the tool can't see them. New hires need to be set up in Zenoti first.
Process Payroll button is grey	Make sure both verification checkboxes are checked AND the Zenoti file is uploaded.
Something else weird	Refresh the page and start over. Nothing is saved between sessions, so refreshing won't lose any real data — just whatever you typed in this session.

👥 Quick Reference: Who's Who

Cash People (Saturday payroll)

Name	Pay Rate	How They Get Paid
Ede	$100/day flat	Venmo
Jasmin	$13/hr Mon–Fri • $130/day Sat & Sun	Venmo
María	$110/day flat	Venmo or CashApp

Ede is also a Tech Assistant when working in the salon, but she's paid via cash payroll.

Direct Deposit — Admin

Name	Rate	Notes
Grace	$15/hr	Can help with FD if schedule permits
Mathania	$15/hr	📌 Hired as Front Desk — starts June 11
Mel	$20/hr	📌 Primary Front Desk — FD pay at her regular $20/hr

Direct Deposit — Tech Assistant

Name	Rate	Notes
Magaly	$12/hr	Listed as "Therapist" in Zenoti because she offers massage

Direct Deposit — Technicians (Commission)

Angel, Angy, Heather, Jennifer, Kerlin, Lucy, Rosana

FD-eligible (can cover front desk at $15/hr): Heather, Jennifer, Kerlin, Rosana

Owner

Leona — commission only. Hours not tracked for the Department of Labor.