Know your gift card liability before it surprises your books
Every Monday, WebRun opens ECRS CATAPULT gift card management, reads all outstanding balances, calculates total unredeemed liability and week-over-week change, logs the figures to Google Sheets, and emails a concise digest to the owner and accountant.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track and report grocery store gift card liability each week?
WebRun opens ECRS CATAPULT gift card management every Monday, reads all outstanding balances, calculates total unredeemed liability and the week-over-week change, logs the figures to Google Sheets, and emails a concise digest to the owner and accountant before the Monday accounting review.
- Weekly gift card liability figure on the owner's desk every Monday
- Week-over-week trend tracked automatically in Google Sheets
- Accountant has accurate liability data without manual CATAPULT lookups
Built for independent grocery store owners · grocery store accountants · supermarket finance managers
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
www.ecrs.comin a real browser with your saved login - no setup, no API keys. -
1
ECRS CATAPULT - read outstanding gift card balances
ecrs.com How to Automate ECRS CATAPULT
WebRun opens ECRS CATAPULT to read outstanding gift card balances. - Open CATAPULT gift card management and pull the current outstanding balance for all active gift cards
- Note the number of active cards, the total outstanding balance, and cards issued or redeemed this week
- Capture the average balance per card and flag any card with a balance over $200 for review
Done when All gift card balances and weekly movement figures are captured.
-
2
Google Sheets - log liability and compute week-over-week change
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log liability and compute week-over-week change. - Append a new row to the gift card liability tracking Sheet with today's date and this week's figures
- Compute week-over-week change in total liability using the Sheet formula
- Confirm the row saved without errors
Done when This week's liability figure is logged and the trend is visible.
-
3
Gmail - email the digest to owner and accountant
gmail.com How to Automate Gmail
WebRun opens Gmail to email the digest to owner and accountant. - Compose a digest email summarising total outstanding liability, card count, and week-over-week change
- Address it to the owner and accountant distribution list
- Send the email so it arrives before the Monday accounting review
Done when The gift card liability digest is in the owner's and accountant's inbox.
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
Will it contact gift card holders or make any changes to card balances?
No. WebRun reads balances only for reporting purposes and never modifies a card balance or contacts a cardholder.
Why does my accountant need a weekly gift card liability figure?
Outstanding gift card balances are a liability on your books. A weekly digest keeps the figure current so your accountant can record it accurately rather than relying on a once-a-year snapshot.
Can it flag dormant cards that have not been used in over a year?
Yes. You can configure a dormancy threshold and WebRun will include a count of cards inactive beyond that period in the digest, which is useful for state unclaimed-property compliance.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.