Four tools for a grocery store or any Klamath Falls, OR business getting ready to call: a gap worksheet with invented figures, a statement read-through, a records list by funding type and the calculator.
Payroll Week Gap Worksheet for a Klamath Falls, OR Grocery Store
Illustration only, invented figures: before calling, a grocery store sets the next two weeks of cash going out against the cash coming in. Every amount in the table is invented; the store would fill in its own.
| Line | Invented amount | Where the figure comes from |
|---|---|---|
| Payroll for the next two weeks | $18,935 | The payroll register or the last two pay runs |
| Supplier invoices due in the same two weeks | $12,715 | Supplier statements |
| Cash going out | $31,650 | The two lines above, added |
| Bank balance today | $4,965 | Online banking or the latest statement |
| Card deposits expected | $24,170 | Card processing statements for recent weeks |
| Gap to cover | $2,515 | Cash going out, less the balance and the deposits |
An invented gap of $2,515 that closes once the next weeks’ sales come in points to a short draw on a line of credit or a small working capital loan, not a multi-year term loan. Keep the sheet in front of you on the call.
Reading Your Bank Statements Before a Funding Partner Does
- Mark every deposit that came from sales, and set aside transfers between your own accounts.
- Total the sales deposits for each month and set the months side by side.
- Circle each loan payment and each lease payment, with its amount and its schedule.
- Flag any overdraft or returned-item fee and write one line on what caused it.
- Note how far the balance dropped in each month, not only where it closed.
- List any large one-time deposit, such as an insurance payment or money the owner put in, with a short explanation.
A partner reads statements for its own reasons and may weigh them differently. This read-through only makes sure nothing in them surprises you on the call.
Records by Funding Type, Starting With the Payroll Register
- Working capital: the payroll register and the bank statements that show when deposits land.
- Line of credit: the same statements, plus a list of the recurring supplier orders the line would carry.
- Equipment financing: the dealer’s written quote naming the machine, its price and its delivery date.
- Inventory financing: supplier invoices or a purchase order, and a recent stock count.
- Merchant cash advance: the card processor’s monthly statements, because the provider takes its share out of card sales.
A term loan draws on the same records as working capital, with the quote or invoice for the one-time cost added. A partner can add to this list as it sees fit.
The Working Capital Payment Calculator
The working capital and credit line calculator takes an amount, an annual rate and a number of months, and returns the level monthly payment and the interest over the term. Credit line draws do not fit a level payment, so that page works them by hand, with invented draws at a motel.
Cash Flow Forecasts and Longer Cases on the Blog
The Fairgrove blog lays out a 13-week cash flow forecast for a lodge and the steps for building a forecast around a grocery store’s equipment repair. It takes one cost at a time further than these worksheets do.
By Fairgrove Funding Group · Updated