365 Retail Markets Automated Gift Card Liability Digest
Every Monday, WebRun opens 365 Retail Markets ADM, pulls the total outstanding Global Market Account balances and employer gift card liabilities across all locations, logs a weekly snapshot to Google Sheets, and posts the unredeemed stored value total to QuickBooks as a liability entry for accurate balance sheet reporting.
How do I automatically track micro market gift card and stored value liability each week?
WebRun pulls total outstanding Global Market Account and employer gift card balances from 365 Retail Markets ADM every Monday, logs a per-location stored-value liability snapshot to Google Sheets with week-on-week trends, and posts a liability entry to QuickBooks so the finance team has an accurate and current deferred revenue figure each week.
- Stored-value liability is tracked weekly without manual ADM exports or spreadsheet work
- QuickBooks receives a current liability entry every Monday for accurate balance sheet reporting
- Rapid accumulation of unredeemed balances is flagged before it becomes a reconciliation problem
Built for micro market operators · unattended retail finance teams · small business accountants · route 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
adm.365retailmarkets.comin a real browser with your saved login - no setup, no API keys. -
1
365 Retail Markets - pull outstanding GMA and gift card balances
365retailmarkets.com
WebRun opens 365 Retail Markets to pull outstanding GMA and gift card balances. - Open ADM and navigate to the account or stored value reports
- Pull the total outstanding balance across all active Global Market Accounts by location
- Pull the total unredeemed employer gift card and subsidy balance by location
- Calculate the combined stored value liability for each location and a fleet-wide total
Done when GMA and gift card balances are captured for every location with a combined stored value liability figure.
-
2
Google Sheets - log weekly stored-value liability snapshot
google.com
WebRun opens Google Sheets to log weekly stored-value liability snapshot. - Append a weekly row to the stored-value liability tracking sheet with the date, per-location balances, and fleet total
- Calculate week-on-week change in total liability to highlight rapid accumulation
- Flag any location where liability has grown more than 15 percent week over week
Done when Google Sheets has a new dated liability row for every location with week-on-week trend indicators.
-
3
QuickBooks - post liability entry for balance sheet reporting
- Create or update a liability account entry in QuickBooks for total outstanding stored value as of the current week
- Tag the entry with the date and source so it reconciles cleanly with the balance sheet
- Flag the entry for accountant review if the fleet total has changed by more than 10 percent from last week
Done when QuickBooks has a current weekly stored-value liability entry tagged for reconciliation.
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 stored value liability matter for my balance sheet?
Outstanding GMA balances and unredeemed gift cards are a financial liability because the business owes that value to customers. Tracking it weekly keeps your balance sheet accurate and helps your accountant handle deferred revenue correctly.
Does it include employer subsidy balances as well as customer GMA accounts?
Yes. WebRun pulls both employee-funded GMA accounts and employer-funded subsidy or gift card programs from ADM, so the total stored value liability figure covers all outstanding balance types.
Does it move money or adjust account balances automatically?
No. WebRun reads and reports the balances only. No funds are transferred, credited, or debited. All financial adjustments are handled by your accountant in QuickBooks.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.