Interim financial statement underwriting for commercial lenders

A borrower's interim statements arrive unaudited, often monthly or quarterly, with a year to date column beside the period. SpreadSpace reads each statement as printed, keeps every column to the months it covers and traces every figure to its page, so a quarter is never read as a year and a year to date never stands in for one.

SpreadSpace™ reads the income statements, balance sheets and cash flow statements a borrower prepares between fiscal year ends, whether they arrive as a monthly export from the accounting system, as a quarterly package from the controller or as compiled or reviewed interim statements from a CPA. Each one enters the same review as the audited year-end set, with the company, the period and the source page on every figure.

SMB and middle-market lenders underwrite on these statements because the last fiscal year end is months behind the request. SpreadSpace lays the interim periods beside the fiscal years, carries the statements into the spread, the EBITDA build and the debt service coverage analysis, and brings the exhibits into the memo in your own format.

Read the interim statements as the borrower prints them

Upload the monthly profit and loss export, the quarterly package or the compiled interim set, and SpreadSpace reads the income statement, the balance sheet and the cash flow statement as printed. Every line keeps its printed name and figure, the stated unit rides every cell, and each subtotal is checked against the lines beneath it. An extraction that fails validation is rejected rather than shown, and a retained statement with a discrepancy carries a visible notice for review.

The engagement level is read off the statement itself. A company-prepared export, a compiled or reviewed interim set and an audited year end are each recorded as what they are, and when two statements print the same period the higher engagement stands.

A monthly export reads as a monthly grid. Each month heads its own column, the printed total stays beside the months rather than being recomputed from them, and the months chart as a series over the window the analyst picks, with the reporting period stated in the title.

Keep each column to the months it covers

An interim column says how long it is, and SpreadSpace reads that from the column itself. Three months ended June 30 is a quarter, six months ended June 30 is a half year, and a column headed year to date runs from the first of the year through its month end. A column whose months cannot be read is never seated under a guess taken from a neighboring column or a file name.

On the spread each column is named for its span, counted from the borrower's fiscal year end. A three-month column reads Q2 2026, a six-month column H1 2026 and a nine-month column Q1-Q3 2026. A span with no such name, five months into the year, keeps its months in the head, and a footnote states the months each interim column covers and the date it ends. A quarter never reads as a year, and a year to date never stands in for one.

The ratios respect the span. A ratio that divides a flow by a balance, receivable days or asset turnover, stays blank on a partial year rather than annualizing a figure the statement never printed. Margins, which divide one line of a column by another, read on every period.

Line the periods up across the statements and against the fiscal years

The income statement, the balance sheet and the cash flow statement of one period seat on one column. The balance sheet sits by its as-of date, the income statement by the quarter or the months it covers and the cash flow statement by its year to date, so the review reads across the three for the same company and the same date.

The fiscal years stay in view. A compiled or reviewed interim package keeps a board of its own on a period-end axis, switched with the Annual and Quarterly chips on the years row, and the audited year end stays on the annual board, where an interim print never supersedes it. A company-prepared export seats its year to date beside the full years, named for the months it covers.

Where the statements on file print a company's quarters, the spreadsheet's quarterly dataset lays them in order. A quarter a statement prints only as a year to date is worked out as that year to date less the one before it, and the fourth quarter as the fiscal year less the nine months before it, each with the two printed figures behind the cell. On that axis a ratio that divides a flow by a balance reads the trailing twelve months, four quarters summed, in place of the blank it leaves on a partial year.

Carry the statements into the spread and the global cash flow analysis

The interim statements feed the same spread as the year-end set. EBITDA builds from the statement's own lines, the standard add-backs switch on or off, any line the statement prints can be added or deducted, and the configuration is saved and reused across loans. Map the lines to your chart of accounts and the same presentation applies to every borrower, with the printed lines kept behind the mapped ones.

Debt service coverage reads the company's statements as a source. The numerator is the EBITDA the spread built with the analyst's add-backs folded in, and the denominator is the interest expense the statement prints plus the year-over-year change in the balance sheet debt lines the analyst ticks, since the analyst, not a caption rule, decides which liabilities are debt. The guarantors' personal financial statements and returns join it in the global cash flow analysis, one coverage ratio per entity added up, with the proposed loan payment counted once at the loan level.

Open every figure on its page and write the memo in your format

Every figure on the spread, in a chart and in the spreadsheet opens the statement at the line it came from. A derived figure, a trailing twelve months or a quarter worked out from two year to date columns, shows the printed figures behind it before any of them opens. A reviewer who asks where an interim figure came from gets the page, not a summary.

Upload a past credit memo as a PDF or Word document and SpreadSpace reproduces its structure as a reusable template. Bring the spread with the interim columns beside the fiscal years, the coverage table and the charts into it as exhibits, and write the recommendation around them. Finalizing records the version the committee received.

Review the statements inside your loan platform

Embed the SpreadSpace workspace in your loan origination system so the team reads the interim statements where it manages the loan. Period comparisons, source review, comments and the memo workflow stay connected to the file, and the API returns the extracted statements for a custom interface.

Bring a borrower's interim package

Bring the monthly export or the quarterly package your team last underwrote on, and the audited year end behind it. See each column named for the months it covers, open a year to date figure on its page and follow the figures into the spread and the memo.

Keep exploring