What This Resource Does
This workbook is a fact-gathering register for business obligations. It keeps a claimed amount, the party that owes it, the supporting evidence, and the next action in one place. It does not validate liens, assign legal priority, estimate a recovery, or decide whom to pay.
The first sheet contains 50 blank rows and a summary of recorded claims and numeric amounts. The second explains every field and supplies separate, invented examples. Example balances do not feed the blank register’s totals. There are no macros, external data connections, or automatic uploads.
How to Use This Resource
Set the Scope
Name the business and the date of the information. Use one row per distinct claim and legal obligor. A lender appearing on both a company claim and a guarantee needs clear cross-references so the same exposure is not casually added twice.
Record What the Documents Say
Enter the creditor, obligor, amount if known, and a document reference. Keep an unknown amount blank; a zero means a known zero. Use the amount-status field to distinguish Documented, Estimated, and Unknown. “Documented” means a source is available, not that the claim is legally allowed.
Make Uncertainty Visible
Mark whether a lien is claimed and whether the balance is disputed. A lien assertion is not proof of attachment, perfection, priority, or collateral value. Capture those unresolved questions in the notes and ask an adviser to assess them.
Assign the Next Action
Enter an actual deadline only when sourced, along with its basis, the responsible person, and the next step. Do not infer a legal deadline from a generic template. Keep confidential source documents in your controlled records and use references in the sheet.
Check the Summary Before Sharing
Recorded amounts exclude blank and nonnumeric entries. They are gross recorded claims, not a verified debt total or a distribution waterfall. The summary covers the 50 supplied rows; if you extend the workbook, extend and recheck its summary ranges. Review duplicate obligations and uncertain amounts before using any total.
A creditor spreadsheet helps reveal missing information. It does not adjudicate claims or establish a lawful order of payment.
The distinction between estate administration and a simple balance list is reflected in U.S. Courts’ Chapter 7 overview; restrictions on estate cash appear in § 363.
An Example of a Useful Entry
Hypothetical only: “Example Equipment Lender” asserts $125,000 against “Example Manufacturing LLC.” The equipment lien is claimed but unverified. The next action is to obtain the note, security agreement, and relevant filing information. The owner is the finance lead; the deadline field stays blank until an actual deadline and its basis are established. This is an investigation record, not a finding that $125,000 should be paid first.