Track your gift card liability so it never surprises you
On the first Monday of each month, WebRun opens Bookmanager, pulls all outstanding gift card balances grouped by issuance quarter, logs the liability totals to your Google Sheet, and sends a summary digest to your Telegram so you always know the outstanding liability before month-end close.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track my bookstore's gift card liability each month?
WebRun opens Bookmanager on the first Monday of each month, pulls all outstanding gift card balances grouped by issuance quarter, logs the liability totals to your Google Sheet as a running record, and sends you a concise digest via Telegram so month-end never catches you off guard.
- Your total gift card liability is logged and trended in Google Sheets every month
- Long-dormant cards are flagged automatically so you can review them on your schedule
- Month-end close no longer surprises you with an unreported liability figure
Built for independent bookstore owners · bookstore bookkeepers · indie bookseller 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
bookmanager.comin a real browser with your saved login - no setup, no API keys. -
1
Bookmanager - pull outstanding gift card balances by issuance period
bookmanager.com How to Automate Bookmanager
WebRun opens Bookmanager to pull outstanding gift card balances by issuance period. - Open Bookmanager and navigate to the gift card balance report
- Pull all unredeemed gift cards with their current balance, issuance date, and last-used date
- Group balances by issuance quarter (for example, Q1 2025, Q2 2025) to age the liability
- Calculate the total outstanding liability and note any cards that have not been used in more than 24 months
Done when All outstanding gift card balances are captured, grouped by quarter, with a total liability figure.
-
2
Google Sheets - log the liability totals as a monthly record
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the liability totals as a monthly record. - Open the gift card liability tracking Google Sheet
- Append a new row for this month's date with the total outstanding balance and the quarter-by-quarter breakdown
- Flag any quarter cohort where the outstanding balance has increased month-over-month
- Note the count of cards unused for more than 24 months as a separate column
Done when This month's gift card liability is logged to the Google Sheet with quarter breakdown.
-
3
Telegram - send the monthly liability digest to your private chat
telegram.org How to Automate Telegram
WebRun opens Telegram to send the monthly liability digest to your private chat. - Format a concise digest message with the total outstanding liability at the top
- List the breakdown by issuance quarter with the amount for each
- Note the count and total of long-unused cards and your jurisdiction's relevant rules for dormancy if applicable
- Send to your private Telegram chat
Done when The monthly gift card liability digest is delivered to your Telegram.
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 expire or cancel any gift cards automatically?
No. WebRun only reads and reports the data. Any decisions about dormant cards are made by you in line with your local consumer protection rules.
How does it know which quarter to assign a card to?
It reads the issuance date recorded on each gift card in Bookmanager and groups by calendar quarter from that date.
Can I see a trend over time?
Yes. The Google Sheet grows each month as new rows are appended, so you can chart the total outstanding liability trend over any period you choose.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.