All templates

KORONA POS Automated Gift Card Liability Tracking

Every Monday, WebRun opens KORONA POS, pulls the full list of active gift cards with their remaining balances, calculates the total outstanding liability, segments it by cards sold in the last 30 days versus older cards, and appends a dated summary row to your Google Sheet so your bookkeeper has a running gift card liability log for accurate financial reporting.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 KORONA POS pull active gift card balances and calculate total liability
2 Google Sheets log the weekly liability summary with segment breakdown
In short

How can I automatically track gift card liability for my smoke shop?

Every Monday, WebRun pulls all active gift card balances from KORONA POS, calculates the total unredeemed liability, segments it by card age, and appends a dated row to your Google Sheet. Your bookkeeper has an accurate, up-to-date gift card liability figure every week without pulling any manual report.

  • Bookkeepers have an accurate weekly gift card liability figure without any manual pulls
  • Card-age segmentation highlights dormant balances that may need accounting treatment
  • A running trend chart shows how liability grows or shrinks with sales and redemptions

Built for smoke shop owners · vape shop bookkeepers · tobacco retail accountants

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

  2. 1
    KORONA POS - pull active gift card balances and calculate total liability
    koronapos.com
    WebRun in KORONA POS: pull active gift card balances and calculate total liability
    WebRun opens KORONA POS to pull active gift card balances and calculate total liability.
    • Open KORONA POS and navigate to the gift card management report
    • Pull all active gift cards with their card number, issue date, and remaining balance
    • Calculate the total unredeemed balance across all active cards
    • Segment the total into cards issued in the last 30 days and cards older than 30 days
    • Note the number of cards with a balance below $5 as likely dormant

    Done when Total gift card liability is calculated with issue-date segmentation and dormant card count.

  3. 2
    Google Sheets - log the weekly liability summary with segment breakdown
    google.com
    WebRun in Google Sheets: log the weekly liability summary with segment breakdown
    WebRun opens Google Sheets to log the weekly liability summary with segment breakdown.
    • Append a new row to the gift card liability sheet with today's date, total liability, 30-day new card balance, older card balance, and dormant card count
    • Update a running total chart in the summary tab to show the liability trend over time

    Done when The weekly liability row is logged and the trend chart updated.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
koronapos.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Liability digest · Google Sheets
OutputWhat each run produces - A dated row in Google Sheets with total gift card liability, segmented by card age, plus a dormant card count and a running trend chart.
Spreadsheet row
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

Why does gift card liability matter for bookkeeping?

Outstanding gift card balances are a financial liability on your books because the money has been received but the goods have not yet been provided. Tracking the total weekly keeps your balance sheet accurate.

Can it flag cards that may be eligible for escheatment under state law?

WebRun can flag cards older than a configurable age, for example 3 years, as potentially subject to your state's unclaimed property rules. Always consult your accountant for the specific escheatment obligation in your state.

Does it reveal individual customer card balances?

The weekly digest logs aggregate liability totals only. Individual card numbers and balances are captured internally for the calculation but are not included in the Google Sheets output.

Keep going

Related templates

KORONA POS Automated Age-Verification Compliance Alerts
Every morning, WebRun scans KORONA POS for tobacco and vape transactions where the age-verification prompt was bypassed or skipped, and posts a flagged compliance report to Slack so management can act before a fine lands.
KORONA POS›Slack
KORONA POS Automated Daily Sales Digest
Every evening, WebRun pulls the day's totals from KORONA POS, formats a clean summary by category, and posts it to your Slack channel so you always know where you stand.
KORONA POS›Slack
KORONA POS Automated End-of-Day Reconciliation
Every evening, WebRun pulls the KORONA POS end-of-day report, compares expected cash to the blind drop count, flags any discrepancy, and posts the reconciliation summary to a Google Sheet.
KORONA POS›Google Sheets

Put this on autopilot.

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

Deploy this workflow Talk to us