Spreadsheet: 881177d1729101031-financial-forecasting-spreadsheet-financial-forecast_sheet
Sheet: Forecast

Month of … |  | Checking Beginning amount | This will need to be a manual entry |  |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12
 |  | Checking Month End |  |  | Checking Beginning amount | xxxxxx
 |  | [NAME] | Manual |  | Less monthly payments | xxxxxx
 |  | Petty Cash | Manual |  | Plus Accounts Receivables
 |  |  |  |  | Checking Month End
 |  | Payments to be made | Estimated payment total ([NAME]) |  | [NAME]
 |  |  |  |  | Petty Cash
 |  | Accounts Receivable | [NAME]  ([NAME] based on the GL account system will provide) |  | Ending balance takes in account the balances of AR, AP due dates on invoices and average days to pay.
 |  |  |  |  |  | Would like a conditional formatting so when cash gets low it changes colors.
Invoices Outstanding past due |  | 3 or 7 or 10 etc | Have a calculation that pushes invoices to the Pay invoice columun F22 based on the number of days past due specified. Which can change.
HEre I would like to have vendors that are monthly reoccuring payments that are the same payments. Electric, Health insurance, Subscriptions.
These would also be factored into the overal payables but since we wont get invoice numbers for them they may not appear in the list below.
Vendor1
 | oct- | $$$ | DATE
 | Nov- | $$$$ | Date | These dates wont get pushed over until it falls into the bracket specified above in C17
Vendor2 | Week1 | $$$$ | DATE
 | Week3 | $$$$ | Date
 |  |  |  |  |  |  | Payables
 |  |  |  |  |  |  | WEEK#1 | WEEK#2 | WEEK#3 | WEEK#4 | WEEK#5 | WEEK#6 | WEEK#7 | WEEK#8 | WEEK#9 | WEEK#10 | WEEK#11 | WEEK#12 | WEEK#13 | WEEK#14 | WEEK#15 | WEEK#16 | WEEK#17 | WEEK#18 | WEEK#19 | WEEK#20 | WEEK#21 | WEEK#22 | WEEK#23 | [NAME] | WEEK#25 | WEEK#26 | [NAME] | WEEK#28 | WEEK#29 | WEEK#30 | WEEK#31 | WEEK#32 | WEEK#33 | WEEK#34 | WEEK#35 | WEEK#36
Vendors to Pay
 | Invoice# | Invoice amount | Date due |  | Pay invoice (Formula)s | E | invoice 1
 |  | Invoice amount | Date1 |  |  |  | invoice 2
Lists all open Invoices for vendor # 100257 | invoice 2 | Invoice amount | Date2 |  |  |  | invoice 3
 | invoice 3 | Invoice amount | Date3 |  |  |  |  | invoice 4
 | invoice 4 | Invoice amount | [NAME] |  |  |  |  | invoice 5
 | invoice 5 | Invoice amount | Date5 |  |  |  |  | invoice 6
 | invoice 6 | Invoice amount | Date6 |  |  |  |  | invoice 7
 | invoice 7 | Invoice amount | Date7 |  |  |  |  |  | invoice 8
 | invoice 8 | Invoice amount | Date8 |  |  |  |  |  | invoice 9
 | invoice 9 | Invoice amount | Date9
 |  |  |  |  |  |  | invoice 1
Vendor B |  | Invoice amount | Date due |  |  |  |  | invoice 2
 | invoice 1 | Invoice amount | Date1 |  |  |  |  | invoice 3
 | invoice 2 | Invoice amount | Date2 |  |  |  |  | invoice 4
 | invoice 3 | Invoice amount | Date3 |  |  |  |  | invoice 5
 | invoice 4 | Invoice amount | [NAME] |  |  |  |  | invoice 6
 | invoice 5 | Invoice amount | Date5 |  |  |  |  | invoice 7
 | invoice 6 | Invoice amount | Date6 |  |  |  |  | invoice 8
 | invoice 7 | Invoice amount | Date7 |  |  |  |  | invoice 9
 | invoice 8 | Invoice amount | Date8
 | invoice 9 | Invoice amount | Date9
 |  |  | Total AP