Picture the last week of September: it starts on Monday the 28th and runs straight into October. Now your manager wants the monthly totals — and you’ve got one weekly figure sitting across two months. The free tool below ends the guesswork: paste your weekly totals, choose how a week should be weighted, and it splits every week across calendar months with an audit table that proves every number adds back up.
Weekly to Monthly Allocator
How the weekly to monthly allocator works
Every weekly total gets spread across the calendar months its days fall in. You decide what a week means and how each day is weighted, and the tool applies the same arithmetic every time — no hidden choices, no silent rounding.
To start, paste a table with the week date in the first column and one numeric column per zone or category. Tabs or commas both work, and the first row can be a header. Everything runs in your browser, so the numbers never leave your computer. Paste a handful of rows to test the idea, or your entire year at once — the tool treats both the same.
Split your weeks in four steps
- Paste your data. Copy the week dates and weekly totals straight from Excel or Google Sheets into the big box. Dates go in column one, and each extra column becomes its own zone or category.
- Define the week. Tell the tool whether your date marks the week start or the week end, and set the week length in days. Seven is the default, but any length works.
- Choose the weighting. Split by calendar days to count every day equally, or by weekdays only so weekends and listed holidays get zero weight. Tick whichever days count as your weekend — Saturday and Sunday come pre-selected.
- Pick the rounding. The default rounds every monthly slice to two decimals and fixes the remainder with the largest-remainder method, so each week’s split adds back to its input exactly. Choose No rounding if you’d rather see the raw shares.
Results show up live as you type: a month-by-category table, a week-by-week audit table, and a reconciliation badge that turns green when total in equals total out. Copy the table as TSV or download it as CSV when you’re done.
Split a pasted weekly table across months, with an audit trail
Paste your weekly table with a week date column and one number per zone or category, then set the week-start, week-end and week-length controls. The tool splits each week across its months by calendar days or weekdays only, and shows the month-by-category table plus a week-by-week audit table so you can check the totals add back exactly.
Worked example: one week, 700 in Zone A, split across September and October
Take the week starting Monday, September 28, 2026, with a Zone A total of 700. Split by weekdays only, the week holds five working days: September 28, 29 and 30 (three days in September) plus October 1 and 2 (two days in October). October 3 and 4 are the weekend and get zero weight.
September’s share is 3/5 of 700, which is 420. October’s share is 2/5 of 700, which is 280. Click Load example in the tool to watch it happen: the audit table shows 420.00 under September 2026 and 280.00 under October 2026, the split total reads 700.00, and the reconciliation badge turns green.
Pick calendar days instead and the same week splits 3/7 to September (300.00) and 4/7 to October (400.00) — a clearly different answer from the same input. Same week, same 700 — only the rule changes. That’s exactly why the weighting choice matters, and why the tool makes it explicit.
Why the monthly totals always add back exactly
Rounding is where most spreadsheet splits quietly break. Round each slice to two decimals on its own and a week of 700 can come back as 699.99 or 700.01 — small, but enough to fail an audit.
Worked example
So the tool rounds every slice first, then hands the leftover fraction to the slice with the largest remainder, and the rounded monthly figures add back to the input total exactly. It’s the largest-remainder method — the same arithmetic election counts use. No manual fudging, no tweaked decimals — the maths handles the difference for you.
Then the reconciliation badge double-checks the whole table: total in against total out. Green means they match; red means something needs a look. Rows with an invalid date or a non-numeric value are skipped with a clear per-row warning, so one bad line can never corrupt the totals or produce a NaN.
Pairs well with your other cleanup tools
If your pasted numbers arrive glued to their units, run the column through a splitter that pulls numbers and units apart first. If the formulas that produced those weekly totals keep breaking when you copy them down a column, lock the references with a bulk reference locker. And if you also need to count how many days each trip or assignment actually spent inside a year, a counter for days spent inside a year handles that part.
Weekly to monthly allocator FAQs
If a week includes October 1, does that day belong to September or October?
October. Each day goes to the calendar month it actually falls in, so a week running September 28 to October 4 puts its September days in September and its October days in October — the tool never dumps a whole week into one month.
Should I split by calendar days or weekdays?
Pick weekdays when the total is really about work — sales targets, hours, staffing costs — because weekends and holidays shouldn’t take a share of it. Pick calendar days when the total accrues evenly every day, like rent or a daily rate. Not sure? Run both and compare; the audit table lays the difference out clearly.
Do the monthly totals add back exactly to my weekly totals?
Yes. Largest-remainder rounding guarantees each week’s monthly slices sum to its input, and the reconciliation badge checks that total in equals total out across the whole table. If anything ever fails the check, the badge turns red and tells you.
Can I paste a whole weekly table at once?
Yes. Paste the table with a week date column and one number per zone or category, and the tool splits every week across its months in one pass. The month-by-category table shows the result, and the week-by-week audit table shows how each week was split.
What is the audit table for?
It shows each week and how it was split, so you can check the work before trusting the monthly totals. Every day of every week lands in exactly one month, which is why the monthly totals always add back exactly to the weekly totals.
Note: this tool only splits the numbers you paste — it is plain arithmetic, not financial advice.