How to Prepare a Loan-Ready Financial Pack From Your Dashboard

c
ceofounder
3 min read 84 views
How to Prepare a Loan-Ready Financial Pack From Your Dashboard
Loan-Ready Financials

The Good Float, Bad Books Problem

You have a solid business. Your M-Pesa statement shows KSh 800,000 monthly inflows. You need a KSh 2M loan to expand. The loans officer asks for your management accounts. You hand over a shoebox of receipts and a printed M-Pesa statement.

The problem is not your business. The problem is the presentation of your financial data. This tutorial shows you how to generate a professional, loan-ready financial pack from your dashboard in under an hour.

What banks actually want to see

Kenyan banks evaluate SMEs using the 5 C's of Credit. Three of them you can demonstrate with a dashboard.

Capacity

Can you repay from cash flow?

  • Your ability to repay from business cash flow
  • Shown through P&L statements
  • Needs 12 months of history
  • Must show a stable or rising trend
  • Owner's salary included as an expense
Capital

How much of your own money is in it?

  • Your own equity in the business
  • Shown through a balance sheet
  • Assets, liabilities and equity
  • Signals how much skin you have in the game
  • Low equity means higher risk to the bank
Conditions

What is happening in your market?

  • The market context you operate in
  • Shown through revenue trends
  • Supported by industry data
  • Explains seasonality in your numbers
  • Turns a bad month into a known pattern

Step 1: Ensure your data is clean

Before generating the pack, verify four things. If any of them are messy, spend a week cleaning them first. A clean pack is a credible pack.

  • All M-Pesa transactions are reconciled with your order records.
  • All expenses are recorded and categorised.
  • Inventory is counted and valued.
  • Debtors, who owe you, and creditors, who you owe, are up to date.
A loans officer can tell in two minutes whether a pack was assembled carefully or thrown together. Clean data is the difference between a conversation and a polite smile.

Step 2: Generate the monthly P&L statement

  1. Go to "Reports" then "Profit & Loss."
  2. Select the date range: last 12 months.
  3. Export as PDF.

The P&L should show these five lines, in this order.

1

Revenue

Total sales for the period. This is the number your M-Pesa inflows should support.

Revenue is the top line. It is not the story yet.
2

Cost of Goods Sold

The cost of the products sold. This is what turns revenue into gross profit.

Gross Profit = Revenue minus COGS.
3

Operating expenses and net profit

Rent, salaries, utilities, transport and the rest. What remains after these is net profit.

Net Profit = Gross Profit minus Operating Expenses.
Important: Ensure "Owner's Salary" is included as an expense. This shows the bank the true profitability of the business, not a profit inflated by unpaid labour.

Step 3: Generate the balance sheet

  1. Go to "Reports" then "Balance Sheet."
  2. Select the most recent date.
  3. Export as PDF.
Assets Cash, stock, equipment, receivables
Liabilities Supplier credit, loans, payables
Equity Your stake in the business
The balance sheet answers the question the P&L cannot. What is the business actually worth, and how much of it is yours?

Step 4: Generate the debtor and creditor aging reports

  1. Go to "Reports" then "Accounts Receivable Aging."
  2. Go to "Reports" then "Accounts Payable Aging."
  3. Export both as PDF.
Debtors

Future cash inflows

  • Who owes you money
  • How much they owe
  • How overdue the balance is
  • Proof of upcoming cash coming in
  • A bank wants to see this is healthy
Creditors

Known obligations

  • Who you owe money to
  • How much you owe
  • When it falls due
  • A clear picture of obligations
  • Prevents surprises during review

Step 5: Generate the inventory valuation report

  1. Go to "Reports" then "Inventory Valuation."
  2. Export as PDF.

This shows the value of your stock at cost. Banks sometimes accept inventory as collateral for asset-based lending, so a valued stock list is not just housekeeping.

Step 6: Generate the eTIMS reconciliation report

  1. Go to "Reports" then "eTIMS Summary."
  2. Export as PDF.
This shows your compliance status and that your sales are properly reported. Banks increasingly care about tax compliance, and a clean eTIMS summary quietly answers questions before they are asked.

Step 7: Compile the loan-ready pack

Combine all the PDFs into a single document with a cover page.

  • Business name, registration number and KRA PIN.
  • Contact details.
  • Table of contents.
  • All the reports listed above.
Optional but powerful: Have a small accounting firm review and stamp the pack. The cost, around KSh 5,000 to 15,000, is worth it for the credibility boost.

Step 8: Present with confidence

When you walk into the bank, hand over a clean, professional pack. The loans officer will immediately see that you are organised and credible. This dramatically improves your chances of approval and can even get you a better interest rate.

You are not asking for a favour. You are presenting a business. The pack does the arguing before you say a word.

The compound effect

The short version

Once you have built this pack once, it is easy to update quarterly. Your business becomes loan-ready at any time.

You can seize opportunities quickly, without scrambling for paperwork. Make your business credit-ready. Build the pack.

Ready to walk in with a real pack?

Stonehenge Digital builds business management systems that generate P&L statements, balance sheets, aging reports and eTIMS summaries, so your loan pack is ready whenever the opportunity appears.

Make My Business Loan-Ready →
Share Written by ceofounder

Interested in Business Management System?

Let's build this for your business

Replace spreadsheets, paper records, and WhatsApp chaos with a custom system built for exactly how your business works.

Leave a Comment

Share Your Thoughts