Waiting to get paid is not always the same problem.

One construction business may be waiting because an invoice was submitted late. Another may have a pay application waiting for approval. Another may be carrying retainage that is not yet expected to be collected. Another may have invoices that are genuinely overdue.

This worksheet helps you organize the financial information behind those situations so you can see where money is being delayed and which collection question deserves further investigation.

Use information from your Accounts Receivable Aging, billing records, customer or job details, retainage records, and other available financial information.

The goal is not to label every outstanding balance as a problem. It is to understand what is outstanding, how long it has been outstanding, why meaningful balances remain unpaid, and what that timing may mean for the financial capacity of your business.

This is an educational review worksheet. It does not determine collectibility, interpret contract rights, establish a universal acceptable collection period, or provide legal advice.

Accounts receivable changes as invoices are issued and payments are collected. Start with one review date so the information you examine represents the same point in time.

Start with the total amount customers owe the business as of the review date.

This number tells you how much is outstanding. By itself, it does not tell you whether collections are performing well. The remaining sections add the timing and context needed to interpret that balance.

An Accounts Receivable Aging helps you see how long customer balances have remained unpaid.

Enter the balances using the aging categories available in your accounting system. Your report may use slightly different bucket names or timing ranges. The purpose is to identify where the receivable balance is concentrated—not to force every accounting system into the same report format.

Retainage may remain uncollected because the contract intentionally allows part of a payment to be held until later.

That is different from an ordinary invoice that should already have been paid.

Separating retainage helps prevent intentionally withheld amounts from being interpreted automatically as ordinary collection problems.

You do not necessarily need to investigate every receivable with the same level of attention.

Start with balances that are financially meaningful, unusually old, repeatedly delayed, disputed, connected to important jobs, or otherwise stand out in your review.

A collection delay can begin before the customer has an opportunity to pay.

Review whether billable work is being converted into accurate invoices, progress bills, or pay applications without unnecessary delay.

A properly billed receivable can still age if no one consistently owns the follow-up process.

The purpose of this review is not to judge the person responsible. It is to determine whether the business has enough visibility into who is following up, what the customer has said, and what happens next.

One receivable balance gives you a point-in-time view. Trends can help you see whether collection performance is changing.

You do not need every possible measurement. Look for patterns that help you ask better questions.

Money in accounts receivable may belong to the business economically, but it is not available cash until it is collected.

Consider what the business must continue funding while meaningful receivables remain outstanding.

Now bring the evidence together.

You may find one clear issue, several contributing issues, or insufficient information to determine the cause yet. Any of those can be useful findings because the purpose of the worksheet is to improve visibility—not force a diagnosis.

Financial Visibility does not require every question to be answered at once.

Choose the one question that would most improve your understanding of why money is remaining uncollected.

Accounts receivable becomes useful financial information when you can see more than the total balance.

You need to understand what has been billed, when payment is expected, how long meaningful balances have remained outstanding, why delays are occurring, how much is retainage, and what the business must continue funding while it waits.

That does not automatically tell you what action to take.

It gives you better Financial Visibility into where the collection cycle deserves attention and what question should be investigated next.

FINANCIAL VISIBILITY

Accurate books and clear financial reporting can help you understand what is outstanding, where collection timing may be creating pressure, and which financial questions deserve attention.