All templates

Automated Petpooja Payroll Hours Export

Every Monday, WebRun opens Petpooja, reads last week's staff attendance and shift logs, calculates hours, overtime, and late marks in a Google Sheet, and drafts a payroll run in Xero, left unposted for you to review before anyone is paid.

Runs on WebRun · Strict Lockdown policy
Every Monday at 7:00 AM WebRunorchestrates each step
1 Petpooja read staff attendance
2 Google Sheets calculate hours and overtime
3 Xero draft the payroll run
In short

How do I turn restaurant staff attendance into payroll?

Every Monday, WebRun opens Petpooja and reads last week's staff attendance and shift logs. It calculates hours, overtime, and late marks in a Google Sheet, applies each pay rate, and drafts a payroll run in Xero, left unposted for your review, so wages are ready to approve without anyone being paid on its own.

  • Weekly hours and overtime calculated with no manual timesheet
  • A payroll run drafted in Xero, approved only by you
  • Missed punches flagged before wages are reviewed

Built for restaurant owners · HR and payroll teams · multi-outlet operators · cafe managers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens web.petpooja.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Petpooja - read staff attendance
    petpooja.com
    WebRun in Petpooja: read staff attendance
    WebRun opens Petpooja to read staff attendance.
    • Open Petpooja and read last week's attendance and shift logs per staff member
    • Capture clock-in and clock-out times, breaks, and absences
    • Note late marks and any missed punches for review

    Done when Every staff member's hours for the week are captured.

  3. 2
    Google Sheets - calculate hours and overtime
    google.com
    WebRun in Google Sheets: calculate hours and overtime
    WebRun opens Google Sheets to calculate hours and overtime.
    • Calculate regular hours, overtime, and late deductions per person
    • Apply each staff member's pay rate to work out gross pay
    • Highlight missed punches or anomalies for a human to confirm

    Done when A per-staff hours and pay summary is ready in the sheet.

  4. 3
    Xero - draft the payroll run
    xero.com
    WebRun in Xero: draft the payroll run
    WebRun opens Xero to draft the payroll run.
    • Draft a payroll run in Xero using the calculated hours and pay
    • Map each staff member to their pay record
    • Leave the run as a draft for you to review and approve. Never finalise or pay it automatically

    Done when A draft payroll run is ready in Xero for your review.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
web.petpooja.com
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
Payroll draft · Xero
OutputWhat each run produces - A per-staff hours and overtime summary in Sheets plus a drafted Xero payroll run, left unposted for your review. Nothing is paid without you.
Text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it pay staff without me?

No. WebRun leaves the payroll run as a draft in Xero. You review the hours and amounts and approve the run yourself, so no one is paid until a human signs off.

How does it handle missed punches?

It flags any missing clock-in or clock-out in the sheet rather than guessing the hours, so you can correct an anomaly before the draft payroll run is reviewed.

Can it calculate overtime and late marks?

Yes. It applies your hours, overtime, and late rules to each person's attendance, then shows the workings in the sheet so every figure in the draft is easy to check.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.