How to Prepare an Accounts Receivable Aging for Financing

TL;DR

An accounts receivable aging report prepared for financing is not the same document you use for internal collections. Lenders, factors, and asset-based lending (ABL) providers need a report that shows eligible collateral, not just overdue invoices. This guide walks through the exact steps to build a lender-ready aging, explains what underwriters actually scrutinize (cross-aging, concentration, ineligibles), and covers the common mistakes that delay or kill funding applications.

What Is an Accounts Receivable Aging Report?

An accounts receivable aging report is a financial document that categorizes a company’s outstanding invoices based on how long they have been due. It groups every open invoice into time-based buckets, typically current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days past due, and rolls them up by customer.

Most business owners encounter the aging report as a collections tool. It answers the question: who owes us money, and how late are they? That is useful internally, but it is only half the story.

When you are pursuing receivables-based financing, whether invoice factoring, an asset-based lending facility, or an AR-backed line of credit, the aging report becomes a financing document. Lenders and factors rely heavily on these numbers to judge risk before offering any cash advance. A clear and accurate aging schedule can lead to better financing options, while a messy or overdue report may cause higher fees, lower advance rates, or outright decline.

The distinction matters. A collections list asks what action gets an invoice paid. A lender eligibility schedule asks a different question entirely: which balances qualify under the financing contract today? A current invoice could still be excluded because of customer concentration, related-party status, foreign-customer rules, or another contractual limit. Understanding how to prepare an accounts receivable aging for financing means understanding this difference from the start.

Why Lenders and Factors Require an AR Aging

If you need funding, your lender will want to see an up-to-date AR aging report before issuing credit. That is especially true for receivable-based financing options like invoice factoring, where financial institutions assess your business based not on internal earnings but on your aged receivables and customer payment history.

Factors use the aging report in two distinct ways. First, during the initial underwriting process before approving a factoring program. Second, on an ongoing basis to monitor the portfolio. The initial review reveals which customers pay on time, which are consistently slow, and what the average collection cycle looks like. That information informs credit limits, advance rates, and reserve requirements.

For ABL lenders, the aging feeds directly into the borrowing base certificate, which determines how much a business can actually draw against its facility. More on that calculation below.

Roughly 80% of B2B transactions in Canada involve credit terms, with average payment periods of 45 to 60 days. That gap between invoicing and collection is precisely the cash flow challenge that AR financing solves, and the aging report is the lender’s window into how well you manage it.

If you are exploring how AR finance can bridge that gap, this overview of powering growth with AR finance provides useful context.

What a Financing-Ready Aging Report Includes

Standard Aging Buckets

The standard five columns lenders expect:

Bucket	Meaning
Current	Not yet past due
1–30 days	Up to one month overdue
31–60 days	One to two months overdue
61–90 days	Two to three months overdue
90+ days	More than three months overdue

Some businesses with very short payment terms add a 1 to 15 day bucket, but the standard five match what lenders expect to see. Stick with them unless your lender requests otherwise.

Required Fields

Every lender-ready aging should include:

Customer name
Invoice number
Invoice date
Due date
Payment terms
Outstanding balance
Aging bucket assignment
Report “as of” date
Aging basis (invoice date or due date, clearly stated)

The Invoice Date vs. Due Date Problem

This is the single most misunderstood element when preparing an accounts receivable aging for financing, and it trips up experienced controllers, not just first-time applicants.

The issue is straightforward. Two invoices issued on the same day but carrying different payment terms (net-30 versus net-60, for example) will be at completely different points in their collection lifecycle even though they look identical by invoice date alone. An aging based on invoice date will show both invoices in the same bucket. An aging based on due date will correctly show one as current and the other as not yet due.

Neither convention is necessarily wrong. But a lender and borrower comparing different conventions can reach different conclusions about how much of the AR is overdue. Some loan agreements specify aging from invoice date explicitly, stating things like “those aged 60 days or less from date of invoice.” Others require due date aging.

Practitioners on accounting forums note that QuickBooks Desktop offered an option to change the aging basis universally in company preferences, but QuickBooks Online does not provide this toggle. Many banking institutions require invoice-date aging when reviewing business reports, which forces QBO users to manipulate exports manually.

The fix is simple: before pulling your aging report, ask your lender whether they need aging from invoice date or due date. Put the reporting date and aging basis at the top of the schedule so there is no ambiguity.

How to Prepare a Financing-Ready AR Aging: Step by Step

Here is the process to prepare an accounts receivable aging for financing that will survive underwriting without delays or follow-up questions.

Step 1: Export All Open Invoices

Pull a complete export of open invoices from your accounting software. You need issue date, due date, payment terms, customer name, invoice number, and current balance for every outstanding invoice. Most platforms (QuickBooks, Xero, NetSuite, Sage) generate this with a standard AR aging report or open invoice export.

Step 2: Confirm the Aging Basis

Call or email your lender and ask: “Do you want the aging measured from invoice date or due date?” This one question can save a week of back-and-forth during underwriting. Document their answer and apply it consistently.

Step 3: Assign Each Invoice to the Correct Bucket

Calculate the number of days between the aging basis date (invoice date or due date, per your lender’s requirement) and the report date. Slot each invoice into the appropriate bucket: current, 1–30, 31–60, 61–90, or 90+.

Step 4: Roll Up by Customer

Lenders want a customer-level summary, not just an invoice-level detail report. Each customer should show their total balance broken out across the five buckets. Include the detail behind it as a supporting schedule, but the summary view is what underwriters review first.

Step 5: Reconcile to the General Ledger

Your aging report’s grand total must match the AR balance on your balance sheet. If it does not, you likely have unapplied cash or a timing mismatch to track down. Submitting an aging that does not tie to the GL is one of the fastest ways to erode a lender’s confidence in your financial reporting.

Step 6: Flag Exceptions Separately

Three categories need separate treatment:

Disputed invoices. A disputed invoice is not a collections problem; it is a dispute resolution problem. Mixing disputed invoices into standard aging buckets without a separate flag misleads the lender about actual collection risk.
Unapplied cash and credit memos. Leaving these out inflates past-due totals and makes healthy customers look like delinquent risks. Two fields that get skipped constantly, and both distort the picture.
Intercompany, related-party, and foreign receivables. These are almost always ineligible under standard lending agreements. Calling them out proactively shows the lender you understand their eligibility framework.

Step 7: Date-Stamp the Report

Run your aging report on the same day each week or month, and keep the “as of” date fixed relative to your billing cycle. Stale report dates are a red flag. If your lender asks for a current aging and you hand over something from six weeks ago, you will face delays.

For a broader view of what to expect during underwriting, including how the aging fits into the overall credit assessment, that guide walks through the full process.

What Lenders Actually Look For in Your Aging

Knowing how to prepare an accounts receivable aging for financing is one thing. Understanding what the underwriter does with it is another. Here are the key tests they apply.

Past-Due Cutoff

Most lenders treat invoices over 90 days past due as ineligible. They will not advance against them regardless of the customer’s creditworthiness. Some facilities use a tighter cutoff of 60 days, particularly for industries with short payment cycles.

Cross-Aging

This is the concept that catches most borrowers off guard, and no ranking page on the internet explains it well for non-accountants.

Cross-aging works like this: when a customer has more than a certain percentage of their total balance aged over 90 days, the lender declares the entire balance from that customer ineligible. Not just the overdue portion. Everything.

The threshold varies by lender. Some use 10%, others 25%, and some go as high as 33%. Here is a worked example:

Customer A owes your company $100,000 total. Of that, $12,000 is more than 90 days past due. Your lender’s cross-aging threshold is 10%.

Because 12% of Customer A’s balance ($12,000 / $100,000) exceeds the 10% threshold, the entire $100,000 becomes ineligible. Not $12,000. All of it.

This is why a handful of small, old invoices can have an outsized impact on your borrowing capacity. Cleaning up aged balances before submitting your aging is not just good housekeeping; it directly protects your available funding.

Concentration Limits

Lenders prefer not to put all of their eggs in one basket. A concentration limit caps how much of your total AR any single customer can represent before the excess becomes ineligible.

Trade credit insurers flag any single-customer concentration above 20% as a significant risk factor, while banking regulators consider anything over 10% as concentrated exposure requiring additional oversight. In practice, most ABL facilities and factoring programs set the limit between 15% and 25%.

If your largest customer represents 40% of your AR, only 15% to 25% (depending on the contract) counts toward your eligible base. The rest is stripped out. Practitioners on Reddit and finance forums consistently advise disclosing customer concentration upfront rather than letting underwriting discover it mid-file. Transparency builds trust; surprises erode it.

Other Standard Ineligibles

Beyond past-dues, cross-aging, and concentration, lenders typically exclude:

Contra accounts where the customer is also a vendor (the lender cannot collect what might be offset by payables you owe them)
Foreign receivables without credit insurance (Export Development Canada coverage can make these eligible for Canadian lenders)
Government receivables subject to assignment restrictions
Affiliate or intercompany receivables (no arm’s-length collection recourse)
Cash/COD customers (no credit terms means no financing basis)
Disputed or contested invoices

A note for Canadian businesses: accounts receivable from most Canadian provinces are typically eligible, but debtors based in Quebec may be treated differently by some lenders due to provincial legal frameworks around assignment of receivables.

Explore how factoring handles these eligibility questions differently than a traditional bank line of credit.

How Your Aging Report Affects Advance Rates and Terms

The quality and composition of your aging directly determines how much cash you can access.

The Borrowing Base Formula

Every asset-based facility runs on this calculation:

Gross AR → minus ineligibles → Eligible AR × advance rate = availability

Say your total AR is $500,000. After stripping out $125,000 in ineligibles (past-dues, cross-aged accounts, concentration overages, foreign receivables), your eligible AR is $375,000. At a typical 75% advance rate from a Canadian chartered bank, your borrowing availability is $281,250.

That same aging, cleaned up to reduce ineligibles to $50,000, yields $450,000 eligible and $337,500 in availability. The difference ($56,250) came from report preparation, not from generating new revenue.

For a deeper walkthrough of this math, estimating your borrowing base covers the calculation in detail.

What “Clean” vs. “Dirty” Aging Looks Like to a Lender

A schedule with most invoices in the current and 1-to-30-day columns shows a business that collects payments efficiently. That is attractive to factors and ABL lenders because it suggests lower risk of default. A schedule heavy on the 60+ day side raises red flags, signaling potential collection issues or disputes.

Advance rates on Canadian factoring facilities typically run 75% to 90% of eligible invoice face value. Factoring fees in Canada generally range from 1% to 2% per 30-day cycle. A stronger aging, one with faster turns and fewer overdue balances, earns rates at the favorable end of those ranges.

Not all invoices will be accepted for factoring, especially those that are significantly aged. Factors usually refuse to purchase invoices over a certain age threshold, most commonly 90 days past due. Knowing this before you submit helps you set realistic expectations for how much funding your AR will support.

If you are weighing factoring against other options, AR financing vs. supply chain financing breaks down the key differences.

Common Mistakes That Delay or Kill Funding Applications

Knowing how to prepare an accounts receivable aging for financing means also knowing what not to do. These errors come up repeatedly in lender discussions and practitioner forums.

1. Wrong Aging Basis

Submitting an aging based on invoice date when the lender’s agreement specifies due date (or vice versa) forces a restatement. It is the most frequent error, and it is entirely preventable with a single question at the outset.

2. Unapplied Cash Inflating Past-Due Balances

When payments are received but not applied to specific invoices, those invoices still show as outstanding. The result: artificially high past-due balances that can trigger cross-aging penalties and make healthy customers look like slow payers. Clean up unapplied cash before running the report.

3. Missing GL Reconciliation

If your aging total does not match the accounts receivable balance on your balance sheet, the lender will stop reviewing and start asking questions. This mismatch usually signals sloppy bookkeeping, and it can stall a deal for weeks.

4. Hiding Concentration

Some borrowers try to obscure the fact that one or two customers dominate their AR. Underwriters will find it. Being upfront about concentration, and explaining what you are doing to diversify, is a far better approach than hoping it goes unnoticed.

5. Failing to Flag Disputes

Disputed invoices carry different risk characteristics than simply late invoices. A customer who disputes a $50,000 charge is not the same risk as a customer who is 60 days late on a $50,000 payment. Flag disputes separately so the lender can assess them correctly.

6. Stale Report Dates

An aging report is a snapshot. The older the snapshot, the less useful it is. Most lenders want aging reports no more than 30 days old, and many prefer weekly updates during the underwriting period.

For more on what the overall application process looks like, including documentation timelines, this guide on speeding up funding covers practical tips for reducing delays.

Quick Reference: Aging Buckets and Lender Treatment

Aging Bucket	What the Lender Sees	Typical Treatment
Current	Strong collateral, low risk	Fully eligible (subject to other rules)
1–30 days	Acceptable, normal commercial terms	Eligible
31–60 days	Watchlist, especially if terms are net-30	Usually eligible, reviewed closely
61–90 days	Elevated risk, possible collection issue	May be eligible at tighter advance rates; some lenders exclude
90+ days	High risk, likely ineligible	Excluded from borrowing base; may trigger cross-aging on entire customer balance

Preparing Your Aging Report: A Submission Checklist

Before you send your aging to a lender or factor, run through this list:

[ ] Aging basis confirmed with lender (invoice date or due date)
[ ] All open invoices exported and bucketed correctly
[ ] Customer-level summary view included
[ ] Grand total reconciled to GL balance sheet AR figure
[ ] Unapplied cash and credit memos applied or flagged
[ ] Disputed invoices separated and noted
[ ] Intercompany and related-party receivables identified
[ ] Foreign receivables identified (with EDC insurance status noted if applicable)
[ ] Customer concentration percentages calculated
[ ] Report “as of” date clearly stated
[ ] Aging basis clearly stated on the report header

Ready to discuss how your aging report translates into actual funding? Start a loan enquiry to connect with a financing specialist who can review your AR and identify the right structure.

Frequently Asked Questions

What is the difference between an AR aging for collections and one for financing?

A collections aging focuses on which invoices are late and what actions will get them paid. A financing aging asks which balances qualify as eligible collateral under a lender’s criteria. Current invoices can still be ineligible due to concentration limits, foreign debtor rules, or related-party status. The financing version requires additional flags and reconciliations that a collections report does not.

Should I age my invoices from invoice date or due date?

It depends on what your lender requires. Some loan agreements specify invoice date, others specify due date, and the choice changes which invoices appear overdue. Always ask before generating the report. If you do not have a specific instruction, due date is generally the more accurate measure of collection risk because it accounts for varying payment terms.

What is cross-aging and why does it matter for my borrowing capacity?

Cross-aging is a rule where, if a certain percentage (often 10% to 25%) of a customer’s total balance is more than 90 days past due, the lender declares that customer’s entire AR balance ineligible. A few small, old invoices can wipe out a large eligible balance from a single customer. Cleaning up aged invoices before submitting your report is one of the highest-impact steps you can take.

How often should I update my AR aging for a lender?

During underwriting, most lenders want a report no more than 30 days old. Once a facility is in place, monthly or even weekly updates are common for asset-based lending and factoring programs. Run the report on a consistent date relative to your billing cycle to ensure comparability over time.

What advance rate can I expect on my eligible receivables in Canada?

Canadian chartered banks typically advance around 75% of eligible AR. Factoring companies generally offer 75% to 90% of eligible invoice face value, with fees ranging from 1% to 2% per 30-day cycle. The cleaner your aging (more invoices in the current and 1-to-30-day buckets), the better your rate.

Will foreign receivables be excluded from my borrowing base?

Usually, yes, unless you carry credit insurance. In Canada, Export Development Canada (EDC) coverage can make foreign receivables eligible for advance purposes. Without it, most lenders treat foreign AR as ineligible due to the difficulty of cross-border collection enforcement.

What happens if my aging report total does not match my balance sheet?

The lender will flag the discrepancy and pause the review until you resolve it. The mismatch usually comes from unapplied cash, unposted credit memos, or timing differences between your subledger and general ledger. Reconcile before you submit.

Can I prepare an AR aging in a spreadsheet, or do I need accounting software?

Either works. You can build an aging report in a spreadsheet in under an hour, or pull one directly from your accounting system in seconds. Both methods require the same underlying data: a full export of open invoices including issue date, due date, terms, and current balance. The spreadsheet approach gives more control over formatting but requires manual bucket calculations. For ongoing reporting to a lender, pulling directly from your accounting system is faster and less error-prone.