Track your Epos Now gift card liability every week
Every Monday, WebRun opens Epos Now Back Office, reads the outstanding balance on all active gift cards, totals the liability, breaks it down by card age and value band, and appends a weekly snapshot to your Google Sheets liability tracker so finance has an up-to-date figure at all times.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track Epos Now gift card liability each week?
WebRun opens Epos Now Back Office every Monday, reads all active gift card balances, totals the outstanding liability, and logs a weekly snapshot to Google Sheets broken down by card age and value band. Any week-on-week spike above 20 percent is flagged automatically for finance review.
- Total gift card liability updated in Google Sheets every Monday without manual reporting
- Age and value band breakdowns ready for period-end provisioning
- Liability spikes flagged automatically so finance is never caught out
Built for retail finance teams · Epos Now users · store owners · hospitality operators
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
backoffice.eposnow.comin a real browser with your saved login - no setup, no API keys. -
1
Epos Now - read outstanding gift card balances
eposnow.com How to Automate Epos Now
WebRun opens Epos Now to read outstanding gift card balances. - Open Epos Now Back Office and navigate to Gift Cards or Vouchers report
- Pull all active gift cards with their current outstanding balance
- Group cards by age band: issued in last 30 days, 31 to 90 days, 91 to 365 days, and over 1 year
- Group by value band: under 10, 10 to 50, 51 to 100, and over 100
- Calculate total outstanding liability across all active cards
Done when Total gift card liability and breakdowns by age and value are captured from Epos Now.
-
2
Google Sheets - log weekly liability snapshot by age and value band
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log weekly liability snapshot by age and value band. - Append a new dated row to the liability tracker sheet with total outstanding liability
- Include the breakdown by age band and value band as additional columns
- Flag any week where total liability has grown more than 20 percent compared with the prior week
Done when This week's gift card liability snapshot is logged in Google Sheets with trend comparison.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
Why does gift card liability matter for finance?
Outstanding gift card balances are a liability on your balance sheet: you have received money but not yet delivered the goods. Tracking the total weekly helps you provision accurately and avoid surprises at period end.
Does it include expired gift cards?
No. WebRun reads only active gift cards with a remaining balance. Expired cards with zero balance are excluded. If your Epos Now account tracks expired card breakage separately, you can add that as an optional column.
Can it alert finance if the liability spikes?
Yes. WebRun flags any week where total liability has grown more than 20 percent compared with the prior week in the Google Sheets log. You can add a conditional email notification from Sheets if you want a proactive alert.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.