Run your end-of-day cash reconciliation and flag variances
Every night after close, WebRun opens PDI Technologies, pulls cash-register and payment-method totals for each site, compares them against expected amounts, logs variances to a Google Sheet, and pushes a summary journal entry to QuickBooks so your accounting team starts the morning with clean books and every discrepancy already flagged.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automate end-of-day cash reconciliation for my convenience stores?
WebRun opens PDI Technologies each night after close, pulls cash-register and payment-method totals for every location, and compares them against expected amounts. Variances are logged to a Google Sheet with red highlights, and a summary journal entry covering all sales and over/short amounts is posted to QuickBooks automatically.
- Every register variance is flagged and logged by midnight
- QuickBooks journal entries are posted nightly without manual data entry
- Accounting team starts each morning with a clean, reconciled ledger
Built for convenience store accountants · c-store finance managers · fuel retail back-office teams
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
pditechnologies.com/increase-productivity/erp-back-officein a real browser with your saved login - no setup, no API keys. -
1
PDI Technologies - pull register totals and payment breakdowns
pditechnologies.com How to Automate PDI Technologies
WebRun opens PDI Technologies to pull register totals and payment breakdowns. - Open PDI Technologies and navigate to the End-of-Day report for each active location
- Pull total sales by payment method: cash, credit, debit, and fuel card
- Capture the over/short amount reported by each register
- Note any register showing a variance above $10
Done when All register totals and variances are collected for every active location.
-
2
Google Sheets - log variances by site and register
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log variances by site and register. - Open the reconciliation sheet and append a new row for each register with date, site, expected, actual, and variance columns
- Highlight in red any row where variance exceeds the threshold
- Add a summary row at the bottom with total sales and total variance for the day
Done when The reconciliation sheet is updated with all register data and variances are highlighted.
-
3
QuickBooks - record summary journal entry for the day
- Create a journal entry in QuickBooks with total sales by category for the day
- Post cash and card receipts to the correct income accounts
- Record any over/short amount to the designated variance account
- Save the journal entry and add a reference note with the date and location count
Done when A journal entry for the day is saved in QuickBooks with all payment method totals posted.
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
What happens if a register is over or short by a large amount?
Any variance above the threshold you set is highlighted in red in the Google Sheet. The QuickBooks journal entry still records the actual amount, and a note flags it for your accounting team to investigate.
Does it post journal entries to QuickBooks automatically?
Yes. End-of-day journal entries are internal accounting records, not external-facing actions, so WebRun posts them automatically. Your accountant can review and adjust them the next morning.
Can it handle multiple store locations in one run?
Yes. It processes every active location in PDI Technologies and produces one Google Sheets row per register, plus a single consolidated journal entry in QuickBooks for the full day.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.