Financial reporting lenders expect from businesses: 3 tie-outs
serenalovejoy0 đã chỉnh sửa trang này 3 tuần trước cách đây


The financial reporting lenders expect from businesses comes down to whether the numbers tie out. Before a loan officer weighs any ratio, they usually check that the statements agree with the bank accounts, the receivables report, and the debt balance. This article covers three tie-outs to run first, and the main condition: each one needs a source record you can open.

Why lenders check whether the numbers tie before they read ratios


A lender rarely starts with the most impressive number in the package. The first pass is usually mechanical: does the income statement agree with the balance sheet, does the cash flow start from the same net income, and do the key balances match records kept outside your own files? This is the simplest test of a reporting package, and it is where weak packages tend to fail.


The reason is practical. Ratios such as current ratio, debt service coverage, or gross margin are only as good as the inputs behind them. If the cash balance on the balance sheet differs from the bank statement, every ratio built on cash inherits that gap. A reviewer who finds one unexplained difference will reasonably ask what else has not been reconciled.


Tie-outs are the checks that connect your internal records to a source outside them. A bank statement is an outside source. So is a loan statement from a lender, a customer aging report pulled from invoicing software, or a payroll provider's filing. Each external record gives a reviewer something to test your ledger against, which is why these checks carry more weight than a summary slide. Think of a tie-out as a line-by-line proof that two records describe the same money.


Show your working. Before sending anything, write down the source for each figure and the date it was pulled. If you cannot name the source for a balance, the reviewer will assume there is no source. That assumption can be unfair, but it is hard to argue with when a package has no trail. A useful report should make the next question easier to ask. If the numbers need a long explanation, start by checking what is missing.


This article covers three tie-outs that appear in most lender reviews: cash, receivables tied to revenue, and debt. They are not the only checks, and they will not answer every question a credit committee may raise. They do give you a practical way to test whether the package is internally consistent before someone else finds the gaps for you.

Tie-out one: bank balances matched to the general ledger cash accounts


Start with cash because it is the easiest balance to verify and the one reviewers check first. For each bank and credit card account, compare the ending balance in the general ledger to the statement balance at the same cut-off date. Any difference should be explained by a named item, not by a general sense that the books are close enough.


Common reconciling items are checks that have not cleared, deposits recorded in the books but not yet credited by the bank, bank fees not yet booked, and card processor settlements that arrive net of fees. Each has a normal explanation, and each should appear on the reconciliation with its own line. A reconciliation that shows a single plug amount tells the reviewer the difference was never investigated.


In a hypothetical example, the bank statement shows $48,200 and the ledger shows $46,900. The $1,300 gap comes from two checks totaling $1,500 that have not cleared yet, less a $200 bank fee the books have not recorded. Once both items are listed and the adjusted balances agree, the difference is explained, and the reviewer can see exactly how.


Cash tie-outs also reveal process problems. If the same kind of item appears every month, such as a recurring fee or a payment that always clears a few days late, the fix is usually a rule in the accounting software or a standing journal entry, not another manual adjustment. Systems such as QuickBooks, NetSuite, and Sage Intacct offer bank feeds and reconciliation workflows, though how they are configured varies widely from one company to the next.


Ask who prepares the reconciliation and who reviews it. A reconciliation prepared and approved by the same person is weaker evidence than one with a separate reviewer and a signed date. You do not need a large team to separate those roles, but the reviewer does need to see the bank statement itself, not only a summary of the reconciliation.

Tie-out two: receivables aging matched to revenue and the balance sheet


The second tie-out connects sales to the balance sheet. Revenue on the income statement should agree with the sales recorded in the ledger for the same period, and accounts receivable should agree with the open invoices in the customer aging report. When these two sets of numbers differ, the gap often sits in credits, prepayments, or invoices recorded on the wrong date.


The aging report is the record a lender will ask for early. It lists each open invoice by customer and age bucket, and it should total to the receivables balance at the cut-off date. If the total does not match, check for unapplied customer payments, credit memos not yet posted, and invoices voided in the system that still sit in the ledger. Each one has a clear fix once it is found.


Revenue raises a separate question: were the sales recognized in the right period? For companies with contracts that include multiple deliverables, subscriptions, or milestone payments, ASC 606 sets the model for recognizing revenue from most customer contracts under US GAAP. A tie-out cannot prove the policy is right, but it can show that the revenue schedule supports the amount reported and that deferred revenue balances match the contracts behind them.


Reviewers also look at the trend in receivables. If sales grow but collections slow, the aging will show more balances in the older buckets. That pattern does not prove a problem, because a company may have chosen longer payment terms or taken on a larger customer. Explain which customers drive the change and whether any balances are in dispute, so the reviewer does not have to guess.


Write down your policy for doubtful accounts and the basis for the reserve. If the reserve is an estimate, the reviewer needs to see the method, not only the figure. A method based on specific customer reviews and historical write-offs is easier to defend than a flat percentage applied to the total without explanation.

Tie-out three: the debt schedule matched to loan statements and covenant calculations


The third tie-out covers debt, and it matters most when the package supports a loan renewal, a new facility, or a financing round with existing lenders. The balance for each loan on the balance sheet should agree with the lender's statement at the same date. Interest expense should agree with the rate in the loan agreement applied to the balances that were outstanding during the period.


Build a debt schedule with one row per instrument. Include the original principal, start date, rate, payment terms, current balance, and the portion due within twelve months. Lenders often ask for this schedule even when the balance sheet looks simple, because it shows how the balances will move over the coming year.


Covenants are where the tie-out becomes specific. A covenant such as a minimum debt service coverage ratio or a maximum leverage ratio is defined in the loan agreement, and the definition may exclude certain items or adjust earnings in ways that differ from your management reporting. Before calculating a covenant, read the definitions section and write down each adjustment used, with a reference to the clause that allows it.


Equity financing has a parallel. If you have issued preferred shares, convertible notes, or SAFE agreements, the capitalization table and any accrued dividends or interest should agree with the legal documents. Investors may not use the phrase tie-out, but they will ask whether the share count in the ledger matches the cap table and whether any instrument has changed since the last round.


A hypothetical example helps here. Suppose a loan agreement defines the earnings measure for a covenant with a specific exclusion for one-time costs, but the internal report adds back a recurring software fee. The internal figure looks stronger, yet the covenant calculation cannot use it. The reviewer will expect the covenant figure to follow the agreement, not the management report.

Connecting the cash flow statement and forecast back to the three tie-outs


Once the three tie-outs hold for the historical period, the cash flow statement and the forecast can be checked against them. The indirect method starts with net income and adjusts for changes in working capital and noncash items. Each adjustment should map to a balance sheet movement that you have already verified, so nothing in the statement depends on an unexplained entry.


This is where many packages break. A cash flow statement can be internally balanced and still disagree with the bank activity, because it was built from a plug or from a template that was never updated. Compare the net change in cash on the cash flow statement with the change in bank balances across the same period. If the two differ, the reconciliation work from the first tie-out has not been carried through.


The forecast should start from the last verified cash balance, not the most recent estimate. Lenders read the forecast as a set of assumptions. If the opening cash is wrong, every later month inherits the error. Use the reconciled bank balance as the starting point, then show the assumptions for collections timing, payroll, and debt payments on separate lines so each one can be questioned on its own.


Working capital assumptions need the same discipline. Collection periods, inventory turns, and payment terms should be calculated from the historical data you have already tied out, and the forecast should state any change from that history. A forecast that assumes faster collections without explaining how they will happen invites exactly the questions you want to avoid. Treat working capital as a set of inputs to defend, not a line to adjust until the cash balance looks right.


Ask whether the forecast can be rerun when one assumption changes. A model with hard-coded numbers buried in formulas is hard to audit. Keep inputs in one place, label them, and link them to the tie-out schedules so a reviewer can trace each number back to its source.

Comparing who runs the tie-outs: in-house staff, a fractional CFO, outsourced bookkeeping, or ERP-led controls


Four common approaches cover this work, and they are not interchangeable. An in-house accountant or controller owns the process day to day and knows the business closely, though the workload depends on team size. A fractional or interim CFO usually adds senior review and forecasting on a part-time basis, and the depth of involvement depends on the agreement. Outsourced bookkeeping handles recording and reconciliations, often with less review of judgment areas. ERP-led controls rely on system setup, approval steps, and integrations, such as SAP S/4HANA, that make tie-outs routine.

Attribute In-house accountant or controller Fractional or interim CFO Outsourced bookkeeping ERP-led controls

who is a outsourced Cfo in massachusetts runs the tie-outs Internal staff, day to day An outside leader, part-time, with internal staff doing the detail The provider's bookkeepers, with the company approving entries Internal staff and the system, with automated matching

Review of estimates and judgment areas Depends on training and available time Senior review of reserves, revenue timing, and covenant definitions Usually limited to the agreed scope Set by written policy and approval steps

Typical cadence Monthly close and ad hoc requests Scheduled reviews, plus extra support before lender deadlines Monthly or as set in the service agreement Continuous matching, with monthly sign-off

Key question to ask Who has time to reconcile and review? Which judgment areas are covered, and who signs off? Which reconciliations are included, and who reviews them? Which integrations and approvals are configured?

Best fit when The workload justifies a dedicated hire Strategic direction and lender packages are needed without a full-time executive Transaction volume is high and the work is routine Systems are stable and the process is documented


None of these is the right answer by default. The table shows where each approach puts its effort, not which one will produce a better package. A small company with a strong bookkeeper may need little more than a monthly review of judgment areas. A company with several entities and a pending loan may need the senior review a fractional arrangement provides, at least for one cycle.


Scope matters more than the label. When evaluating any engagement, ask which of the three tie-outs the provider will perform, which ones your team will perform, and who signs off on each reconciliation. A proposal that says it covers financial reporting without naming the tie-outs leaves the most important questions open.


Fit also depends on the situation. A company preparing a single loan request may need a short, focused review of the package. A company that expects to repeat the process every quarter needs a routine the internal team can run without outside help. Be cautious with any provider that describes the same deliverables regardless of stage, systems, or financing type, because the right scope changes with each of those.


Ask for examples of the work product itself rather than a summary of services. A sample reconciliation, a debt schedule layout, or a covenant calculation worksheet with the definitions noted will tell you more about how the work is done than a list of capabilities. Any example should be shared with client details removed, and you should not assume it reflects typical results.

Fitting the tie-outs to your stage and type of financing


Not every company faces the same lender review. A business with one bank account, a single credit line, and no outside equity may need a much simpler package than one with several entities, multiple lenders, who is a outsourced CFO in Massachusetts and convertible instruments. The three tie-outs stay the same in principle, but the number of accounts and documents to check grows with the structure.


A company preparing for a first funding round often has the widest gap between its internal records and what outside investors expect. Early records may mix personal and business transactions, or cash may be tracked in a spreadsheet rather than a ledger. The first priority is usually the cash tie-out, because it sets the base for everything that follows. If the opening balance is wrong, the rest of the history is hard to trust.


A company seeking a bank loan or line of credit will spend more time on debt and covenant definitions. The lender may request several years of historical statements, and each year should tie to the tax return or to the prior package. Where the numbers changed from one year to the next, document why, such as a change in revenue recognition, a reclassification of expenses, or a new accounting system.


Companies preparing for a sale or acquisition face a different test. Buyers run diligence across the same three areas, and they often expect the tie-outs to be finished before the data room opens. Gaps found during diligence can slow the process or change the terms discussed, so the work is worth starting early. Preparation supports the process, but it does not decide the outcome, and no tie-out can promise a particular result.


If your business is early stage or relies on basic software, start with a monthly tie-out routine before adding lender-specific schedules. A monthly routine is easier to keep than a one-time scramble before a meeting, and it leaves a record you can show a reviewer when the need arises. Consistency also makes the later, larger package faster to assemble.

Six checks to run before the lender package leaves your desk


Use these questions to test the package before it goes out. They work as a checklist for an internal review, and you can put the same questions to an outside advisor if one is involved.

Which bank accounts and cards were reconciled at the cut-off date, and who reviewed each reconciliation? Does the customer aging total to the receivables balance, and which credits or unapplied payments explain any difference? Does each loan balance agree with the lender's statement, and does the debt schedule show the portion due within twelve months? Which covenant definitions were used, and where in the agreement does each adjustment come from? Does the net change in cash on the cash flow statement match the bank activity for the same period? Can the forecast be traced from its opening cash to a reconciled source, and which assumptions have changed since the last version?


If any answer depends on memory rather than a document, start there. A reviewer will not accept a verbal explanation for a balance that no one can trace. Write the answer down, attach the source, and note who checked it.


Keep the order of the work in mind. Cash comes first because it anchors everything else. Receivables come next because they connect revenue to the balance sheet. Debt comes last because covenant calculations depend on accurate balances from the first two. Working in that order makes each later tie-out easier and leaves a record that answers the questions a lender is most likely to ask.


If the list is longer than the time you have, pick the cash and debt tie-outs for the next package and schedule the receivables work for the following cycle. The goal is not a flawless package on the first attempt. The goal is a set of numbers you can explain line by line, with a source for each one.