Mon – Fri, 9:00am – 5:30pm ET
Call (516) 548-1622 / sales@riveredgeadvisors.com
River Edge Advisors — Complete Back Office Solution River Edge Advisors Fractional CFO & Back Office Book a Consultation
AI, Dashboards & Custom Tools

Dashboards, AI insight and tools built around how you decide

Most businesses get a P&L three weeks after month end and still cannot say which customers or jobs made money. We give owners live visibility instead. Dashboards run on the metrics you manage against, AI-assisted analysis explains what changed, and we build tools for the decisions you face weekly.

Profitability dashboard — illustrative
Auto-refreshed daily
Revenue MTD
$1.30M
104% of plan
Gross margin
38.4%
+2.1 pts vs. Q2
Cash on hand
$1.42M
13-wk low: $1.10M
DSO
41 days
−6 days since Jan
Gross margin by customer
Customer A — Retail portfolio
$482,000 44% +3 pts
Customer B — Industrial
$361,500 36% +1 pt
Customer C — Municipal
$298,200 27% flat
Customer D — Legacy contract
$154,800 9% −12 pts
Where you made and lost money AI-flagged, CFO-reviewed
−$34,200 Customer D is now losing money

Margin fell from 21% to 9% after three jobs ran over on labor. The contract was priced in 2023 and never re-rated for the current wage base. Re-price at renewal or walk.

+$61,800 Retail portfolio carried the quarter

Customer A's margin rose 3 points on better crew scheduling, the same work with 140 fewer field hours. Worth replicating on the industrial accounts.

−$18,400 Subcontractor costs outran billing

Sub spend rose 9% while change orders were billed at the old rate on two projects. Change-order pricing is the leak, not sub rates.

+$12,600 Collections freed cash

DSO improved 6 days, pulling roughly $12.6k of cash forward. Two accounts over 90 days still represent $41k of exposure.

Illustrative figures. Your dashboard is built on your own accounts, customers and jobs.

How we work with you

01

Start with your decisions

We ask what you are actually trying to decide: which jobs to bid, which customers to keep, whether you can afford the hire, then work backward to the numbers that answer it.

02

Build the dashboard

Your metrics on your own books, reporting down to the customer, job, property or provider level. Live, not a static monthly PDF, and available whenever you want to look.

03

Add AI-assisted analysis

We use AI to read the variances and flag what moved and why: unusual spend, margin slipping on a job, a customer trending toward a cash problem. Exceptions come to you instead of sitting buried in a report.

04

Build custom tools

Job bid calculators, pricing and margin models, cash planners, commission or draw schedules. Whatever you run today in a fragile spreadsheet, built properly around your business.

05

Review it with a CFO

A standing monthly session where a partner walks the numbers with you: what changed, what it means, and what to do about it.

KPI library

Metrics we track for clients

This is a starting menu rather than a fixed package. We build the dashboard around the decisions you are trying to make, and most clients end up running 8 to 15 of these.

Profitability

  • ·Gross margin by customer
  • ·Gross margin by job or project
  • ·Margin by location and service line
  • ·Contribution margin per unit
  • ·EBITDA and EBITDA margin
  • ·Budget vs. actual variance
  • ·Breakeven revenue
  • ·Revenue per employee

Job & project costing

  • ·Estimated vs. actual cost
  • ·Work in progress (WIP) schedule
  • ·Over/under billing
  • ·Change order impact
  • ·Labor efficiency ratio
  • ·Cost to complete

Cash & working capital

  • ·13-week cash forecast
  • ·Cash conversion cycle
  • ·Runway in months
  • ·DSO, DPO and DIO
  • ·Free cash flow
  • ·Early-pay discount capture

Receivables & payables

  • ·AR aging by bucket
  • ·Collection effectiveness index
  • ·Bad debt as % of revenue
  • ·AP aging and on-time payment rate
  • ·Vendor spend concentration

Customer & revenue

  • ·Customer concentration %
  • ·Revenue retention and churn
  • ·Lifetime value and CAC
  • ·Repeat purchase rate
  • ·Recurring vs. one-time revenue

Real estate

  • ·NOI by property
  • ·Occupancy and rent roll collections
  • ·DSCR and covenant headroom
  • ·Operating expense ratio
  • ·Construction draw status
  • ·Distribution waterfall position

Healthcare

  • ·Revenue and margin per provider
  • ·Payor mix and net collection rate
  • ·Collections per visit
  • ·Denial and write-off rate
  • ·Patient volume by site
  • ·Provider productivity

Funds & investment

  • ·Management fee accruals
  • ·Capital called vs. deployed
  • ·Expense ratio
  • ·Partner allocation summary
  • ·IRR and MOIC support schedules

Lending & specialty finance

  • ·Portfolio yield and net interest margin
  • ·Weighted average factor rate
  • ·Default and charge-off rate
  • ·Advance rate and dilution
  • ·Days past due buckets
  • ·Borrowing base availability
  • ·Syndication participation split
  • ·Static pool performance
  • ·Cost of funds

Close & controls

  • ·Days to close
  • ·Reconciliation completion status
  • ·Unposted transaction count
  • ·Covenant compliance tracker
  • ·Approval exception log
Custom tools

Tools we build for your business

Every business runs on a handful of calculations that matter more than the rest. Usually they live in a spreadsheet one person maintains. We rebuild them properly, on top of your live numbers. Some examples:

Job bid calculator

Price a job off your real labor, burden and material costs instead of a gut-feel markup.

Pricing & margin model

Test a price change or a new service line against actual cost structure before you commit.

Cash planner

See the effect of a hire, a piece of equipment or a slow-paying customer on cash, week by week.

Commission & draw schedules

Calculate partner draws, commissions or provider comp off live numbers, without the monthly spreadsheet rebuild.

Customer profitability tracker

Rank every customer by true margin, including the servicing cost most reports leave out.

Owner's weekly snapshot

The five numbers you actually check, delivered on a schedule you choose.

The payoff

What owners actually get

Profitability by customer and job

Stop guessing which accounts and jobs carry the business. We allocate revenue, labor and direct cost down to the customer, job, property or provider.

Decisions in days

Pricing, hiring and bidding questions get answered while they still matter, rather than confirmed by a P&L a month later.

Tools built for how you work

Custom calculators and models replace the spreadsheet that only one person understands. They run on the same books we maintain.

One source of truth

The dashboard, the financial statements and the lender package all reconcile, because they come off the same books.

Platforms we work in

We work in the platforms you already use

No migration and nothing new to adopt. We log into what you already run. If a platform exports data, we can report on it.

Accounting & ERP

QuickBooks Online QuickBooks Desktop & Enterprise Xero Sage Intacct Sage 50 NetSuite Dynamics 365 Business Central Zoho Books

Real estate & property management

Rent Manager RealPage Yardi AppFolio Buildium Entrata MRI Software Propertyware Procore Sage 300 CRE

Payroll providers

ADP Paychex Gusto Paylocity Paycom Paycor Rippling Fingercheck Justworks TriNet Insperity QuickBooks Payroll Square Payroll Patriot Heartland Deel Papaya Global Wave Payroll

Time, PTO & scheduling

When I Work Deputy Homebase TSheets / QuickBooks Time Clockify 7shifts Buddy Punch Timeero ADP Time & Attendance Kronos / UKG

Benefits & HR administration

Employee Navigator Ease Zenefits BambooHR Namely Guideline Human Interest Vestwell Principal Empower PEO plan administration COBRA & carrier reconciliation

AP, spend & expense

Bill.com Ramp Brex Melio Expensify Stampli AvidXchange Divvy Dext

Billing, payments & POS

Stripe Square PayPal Shopify Authorize.net Chargebee Recurly Toast Clover

Funds & investment operations

Allvue Investran Juniper Square Addepar Carta FundCount Agora Administrator portals (Apex, SS&C)

Healthcare & human services

Athenahealth eClinicalWorks Tebra / Kareo AdvancedMD CentralReach Rethink Behavioral Health PointClickCare MatrixCare Kipu KanTime Procare Brightwheel WebPT EHR & EMR data exports

Inventory, field service & operations

ServiceTitan Jobber Housecall Pro Fishbowl Cin7 Katana Unleashed

Sales tax & compliance

Avalara TaxJar Vertex

Reporting, BI & dashboards

Power BI Tableau Looker Studio Fathom Jirav Reach Reporting Syft Analytics Excel & Google Sheets models

Banking & integrations

Direct bank & card feeds Plaid Mercury Relay Zapier Make Custom API integrations

Already on QuickBooks?

We are a certified QuickBooks Online ProAdvisor firm and build on the file you already have. No migration and no new platform to learn. Your dashboards and tools sit on top of it.

View our ProAdvisor profile →

Running something not listed?

We onboard new systems regularly and have yet to meet a platform we could not pull clean data out of. Tell us what you are running.

Ask us about your stack →

Also part of your finance function