Because my company uses bi-weekly payroll periods, and also starts its week on Mondays (85 franchises, so I cannot effectively change everybody else!), I want to budget and track income and expenses based on some multiple of weeks, not months.
Your suggestion would work if I'm satisfied with only outputting a single period of time (2 week; 4 week, whatever) then just chose a time unit which is longer, thus will display all days in a single column. Thing is, I want to output multiple time periods, for comparison, budgeting, production bonuses, etc. QBO supports this, which is great
In the report settings (see image 1) I can choose a variety of time units, including monthly and weekly. Given readouts in weekly format, I can export to Excel, then combine the weeks into 2-week or 4-week units and get what I want.
However, the start/end dates will always be wrong unless I can re-define the default week as Mon-Sun, not Sun-Sat. The "weekly" readout shows my weeks OK, but they start and end on the wrong dates; the first complete week of 2015 for my business was Jan 5 - Jan 11, not Jan 4 - Jan 10; the second Jan 12 - Jan 18, not Jan 11 - Jan 17 (please see image 2) Therefore any combining or other manipulation of output will always be flawed, and will never match my payroll records, or my billing invoices to clients.