Hi all - I'm trying to set up some budgeting and forecasting tools for my CEO. I've downloaded the "Small business budget" template, which helps, but he's got a preferred way of forecasting that doesn't quite correspond to anything simple.
Essentially, he's looking at when funds hit the business' bank account, not when the client pays the invoice.
I have invoice information and payments coming into my "income" table. I have my "Forecasts & Actuals" table with dates calculated there to show me the range of when payments coming in would hit that month.
For example - for January 2023 income, he'd be looking at payments between December 28th and January 27th instead of January 1 - 31. I've created columns with formulas that give me the "first date of payments" and "last date of payments" for each month.
I'm struggling with calculating the rollup of the sum of invoices paid between these two dates, as marked on the "Income" table.