All templates

Automated FFL Acquisition Reconciliation

Every morning, WebRun pulls yesterday's shipments and invoices from RSR Group, compares each serialized firearm against the acquisitions recorded in FastBound, logs any serial that is on an invoice but missing from the bound book to a Google Sheet, and lists the gaps for staff to correct.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 RSR Group pull yesterday's firearm receipts
2 FastBound match against logged acquisitions
3 Google Sheets flag serials missing from the book
In short

How do I reconcile distributor receipts against my FFL bound book each day?

Every morning, WebRun pulls yesterday's firearm receipts from RSR Group and matches each serial against the acquisitions recorded in FastBound. It logs any serial that is on an invoice but missing from the bound book to a Google Sheet, so your staff can enter the acquisition before a distributor delivery ever slips through unrecorded.

  • Unrecorded distributor firearms surface the next morning, not at audit
  • Every RSR serial is checked against the bound book daily
  • Staff get a short gap list instead of re-checking every invoice

Built for FFL dealers · gun stores · receiving clerks · compliance managers

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens rsrgroup.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    RSR Group - pull yesterday's firearm receipts
    rsrgroup.com
    WebRun in RSR Group: pull yesterday's firearm receipts
    WebRun opens RSR Group to pull yesterday's firearm receipts.
    • Open RSR Group and review the firearm invoices and shipments dated yesterday
    • Capture the manufacturer, model, and serial number for each firearm received
    • Note the invoice number tied to each serial

    Done when Every serialized firearm received from RSR yesterday is listed with its invoice.

  3. 2
    FastBound - match against logged acquisitions
    fastbound.com
    WebRun in FastBound: match against logged acquisitions
    WebRun opens FastBound to match receipts against logged acquisitions.
    • Open FastBound and search the A&D bound book for each received serial
    • Confirm the acquisition was logged with the matching manufacturer, model, and date
    • Mark any serial that is on an RSR invoice but has no acquisition record

    Done when Each received serial is confirmed present or marked missing in the bound book.

  4. 3
    Google Sheets - flag serials missing from the book
    google.com
    WebRun in Google Sheets: flag serials missing from the book
    WebRun logs each unrecorded serial to the reconciliation sheet.
    • Open your reconciliation Google Sheet and add a row for every serial missing from the bound book
    • Record the manufacturer, model, serial, and RSR invoice number
    • Leave a clear note that staff need to enter the acquisition in FastBound

    Done when The sheet lists every distributor serial not yet acquired in the book.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
rsrgroup.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Reconciliation gaps · Google Sheets
OutputWhat each run produces - A Google Sheet of RSR serials that are on an invoice but not yet acquired in the FastBound bound book.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it enter acquisitions in FastBound for me?

No. WebRun only reads both systems and lists the serials that are missing from your bound book. Your staff enter each acquisition in FastBound so a person owns every record that lands in the book.

How does it match a receipt to a bound-book entry?

It matches on serial number first, then confirms the manufacturer and model line up. Any serial on an RSR invoice with no matching FastBound acquisition is flagged as a gap.

What if a serial was logged under a different date?

It searches the full bound book by serial, not just yesterday, so an acquisition entered a day late is still found and is not flagged as missing.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.