Automated Sintel Bulk Bin Reconciliation
Every Monday, WebRun opens Sintel Systems, compares each bulk bin's recorded weight sold against its counted starting and ending stock, logs any variance to Google Sheets, and drafts a shrinkage adjustment in QuickBooks Online for your accountant to review before it posts.
How do I reconcile bulk bin scale weights each week?
WebRun reconciles your bulk bin scales every week. It compares each bin's weight sold in Sintel Systems against the counted starting and ending stock, logs any variance to Google Sheets, and drafts a shrinkage adjustment in QuickBooks Online for your accountant to review, so shrinkage gets caught and documented instead of quietly eating into margin.
- Scale variance gets caught and valued every week, not once a year
- A draft adjustment is ready before your accountant even asks
- Shrinkage patterns show up bin by bin instead of hiding in one total
Built for candy shops · chocolatiers · bulk bin retailers · shop accountants
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
sintelsystems.com/candy-shop-posin a real browser with your saved login - no setup, no API keys. -
1
Sintel Systems - pull weight sold by bin
sintelsystems.com
WebRun opens Sintel Systems to pull weight sold by bin. - Open Sintel Systems and pull each bulk bin's weight sold for the week
- Compare it against the counted starting and ending stock weight for that bin
- Calculate the variance in weight and dollar value for each bin
Done when Every bulk bin has a calculated variance between recorded sales and counted stock.
-
2
Google Sheets - log the variance by bin
google.com
WebRun opens Google Sheets to log the variance by bin. - Open the weekly reconciliation tracker in Google Sheets
- Log each bin's variance in weight and dollar value
- Flag any bin with a variance over your set threshold
Done when Every bin's variance is logged with flagged bins highlighted.
-
3
QuickBooks Online - draft the shrinkage adjustment
- Draft a shrinkage adjustment entry for the flagged variance total
- Attach the bin level detail from the reconciliation sheet
- Leave the entry as a draft. Never post it to the books automatically
Done when A draft shrinkage adjustment is waiting in QuickBooks Online for your accountant's review.
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 post the shrinkage adjustment to the books automatically?
No. WebRun only drafts the adjustment in QuickBooks Online. Your accountant reviews the bin level detail and posts it themselves.
What counts as a variance worth flagging?
Whatever threshold you set, in weight or dollar value. Tell WebRun your threshold and only bins over it get flagged for review.
Does it need a manual bin count every week?
Yes. It compares Sintel Systems sales against a counted starting and ending weight, so someone still needs to weigh each bin. WebRun handles the comparison and the paperwork after that.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.