Step 1 of 5 — Your Situation

Before we look at your numbers,
tell us how things feel.

Your honest answers calibrate what your data means — not just what the numbers say in isolation.

How confident are you in your current collections process?

How often do customers pay you late?

When did you last formally review your credit terms with customers?

Step 2 of 5 — Your Industry & Risk Framework

Your numbers only matter
relative to your peers.

Select your industry and define your risk thresholds. You can use industry defaults or set your own — the analysis will apply whichever you choose.

Annual Revenue Range

SIC Code (Optional)

Risk Thresholds — Days Past Due

Low Risk

Current through 30 days past due

Medium Risk

31 through 60 days past due

High Risk

61+ days past due

Automatically anything above medium threshold

💡 These thresholds apply universally. Segment-level overrides can be set after your file is uploaded if your file contains a group or segment column.

Step 3 of 5 — Your Data

Upload your AR aging report
or enter it manually.

Export from QuickBooks, Xero, SAP, NetSuite, or any system. We support up to 30 columns — 10 identifier and 20 aging. You map every column. No assumptions.

📊

Drop your AR aging report here

Supports exports from QuickBooks, Xero, SAP, NetSuite, and more

CSV XLSX XLS

✅File loaded

📋 Where to export: QuickBooks → Reports → A/R Aging Detail → Export | Xero → Accounting → Aged Receivables | SAP → FBL5N → Export to spreadsheet

ℹ️ The tool supports up to 30 columns. Subtotal columns (1+, 91+) and percentage columns are automatically excluded from calculations. All mapping is done by you — nothing is assumed.

Step 4 of 5 — Column Mapping

Tell us how your business
tracks receivables.

Map each column in your file to the rIQ standard header. We have made our best guess — confirm or correct each one. Nothing is assumed. You control every field.

rIQ Column Mapping

Identifier: 0/10

Aging: 0/20

Excluded: 0

Average Daily Credit Sales ($) — Required for DSO

File Type Detected

Data Integrity Pre-Check

📡

Building Your AR Profile

Analyzing your portfolio against industry peers...

○ Reading and validating your data

○ Applying rIQ header standardization

○ Calculating cumulative aging metrics

○ Benchmarking against your industry

○ Scoring risk by threshold framework

○ Building your exception list

Step 5 of 5 — Your Results

—

Your AR Risk Assessment

Complete the steps to see your full analysis.

Cumulative Aging Metrics

Portfolio Metrics

Your Aging Distribution

—

Your Position vs. Peers

—

Customer Exception List

Flag accounts with balances past due beyond days

Your Action Plan

Download Your Enriched AR Report

Your file enriched with rIQ standard headers, cumulative metrics, risk tiers, validation flags, and days past due — ready to share with your team or advisors.

One last question — from you.

Based on what you just saw, how equipped do you feel to address your AR position on your own?

Before we look at your numbers,tell us how things feel.

Your numbers only matterrelative to your peers.

Upload your AR aging reportor enter it manually.

Drop your AR aging report here

Tell us how your businesstracks receivables.

rIQ Column Mapping

Your AR Risk Assessment

Download Your Enriched AR Report

One last question — from you.

Before we look at your numbers,
tell us how things feel.

Your numbers only matter
relative to your peers.

Upload your AR aging report
or enter it manually.

Tell us how your business
tracks receivables.