Skip to content
Showcase

Solutions for Edge Members

Quarterly purchase report designed for Edge members using Q360.

Edge rebate reporting

Edge-aligned AV integrators in USAV's purchasing collective report eligible vendor purchases each quarter. Late submissions, incorrect categories, and ineligible purchases can lower the rebate.

Q360 Edge Quarterly Report demo Open on Loom

Q360 does not include a native Edge purchase report. Teams can spend a day or two each quarter exporting vouchers, filtering vendors, and totaling purchases by manufacturer in Excel.

Why it matters

We've seen a $10-30k difference in quarterly rebates for mid-size integrators depending on reporting accuracy.

The Q360 purchase report

We built the report to replace manual Excel work for our Q360 clients. It runs in Live Data or Quick Views and produces an audit-ready report for the selected year and quarter.

Get your Edge rebate right without a day of spreadsheet work. The data's already in Q360: we just make it readable.
Rubi Works, Edge Quarterly Report

Report features

  • Eligible purchases by quarter: select the current quarter, trailing four quarters, or a historical period.
  • Configurable vendor inclusion: control which vendors count through customer group assignments inside Q360 itself
  • Summary by vendor or manufacturer: switch views depending on whether you're reporting to USAV or reviewing internal trends
  • Item-type filtering: restrict to A-type (serialized equipment), Q-type (non-serialized), or K-type (kits), or combinations that match Edge's reporting taxonomy
  • Voucher-based totals: count completed purchases, excluding orders that were later canceled.

How it works.

1. Vendor classification Create two customer groups in Q360 maintenance: USAV_ON for eligible vendors and USAV_OFF for tracked vendors outside the program. Initial classification takes about 20 minutes.
2. Report runs against voucher data The report applies vendor group and date filters to voucher lines, then summarizes them in the format Edge expects.
3. Access via Live Data or Quick Views Located under Live Data > Accounting or Accounting > Quick Views depending on how your Q360 menus are configured. Users open it like any other report.
4. Export to Excel for submission Export to Excel in Q360 and paste the results into the USAV vendor portal.

Deployment.

  1. Create the customer group codes (USAV_ON, USAV_OFF) in Q360 maintenance and activate them
  2. Assign your Edge vendors to the USAV_ON group. We provide a one-time classification template based on current Edge vendor lists
  3. Deploy the SQL report definitions. Contact customer support for the definitions. They install into your Q360 database like any other custom report.
  4. Validate against a known quarter. We help compare the output to a prior manual submission.
  5. Go live. Next quarter's report is a 10-minute job.

Frequently asked questions.

We're not on Edge. We're on another purchasing program. Can this work for us?

Yes. We've adapted the same vendor classification and voucher reporting approach for PSA, BTX, and CI Allies.

What if a vendor switches in or out of the Edge program mid-quarter?

The report uses effective dates. A vendor that joins on April 1 is eligible beginning April 1, while Q1 purchases retain their previous classification.

Can you handle historical re-reporting?

Yes. Rerun any date range for corrected vendor classifications or missed purchases. Corrections mode shows changes from a previously submitted report.

Let's put this to work for your team.

Book a 30-minute call. We'll walk through your current stack and show you exactly how we'd approach your situation.