A/R Aging, A/P Aging, and 13-Week Cash Flow Forecast

The Problem With Not Knowing Where Your Cash Stands

Most small business owners know their bank balance. Very few know how much of what they're owed is already late, how much they owe and when it's due, or whether they'll have enough cash to cover payroll in six weeks. QuickBooks has the raw data. It just doesn't surface it in a way that tells you what to do about it.

These three tools close that gap, all pulling live from your QuickBooks data.

A/R Aging: Know Exactly Who Owes You and How Late They Are

The A/R Aging Report pulls every open invoice from QuickBooks and buckets it by how overdue it is: Current, 1–30, 31–60, 61–90, and 90+ days past due. Click any bucket to see the individual invoices behind it. Click an invoice to trace it straight back to the source transaction in QuickBooks.

Key metrics at a glance: Total A/R, percent overdue, 90+ day exposure, concentration risk (which customer makes up a dangerous share of what you're owed), DSO, and average days late. FREM reads each metric and tells you what it means in plain English.

A/P Aging: See What You Owe and When It's Due

The same report, flipped to payables. Every open bill from QuickBooks is bucketed by days past due. See which vendors you're most overdue with, your total payables, DPO, and concentration risk on the vendor side. The A/P tab lives right alongside A/R in the same report, one click away.

The A/P FREM insights tell you how much is still current versus already past due, and which vendor relationship to protect first if you need to prioritize payments.

13-Week Cash Flow Forecast: See Where Your Cash Is Headed

The 13-Week Cash Flow Forecast starts with your current bank balance from QuickBooks and rolls it forward week by week, layering in your expected A/R collections (by invoice due date), scheduled A/P payments (by bill due date), and any recurring obligations you configure, payroll, rent, debt service, taxes, and more.

The result is a week-by-week projection of your cash position for the next 13 weeks. The chart highlights any week where your projected balance dips below your minimum buffer. Click any week to see exactly which invoices, bills, and obligations are driving that week's cash movement.

What you can ask FREM

FREM is context-aware on all three tools. Some examples:

• “Who owes me the most?”
• “What’s my DSO?”
• “What do I owe and when is it due?”
• “Will I run out of cash?”
• “When is my tightest week?”
• “How do I prioritize what to pay this week?”

Recurring Obligations: Make the Forecast Accurate

The 13-Week Forecast includes a Recurring Obligations manager built right into the page. Add your payroll cadence, rent, debt payments, estimated taxes, or any other fixed outflow. Each obligation expands across the forecast window automatically based on the frequency you set, and the chart and weekly table update instantly.

The more obligations you add, the more accurate your forecast becomes.

How to Get Started

All three tools are available today. Connect QuickBooks and run a sync from the Aging Report or Dashboard. A/R and A/P data populate immediately. The Cash Flow Forecast loads your bank balance from QuickBooks automatically as your starting cash.

Find the A/R Aging Report and 13-Week Cash Flow Forecast in the navigation bar of your dashboard. For the full feature breakdown, see the Aging and Cash Flow feature page.