The one thing to fix this month
Old Mill Outfitters has started paying late
31 days late, on average, on its invoices since May
Old Mill Outfitters is your most regular customer: a Barrel Room event almost every month. It paid on time until April. Since then it has paid each balance 28–34 days after the due date, and the October balance of $1,125 is 13 days overdue now. Everyone else pays on time (0.6 days late on average).
Suggestion: ask Old Mill for the full balance a week before each event, as you already do for the deposit, or call them about the October invoice before their next booking.
Revenue, last 12 months
$316.5K
+10% vs the 12 months before
Revenue, October
$24,100
+8% vs Oct 2025
Unpaid balances
$6,900
4 invoices, $1,125 overdue
Booked ahead, Nov–Jan
$50.6K
+15% vs this time last year
Revenue by month
Private events bring in most of the money; July was the best month ($48,600). October 2026 came to $24,100.
- Private events (Barrel Room, Beer Garden)
- Brewery tours
The chart needs JavaScript; the same numbers are in the table below.
Show the numbers as a table
| Month | Private events | Tours | Total |
|---|---|---|---|
| Nov 2025 | $20,950 | $1,675 | $22,625 |
| Dec 2025 | $35,050 | $975 | $36,025 |
| Jan 2026 | $10,350 | $800 | $11,150 |
| Feb 2026 | $9,500 | $625 | $10,125 |
| Mar 2026 | $10,750 | $625 | $11,375 |
| Apr 2026 | $13,800 | $1,275 | $15,075 |
| May 2026 | $28,300 | $1,650 | $29,950 |
| Jun 2026 | $37,850 | $1,950 | $39,800 |
| Jul 2026 | $46,700 | $1,900 | $48,600 |
| Aug 2026 | $27,350 | $3,025 | $30,375 |
| Sep 2026 | $35,400 | $1,925 | $37,325 |
| Oct 2026 | $22,950 | $1,150 | $24,100 |
Unpaid invoices
$6,900 is waiting on 4 invoices. Balances are due 14 days after the event.
- Not yet due
- 1–30 days overdue
- 31–60 days overdue
- Over 60 days overdue
Show the unpaid invoices
| Invoice | Customer | Due | Balance | Status |
|---|---|---|---|---|
| FF-2026-0118 | Old Mill Outfitters | Oct 18 | $1,125 | 13 days overdue |
| FF-2026-0123 | C-1235 | Nov 8 | $2,175 | Not yet due |
| FF-2026-0124 | Bramblewood Architects | Nov 10 | $1,688 | Not yet due |
| FF-2026-0125 | C-1231 | Nov 14 | $1,912 | Not yet due |
Slowest-paying regular customers
Average days late per invoice over the last 12 months, for business customers with two or more events. Paying early counts as zero.
- Old Mill Outfitters12.4 days
- Lantern & Quill Books1.7 days
- Tumbleweed Software0.5 days
- Nowhere Springs Historical Society0.3 days
- Nowhere Springs Rotary0.2 days
- Copper Kettle Catering0.2 days
Bookings vs last year
Events and tours held each month: 177 in the last 12 months, against 160 the year before (+11%).
- Nov 2025–Oct 2026
- Nov 2024–Oct 2025
The chart needs JavaScript; the same numbers are in the table below.
Show the numbers as a table
| Month | This year | Last year |
|---|---|---|
| Nov | 14 | 10 |
| Dec | 21 | 18 |
| Jan | 7 | 7 |
| Feb | 7 | 7 |
| Mar | 7 | 9 |
| Apr | 11 | 10 |
| May | 16 | 16 |
| Jun | 20 | 13 |
| Jul | 22 | 20 |
| Aug | 19 | 19 |
| Sep | 18 | 17 |
| Oct | 15 | 14 |
What changed since last month
- Revenue was $24,100, down 35% on September ($37,325), as the Beer Garden season ended. Compared with Oct 2025 it is up 8%.
- 8 new private events were booked in October, against 10 in September. 6 of them are for December, the busiest month for parties.
- Booked ahead for November to January: 24 events and tours worth $50,650, up 15% on the same point last year.
- Old Mill Outfitters went from paying late to having an overdue balance (FF-2026-0118, $1,125).
Notes
-
Built from
invoices.csvandbookings.csv, exported October 31, 2026. Revenue is the value of events and tours held each month, not counting cancellations. Tours are paid when booked, so they have no invoices. - Only operating records were used: no names of people, contact details, payroll, bank or card data. Individual customers appear as customer IDs.
- These figures are estimates built from the files you shared. They are not tax, accounting or financial advice. Check anything important with your accountant.