1 How to build a sources and uses table before a lender call
etsukogarvan1 edited this page 2 days ago


A sources and uses table shows where the money for a project will come from and where it will go. The criterion that separates a table a lender can trust from one that raises questions is whether each line ties to a document someone outside the organization can check. Here is how to build a sources and uses table before a lender call, one line at a time.
The symptom: the lender call stalls on one question
Picture the call. The lender has read your request, you have explained what the loan is for, and then the question comes: where does the rest of the money come from? If the room goes quiet, the problem is rarely the loan itself. It is usually the way the numbers were put together before anyone dialed in.

This happens often with nonprofit leaders who are very good at their mission but were never asked to think like a borrower. An executive director may know exactly how many families a clinic will serve and still struggle to name the source for each dollar of a renovation. The lender is not asking you to defend the mission. They are asking whether the money adds up.

Let's slow down for a second. The symptom you see on the call is a hesitation, a request to send more information after the meeting, or a note that the request is still under review for weeks. Those are signs that the lender cannot yet see a complete path from the money requested to the money spent.

A simple test helps here: a good report should let a board member ask a smart question in under a minute. If it can't, the format needs work, even when every figure is correct. Lenders read the same way. They want to find the total, the source of each line and the gap without hunting through three attachments.

So the symptom has two faces: a call that stalls, and a packet that nobody can read quickly. Both point to the same gap. The table either does not exist, or it exists as a list of totals that nobody has traced back to a document.

It also helps to notice when the symptom started. Often the problem appears only after the first draft is shared, when someone asks for the quote behind a line. The director hears the question, realizes the number came from memory, and the rest of the packet starts to feel less solid. Catching that moment early is the whole point of building the table in the right order.
What a sources and uses table says in plain language
A sources and uses table has two halves. The uses side lists what the money pays for: construction, equipment, professional fees, closing costs and any cash held back for the months ahead. The sources side lists where that money will come from: a loan, a grant, donations, cash already in the bank or gifts of materials.

The rule is that the two sides must match. Total sources must equal total uses. If they do not match, the table is not finished, and a lender will notice before the board does. When sources fall short of uses, that shortfall is a gap, and showing the gap openly is far more useful than hiding it inside a bigger loan request.

Several terms show up in almost every version. Working capital is the cash a group needs to pay its bills while it waits for money to come in. Runway is how long current cash lasts at the current rate of spending. A contingency is a reserve set aside for costs nobody can fully predict yet, such as a repair found after the walls open up.

You do not need an accounting background to read these terms, but you do need to know which meaning your lender uses. Ask early whether the lender expects contingency and working capital to appear as separate uses, because some lenders prefer them broken out and others accept a single reserve line. Asking takes one sentence and can save a week of revisions.

Keep the table to one page if you can. A lender and a board should be able to read it together, line by line, without a calculator. If the table needs three pages of footnotes to make sense, the footnotes are probably doing the work that the labels should be doing.

Think of the table as a translation. Your mission lives in the program narrative, where the work is described in human terms: patients seen, rooms opened, families served. The table turns the same project into dollars so a lender can weigh it. Neither version is complete alone, and the table is the one a lender reads first.
The likely cause: totals built backward from the loan amount
The most common cause of a broken table is working backward. The team decides how much to borrow, then fills in the uses until they reach that number, and fills in the sources with whatever seems likely to arrive. The table balances on paper, but nothing on it was built from a quote or a signed commitment.

Here is an explicitly hypothetical example. A community clinic wants a bridge loan to cover a second-floor renovation while a foundation grant is still being finalized. The director writes a uses total of $420,000 and a sources total that matches it, counting the grant at the full amount requested. The table balances, and it is wrong.

Why is it wrong? The grant was requested, not awarded. The contractor's bid is based on an older estimate, not a current proposal. Nothing on the sources side has been confirmed, and the uses side has no room for a repair that might appear once construction starts. A lender who asks for the award letter will see the problem immediately.

The correction starts with the opposite habit. Build the uses first from the best documents you have, then build the sources from what is confirmed, and let the difference show up as a gap. A gap is an honest starting point for a conversation. A table that balances by force leaves the lender to find the problem, and that is a hard position to recover from.

Let's slow down for a second on the word balance. A table that balances is not automatically a table that works. Balance tells you the arithmetic adds up. It does not tell you that the money is real, that it is available on the date you need it, or that it can be used for the purpose listed.

This pattern is easy to fall into because it feels practical. The loan amount is often the first number a director knows, and it is tempting to shape everything else around it. Yet the table exists to test the request, not to justify it. A table built to justify the request rarely survives a careful reader, and the director ends up explaining the numbers instead of discussing the plan.
Gathering the documents a lender can check
Before you type a single number, collect the paper behind it. Think of each document as the evidence for one line. A lender reads a table the way an auditor fractional CFO companies in Miami reads a ledger: the first question is always where the figure came from.

Not every document carries the same weight. A signed contract is firm. A verbal promise from a donor is not yet a commitment, even when the donor is kind and sincere. Mission matters here, but a lender needs to see paper. You will serve the mission better by asking a donor fractional CFO for exit planning in Miami a signed pledge than by counting a warm conversation as money.

A useful checklist for the document folder looks like this:

Signed contracts or current written proposals for construction, equipment and professional fees Vendor quotes dated recently enough to reflect current prices Award letters from grantors, showing the amount, any conditions and the payment schedule Pledge agreements or signed commitment forms from donors Recent bank statements showing the cash the organization already holds The board-approved budget or resolution that authorizes the project and the loan


Keep the folder organized by table line, not by date. When a lender asks about the elevator quote, you should be able to open one file and find the quote, the date it was issued and a note saying who approved it. That structure makes the call shorter and the follow-up emails easier to write.

If a document is missing, do not invent its line. Put the line in the table with a status that says what is missing, such as quote requested, not yet received. That honest status will do more for your credibility than a finished-looking number with nothing behind it.

It helps to set a date for the folder. Ask each person who owns a document, such as the bookkeeper or the construction lead, to send the current version by a set day. Old quotes are a common source of surprise, and a dated file makes it clear which version the table relies on.
Building the uses side one line at a time
Start with the uses side because it describes the project, and the project should drive the money, not the other way around. Walk through the work from start to finish and name every cost you expect to pay between now and the end of the job.

List each cost category: construction, equipment, professional fees, permits, loan closing costs and interest during construction. Attach one document to each line, using the vendor quote or contract you gathered. Separate one-time costs from ongoing costs the organization will carry after the project opens. Add a contingency line sized to the risk of the work, such as older buildings that may hide surprises. Add a working capital line if the organization must cover payroll or bills before grant or donor money arrives.


The contingency line deserves a short note. Renovations are where costs tend to grow after walls open up, so a reserve here is prudent, not pessimistic. Set the amount with the contractor or architect, and write down how you arrived at it. That way a board member can ask about it without a long explanation.

Be careful with professional fees. Architects, attorneys and accountants often appear in a budget as a single round number that was written down months ago. Replace that round number with the actual proposals, even if the total changes by a small amount. A lender can tell the difference between a placeholder and an estimate.

Mission-first thinking keeps this honest. For the clinic, the renovation exists so that staff can see more patients each week in rooms that work. Each use line should connect back to that purpose. If a cost does not serve the project, ask whether it belongs in the request at all. A tighter request is easier to explain and easier to approve.

Once every line has a document and a note, read the uses side aloud as if you were the lender. Each line should answer a question before it is asked. If you find yourself saying "we think" or "probably," that line needs another document or a clearer label.

Last, check the total against the project plan itself. If the drawings show a new elevator and the uses side has no elevator line, the table is missing something. Walking the physical project against the table catches gaps that spreadsheet checks cannot see.
Building the sources side and naming the status of each dollar
The sources side needs the same discipline, with one extra step: every source needs a status. Money is not equally certain. A lender will want to know which dollars are committed, which are pending and which depend on a condition being met.

Source type What the lender can check Common problem How to label it

Bank loan or commitment letter Signed commitment with amount and terms Treated as final before the lender has approved it Committed once signed, pending before

Awarded grant Award letter with conditions and payment schedule Counted at the amount requested Committed if awarded, conditional if tied to reimbursement

Pledged donations Signed pledge agreements and payment schedule Counted before the donor signs Pledged, shown with the schedule

Cash on hand Recent bank statements Money already set aside for other bills Available after existing obligations

In-kind gifts Donor letter and documented value estimate Used to fill a cash gap Separate line, not counted as cash


Notice what the table asks you to do. Each source type gets its own label, and the label travels with the number onto the page. A pledge is not a grant, a grant is not a loan, and cash on hand is not the same as cash you expect to raise next quarter. Keeping those categories separate lets a reader see the risk without asking.

In-kind gifts deserve special care. If a supplier donates materials, the value you show should come from a documented estimate, and it should sit on its own line. Do not let it quietly fill a gap in the cash sources, because the lender cannot receive donated lumber as a cash payment.

When sources fall short, add a line called funding gap and put the amount there. Then write one sentence explaining the plan for it: a pending grant decision with a known date, a second donor being approached, or a reserve the board has agreed to use. A plan you can state in one sentence is far more convincing than a total that appears to balance on its own.

Let's slow down for a second on pledges. A pledge is a promise that may be paid in installments. Show the amount promised and the amount received on separate lines, and note the schedule. A lender does not need the donor's full story, only enough detail to judge how reliable the money is.

Keep the sources in an order a lender is likely to follow. Put committed money first, then pending items, then the gap. That sequence tells the story of how the project will be funded, and a reader who sees the story early has fewer reasons to ask for the same information twice.
Reviewing the table before the call with a short checklist
Before the lender call, read the table as a board member would. Can you answer the obvious question about any line within a minute? If not, that line needs a clearer label, a document or a note. The goal is not to make the table look impressive. The goal is to make it easy to check.

Use this checklist as a final pass. Each item is a question a careful reader is likely to ask.

Does total sources equal total uses, or is the difference shown as a labeled gap? Does every use line point to a quote, contract or estimate with a date? Is every source labeled as committed, pending, conditional or in-kind? Are grant conditions and payment schedules written beside the grant amount? Is the contingency sized and explained, not just a round number? Can you point to the document behind any line within one minute?


Some teams build the table in a spreadsheet, and that is a fine place to start. Larger organizations often move the same logic into an accounting or planning system. Tools such as QuickBooks, NetSuite, Sage Intacct, Adaptive Insights and Prophix can produce reports that feed the table, but software does not make a weak source strong. The discipline sits in the labels, not the platform.

Keep a companion view of cash over the coming weeks. A 13-week cash flow forecast shows when money goes out and when it comes in, which helps the lender see whether the organization can cover the months between now and the first payment. It is often the second page that answers the questions the first page raises.

Let's slow down for a second again. Do not send the table to the lender for the first time during the call. Share it a few days ahead, with a short cover note listing what is confirmed and what is pending, so the conversation starts from the honest version and not from a surprise.

If something on the checklist fails, fix it before the call rather than explaining it on the call. Explaining a gap you have already named is a short conversation. Explaining a gap you hoped nobody would notice is a long one, and the lender usually remembers the second kind.
The costliest mistake: counting pending money as committed money
The most expensive mistake in this process is treating pending money as if it were committed. It shows up as a grant listed at its full requested amount, a pledge counted before the donor has signed, or a sale of an asset assumed to close on a certain day. On the surface the table looks complete. Under questioning it falls apart.

The cost is more than an awkward call. A lender who finds a sources line that cannot be documented may slow the review, ask for a larger reserve or stop trusting the rest of the packet. Board members who learn about the gap from the lender rather than from the director lose confidence in the process, and that loss is harder to repair than a delayed loan.

Here is how to avoid it. Label every source with its status before you total anything. Carry only committed money into the sources total unless the table has a clearly separated section for pending items. Attach the award letter, signed pledge or bank commitment to each line that depends on it.

Also avoid the reverse mistake, which is hiding a real gap by inflating a use line. If you cannot yet price a repair, say so in the note and carry a contingency that reflects the risk. An honest gap with a plan tends to be easier to discuss than a table that conceals one, and it leaves the board with a decision they can actually make.

When the table is honest, the call changes. The conversation moves from whether the numbers are real to what the plan is for the gap, and that is a discussion a careful lender and a thoughtful board can have calmly. Build for that conversation, and the table will do its job.

Before the call, ask one last question of the table: would every committed source still hold if the donor, grantor or bank were asked to confirm it today? If the answer is yes for every line, the table is ready. If the answer is no for even one line, label it honestly and write down what you are doing about it.