Spreadsheet: 782181d1653885557-aged-debtor-report-formatting-question-aged-debtor-formatting
Sheet: PQ

Aged Debtor Report
 |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |  |  | Debtor | Invoice No | Date | Total | Period 1 | Period 2 | Period 3
 |  | Debtor ABC1 | Date | Total | Period 1 | Period 2 | Period 3 |  |  | Debtor ABC1 | Inv-001 | 2022-05-24 00:00:00 | 77 | 35 | 41 | 1
 |  | Inv-001 | 2022-05-24 00:00:00 |  | 35 | 41 | 1 |  |  | Debtor ABC1 | Inv-002 | 2022-05-26 00:00:00 | 86 | 21 | 37 | 28
 |  | Inv-002 | 2022-05-26 00:00:00 |  | 21 | 37 | 28 |  |  | Debtor ABC1 | Inv-003 | 2022-05-29 00:00:00 | 52 | 27 | 3 | 22
 |  | Inv-003 | 2022-05-29 00:00:00 |  | 27 | 3 | 22 |  |  | [NAME] | Inv-001 | 2022-05-22 00:00:00 | 111 | 44 | 17 | 50
 |  |  | TOTALS |  |  |  |  |  |  | [NAME] | Inv-002 | 2022-05-27 00:00:00 | 33 | 3 | 15 | 15
 |  |  |  |  |  |  |  |  |  | Debtor ABC3 | Inv-001 | 2022-05-27 00:00:00 | 56 | 12 | 36 | 8
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3 |  |  | [NAME] | Inv-001 | 2022-05-27 00:00:00 | 110 | 40 | 41 | 29
 |  | Inv-001 | 2022-05-22 00:00:00 |  | 44 | 17 | 50 |  |  | [NAME] | Inv-002 | 2022-05-24 00:00:00 | 108 | 31 | 27 | 50
 |  | Inv-002 | 2022-05-27 00:00:00 |  | 3 | 15 | 15 |  |  | Debtor ABC5 | Inv-001 | 2022-05-22 00:00:00 | 54 | 15 | 23 | 16
 |  |  | TOTALS |  |  |  |  |  |  | Debtor ABC5 | Inv-002 | 2022-05-29 00:00:00 | 100 | 43 | 48 | 9
 |  |  |  |  |  |  |  |  |  | Debtor ABC5 | Inv-003 | 2022-05-23 00:00:00 | 61 | 23 | 20 | 18
 |  | Debtor ABC3 | Date | Total | Period 1 | Period 2 | Period 3 |  |  | Debtor ABC6 | Inv-001 | 2022-05-26 00:00:00 | 138 | 45 | 50 | 43
 |  | Inv-001 | 2022-05-27 00:00:00 |  | 12 | 36 | 8 |  |  | Debtor ABC6 | Inv-002 | 2022-05-23 00:00:00 | 72 | 1 | 47 | 24
 |  |  | TOTALS |  |  |  |  |  |  | [NAME] | Inv-001 | 2022-05-22 00:00:00 | 86 | 19 | 35 | 32
 |  |  |  |  |  |  |  |  |  | [NAME] | Inv-002 | 2022-05-28 00:00:00 | 108 | 46 | 20 | 42
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3 |  |  | [NAME] | Inv-003 | 2022-05-29 00:00:00 | 52 | 3 | 45 | 4
 |  | Inv-001 | 2022-05-27 00:00:00 |  | 40 | 41 | 29 |  |  | Debtor ABC8 | Inv-001 | 2022-05-27 00:00:00 | 100 | 19 | 32 | 49
 |  | Inv-002 | 2022-05-24 00:00:00 |  | 31 | 27 | 50 |  |  | Debtor ABC9 | Inv-001 | 2022-05-23 00:00:00 | 52 | 10 | 39 | 3
 |  |  | TOTALS |  |  |  |  |  |  | Debtor ABC9 | Inv-002 | 2022-05-25 00:00:00 | 97 | 24 | 39 | 34
 |  |  |  |  |  |  |  |  |  | Debtor ABC9 | Inv-003 | 2022-05-26 00:00:00 | 77 | 41 | 15 | 21
 |  | Debtor ABC5 | Date | Total | Period 1 | Period 2 | Period 3 |  |  | [NAME] | Inv-001 | 2022-05-25 00:00:00 | 50 | 4 | 4 | 42
 |  | Inv-001 | 2022-05-22 00:00:00 |  | 15 | 23 | 16 |  |  | [NAME] | Inv-002 | 2022-05-27 00:00:00 | 86 | 35 | 28 | 23
 |  | Inv-002 | 2022-05-29 00:00:00 |  | 43 | 48 | 9 |  |  | [NAME] | Inv-003 | 2022-05-27 00:00:00 | 91 | 13 | 44 | 34
 |  | Inv-003 | 2022-05-23 00:00:00 |  | 23 | 20 | 18 |  |  | [NAME] | Inv-004 | 2022-05-25 00:00:00 | 52 | 10 | 39 | 3
 |  |  | TOTALS |  |  |  |  |  |  | [NAME] | Inv-005 | 2022-05-27 00:00:00 | 97 | 24 | 39 | 34
 |  |  |  |  |  |  |  |  |  | [NAME] | Inv-006 | 2022-05-27 00:00:00 | 77 | 41 | 15 | 21
 |  | Debtor ABC6 | Date | Total | Period 1 | Period 2 | Period 3 |  |  | [NAME] | Inv-007 | 2022-05-25 00:00:00 | 226 | 75 | 93 | 58
 |  | Inv-001 | 2022-05-26 00:00:00 |  | 45 | 50 | 43 |  |  | [NAME] | Inv-008 | 2022-05-27 00:00:00 | 138 | 45 | 50 | 43
 |  | Inv-002 | 2022-05-23 00:00:00 |  | 1 | 47 | 24 |  |  | [NAME] | Inv-009 | 2022-05-27 00:00:00 | 72 | 1 | 47 | 24
 |  |  | TOTALS |  |  |  |  |  |  | [NAME] | Inv-010 | 2022-05-25 00:00:00 | 210 | 46 | 97 | 67
 |  |  |  |  |  |  |  |  |  | [NAME] | Inv-011 | 2022-05-27 00:00:00 | 282 | 41 | 15 | 21
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3 |  |  | [NAME] | Inv-012 | 2022-05-27 00:00:00 | 492 | 75 | 93 | 58
 |  | Inv-001 | 2022-05-22 00:00:00 |  | 19 | 35 | 32
 |  | Inv-002 | 2022-05-28 00:00:00 |  | 46 | 20 | 42
 |  | Inv-003 | 2022-05-29 00:00:00 |  | 3 | 45 | 4
 |  |  | TOTALS
 |  | Debtor ABC8 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-27 00:00:00 |  | 19 | 32 | 49
 |  |  | TOTALS
 |  | Debtor ABC9 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-23 00:00:00 |  | 10 | 39 | 3
 |  | Inv-002 | 2022-05-25 00:00:00 |  | 24 | 39 | 34
 |  | Inv-003 | 2022-05-26 00:00:00 |  | 41 | 15 | 21
 |  |  | TOTALS
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-25 00:00:00 |  | 4 | 4 | 42
 |  | Inv-002 | 2022-05-27 00:00:00 |  | 35 | 28 | 23
 |  | Inv-003 | 2022-05-27 00:00:00 |  | 13 | 44 | 34
 |  | Inv-004 | 2022-05-25 00:00:00 |  | 10 | 39 | 3
 |  | Inv-005 | 2022-05-27 00:00:00 |  | 24 | 39 | 34
 |  | Inv-006 | 2022-05-27 00:00:00 |  | 41 | 15 | 21
 |  | Inv-007 | 2022-05-25 00:00:00 |  | 75 | 93 | 58
 |  | Inv-008 | 2022-05-27 00:00:00 |  | 45 | 50 | 43
 |  | Inv-009 | 2022-05-27 00:00:00 |  | 1 | 47 | 24
 |  | Inv-010 | 2022-05-25 00:00:00 |  | 46 | 97 | 67
 |  | Inv-011 | 2022-05-27 00:00:00 |  | 41 | 15 | 21
 |  | Inv-012 | 2022-05-27 00:00:00 |  | 75 | 93 | 58
 |  |  | TOTALS