Spreadsheet: 823682d1680090207-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-r-and-ft-template-2-
Sheet: Budget

 | (Project name and code) - BUDGET TRACKER
 | Date | Cost Centre | Budget (At Strategise/Shape) | Approved Budget (at Initiate) | Change Requests |  | Budget Amounts
 |  |  |  |  | Reference | Value £
 | 2023-01-01 00:00:00 |  | 12000 | 15000
 |  |  |  |  | IT CR 578 | 10000
 | TOTALS
 | Total Budget | Committed | Remaining Budget | Actuals (to date)
 | PO INFO |  |  |  |  |  |  | BUDGET vs ACTUAL |  |  |  | INVOICES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICES
 |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | 2023-02-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2023-04-01 00:00:00 |  | 2023-05-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 | PO Number | Description | Cost Centre | Supplier | Date Requested | Status | PO Amount (Including VAT) | FORECAST | ACTUALS | PO BALANCE |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS
 | PO0000001 |  |  |  |  |  | 12500 | 13000 |  |  |  | 500 | 400 | 500 | 500 |  |  | 2000 | 2000 |  |  | 1000 | 500 |  |  | 1000 |  |  |  | 8000 | 7800
 | TOTALS
 | CHARGES INFO |  |  |  |  |  |  | BUDGET vs ACTUAL |  |  |  | INVOICES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVOICES
 |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | 2023-02-01 00:00:00 |  | 2023-03-01 00:00:00 |  | 2023-04-01 00:00:00 |  | 2023-05-01 00:00:00 |  | 2023-06-01 00:00:00 |  | 2023-07-01 00:00:00 |  | 2023-08-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-10-01 00:00:00 |  | 2023-11-01 00:00:00 |  | 2023-12-01 00:00:00 |  | 2024-01-01 00:00:00 |  | 2024-02-01 00:00:00 |  | 2024-03-01 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-05-01 00:00:00 |  | 2024-06-01 00:00:00 |  | 2024-07-01 00:00:00 |  | 2024-08-01 00:00:00 |  | 2024-09-01 00:00:00 |  | 2024-10-01 00:00:00 |  | 2024-11-01 00:00:00 |  | 2024-12-01 00:00:00
 | Charges Info | Description | Cost Centre | Supplier | Date Requested | Status | Amount (Including VAT) | FORECAST | ACTUALS | FORECAST VS  ACTUALS |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS
 |  |  |  |  |  |  |  | 13000 |  |  |  | 500 | 400 | 1000 | 500 |  | 500 | 1700 | 1700 |  |  | 500 |  |  | 500 |  |  | 8800 | 8500
 | TOTALS