All templates

Automated Lavu POS Gift Card Liability Digest

Every Monday, WebRun opens Lavu, reads all active gift card balances and recent issuances and redemptions, totals the outstanding liability, logs the figures to a running Google Sheet, and posts a summary to Slack for the finance team.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Lavu read active gift card balances and weekly activity
2 Google Sheets log weekly liability totals to running sheet
3 Slack post gift card liability summary
In short

How do I automatically track Lavu POS gift card liability each week?

Every Monday, WebRun reads all active gift card balances from Lavu, totals the outstanding unredeemed liability, captures new issuances and redemptions for the week, logs the figures to a Google Sheet, and posts a concise summary to Slack for the finance team. Cards expiring within 30 days are flagged automatically.

  • Gift card liability tracked weekly as a real balance-sheet item
  • Expiring cards flagged 30 days in advance so breakage is handled correctly
  • Running Google Sheet log makes audits and period-end reconciliation straightforward

Built for restaurant owners · restaurant finance teams · hospitality accountants · multi-location restaurant operators

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 lavu.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Lavu - read active gift card balances and weekly activity
    lavu.com
    WebRun in Lavu: read active gift card balances and weekly activity
    WebRun opens Lavu to read active gift card balances and weekly activity.
    • Open Lavu and navigate to the Gift Card report section
    • Read total outstanding (unredeemed) gift card balances across all active cards
    • Capture new gift cards issued this week, total value issued, and total value redeemed
    • Note any cards that have expired or are near expiry

    Done when All gift card balances, issuances, redemptions, and expiry data for the week are captured.

  3. 2
    Google Sheets - log weekly liability totals to running sheet
    google.com
    WebRun in Google Sheets: log weekly liability totals to running sheet
    WebRun opens Google Sheets to log weekly liability totals to running sheet.
    • Open the gift card liability Google Sheet
    • Append a new row with this week's date, outstanding balance, new issuances, redemptions, and net change
    • Highlight any week where the outstanding liability increased by more than 10 percent

    Done when This week's gift card liability figures are logged to the Google Sheet.

  4. 3
    Slack - post gift card liability summary
    slack.com
    WebRun in Slack: post gift card liability summary
    WebRun opens Slack to post gift card liability summary.
    • Post a summary to the finance Slack channel: outstanding liability, new issuances, total redeemed, and net change from last week
    • Flag any cards expiring in the next 30 days
    • Include a link to the full Google Sheet

    Done when The weekly gift card liability summary is posted to Slack for the finance team.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
lavu.com
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Liability digest · Slack
OutputWhat each run produces - A Google Sheet row with weekly gift card liability totals plus a Slack summary with outstanding balance, issuances, redemptions, and expiring cards.
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

Does it contact gift card holders or post anything publicly?

No. The digest is an internal report only, posted to the finance team's Slack channel and logged in Google Sheets. No guest communication is involved.

Why does gift card liability matter on the balance sheet?

Unredeemed gift card balances are a liability on your books. Tracking them weekly ensures your financial statements reflect what the business owes to cardholders and flags unusual spikes in issuance or a drop in redemption.

What happens when a gift card expires?

Lavu records expiry dates, and WebRun flags any cards expiring in the next 30 days in the Slack summary so you can handle them according to your local breakage accounting rules before they lapse.

Put this on autopilot.

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