Spreadsheet: 800241d1665557639-index-and-match-ref-error-cash-budget-template
Sheet: budget_V(n)

 | Project Cash Flows
 | [NAME] |  | :
 | Project Name |  | :
 | As of |  | :
 |  |  |  | BUDGET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUDGET
 |  | Cash Flow Category |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 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 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00 |  | Project Total
 |  | CASHFLOWS
 |  | CASH INFLOWS
 |  | Advanced Payments
 |  | Progress Billing
 |  | Retention Payments
 |  | Other Collections
 |  | TOTAL INFLOWS
 |  | CASH OUTFLOWS
 |  | Labor
 |  | Plant and Equipment
 |  | Materials
 |  | Subcontractors
 |  | Temporaries
 |  | General Expense
 |  | Others
 |  | TOTAL OUTFLOWS
 |  | Interdepartmental charges
 |  | Internal Plant Billing - Internal Plant
 |  | Internal Plant Billing - RMCD/Concrete
 |  | TOTAL INTERNAL OUTFLOWS
 |  | CASH FLOWS FOR THE PERIOD
 |  | CASH FLOWS TO DATE
 |  | REVENUE AND COSTS
 |  | Accomplishment to Date (%)
 |  | Revenue to Date
 |  | Cost to Date
 |  | Margin to Date
 |  | Margin %
 |  | OTHER INFORMATION
 |  | RECEIVABLES
 |  | Billed Receivables
 |  | Unbilled Receivables
 |  | [NAME]
 |  | PAYABLES
 |  | Account Payable
 |  | [NAME]
 |  | INVENTORIES
 |  | UNSERVED PO
 |  | NO PO