Spreadsheet: 786822d1657471685-transposing-data-from-matrix-to-linear-format-sample
Sheet: Master Sheet

Item | Project # | Project | Contract Amount (ex GST) | Claimed to Date | Remaining to Claim | Remaining to be Paid | Invoice #1 |  |  |  |  | Invoice #2 |  |  |  |  | Invoice #3 |  |  |  |  | Invoice #4 |  |  |  |  | Invoice #5 |  |  |  |  | Invoice #6 |  |  |  |  | Invoice #7 |  |  |  |  | Invoice #8 |  |  |  |  | Invoice #9 |  |  |  |  | Invoice #10
 |  |  |  |  |  |  | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid | Amount | Date of Issue | Invoice # | Date Paid | Amount Paid
 | 2019 - 001 | Preparation of Generic Briefing Document for Literature Review and Gap Analysis |  |  |  |  | 3300 | 2019-10-28 00:00:00 | 2019-JPS-001-01 | 2019-11-21 00:00:00 | 3300
 | 2019 - 006 | Review of Community Sites | 7840 |  |  |  | 7840 | 2019-12-19 00:00:00 | 2019-006-01 | 2020-01-14 00:00:00 | 7840
 | 2019 - 014 | MITS Earthworks Review | 22680 |  |  |  | 20020 | 2020-02-19 00:00:00 | 2019-014-01 | 2020-03-12 00:00:00 | 20020 | 1540 | 2020-03-02 00:00:00 | 2019 -014-02 | 2020-03-24 00:00:00 | 1540 | 1120 | 2020-06-26 00:00:00 | 2019-014-03 | 2020-07-07 00:00:00 | 1120
 | 2019 - 015 | MITS Rigid Pavement Review | 20160 |  |  |  | 19316 | 2020-02-19 00:00:00 | 2019-015-01 | 2020-03-12 00:00:00 | 19316 | 884 | 2020-06-26 00:00:00 | 2019-015-02 | 2020-07-07 00:00:00 | 884
 | 2019 - 017 | Dickson S72 Driveway Review | 13440 |  |  |  | 9040 | 2020-03-12 00:00:00 | 2019-017-01 | 2020-03-31 00:00:00 |  | 4400 | 2020-03-26 00:00:00 | 2019-017-02 | 2020-04-07 00:00:00
 | 2019 - 027 | MITS & TRITS (RMS) Consultation | 21200 |  |  |  | 17020 | 2020-06-26 00:00:00 | 2019-027-01 | 2020-07-07 00:00:00 | 17020 | 4180 | 2020-11-25 00:00:00 | 2019-027-02 | 2020-12-03 00:00:00 | 4180
 | 2020 - 007 | [NAME] |  |  |  |  | 7840 | 2020-12-01 00:00:00 | 2020-007-01 | 2020-12-20 00:00:00 |  |  | 2021-06-01 00:00:00 | 2020-007-02 | 2021-01-18 00:00:00 |  |  | 2021-02-01 00:00:00 | 2020-007-03 | 2021-02-17 00:00:00 |  | 5440 | 2021-03-01 00:00:00 | 2020-007-04 | 2021-03-12 00:00:00 |  | 7040 | 2021-04-04 00:00:00 | 2020-007-05 | 2021-04-21 00:00:00 |  | 6720 | 2021-05-13 00:00:00 | 2020-007-06 | 2021-05-31 00:00:00 |  | 2240 | 2021-06-04 00:00:00 | 2020-007-07 | 2021-06-14 00:00:00 |  | 10400 | 2021-06-30 00:00:00 | 2020-007-08 | 2021-07-17 00:00:00 |  | 3360 | 2021-08-12 00:00:00 | 2020-007-09 | 2021-10-14 00:00:00 |  | 660 | 2022-03-10 00:00:00 | 2020-007-10 | 2022-06-16 00:00:00
 | 2021 - 024 | Denman Prospect 3 SIR |  |  |  |  | 29817 | 2021-12-13 00:00:00 | 2021-024-01 | 2021-09-02 00:00:00 |  | 24416.39 | 2021-09-17 00:00:00 | 2021-024-02 | 2021-09-23 00:00:00 |  | 2900 | 2021-10-18 00:00:00 | 2021-024-03 | 2021-10-28 00:00:00 |  | 24036 | 2021-11-25 00:00:00 | 2021-024-04 | 2021-12-14 00:00:00 |  | 14785.5 | 2021-12-21 00:00:00 | 2021-024-05 | 2022-01-06 00:00:00 |  |  | 2022-02-02 00:00:00 | 2021-024-06 | 2022-02-10 00:00:00 |  | 4498.7 | 2022-03-10 00:00:00 | 2021-024-07 | 2022-03-17 00:00:00 |  | 10550.06 | 2022-04-13 00:00:00 | 2021-024-08 | 2022-04-26 00:00:00 | 10550.06 | 18323.47 | 2022-05-05 00:00:00 | 2021-024-09 | 2022-05-12 00:00:00 | 18323.47
 | 2021 - 025 | 42 Cowper Street | 10800 |  |  |  | 7200 | 2021-08-12 00:00:00 | 2021-025-01 | 2021-08-31 00:00:00 |  | 2800 | 2021-09-17 00:00:00 | 2021-025-02 | 2021-09-17 00:00:00 | 2800 | 800 | 2021-10-18 00:00:00 | 2021-025-03 | 2021-10-19 00:00:00 | 800
 | 2021 - 026 | [NAME] | 16000 |  |  |  | 2400 | 2021-08-12 00:00:00 | 2021-026-01 | 2021-12-12 00:00:00 |  | 11200 | 2021-09-17 00:00:00 | 2021-026-02 | 2021-10-17 00:00:00 |  | 1600 | 2021-11-25 00:00:00 | 2021-026-03 | 2021-12-12 00:00:00
 | 2022 - 001 | Gladstone Coal Exporters Sports Complex |  |  |  |  | 6400 | 2021-09-17 00:00:00 | 2022-001-01 | 2021-11-10 00:00:00 |  | 6000 | 2021-10-18 00:00:00 | 2022-001-02 | 2021-11-02 00:00:00 |  | 2800 | 2021-11-25 00:00:00 | 2022-001-03 | 2021-12-15 00:00:00 |  | 4400 | 2022-02-02 00:00:00 | 2022-001-04 | 2022-04-01 00:00:00 |  | 3200 | 2022-03-10 00:00:00 | 2022-001-05 | 2022-03-24 00:00:00 |  | 5500 | 2022-04-13 00:00:00 | 2022-001-06 | 2022-06-15 00:00:00 | 5500
 | 2022 - 004 | CSIRO Ginninderra Due Diligence |  |  |  |  | 3200 | 2021-10-18 00:00:00 | 2022-004-01 | 2021-11-09 00:00:00 |  | 7200 | 2021-11-25 00:00:00 | 2022-004-02 | 2021-12-07 00:00:00 |  | 6200 | 2022-02-02 00:00:00 | 2022-004-03 | 2022-02-10 00:00:00 |  |  | 2022-03-10 00:00:00 | 2022-004-04 | 2022-05-10 00:00:00 | 12300 | 1200 | 2022-04-13 00:00:00 | 2022-004-05 | 2022-05-10 00:00:00 | 1200
 | 2022 - 005 | Kooyoo Street | 5000 |  |  |  | 2400 | 2021-09-17 00:00:00 | 2022-005-01 | 2021-10-04 00:00:00 |  | 300 | 2021-11-25 00:00:00 | 2022-005-02 | 2022-03-24 00:00:00
 | 2022 - 006 | [NAME] and Rond Terrace Superintendence |  |  |  |  | 6400 | 2021-10-18 00:00:00 | 2022-006-01 | 2021-11-09 00:00:00 |  | 14976 | 2021-11-25 00:00:00 | 2022-006-02 | 2021-12-07 00:00:00 |  | 19968 | 2022-02-02 00:00:00 | 2022-006-03 | 2022-02-15 00:00:00 |  | 24216 | 2022-03-10 00:00:00 | 2022-006-04 | 2022-04-26 00:00:00 |  | 9695 | 2022-04-13 00:00:00 | 2022-006-05 | 2022-05-10 00:00:00 | 9695
 | Project # | Project | Contract Amount (ex GST) | Invoice # | Amount | Date of Issue | Amount Paid | Date Paid
 | 2019 - 001 | Preparation of Generic Briefing Document for Literature Review and Gap Analysis | 3300 | 2019-JPS-001-01 | 3300 | 2019-10-28 00:00:00 | 3300 | 2019-11-21 00:00:00
 | 2019 - 006 | Review of Community Sites | 7840 | 2019-006-01 | 7840 | 2019-12-19 00:00:00 | 7840 | 2020-01-14 00:00:00
 | 2019 - 014 | MITS Earthworks Review | 22680 | 2019-014-01 | 20020 | 2020-02-19 00:00:00 | 20020 | 2020-03-12 00:00:00
 | 2019 - 014 | MITS Earthworks Review | 22680 | 2019-014-01 | 20020 | 2020-02-19 00:00:00 | 20020 | 2020-03-12 00:00:00
 | 2020 - 014 | MITS Earthworks Review | 22680 | 2019 -014-02 | 1540 | 2020-03-02 00:00:00 | 1540 | 2020-03-24 00:00:00
 | 2021 - 014 | MITS Earthworks Review | 22680 | 2019-014-03 | 1120 | 2020-06-26 00:00:00 | 1120 | 2020-07-07 00:00:00