← Back to Stories

Story · Solution

The owner knows if payroll clears and what closes the gap

Payroll goes out at the end of the month, and our largest coffee bill can fall due in the same week.

Sound familiar?

I cannot tell from today's balance whether payroll will clear in the week our biggest bill falls due.

Why it hurts

I own a small coffee roaster with a wholesale side. Payroll goes out at the end of the month, and our largest coffee bill can fall due in the same week. The bank balance looks fine today, but I cannot tell from it whether the week of payroll will hold, and I do not want to find out in the middle of the night.

How it is solved

Know, two weeks ahead, whether payroll can be paid without the cash falling below the buffer I keep, and if not, exactly what would close the gap.

  1. The owner starts the payroll plan. It checks payroll against the books, asks the cash advisor to explain the result in plain words, and files the plan.
  2. The owner reads the plan, which is three lines: the payroll date and amount with the low point of the tightest week, how far that low point falls below the buffer, and the collections that would close the gap. A line whose figure cannot be filled from the books is held back rather than guessed.
  3. The owner checks the verdict. The payroll check gives one verdict, covered, at risk or a gap, with the size of the shortfall and the accounts and invoices to collect. When the verdict is at risk, it names the customer invoices whose collection would close the gap.
  4. The owner sees the weeks behind it. The cash outlook for the coming weeks shows each week's expected balance and its low band, and marks the tightest week, where payroll and large supplier bills fall together. A fixed monthly cost such as rent is counted as recurring, even when it was entered as a separate bill each month and never marked recurring. Every figure opens onto the rows it came from.

Works with

QuickBooks, Stripe, PayPal

The result

A payroll plan with one verdict, covered, at risk or a gap; the tightest week and how far its low point falls from the buffer; and the invoices to collect to close any gap. The owner knows whom to call, well before the money is needed.

  • If the cash stays above the buffer, payroll is approved with nothing to do.
  • If the cash dips below the buffer, the shortfall is found weeks ahead, with the invoices to chase first.
  • If the cash cannot cover payroll in time, the owner sees it early enough to arrange a transfer or a short-term line.

Try it

The demo runs on WidgetCo Coffee Roasters, an example business: a coffee roaster with an online store and a wholesale side. You will see it as Dana, the owner.

Connected to this story