Short answer
Why can tax payment month create low cash even when profit is positive?
Profit and cash do not move on the same date. A company can show profit in one month, then pay corporate tax, VAT or sales tax, estimated tax, or payroll-related taxes later when cash is already tight.
Review
What to Check
- Tax type: separate corporate tax, VAT or sales tax, payroll tax, and estimated tax assumptions.
- Payment month: model the actual cash payment month, not only the month when profit is recognized.
- Tax payable: check whether an opening payable balance creates a cash outflow after the forecast starts.
- Overlap: tax payments can coincide with payroll, supplier payments, rent, debt service, or capex.
- Checks: review the cash balance and balance sheet checks before exporting Excel.
Next