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.
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
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
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.
Step 2: Generate the monthly P&L statement
- Go to "Reports" then "Profit & Loss."
- Select the date range: last 12 months.
- Export as PDF.
The P&L should show these five lines, in this order.
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.Cost of Goods Sold
The cost of the products sold. This is what turns revenue into gross profit.
Gross Profit = Revenue minus COGS.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.Step 3: Generate the balance sheet
- Go to "Reports" then "Balance Sheet."
- Select the most recent date.
- Export as PDF.
Step 4: Generate the debtor and creditor aging reports
- Go to "Reports" then "Accounts Receivable Aging."
- Go to "Reports" then "Accounts Payable Aging."
- Export both as PDF.
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
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
- Go to "Reports" then "Inventory Valuation."
- 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
- Go to "Reports" then "eTIMS Summary."
- Export as PDF.
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.
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.
The compound effect
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 →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.