Departmental Weekly Invoice Tracking Report

22 March 2024 to date

INVOICES	TOTAL AMOUNT	TOTAL NUMBER	%
TOTAL INVOICES RECEIVED	R55,009,062.06	3106
INVOICES PAID	R47,235,223.25	2468	80%
01 NOV 2023 TO 22 MAR 2024
INVOICES RETURNED WITH QUERIES TO SUPPLIERS	R589,259.99	98	3%
01 NOV 2023 TO 22 MAR 2024
CLOSING BALANCES OF INVOICES NOT PAID	R7,184,578.82	540	17%

01 November 2023 to date

INVOICES	TOTAL AMOUNT	TOTAL NUMBER
TOTAL INVOICES RECEIVED	R50,121,370.43	2889
INVOICES PAID	R41,057,770.18	2172
01 NOV 2023 TO 11 MAR 2024
INVOICES RETURNED WITH QUERIES TO SUPPLIERS	R597,974.19	100
01 NOV 2023 TO 11 MAR 2024
CLOSING BALANCES OF INVOICES NOT PAID	R8,465,626.06	617

19 - 26 February 2024

INVOICES	TOTAL AMOUNT	TOTAL NUMBER
OPENING BALANCE OF INVOICES NOT PAID	R7 656 464,48	707
INVOICES RECEIVED IN CURRENT WEEK	R860 320,79	71
WEEK 19 FEB 2024 - 26 FEB 2024
INVOICES PAID	R1 587 186,38	302
WEEK 19 FEB 2024 - 26 FEB 2024
INVOICES RETURNED WITH QUERIES TO SUPPLIERS	R584 163,83	96
WEEK 19 FEB 2024 - 26 FEB 2024
CLOSING BALANCES OF INVOICES NOT PAID	R6 345 435,06	380

AGING OF INVOICES OF CLOSING BALANCE OF INVOICES NOT PAID
INVOICES LESS THAN 30 DAYS OLD	R5 145 273,14	353
INVOICES MORE THAN 30 DAYS OLD	R1,200,161.92	27

1 November 2023 - 23 January 2024

INVOICES	TOTAL AMOUNT	TOTAL NUMBER
TOTAL INVOICES RECEIVED	R32 912 560,54	1860
INVOICES PAID	R30 626 849,20	1435	77%
01 NOV 2023 TO 31 JAN 2024
INVOICES RETURNED WITH QUERIES TO SUPPLIERS	R578 237,42	90	5%
01 NOV 2023 TO 31 JAN 2024
CLOSING BALANCES OF INVOICES NOT PAID	R1 707 473,92	335	18%

AGING OF INVOICES NOT PAID
INVOICES LESS THAN 30 DAYS OLD	R1 587 872,55	296
INVOICES MORE THAN 30 DAYS OLD	R119 601,37	39

16 - 23 January 2024

INVOICES	TOTAL AMOUNT	TOTAL NUMBER
OPENING BALANCE OF INVOICES NOT PAID	R4 697 211,05	451
INVOICES RECEIVED IN CURRENT WEEK	R326 504,04	35
WEEK 16 JAN 2024 - 23 JAN 2024
INVOICES PAID	R2 796 113,64	142
WEEK 16 JAN 2024 - 23 JAN 2024
INVOICES RETURNED WITH QUERIES TO SUPPLIERS	R517 745,93	88
WEEK 16 JAN 2024 - 23 JAN 2024
CLOSING BALANCES OF INVOICES NOT PAID	R1 056 847,44	186

AGING OF INVOICES OF CLOSING BALANCE OF INVOICES NOT PAID
INVOICES LESS THAN 30 DAYS OLD	R840 837,33	142
INVOICES MORE THAN 30 DAYS OLD	R216 010,11	44

30 October 2023 to date

INVOICES	TOTAL AMOUNT	TOTAL NUMBER	%
TOTAL INVOICES RECEIVED	R29 200 979,81	1482
INVOICES PAID 30 OCT 2023 TO 17 JAN 2024	R26 683 516,78	1241	84%
INVOICES RETURNED WITH QUERIES TO SUPPLIERS 30 OCT 2023 TO 17 JAN 2024	R523 842,03	91	6%
CLOSING BALANCES OF INVOICES NOT PAID	R1 993 621,00	150	10%

04 - 08 December 2023

INVOICES	TOTAL AMOUNT	TOTAL NUMBER
OPENING BALANCE OF INVOICES NOT PAID	R5 831 399,66	476
INVOICES RECEIVED IN CURRENT WEEK	R6 049 216,53	231
WEEK 04 DEC 2023 - 08 DEC 2023
INVOICES PAID	R2 096 200,74	87
WEEK 04 DEC 2023 - 08 DEC 2023
INVOICES RETURNED WITH QUERIES TO SUPPLIERS	R55 436,87	20
WEEK 04 DEC 2023 - 08 DEC 2023
CLOSING BALANCES OF INVOICES NOT PAID	R9 728 978,58	600

AGING OF INVOICES OF CLOSING BALANCE OF INVOICES NOT PAID
INVOICES LESS THAN 30 DAYS OLD	R9 723 111,08	597
INVOICES MORE THAN 30 DAYS OLD	R5 867,50	3

AGING OF INVOICES OF CLOSING BALANCE OF INVOICES NOT PAID

INVOICES LESS THAN 30 DAYS OLD

R9 723 111,08

597

INVOICES MORE THAN 30 DAYS OLD

R5 867,50

27 November - 1 December 2023

INVOICES	TOTAL AMOUNT	TOTAL NUMBER
OPENING BALANCE OF INVOICES NOT PAID	R3 624 395,43	304
INVOICES RECEIVED IN CURRENT WEEK	R4 110 488,13	254
WEEK 27 NOV - 01 DEC 2023
INVOICES PAID	R1 660 497,93	71
WEEK 27 NOV - 01 DEC 2023
INVOICES RETURNED WITH QUERIES TO SUPPLIERS	R12 688,25	3
WEEK 27 NOV - 01 DEC 2023
CLOSING BALANCES OF INVOICES NOT PAID	R6 061 697,38	484
INVOICES LESS THAN 30 DAYS OLD	R6 057 189,88	482
INVOICES MORE THAN 30 DAYS OLD	R4 507,50	2

AGING OF INVOICES OF CLOSING BALANCE OF INVOICES NOT PAID
INVOICES LESS THAN 30 DAYS OLD	R6 057 189,88	482
INVOICES MORE THAN 30 DAYS OLD	R4 507,50	2