Merchant Fund Express
(305) 384-8391Apply

Worksheet

Payroll funding gap worksheet: how big is the gap, and when?

Enter your pay dates and when customer money is actually expected. The worksheet builds a dated ledger, finds the low point and sizes the bridge, so you request the right amount or none at all.

✓ Checking what you qualify for does not affect your credit score.

Map the gap

Updated October 13, 2026 · Merchant Fund Express

Payroll runs
Expected collections
First date below your cushion–
Low point–
Bridge needed (cushion minus low point)–
Gap window–

Illustrative arithmetic only. This is not an offer or a quote; real terms depend on your file and the funder.

See what I qualify for   All calculators

How the worksheet works

It sorts every payroll run and every expected collection by date, starts from the cash on hand you enter, and keeps a running balance. The rules it follows:

Rows with no date or a 0 amount are skipped, so blank rows never break the math
When payroll and a collection fall on the same date, payroll is subtracted first; money that arrives that afternoon does not help a morning payroll file
Low point = the lowest running balance across all dates
Bridge needed = your minimum cushion minus the low point, or $0 if the low point stays above the cushion
Gap window = from the first date below your cushion to the first date after the low point when the balance is back above it

Payroll here means the full amount that leaves the account on that date: net pay plus the payroll taxes your provider debits. Other bills are not modeled; take them out of cash on hand, or add them as payroll rows if they land on fixed dates.

A dated worked example

A staffing-heavy service business has $18,000 in the bank on November 2, 2026, wants to keep $5,000 as a cushion, and runs a $22,000 payroll every other Friday. Customers pay on 30-day terms, so collections arrive on their own schedule.

DateEventAmountBalance
Nov 6, 2026Payroll-$22,000-$4,000
Nov 10, 2026Collection$15,000$11,000
Nov 20, 2026Payroll-$22,000-$11,000
Nov 25, 2026Collection$20,000$9,000
Dec 1, 2026Collection$18,000$27,000
Dec 4, 2026Payroll-$22,000$5,000
Dec 15, 2026Collection$25,000$30,000

The account first drops below the cushion on November 6. The low point is -$11,000 on November 20. To cover that and keep $5,000 in the account, the bridge is $5,000 minus (-$11,000) = $16,000. The balance is back above the cushion on November 25, and the business is ahead again by December 15. A $16,000 bridge for 19 days is below the $25,000 minimum we fund, so this owner's better move is to ask one customer to pay early, shift a pay date, or draw on a smaller line of credit.

All figures in worked examples are illustrations of the arithmetic, not offers or quotes. Real terms depend on your file and the funder.

Who fits a payroll bridge, and who does not

A bridge fits a timing gap: the money is earned and invoiced, and the worksheet shows the balance recovering on a known date. If the gap is $25,000 or more and recovers within the term, a short working capital product or a business line of credit is the usual match. When most of the money owed sits in invoices to other businesses, invoice factoring can turn those invoices into cash without adding a daily payment.

It does not fit a cost gap: if the balance never recovers across the dates you entered, payroll is larger than what the business brings in. Borrowing for that only moves the shortfall forward and adds a payment on top. Fix staffing or pricing first, then test again. The payroll loans guide walks through those options.

What a funder reads

About 3 months of business bank statements, as PDFs, which show the payroll debits and customer deposits on their real dates
An accounts receivable list with due dates, when the plan depends on collections
Any existing advance or loan payments on those statements

Funding ranges from $25K to $5M, decisions are same-day on complete files, and funding can arrive in as little as 24 hours for qualified businesses. That speed helps only if you start before the pay date, not on it. See the funding requirements for the tier rules.

Next step

If the bridge is $25,000 or more and the balance recovers, test the payment it would add in the MCA cash flow stress test, then check what you qualify for with a soft credit pull.

Keep reading

MCA Cash Flow Stress Test: Base, -15% and -30% monthly cash test for an MCA payment, on gross profit.
Payment Burden Calculator: A dated 13-week cash test for a new payment, with a slow stretch built in.
Business Financing Guide: Every practical financing guide, organized by task.

Common questions

Should the cushion be zero?

Rarely. A zero cushion means one late customer payment or an unexpected debit bounces payroll. Many owners use one week of fixed costs.

Why does the worksheet put payroll before same-day collections?

Payroll files are usually funded at the start of the day, while customer payments can post late. Treating payroll first is the conservative reading.

What if my collections dates are uncertain?

Enter them later than you expect. Run the worksheet twice, on time and a week late, and size any bridge from the late version.

Can I bridge a gap smaller than $25,000 with Merchant Fund Express?

Our funding starts at $25,000. For a smaller, short gap, moving a date, collecting sooner or a small line of credit is often cheaper than any advance.

Does the bridge amount include the cost of the funding?

No. It is the cash the account needs. The payments on any funding come out of later balances, so test them in the stress test before you request.

See what you qualify for

Same-day decision. Applying takes a few minutes and will not affect your credit score.

Apply Now →
Apply NowCall