How to project your December 2027 revenue using May data

Use May transaction data to forecast your December revenue and plan cash flow for year-end. Simple forecasting steps for Florida small businesses.

Small business owner forecasting December 2027 revenue using May 2026 transaction data and cash flow planning

P
Paola Vargas
Content Lead, Outsourcing Processing — Florida sales tax compliance & business reporting

Free Trial — Limited Time

Own a business? Not sure what you actually owe the IRS?

Connect your bank account and see your real numbers, plain and clear — reviewed by a CPA before anything is ever filed.

Built specifically for Florida businesses
Every number reviewed by a real CPA
Connects directly to QuickBooks Online
Free trial for a limited time, no credit card required

You’re halfway through May, and you’re doing okay—but you have no idea what December looks like. Maybe revenue spikes in the holiday season, or maybe it drops. Either way, you can’t plan labor costs, inventory, or tax obligations without knowing what’s coming. That’s the gap between running a business and running a business strategically. Projecting your December revenue using data you already have—transactions, customer patterns, and seasonal trends—turns guesswork into grounded planning. You don’t need advanced analytics or expensive software. You need a repeatable process that works with the numbers you’re tracking right now.

Does this sound like you? You’re running a Florida business and don’t have time to become a tax expert too. If a permit, an exemption rule, or the DR-15 has you stuck, see how the platform keeps this organized — your first period is free for a limited time, every tool unlocked, no credit card.

Does this apply to your business in Florida?

If you operate a Florida small business with variable monthly revenue—whether you sell tangible goods taxed under Florida Department of Revenue rules or deliver services—forecasting December using May data is essential for cash flow planning. This applies to service providers, retailers, contractors, and most other business models. You track transactions monthly; now you’ll use patterns to predict the largest month ahead.

Why December matters for cash flow planning

December is often your pivot point. For many small businesses, it’s a revenue peak (retail, hospitality, services tied to year-end planning). For others, it’s a soft month or unpredictable. Either way, December sets the tone for how you start January—whether you have cash reserves to cover lean months, enough to pay estimated taxes due, or a shortfall that forces borrowing. Your sales tax liability is also tied to sales volume, so forecasting December revenue gives you a better picture of what you owe to the Florida Department of Revenue by the 20th of January when your DR-15 report is due. Knowing this seven months early changes how you set aside cash weekly.

How to pull and organize your May data

Start with the month you’re in right now: May. Pull every transaction—invoices, sales receipts, customer payments—into one view. The goal isn’t perfection; it’s clarity. If you use accounting software, export or download your May P&L and revenue by customer or product line. If you track sales in a spreadsheet or paper receipts, list each transaction with its date and amount. You’re looking for patterns: which days were busiest, which customers spent the most, which products or services moved fastest. If you use our platform, it automatically organizes and categorizes your transactions so you’re not manually sorting through chaos.

Step 1: Calculate your May average daily revenue

Add up all May revenue (the money that came in, before expenses). Divide by the number of days you were open or operating. Say you did $15,000 in May over 22 business days—that’s $682 per day on average. This is your baseline. Don’t overthink seasonal variation yet; just get the number.

Now look at the shape of May. Did revenue cluster on certain days—weekends for retail, mid-month for invoice-based services? Did you land one big customer or contract? Did a particular product or service line drive the bulk? Write these down. These patterns repeat. If Mondays are always slow and Fridays are strong, December Mondays will likely be slow too (unless a holiday shifts things). If you closed a big contract in May, ask: will you close others in December? If that one customer was 40% of May revenue, don’t assume they’ll be 40% of December—instead, ask what’s realistic based on their buying cycle.

Step 3: Apply a seasonal adjustment factor

This is where you move from math into your business judgment. Does December typically run hotter or colder than May for you? If you don’t have historical data, talk to yourself: do you sell holiday gift items (likely up)? Do your customers spend less in December because they’re focused on holiday expenses (likely down)? Do you see a year-end rush of clients trying to complete projects before January (likely up)? Make a conservative guess: multiply your May daily average by a percentage. If you think December will run 20% higher, use 1.2. If you think it’ll run 15% lower, use 0.85. Be honest, not optimistic.

For example: $682 per day × 1.2 (20% seasonal boost) = $818 per day in December. If December has 22 business days, that’s $18,000 in projected December revenue.

Step 4: Stress-test your assumption

Before you trust this number, sanity-check it. Is $18,000 in December realistic based on your recent customer conversations, pipeline, and market conditions? If you know three big orders are likely, do they add up to this? If not, adjust down. If you’re unsure about a seasonal boost, use 1.0 (no change from May). A conservative forecast you believe is more useful than an aggressive one you ignore.

Step 5: Plan what you’ll do with this forecast

Now that you have a number, use it. If December revenue will likely be $18,000 and you typically pay yourself, labor, and fixed costs totaling $12,000, you’ll have $6,000 to set aside. Some of that covers sales tax liability (if you sell taxable goods or certain services, you owe tax on that $18,000 to Florida). Some becomes a cash buffer for January when revenue may drop. The rest is profit or reinvestment. Write down: (1) how much tax you’ll set aside based on December revenue, (2) how much cash you’ll keep for operations, (3) how much is profit. This shapes your weekly behavior between now and December.

How sales tax ties into your projection

If you sell tangible personal property in Florida, it’s taxable at 6% state rate plus a county surtax that varies by location. The combined rate depends on your county. If you provide services, most are not taxable unless they fall under specific taxable categories listed in Florida Statute 212. When you forecast December revenue, you’re forecasting tax liability too. Use floridarevenue.com or Florida’s sales tax calculator to find your county’s combined rate. Then, on your projected December revenue, apply that rate. If December revenue is $18,000 and your combined rate is 7% (example only—confirm with the calculator), you owe $1,260 to Florida by January 20. Set that aside monthly as you earn it, not in one lump sum on January 19.

Common mistakes to avoid when forecasting

Mistake 1: Using only May when you need historical patterns. If you’ve been in business more than one year, pull May data from prior years too. Did May 2025 revenue match May 2026? Did December 2025 spike compared to May? One month of data is a data point, not a pattern. If you’re new, don’t panic—use conservative assumptions (1.0 or slight upward adjustment) and plan to revise as more months pass.

Mistake 2: Forgetting one-time events. May might include a big contract, equipment sale, or refund that won’t repeat in December. Strip out one-time items before you calculate your daily average. Keep them separate so you can layer them back in if you know they’ll repeat in December (they usually don’t).

Mistake 3: Confusing revenue with profit. Projected December revenue of $18,000 doesn’t mean $18,000 cash in hand or $18,000 profit. It’s gross sales. Subtract cost of goods (if you sell products), labor, rent, supplies, and tax liability to get to profit. Many business owners project high revenue but forget their costs rise with it too.

Mistake 4: Setting the forecast and ignoring it until December. Your forecast is a guide, not a prison. Review it in June, July, September. Are actual patterns matching your assumptions? Are new customers or contracts changing the shape of your business? If reality diverges from your May projection by 20%, update the forecast. Forecasting is iterative, not a one-time calculation.

Turning forecasts into action

Once you have a December revenue projection, decide on three specific actions: (1) how much cash will you reserve weekly to cover taxes owed in January, (2) what staffing or inventory changes will you make to handle that revenue level, (3) what’s your plan if December underperforms—what costs can you trim? This is where planning stops being abstract and starts protecting your business. If you’re managing multiple months of forecasts or categories of revenue, organizing this data becomes complex fast. That’s where professional support—whether an accountant, a bookkeeper, or a platform like business process outsourcing—removes the friction and lets you focus on the business itself.

Frequently Asked Questions

Can I use May data alone to forecast December, or do I need more months?

If you’re new or in your first year, May alone is your only option—just use conservative seasonal adjustments (assume December runs similar to May unless you have strong reason to adjust). If you’ve been in business longer, pull 2–3 years of May and December data to spot true patterns. One month shows you the current shape; multiple years show you the seasonal story.

How do I account for holidays when forecasting December?

Count business days, not calendar days. December 2026 has fewer business days than May if Christmas and New Year fall on weekdays. If customers often close for the last week of December, adjust your business days down. A shorter month means lower absolute revenue even if daily rate stays the same—multiply your daily average by actual business days, not 30 or 31.

What if I’m a service business without seasonal patterns?

Use 1.0 as your seasonal factor (assume December matches May). Service businesses without seasonal swings still benefit from forecasting because labor and tax planning don’t change—you’re just confirming that cash flow stays level. If you do see variation (consultants often see year-end crunch), ask whether your customers have budget cycles or deadline pressure in December that drive more work.

Do I owe sales tax on my projected December revenue?

Only if you sell taxable goods or specifically taxable services in Florida. Most services are not taxable unless they’re on the state’s list. If you sell tangible products, yes—you owe tax at the combined state and county rate. Use your projected December revenue to calculate estimated tax liability so you can reserve cash now rather than scramble in January. Check with the Florida Department of Revenue if you’re unsure whether your sales are taxable.

Should I adjust my forecast if I know about a big contract or promotion planned for December?

Yes—but separately. Calculate your baseline December forecast using May patterns, then layer in known one-time events (a planned promotion, a contract you’ve already closed). This way you can see how much of December revenue is recurring (from patterns) and how much is dependent on specific actions. If the promotion falls through, you still know your baseline.

This article is for general educational purposes and isn’t a substitute for advice from a licensed CPA or tax attorney. Rules vary by jurisdiction and change over time—always confirm current requirements with the Florida Department of Revenue or your advisor.

Forecasting December from May data turns seven months of uncertainty into actionable cash flow planning. The math is simple—daily revenue times days times a realistic seasonal factor—but the discipline of doing it regularly builds the habit of running your business on numbers, not hope. Start with May, get one forecast in place, and watch how differently you move through June knowing what’s likely to arrive in December.

See Your Numbers, Organized

Automatic transaction categorization and sales tax tracking — your first period is free for a limited time, every tool unlocked, no credit card.