Formula
Required items on every file: Signed application, Complete bank statements, Owner ID, Voided check or bank letter. Required items missing = count of these not ticked
Conditional items switch on by file: Payoff letters when Open positions > 0; EIN confirmation always; Lease or mortgage statement when Requested amount ≥ $100,000; Tax return and A/R aging when Requested amount ≥ $150,000; Processing statements are listed as optional
Conditional items missing = count of switched-on conditional items not ticked
File status = Ready to submit when both missing counts are zero; otherwise Not ready. The checklist table marks each item Required, Required for this file or Optional, and Provided, Missing or not applicable.
Worked examples
Example 1: the default file, $60,000 with one open position
The default ticks the signed application, complete bank statements and owner ID, leaves the voided check and every supporting item unticked, and sets the requested amount at $60,000 with 1 open position. Required items: application provided, statements provided, ID provided, voided check or bank letter missing, so required items missing = 1. Conditional items: payoff letters switch on because open positions is 1, and they are missing; EIN confirmation switches on for every file and is missing; the lease statement does not switch on because $60,000 is below $100,000; the tax return and A/R aging do not switch on because $60,000 is below $150,000; processing statements are optional. Conditional items missing = 2. File status: Not ready, with one required item (the voided check) and two conditional items (payoff letter and EIN confirmation) to collect. The checklist table lists the lease, tax return and A/R aging as optional with a dash, so the broker knows not to chase them for this size of request.
Example 2: a $175,000 request with no positions, missing the A/R aging
Application, statements, ID and voided check ticked; EIN confirmation, lease and tax return ticked; A/R aging unticked; requested amount $175,000; 0 open positions. Required items missing = 0. Conditional items: payoff letters do not switch on because there are no open positions; EIN confirmation switches on and is provided; lease switches on at $175,000 and is provided; tax return switches on at $175,000 and is provided; A/R aging switches on at $175,000 and is missing. Conditional items missing = 1. File status: Not ready. The one missing item is the accounts receivable aging, which funders ask for on larger requests to see whether the business has receivables that could support a cheaper product and to check that revenue is not concentrated in one customer. Collect it and the file is ready.
Example 3: a clean $40,000 first-position file
Application, statements, ID and voided check ticked; EIN confirmation ticked; requested amount $40,000; 0 open positions; nothing else ticked. Required items missing = 0. Conditional items: payoff letters do not switch on with zero positions; EIN confirmation is on and provided; lease does not switch on below $100,000; tax return and A/R aging do not switch on below $150,000; processing statements are optional. Conditional items missing = 0. File status: Ready to submit. The downloaded checklist shows four required items provided, EIN confirmation provided, and the remaining items marked optional. This is the file that funds in a day: nothing for the underwriter to request, nothing in the statements that the application did not disclose, and a request sized well below the point at which funders ask for tax returns.