Body-shop sublet funding worksheet
Compare the next vendor cash commitment with cleared usable job funds, not expected remittances.
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.
| Job reference | Vendor commitment amount | Actual cash due date | Cleared usable job funds | Approved but uncollected amount | Authorized funding decision | Review owner role |
|---|---|---|---|---|---|---|
| Collision-job-example-4 | 6000, illustrative | Actual vendor date needed | 4500, illustrative | 2500, uncollected | Owner-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.

A supplement approval doesn’t put cash in your body-shop bank account. Before you pay an outside vendor, compare what’s actually due with cleared job funds you’re allowed to use. Keep approved but uncollected amounts separate. The funding worksheet below shows the gap, so the owner decides how to cover the commitment before the vendor’s payment date.
Use with this guide
supplement balance guide
The supplement balance guide separates revised approval from the customer collection.
insurance-check availability guide
The insurance-check availability guide addresses another source of uncertainty in usable job funds.
Browse the complete auto body guides and worksheets.
Define the outside work and its payment date
Get the approved sublet scope, the supplier’s quote, the amount due, and the payment date. Calibration, alignment, and other outside services might follow a different schedule than the insurer’s remittance. Get the vendor’s actual terms; don’t assume every outside invoice waits until delivery. Keep the accepted scope handy so the office isn’t funding work based on an informal scheduling conversation.
Has the vendor asked for a deposit before completing the work, full prepayment, or payment when the work is complete? Record each of these commitments individually, even if the dates are different, so that you can see the total amount that is still remaining to be paid by the date of the next cash event. The supplement balance guide separates revised approval from the customer collection.
Count collected funds separately from approvals
Get the actual provider or bank evidence for job collections. An insurer’s supplement approval, an issued virtual card, a pending authorization, and a captured card payment are different things. Your cash forecast should show the stage and what’s still uncertain. Don’t count an approved supplement as available cash just because the estimator expects payment after the outside work is done.
The sublet-funding sheet tracks the job reference, vendor commitment, cash due date, cleared job funds, approved but uncollected amount, authorized funding decision, and review owner. Use aggregate amounts and internal references only. Restrictions on customer deposits, insurance proceeds, or other funds need review in the actual situation. The public worksheet doesn’t decide which money your shop is legally allowed to use.
Work through a transparent cash-gap example
The next vendor commitment is $6,000, but just $4,500 in cleared funds are allocated to this illustrative job. That leaves a $1,500 cash gap, before other obligations or restrictions. There’s also a separately approved $2,500 supplement that hasn’t been collected, so the worksheet doesn’t count it as available funds. This isn’t a vendor price, insurer payment timetable, or BlueFinch financing offer.
If cleared usable funds later hit $6,500 and the commitment stays at $6,000, the signed gap is negative $500. Keep that sign. The entered job funds exceed the commitment by $500, but don’t call that shop profit. This comparison leaves out other labor, materials, refunds, fees, and commitments. Keep those in your broader cash forecast.
Assign a decision before the commitment is due
The owner or authorized office role should outline what action is required for the identified shortfalls in allowable funds and vendor pay dates. Remember, this worksheet does not approve borrowing or charging customers for services approved as sublets. Any revised collection amounts still need commercial and payment authorization.
Once the work and payment are complete and verified, reconcile outside vendor invoices, the body shop job invoice, and final cash collected. Track supplement approval and receipt dates separately. That helps with future planning and trend analysis. Find the root cause of repeat cash shortfalls, then set specific remedies for a delayed vendor schedule versus a late insurer remittance. The insurance-check availability guide covers another source of uncertainty in usable job funds.
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 Body Shop Payment Guide
- Auto Body Shop Credit Card Processing Calculator
- A supplement after payment: calculate only the new customer balance
- Insurance checks at a body shop: reconcile payees, received money, and available funds
- Body-shop rental questions: route billing to the right contact