Payroll Cashflow Planner

Formula

Monthly Payroll = (Total Salary × (1 + Tax Rate)) / 12; Working Capital Need = (Monthly Payroll / 30) × Revenue Collection Lag Days

The formula calculates total payroll cost including employer taxes, then distributes annually to monthly obligations. Working capital need is calculated by determining daily payroll cost and multiplying by how many days revenue collection lags. This works because it captures the timing mismatch: if you pay employees on day 1 but collect revenue on day 30, you need 30 days of payroll in reserve. The tax multiplier ensures the full cost (not just gross salary) is accounted for.

Worked Examples

Example 1: Growing Startup

Problem:25 employees, $70K average salary, biweekly payroll. $500K monthly revenue with Net-30 terms.

Solution:Payroll: $71,154 biweekly ($142K monthly with taxes). Revenue lags by 30 days. Need $142K working capital minimum. Revenue:Payroll = 3.5x (Healthy).

Result:$142K monthly payroll | Net-30 creates 1-month lag | $150K working capital recommended

Example 2: Seasonal Business

Problem:15 employees, $50K average, weekly payroll. Revenue varies $100K-$400K seasonally.

Solution:Payroll: $18,750/week ($75K monthly). Low season revenue only $100K. Cash strain during slow months. Need $150K+ reserve for 2-month low period.

Result:$75K fixed monthly cost | Revenue varies 4x | Significant reserves needed

Example 3: Service Business

Problem:50 employees, $60K average, biweekly. $800K monthly revenue, Net-45 collection.

Solution:Payroll: $140K biweekly ($280K monthly). Revenue lags 45 days. Need $420K working capital (1.5 months). Revenue:Payroll = 2.9x (Adequate but tight).

Result:$280K monthly payroll | Net-45 is painful | Negotiate faster payment terms

Frequently Asked Questions

What payroll cycle is best for cash flow?

Monthly payroll minimizes administrative overhead and stretches cash flow. But employees often prefer biweekly or weekly. Biweekly is most common in the US. Match to industry norms and employee preferences.

How much working capital do I need for payroll?

At minimum, one full payroll cycle's worth. For biweekly, keep 2 weeks of payroll + taxes in reserve. Add buffer for revenue collection delays. Many small businesses struggle because revenue lags payroll obligations.

What's the full cost of payroll beyond salary?

Add 25-40% for employer taxes (FICA, unemployment), benefits, 401k matching, and payroll processing fees. A $70K salary costs ~$90-100K fully loaded.

How do payroll taxes affect cash flow?

Employer taxes are paid on a schedule (monthly or semi-weekly depending on size). You must set aside funds with each payroll even if payment is later. Failure to pay payroll taxes has severe penalties.

Should I use a payroll service?

Almost always yes. DIY payroll for 5+ employees is risky—errors create tax penalties. Services (Gusto, ADP, Paychex) handle calculations, filing, and payments. Cost is $40-150/month base plus $4-12 per employee.

What if I can't make payroll?

Urgent: cut non-essential expenses, delay vendor payments (not employees), draw on credit line, or seek emergency financing. Long-term: address underlying burn rate or revenue issues. Missed payroll damages morale severely.

How does revenue timing affect payroll planning?

If customers pay Net-30 or Net-60, your cash lags revenue. You may owe payroll before receiving payment for the work. Bridge this with credit lines, faster payment terms, or cash reserves.

What are payroll best practices for startups?

Keep 3 months payroll in reserve, use payroll service from day one, set aside taxes immediately, pay yourself a salary (not just distributions), and plan for payroll growth when hiring.

How do I project payroll for growth?

Model headcount growth, account for step-function costs (new benefit tiers), and plan for raises. Payroll is typically the largest expense—forecasting it accurately is critical for fundraising and planning.

What's the impact of switching payroll frequency?

Weekly to biweekly: halves admin overhead, doubles cash float. Monthly saves more but employees may resist. Changes require clear communication and one-time transition adjustment.

Background & Theory

Payroll cashflow planning ensures sufficient liquidity to meet recurring payroll obligations despite revenue collection delays and variability. ## Concept Overview Payroll is a non-negotiable fixed cost on a fixed schedule. Revenue is variable and often delayed (invoicing, payment terms). The gap between when you owe payroll and when you collect revenue creates working capital requirements. Effective planning models both sides. Project revenue collection timing. Schedule payroll obligations. Identify gaps requiring reserves or credit. The goal is never missing payroll—the damage is catastrophic. ## Key Variables & Intuition • **Total payroll** — Salary plus employer taxes and benefits • **Payroll frequency** — How often you pay (weekly, biweekly, etc.) • **Revenue timing** — When cash actually arrives • **Payment terms** — Net-30, Net-60, etc. • **Seasonal variation** — Revenue fluctuations ## Assumptions • Payroll is consistent and predictable • Revenue forecasts are reasonable • Payment terms are enforced • No major unexpected expenses ## Limitations & Edge Cases • **Payment delays** — Customers may pay late • **Seasonal businesses** — Revenue varies dramatically • **Growth** — Hiring changes payroll faster than revenue scales • **Commission structures** — Variable comp complicates planning **Scenario:** A consulting firm hires aggressively, doubling headcount. Revenue will eventually follow but lags by 3-6 months (sales cycle). Payroll obligation doubles immediately. Without reserves or credit, they run out of cash despite future profitability. ## Interpretation Guide **Revenue to Payroll Ratio:** - Over 3x: Healthy cushion - 2-3x: Adequate - 1.5-2x: Tight - Under 1.5x: Concerning **Working Capital Need:** - Minimum: 1 payroll cycle - Safe: 2-3 months payroll - Conservative: 6 months ## Practical Tips • **Forecast cash, not just revenue** — Revenue on books doesn't pay bills • **Maintain payroll reserve** — 2-3 months minimum • **Negotiate payment terms** — Faster collection improves cash flow • **Plan for growth** — Payroll increases before revenue • **Use credit strategically** — Bridge temporary gaps, not chronic shortfalls • **Monitor daily** — Cash position can change quickly ## Common Mistakes • **Confusing revenue and cash** — Accrual accounting misleads • **No cash reserves** — First unexpected expense creates crisis • **Growing too fast** — Payroll scales before revenue • **Ignoring taxes** — Employer taxes are significant • **No credit facility** — Emergency credit at crisis time is expensive • **Missing payroll** — Destroys morale and may violate law ## When NOT to Use • **Very stable cash flows** — Less planning needed if revenue is predictable • **Funded startups** — Cash runway is primary concern, not monthly gaps • **Solo practitioners** — Different planning approach for individual income

History

Payroll cash flow management evolved from manual ledgers through automated systems to modern real-time financial planning platforms. ## Origins & Why It Emerged Early businesses paid workers daily or weekly in cash. "Cash flow" meant literal cash on hand. Businesses needed cash reserves to meet payroll—a problem as old as employment. Payroll checks (early 20th century) created banking relationships and systematic scheduling. Biweekly and monthly cycles emerged. The timing mismatch between revenue (variable, delayed) and payroll (fixed, immediate) became a planning problem. Payroll taxes (Social Security 1935, Medicare 1965) added complexity. Employers became tax collectors, owing immediate payments even if customers paid later. The working capital requirement increased. ## How It Evolved in Practice Payroll services emerged in the 1940s-50s. ADP, Paychex, and others took on the burden of calculations, checks, and tax filing. This reduced errors but didn't solve cash flow timing. Electronic payments (direct deposit, widespread by 2000s) improved efficiency. Same-day ACH eliminated check float. The timing precision increased—making cash planning more critical. Modern treasury management treats payroll as a scheduled obligation. Cash flow forecasting predicts needs weeks ahead. Lines of credit buffer gaps between revenue collection and payroll dates. ## Modern Usage Today Modern payroll platforms integrate with banking and accounting. Real-time visibility into cash position relative to upcoming payroll. Automated tax withholding and payments prevent penalties. Embedded payroll in accounting systems (QuickBooks, Xero) enables holistic cash planning. Revenue forecasts inform hiring decisions. Scenario modeling shows payroll affordability. ## Common Misconceptions Historically • **Revenue equals cash** — Revenue is recorded when earned, not when collected • **Payroll timing is flexible** — Missing payroll has severe legal and morale consequences • **Payroll is just salary** — Taxes and benefits add 25-40% • **Small businesses don't need working capital** — Timing mismatches affect all sizes • **Credit cards solve cash flow** — Expensive short-term solution that compounds problems