Spreadsheet: 782123d1653813299-aged-debtor-report-formatting-question-pq-aged-debtor-formatting-aligw
Sheet: Aim

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