Machine-shop unpaid customer exposure worksheet
Group the defined receivables snapshot and record the next owned action.
No signup. Enter reference codes, add records and download a CSV. Entries stay in the browser tab. Filled fields do not establish completion, approval or compliance.
| Buyer reference | Snapshot date | Open invoice population reference | Unpaid amount | Acceptance or collection blocker | Next reviewed action | Office owner role |
|---|---|---|---|---|---|---|
| Buyer-example-7 | Fictional snapshot date | Reviewed-ledger-example | 20000 of 50000, illustrative | Acceptance review unresolved | Accounts-role |
- Starting records are fictional examples, not merchant evidence.
- Keep private documents and actual contacts in your approved business system. Use internal reference codes here.
- Missing required fields indicate an unresolved record. Filled fields do not prove authorization, completion, compatibility or compliance.
- Export to approved business storage. Browser edits are cleared on reload.
Customer concentration in unpaid invoices answers a different question from concentration in sales. Your largest revenue account might have paid promptly, while a smaller buyer holds most of the current open balance. Build the report from a defined receivables snapshot. Group balances by the actual responsible buyer, then separate invoice acceptance, disputed amounts and collection status before deciding which task deserves attention.
Use with this guide
historical machining customer concentration guide
The historical machining customer concentration guide reviews sales rather than this unpaid-balance population.
missing remittance allocation worksheet
Use the missing remittance allocation worksheet before leaving an unidentified receipt in the open balance.
Browse the complete machine shop guides and worksheets.
Define the receivables population
Choose the snapshot date and retrieve open invoices from the approved accounting source. Define whether the report includes issued but unaccepted invoices, disputed balances and reviewed credits. Preserve those categories instead of silently excluding the difficult records. Gross historical sales and current unpaid balances use different denominators. Do not divide a customer’s open invoices by last year’s sales and label the result receivables concentration.
Be careful to match customer accounts up to the correct buyer, this may include a parent company, a different plant location or even a different purchasing contact. Ensure that the bookkeeper has reviewed the account grouping where necessary and that any confidential customer identities and agreements are stored safely. This worksheet uses the internal account reference numbers, not a downloadable list of all your buyers. The historical machining customer concentration guide reviews sales rather than this unpaid-balance population.
Separate amount owed from the reason it remains open
Then list out the open invoices, in the same receivables report snapshot, for each balance. Identify the accepted invoice number and the status for each open payment milestone for each. For each disputed charge, note out the reviewed response. This way, all the work the office needs to do to collect is exposed.
The exposure worksheet records the buyer reference, snapshot date, open invoice population, unpaid amount, acceptance or collection blocker, next action and owner. Use aggregate amounts and coded references. It does not assess creditworthiness, forecast default or recommend refusing a customer. Filled fields identify a review task. The source ledger and accepted terms still determine the actual amounts and commercial decisions.
Compare a fictional unpaid-balance snapshot
For this example we’ll look at a hypothetical $50,000 in open receivables. Of that, $20,000 is associated with a confirmed buyer. The 40% figure above represents this one buyer as 40% of the defined ‘unpaid’ population, not 40% of your annual sales. The concentration does not indicate a 40% chance that this buyer will default, nor does it mean that $20,000 is immediately collectible. This figure simply represents the current reported exposure prior to reviewing the terms of acceptance and payment.
If reviewed credits reduce the buyer’s balance by $2,000, update both the relevant balance and the total population consistently. With no other changes, the reviewed amounts become $18,000 of $48,000, or 37.5%. Do not change only the numerator and keep the old denominator. If the population totals zero, the percentage is undefined rather than a meaningful concentration score.
Assign actions without inventing a risk rating
Review the largest unresolved balances with the office owner. Retrieve the actual buyer acceptance and permitted contact route before contacting purchasing or accounts payable. Do not promise a payment date from a verbal estimate or treat an attempted reminder as money received. Keep the task owner and next review date visible so an unresolved acceptance question does not disappear behind a larger balance.
Repeat the report using the same definition, and explain any grouping or population changes. Compare historical sales concentration in its own analysis rather than merging two different measures. Your owner needs a factual picture of unpaid exposure and the next commercial task. Avoid publishing customer-risk benchmarks, guaranteed collection improvements or claims about a real buyer’s financial health without verified supporting records. Use the missing remittance allocation worksheet before leaving an unidentified receipt in the open balance.
Primary sources
BlueFinch last reviewed these sources on October 4, 2026. Payment rules and state requirements can change.
Use this page for general business information. It is not legal, tax, or accounting advice.
Related resources
- 2026 Credit Card Processing Cost Report
- Auto Repair Shop Payment Guide
- Auto Repair Shop Credit Card Processing Calculator
- Compare machine-shop customer concentration before chasing one account
- Machine-shop ACH receipts: resolve missing invoice references
- Machining samples: follow up on the purchasing decision