← Knowledge base
Reporting & Analytics5 min read

Which reports does AirBills give you?

Find the right AirBills report: portfolio spend, bill trends, spikes, bill pay timing, missed bills, fees, arrears, receivables aging and ESG usage data pages.

AirBills has reports in every role. Property managers get spend, trend, spike and bill pay reports. Accountants get a financial dashboard, plain-English analytics, statements, aging and a cash forecast. Utility admins get bill coverage, fees, arrears and missed bills. Every list page exports as CSV, Excel or PDF.

Which report answers which question?

QuestionReport
Where does our utility money go?Property Manager › Company › Insights
Is this account running above normal?Property Manager › Reports › Bill Trends
Which bills spiked?Reports › Spikes (Property Manager and Utility Admin)
Were bills fetched and paid on time?Property Manager › Reports › Bill Pay
Was each bill split correctly?Property Manager › Reports › Bill Accuracy
Which bills never arrived?Missed Bills (Utility Admin, Accountant and Account Payables)
What fees are we paying?Utility Admin › Reports › All Fees
Which accounts has the utility stopped billing?Utility Admin › Reports › Arrears
What do residents owe, and how old is it?Accountant › Receivables › Aging
What will our cash look like?Accountant › Receivables › Forecast

How do you read portfolio spend?

  1. Open Property Manager › Company › Insights. Two headline numbers show total spend and total transactions.
  2. Switch the timeframe on the Spend Over Time chart: This Month, Last 12 Months, This Year or All Time.
  3. Turn on Compare to previous period to overlay last period's bars and show the percentage change.
  4. Break spend down by Billers, Bill Type, Market or Region. Rows are sorted by spend, largest first.

Insights covers the whole portfolio over the preset timeframes. It has no export, custom date range or entity filter. For those, use a list report and filter it.

How do you find unusual bills?

There are two reports, and they use different rules.

Bill Trends compares each account's latest bill with its 3, 6 and 12-month averages.

  1. Open Property Manager › Reports › Bill Trends. Flagged accounts are listed first.
  2. Read the T-3, T-6 and T-12 columns beside the latest bill.
  3. Filter by bill type, biller, city, state or region.

An account is flagged when its latest bill is more than 25% above its T-12 average. This is a fixed rule.

Spikes lists individual bills that came in above their expected amount.

  1. Open Reports › Spikes. Bills are sorted by spike percentage, largest first.
  2. Read the cards at the top: total spikes, average spike and high spikes.
  3. Filter by bill type, biller, location or period.
  4. Open the AI spike agent on a row to investigate that bill.

Which bills count as spikes is set per bill type and occupancy on Settings › Spike Threshold.

How do you check payment and billing quality?

What do the accounting dashboards show?

Accountant › Overview › Dashboard has four headline numbers: Cash Health Score, Bill Processing Rate, Collection Efficiency and Risk Exposure. Hover the help icon on a card to see what goes into it. Below, a chart shows the cash position at each month-end over the last six months, and a breakdown shows how many bills are Auto-Approved, Pending Review, Flagged or in Exceptions.

Account Payables › Dashboard › Overview shows the Processing Health Score, Auto-Approval Rate, Payment Efficiency and Exception Volume. Account Receivables › Dashboard › Overview shows the collection health score, collection rate, aging quality and outstanding amount, with aging buckets.

These dashboards are read-only. Open the matching queue from the sidebar to act.

How do you ask a question in plain English?

  1. Open Accountant › Overview › Analytics.
  2. Pick the CFO, AR or AP view. The view changes the suggested questions.
  3. Type a question, or click one of the quick questions. You get a short summary plus the result as a chart and a table.
  4. Switch between Chart View and Table View.
  5. Click Subscribe to Report to name the result and pick a weekly, monthly or quarterly frequency. The report is delivered to your email.

Questions are matched to topics such as auto-approval rate, flag reasons, missing bills by biller, processing time by stage and bills by status.

How do you report on receivables?

  1. Open Accountant › Receivables › Aging. Each invoice shows days outstanding, its aging bucket and a risk level.
  2. Open the aging settings to change how many days overdue counts as bad debt. The default is 60 days.
  3. Open Receivables › Forecast and pick the next 30, 60 or 90 days. The page shows the forecast cash position with optimistic, realistic and conservative scenarios.

Aging buckets are Current, 1-30, 31-60, 61-90 and 90+ days. Risk is High at 90 or more days outstanding and Medium at 60 or more.

What do the Utility Admin reports cover?

What ESG reporting exists today?

The ESG role's working reports are the Data pages: Data › Energy, Gas, Water and Sewer. Each has totals for records, usage, cost and markets, and exports as CSV, Excel or PDF. Use Settings › Properties and Settings › Markets to choose which homes and markets count.

Three ESG pages are placeholders today: Dashboard › Overview, Usage › GHG and Cost › Spend. AirBills does not calculate greenhouse gas emissions yet. The inputs a calculation needs (kWh and kBtu per home and billing period) are on the Energy and Gas data pages.

How AirBills handles it

AirBills builds each report from the bills, payments and accounts it already manages, so there is nothing to upload. Thresholds you set in Settings decide what counts as a spike.

Billing That Runs Itself

Automate tenant billing, cut disputes, and reclaim hours every week.

Book a Demo