Which months are my weakest?
Slow months do not have to catch you off guard. If you know which months consistently underperform, you can build a cash buffer, cut discretionary spend, and shift sales effort before the dip arrives. Here's how to find your weakest months.
The short answer
Your weakest months show up in a 12-month P&L. Pull a Profit and Loss report displayed by month, covering the last 12 months (ideally 24). The months that consistently land at the bottom are your seasonal valleys. Below, we walk you through how to do this in QuickBooks and Xero.
Why identifying your weakest revenue months prevents cash surprises
January felt terrible. Revenue dropped 35% from December. You scrambled to cover payroll, delayed a vendor payment, and spent the whole month anxious about whether the business was in trouble.
Then February bounced back. And when you looked at the prior year, the exact same thing happened: December was strong, January was weak, February recovered. It was not a crisis. It was a predictable seasonal dip that you could have prepared for with 30 minutes of analysis.
The damage from a slow month is not the slow month itself. It is the reactive decisions you make when you did not see it coming. You cut marketing at exactly the wrong time. You delay a hire you need for the spring rush. You negotiate a desperate payment plan with a vendor when you could have simply held back cash the month before.
What a seasonal valley analysis reveals about your business
When you look at your 12-month revenue broken down by month, you are looking for three things on the low end:
- Consistent low months. Which 2-3 months consistently have the lowest revenue? If January is your weakest month two years in a row, it is structural, not a fluke.
- The depth of the valley. Is your weakest month 10% below average or 40% below? A shallow dip is manageable. A deep valley requires serious cash planning. Calculate how much less your weakest months bring in compared to your monthly average.
- Whether expenses also drop. Revenue drops, but do your costs drop with it? If expenses stay flat while revenue dips, your weakest months might actually be your most dangerous months from a cash flow perspective.
Ideally, compare 24 months of data so you can confirm whether the pattern repeats. One year of data shows the shape. Two years confirms whether the shape is real.
How to find your weakest months in QuickBooks Online (step by step)
The same Profit and Loss by Month report that shows your peaks also shows your valleys. Here is how to pull it:
- 1Go to Reports → Profit and Loss
From the left sidebar, click Reports. Search for “Profit and Loss.”
- 2Set to 12 months displayed by month
Change the date range to the last 12 months. Click Customize, then under Rows/Columns set “Display columns by” to Months. Click Run report.
- 3Identify the lowest Total Income months
Look at the Total Income row across all 12 columns. The 2-3 lowest months are your seasonal valleys. Note the dollar amount and how far below your monthly average they fall.
- 4Check whether expenses also dip
Look at Total Expenses in those same weak months. If revenue drops 30% but expenses only drop 5%, your net income takes a much bigger hit than the revenue number suggests.
- 5Add prior year comparison
Click Customizeand under “Compare another period,” select Previous year (PY). If the same months were weak last year, you have a confirmed seasonal pattern. Export to Excel for side-by-side charting.
Total time: about 10-15 minutes for the report, plus another 10-15 if you export and chart both years. You should revisit this at least quarterly.
How to find your weakest months in Xero (step by step)
Xero's Compare Periods feature makes it easy to see all 12 months side by side:
- 1Go to Accounting → Reports → Profit and Loss
From the top menu, click Accounting, then Reports. Select “Profit and Loss.”
- 2Configure for 12 monthly periods
Click the Compare Periodstab. Set the period to 1 month and under “Compare With,” select Previous 11 Periods. Click Update.
- 3Find the valley months
Scan the Total Revenue row. The months with the lowest numbers are your seasonal valleys. Check Total Operating Expenses for the same months to see whether costs also decrease.
- 4Export and compare to prior year
Export the report to Google Sheets or Excel. Then rerun the report for the prior 12-month window and export again. Place them side by side to see if the same months repeat as valleys.
Total time: about 10 minutes for a single year. Double it if you want to compare two years. Xero does not have built-in year-over-year comparison in the same view, so you will need the spreadsheet.
What it takes to stay ahead of your seasonal valleys
Knowing your weak months once is useful. Keeping that knowledge current and actionable is where most owners give up:
- You need 12+ months of clean data. If your books are behind or miscategorized, the monthly breakdown will be misleading. One large invoice coded to the wrong month throws off the entire pattern.
- Revenue alone does not tell the whole story. Your weakest revenue month might not be your most dangerous month. If expenses are flat and receivables are slow during that same period, the cash impact is worse than the revenue number suggests.
- You need to act 1-2 months before the valley. Knowing January is weak in February does not help. You need the analysis in October or November so you can hold cash and ramp outreach.
- Patterns shift as your business evolves. New products, new markets, and new customer segments can change which months are weakest. You need to recheck this regularly, not just once.
Or get warned about seasonal valleys before they arrive
Bottomline connects to your QuickBooks or Xero account once. Every month, it analyzes your trailing 12 months of revenue, compares it to the prior year, and flags which months are your weakest. More importantly, it tells you before a valley month arrives so you can prepare.
Because Bottomline also connects to your CRM and ad platforms, it can show you whether weak months correlate with lower close rates, reduced ad performance, or both. That context helps you decide whether to push harder during the valley or simply plan around it.