Key takeaways
- Keep a stable request ID as documents change.
- Separate permission to view a record from its review status.
- Record a reviewer and disposition before treating an item as complete.
What belongs in the index before a buyer arrives?
Start with categories and obligations you already know. A blank register is difficult to maintain during a crowded diligence period, so the file begins with editable requests for earnings, shop reports, facility matters, assets and contracts.
Assign a person who can actually produce or explain each file. The bookkeeper may own monthly revenue, while the service manager can explain how no-charge repair orders affect car count. Use one ID for each question with an independently verifiable answer. If a single request asks for lease, landlord consent and insurance, split it so one signed lease cannot make the entire occupancy issue look complete.
Decide what an early buyer can access and what requires a later-stage release. A payroll summary with technician IDs tells a different story from named employee records. Fill in the release group before entering a secure file reference. Permissions still belong in the actual data-room platform; the spreadsheet records your decision and supplies a way to audit it.
Which fields give a diligence request a usable history?
The first section, Build a controlled index, gives you these prompts and room to document your evidence.
- Issue stable IDs. Give each request a distinct ID. Keep revisions attached to the same request and include a date in the version field.
- Limit early disclosure. Use anonymized records for first-pass questions. Record the release group before you add a sensitive file reference.
- Name an owner. Choose the person who can explain the evidence. Avoid forwarding portal credentials or listing passwords in the index.
| Section | Topics covered |
|---|---|
| Build a controlled index | Issue stable IDs · Limit early disclosure · Name an owner |
| Close the loop | Check coverage · Distinguish upload and review · Keep superseded versions legible |
How do you handle a corrected export?
Keep the same request ID when the seller corrects the underlying file. Change the version reference, identify what moved and direct prior reviewers to the corrected exhibit.
Suppose the first repair-order export included two locations and the deal covers one. Replacing the filename alone could leave a buyer’s underwriting and lender package using different numbers. Record the filter change and extraction time, identify who received the earlier version and ask those reviewers to reconcile the revised file. Keep an audit copy of the original release according to your agreed access and retention process.
If you’re selling, use the disposition field to explain a limitation that cannot be fixed by uploading another document. If you’re buying, identify the remaining test in operational terms. “Tie July fleet receipts to the signed aging report” gives a reviewer a defined next step. A simple “needs review” does not tell them what to do.
How can a received file still leave a request open?
Illustrative composite — not a real client.
Imagine eight diligence requests, five with an uploaded document. Of those five, two have an assigned reviewer, evidence reference and recorded conclusion. Three files need examination and three requests still need evidence. Your completion count is two of eight, or 25%, even though 62.5% have files. If the open items include landlord consent and a fleet transfer, the percentage alone tells you little about readiness to close. Read the outstanding descriptions before setting your next deadline.
How do you set up the Request register before sharing files?
Begin in the Request register with a short stable Request ID for each distinct question. Use Category to distinguish financial, staffing, property, equipment, environmental and customer-contract requests. In Requested item, name the source, reporting entity and export you actually need. Put the relevant dates in Period or as-of. A financial result over twelve months, a bank balance on a particular date and a current employee list describe different time frames. Clear fields prevent reviewers from marking a request complete using a file from the wrong period.
Assign Owner to the person who can obtain or authorize the information. Reviewer identifies the person responsible for deciding whether the evidence resolves the request. Those roles can differ. Your office manager may provide a technician productivity export, while an accountant or buyer operations lead must decide whether the billed hours agree with payroll and the proposed staffing plan. Enter an actual date in Due date, then select the appropriate progress Status. Use Release group for the intended audience. That field records a sharing decision. It does not enforce permissions in your actual document platform.
What exactly makes the Follow-up column show Complete?
The formula examines the information in the row. An unused row stays blank. A row marked Reviewed needs a populated File / version, Reviewer and Disposition or exception before the formula labels the follow-up Complete. A populated row missing those review elements can remain Open or become Past due after its recorded deadline. If a completed review found an exception, describe it rather than treating the label as a favorable finding. Set a new linked request when another person must resolve an issue the first review identified.
Try a controlled test. Enter a request for a repair shop’s final December bank reconciliation with an already passed due date. Supply a file reference and leave the reviewer blank. The row should still require follow-up. Add the reviewer, select Reviewed and enter a disposition stating whether the reconciliation balances and which item remains in transit. The row can then show Complete even when the disposition identifies an item for further diligence. Preserve the distinction between a completed review and a resolved business risk before reporting progress to the seller or lender.
How should you handle a corrected source without losing the audit trail?
Illustrative composite — not a real client. A controller supplies an October revenue export with $92,000 of posted repair sales. The reviewer discovers an internal warranty category was included and asks for the export with agreed settings. The controller supplies a revised file showing $89,600. Keep the first file under the controlled record-retention policy and note that the second version supersedes it for the valuation analysis. In Disposition or exception, explain the $2,400 change, the excluded category and whether the revised figure reconciles to the ledger.
If a previous financial package used the $92,000 figure, identify every dependent analysis. A trailing-period valuation, lender cash-flow model and average repair order report could all rely on the older export. Give each reviewer the authorized new reference and document which version their figures now use. A filename ending in “final” offers little help when two different final reports circulate. Include the source period and version or issue date in your reference, with limited permissions controlling who sees either file.
How do you give each buyer the right level of access?
Plan staged release groups before populating the room. An introductory buyer may see high-level operating totals and anonymized staff roles. A qualified buyer’s accountant may need detailed ledgers, while counsel may need unredacted leases or customer assignment terms. Use the platform’s actual access controls to implement those decisions. Check a sample file as a member of the intended audience through a legitimate authorized review. A register that says limited does not protect a publicly accessible file or a folder shared with a wider group.
Avoid copying employee bank details, personal identifiers, customer contact lists or confidential vendor information into the register itself. Use a protected reference to the approved source and identify an owner who can authorize expansion of access. If you have several potential buyers, keep separate release decisions and recipient records where appropriate. An accounting review by one party does not authorize another bidder to receive the same confidential annex. Coordinate any external sharing with the selling owner and the people responsible for transaction confidentiality.
What should happen to open rows when the parties reach a decision deadline?
Filter the register by due date, reviewer and current follow-up. Ask the reviewer to distinguish an unanswered request, a record that conflicts with another source and a matter the buyer has decided to accept with an identified condition. Give unresolved items a specific consequence. A missing proof of equipment title can hold up collateral clearance, while an outdated vendor list might require only an updated contact after the sale. Record the decision and identify which signed agreement or closing schedule governs any continuing obligation.
At the close of diligence, retain a dated snapshot of the register under the agreed retention policy. Give the incoming manager a limited action list for remaining operational obligations, such as obtaining a new diagnostic login or collecting a fleet credit. Give counsel and the lender only the evidence their responsibilities require. This lets the next person reproduce the transaction record while keeping unnecessary personal and commercial information out of daily shop operations.
How can you tell whether a diligence request is closed?
Check the period, reviewer and active version before marking a request ready for the parties to use.
- Check coverage. Enter the period or as-of date. Compare the requested months with the actual export and flag gaps.
- Distinguish upload and review. Set status to Received once the file arrives. Use Reviewed only after recording the reviewer and result.
- Keep superseded versions legible. Record a replacement reference and date when the seller supplies a fresh report. Preserve what was shared with earlier reviewers.
What should be on the final exception list?
Include every outstanding point that changes the price, affects financing or prevents continued operation. Keep ordinary housekeeping visible in the index while prioritizing items with a decision attached.
Use the buyer due-diligence request list when the only entry says “financials” and you need precise evidence. Use the sale-readiness score if missing records expose a broader weakness in preparation. The availability of files and the quality of the business are separate questions.
At a status meeting, filter by past-due items and read the disposition aloud. Verify that each item has a named person on the next action. Where buyer and seller disagree, record both the financial consequence and the evidence that could resolve the difference. Keep your final index with the versions of the files on which you relied.
What else should you know?
Does the workbook grant access to files?
Your data-room provider controls actual access. The workbook tells your team which release group should have permission and where to find the approved version. Test the permissions in the provider separately before sharing sensitive material and avoid putting sign-in credentials or personal records directly into the register.
What should I do with a request that does not apply?
Write why it does not apply, identify who confirmed that and record the disposition. For example, a shop may lease a tire machine and have no purchase invoice. The equipment lease becomes the relevant evidence and the reviewer can check assignment terms separately.
How can I use the sheet with several buyers?
Keep each buyer’s granted access, questions and review comments separate. You may maintain a seller master index and produce a controlled copy for each group. Verify that links, filenames, comments and previous versions do not expose another buyer or an unreleased document before sharing.
When can a reviewer close a row?
A reviewer can close a request after confirming the file covers the right entity, location and period and recording what the evidence establishes. Enter the file reference, reviewer and disposition alongside the status. If an issue remains, record it as an exception with a responsible person.
Which sources can you check?
- Business recordkeeping · Internal Revenue Service · 2026-11-21
- Buy an existing business or franchise · U.S. Small Business Administration · 2026-11-21