Spreadsheet: 771338d1646638910-monthly-revenue-calculation-hang-up-fixed-excel-test-copy-aligw
Sheet: Income

 | Income - Test Copy |  |  |  |  | Note: 2022 entries are just made-up for testing purposes.
 | INCOME
 | 2022
 | SERV | PROJ # | INV # | CLIENT JOB # | CLIENT | INV ISSUED | INV DUE | PAY RECEIVED | PAY TYPE | Pay Month | xLATE | ORGL GROSS | SUBTOTAL | GST | PST | SUM TAX | LATE FEE | TOTAL
 | GW | 33-35 | 25 | 20-22 | Placeholder | 2022-11-02 00:00:00 | 2022-12-02 00:00:00 | 2022-11-26 00:00:00 | direct deposit |  |  |  | 500
 | GW | 32 | 24 | 19 | Placeholder | 2022-10-04 00:00:00 | 2022-11-04 00:00:00 | 2022-10-22 00:00:00 | direct deposit |  |  |  | 1725
 | GW | 29-31 | 23 | 16-18 | Placeholder | 2022-09-22 00:00:00 | 2022-10-22 00:00:00 | 2022-10-01 00:00:00 | direct deposit |  |  |  | 1000
 | E | 28 | 22 | 2 | Placeholder | 2022-05-28 00:00:00 | 2022-06-28 00:00:00 | 2022-05-28 00:00:00 | e-transfer |  |  |  | 290
 | GW | 27 | 21 | 15 | Placeholder | 2022-04-23 00:00:00 | 2022-05-23 00:00:00 | 2022-05-28 00:00:00 | direct deposit |  |  |  | 5000
 | E | 26 | 20 | 1 | Placeholder | 2022-04-19 00:00:00 | 2022-05-19 00:00:00 | 2022-04-19 00:00:00 | e-transfer |  |  |  | 4000
 | GW | 25 | 19 | 14 | Placeholder | 2022-02-18 00:00:00 | 2022-03-18 00:00:00 | 2022-02-26 00:00:00 | direct deposit |  |  |  | 1888
 | RS | 24 | 18 | 2 | Placeholder | 2022-02-08 00:00:00 | 2022-03-08 00:00:00 | 2022-01-29 00:00:00 | e-transfer |  |  |  | 1546
 | GW | 23 | 17 | 13 | Placeholder | 2021-01-01 00:00:00 | 2022-01-15 00:00:00 | 2022-01-29 00:00:00 | direct deposit |  |  |  | 975
 | 2021
 | SERV | PROJ # | INV # | CLIENT JOB # | CLIENT | INV ISSUED | INV DUE | PAY RECEIVED | PAY TYPE | Pay Month | xLATE | ORGL GROSS | SUBTOTAL | GST | PST | SUM TAX | LATE FEE | TOTAL
 | GW | 33-35 | 25 | 20-22 | Placeholder | 2021-11-02 00:00:00 | 2021-12-02 00:00:00 | 2021-11-26 00:00:00 | direct deposit |  |  |  | 3875
 | GW | 32 | 24 | 19 | Placeholder | 2021-10-04 00:00:00 | 2021-11-04 00:00:00 | 2021-10-22 00:00:00 | direct deposit |  |  |  | 1801.8
 | GW | 29-31 | 23 | 16-18 | Placeholder | 2021-09-22 00:00:00 | 2021-10-22 00:00:00 | 2021-10-01 00:00:00 | direct deposit |  |  |  | 2252.25
 | E | 28 | 22 | 2 | Placeholder | 2021-05-28 00:00:00 | 2021-06-28 00:00:00 | 2021-05-28 00:00:00 | e-transfer |  |  |  | 210
 | GW | 27 | 21 | 15 | Placeholder | 2021-04-23 00:00:00 | 2021-05-23 00:00:00 | 2021-05-28 00:00:00 | direct deposit |  |  |  | 3000
 | E | 26 | 20 | 1 | Placeholder | 2021-04-19 00:00:00 | 2021-05-19 00:00:00 | 2021-04-19 00:00:00 | e-transfer |  |  |  | 80
 | GW | 25 | 19 | 14 | Placeholder | 2021-02-18 00:00:00 | 2021-03-18 00:00:00 | 2021-02-26 00:00:00 | direct deposit |  |  |  | 3000
 | RS | 24 | 18 | 2 | Placeholder | 2021-02-08 00:00:00 | 2021-03-08 00:00:00 | 2021-01-29 00:00:00 | e-transfer |  |  |  | 27.03
 | GW | 23 | 17 | 13 | Placeholder | 2020-12-15 00:00:00 | 2021-01-15 00:00:00 | 2021-01-29 00:00:00 | direct deposit |  |  |  | 3000
 | 2020
 | SERV | PROJ # | INV # | CLIENT JOB # | CLIENT | INV ISSUED | INV DUE | PAY RECEIVED | PAY TYPE | Pay Month | xLATE | ORGL GROSS | SUBTOTAL | GST | PST | SUM TAX | LATE FEE | TOTAL
 | RS | 22 | 16 | 1 | Placeholder | 2020-11-17 00:00:00 | 2020-12-17 00:00:00 | 2020-11-17 00:00:00 | e-transfer |  |  |  | 100
 | E | 21 | 15 | 1 | Placeholder | 2020-10-17 00:00:00 | 2020-11-17 00:00:00 | 2020-10-17 00:00:00 | e-transfer |  |  |  | 450
 | RS | 20 | 14 | 1 | Placeholder | 2020-09-15 00:00:00 | 2020-10-15 00:00:00 | 2020-09-15 00:00:00 | e-transfer |  |  |  | 9.01
 | RS | 19 | 13 | 2 | Placeholder | 2020-08-28 00:00:00 | 2020-09-28 00:00:00 | 2020-08-28 00:00:00 | e-transfer |  |  |  | 36.04
 | RS | 18 | 12 | 1 | Placeholder | 2020-08-13 00:00:00 | 2020-09-13 00:00:00 | 2020-08-21 00:00:00 | e-transfer |  |  |  | 60
 | RS | 17 | 11 | 1 | Placeholder | 2020-07-04 00:00:00 | 2020-08-04 00:00:00 | 2020-07-09 00:00:00 | e-transfer |  |  |  | 45.05
 | C | 16 | 10 | 1 | Placeholder | 2020-06-16 00:00:00 | 2020-07-16 00:00:00 | 2020-06-23 00:00:00 | direct deposit |  |  |  | 940
 | GW | 15 | INF | 2 | Placeholder | N/A | N/A | 2020-06-09 00:00:00 | e-transfer |  |  |  | 225.23
 | GW | 14 | 9 | 1 | Placeholder | 2020-05-15 00:00:00 | 2020-06-15 00:00:00 | 2020-05-19 00:00:00 | e-transfer |  |  |  | 50
 | GW | 13 | 8 | 12 | Placeholder | 2020-05-14 00:00:00 | 2020-06-14 00:00:00 | 2020-05-22 00:00:00 | direct deposit |  |  |  | 1000
 | GW | 12 | INF | 1 | Placeholder | N/A | N/A | 2020-05-01 00:00:00 | e-transfer |  |  |  | 225.23
 | GW | 11 | 7 | 11 | Placeholder | 2020-03-24 00:00:00 | 2020-04-24 00:00:00 | 2020-04-03 00:00:00 | direct deposit |  |  |  | 2000
 | GW | 10 | X | 1 | Placeholder | N/A | N/A | N/A | N/A |  |  |  | 0 | 0 | 0 | 0 |  | 0
 | GW | 9 | 6 | 10 | Placeholder | 2019-12-31 00:00:00 | 2020-01-31 00:00:00 | 2020-02-07 00:00:00 | e-transfer |  |  |  | 1000
 | C | 8 | 5 | 2 | Placeholder | 2019-12-13 00:00:00 | 2020-01-12 00:00:00 | 2020-02-04 00:00:00 | e-transfer |  |  |  | 100
 | 2019
 | SERV | PROJ # | INV # | CLIENT JOB # | CLIENT | INV ISSUED | INV DUE | PAY RECEIVED | PAY TYPE | Pay Month | xLATE | ORGL GROSS | SUBTOTAL | GST | PST | SUM TAX | LATE FEE | TOTAL
 | C | 7 | 4 | 1 | Placeholder | 2019-11-28 00:00:00 | 2019-12-28 00:00:00 | 2019-11-29 00:00:00 | e-transfer |  |  |  | 367.5
 | RS | 6 | 3 | 1 | Placeholder | 2019-10-15 00:00:00 | 2019-11-15 00:00:00 | 2019-10-15 00:00:00 | cash |  |  |  | 9.01
 | GW | 2–5 | 2 | 6–9 | Placeholder | 2019-06-06 00:00:00 | 2019-07-06 00:00:00 | 2019-06-21 00:00:00 | cheque |  |  |  | 5000
 | GW | 1 | 1 | 1 | Placeholder | 2019-06-05 00:00:00 | 2019-07-05 00:00:00 | 2019-08-03 00:00:00 | cheque |  | 1 | 504 | 559.44
 |  |  |  |  | Wasn't issuing late paym. invoices yet. Added row for annual calc's. |  |  |  |  |  |  |  | 504