TouchBistro Automated Gift Card Liability Tracking
Every Monday, WebRun opens TouchBistro, pulls the current outstanding gift card balances, calculates total gift card liability, compares it to the prior week, logs the summary to Google Sheets with a running trend, and posts a brief digest to Slack so your finance team stays on top of this often-overlooked balance sheet item.
How do I automatically track gift card liability from TouchBistro?
WebRun opens TouchBistro every Monday, pulls the current outstanding gift card balances and weekly issued vs. redeemed totals, logs the liability snapshot with a week-over-week trend to Google Sheets, and posts a brief summary to Slack so your finance team never loses track of this balance sheet item.
- Gift card liability is tracked weekly without any manual report-pulling
- Week-over-week trend in Sheets supports month-end and year-end close
- Finance team gets a Monday morning summary without logging into the POS
Built for restaurant owners · restaurant accountants · hospitality finance teams · multi-location 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
app.touchbistro.comin a real browser with your saved login - no setup, no API keys. -
1
TouchBistro - pull outstanding gift card balances
touchbistro.com
WebRun opens TouchBistro to pull outstanding gift card balances. - Open TouchBistro Reporting and navigate to the Gift Card report
- Capture total outstanding gift card balance, number of active cards, total issued this week, and total redeemed this week
- Note any gift cards issued but never activated or cards with zero remaining balance
Done when Current gift card totals are captured with issued and redeemed breakdowns.
-
2
Google Sheets - log weekly liability total and trend
google.com
WebRun opens Google Sheets to log weekly liability total and trend. - Append a new row to the gift card liability log with the date, total outstanding balance, cards issued, cards redeemed, and week-over-week change
- Calculate the percentage change from last week and add it to the row
- Keep the multi-week log for quarterly and year-end financial review
Done when This week's gift card liability row is logged alongside prior weeks in Sheets.
-
3
Slack - post digest to finance channel
slack.com
WebRun opens Slack to post digest to finance channel. - Post a brief digest to the finance or management channel with total outstanding liability, week-over-week change, and any notable spike
- Link to the Google Sheets log for the full trend
- Flag any week where outstanding liability jumped more than your threshold
Done when Finance team has this week's gift card liability summary in Slack.
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 my restaurant's finances?
Outstanding gift card balances are a real liability on your books: money received that has not yet been earned. Tracking them weekly prevents surprises at month-end close and supports accurate financial reporting.
Can it track gift cards from third-party providers as well?
WebRun reads gift card data as reported in TouchBistro. Third-party gift card programs that are not integrated into TouchBistro are not visible in this workflow.
How far back does the trend data go in Google Sheets?
The log grows week over week indefinitely. Once you have a few months of data, you can chart seasonal trends and estimate breakage rates for your accountant.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.