| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Tony Chadevski NO GST | Somboon Thilum NO GST (SAM) | NEIL - NM TRANSPORT with GST | Siwakorn Konsawan NO GST (GUY) | VNF PTY LTD with GST (VAN) | GEORGE MINA WITH GST | PEDRO PAID | running total WITHOUT GST | |||||||||||||||||||
2 | Delivery Date Period | Sampedro Invoice | SAM PEDRO FREIGHT BILL TOTAL AMOUNT EX GST | BALANCE EX GST ACCORDING TO SP | Final Balance Invoice amount according to sam pedro (WITH GST) | EX GST AMOUNT | INVOICE NUMBER | EX GST AMOUNT | INVOICE NUMBER | EX GST AMOUNT | GST AMOUNT | INVOICE NUMBER | EX GST AMOUNT | INVOICE NUMBER | GST AMOUNT | EX GST AMOUNT | INVOICE NUMBER | EX GST AMOUNT | GST AMOUNT | INVOICE NUMBER | DRIVERS TOTAL AMOUNT as per each drivers invoice EX GST | FINAL BALANCE ACCORDING TO JJ , NEGITIVE MEANS SAM PEDRO OWES | DIFFERENCE JJ TO Sp ,EX GST NEGITIVE IS SAM PEDRO OWES JJ MORE | NOTES | |||
3 | 04/01/21 | MICK SAM PEDRO GAVE CHEQUE | $584.10 | ||||||||||||||||||||||||
4 | 04/01 - 08/01/21 | 2474 | $4,395.00 | -$555.00 | -$610.50 | $1,260.00 | 63 | $1,200.00 | 61843812 | $1,250.00 | $1,375.00 | 1 | $1,200.00 | 202101W01 | $4,910.00 | -$515.00 | $40.00 | TONY AGREED TO DEDUCT $40 FROM INVOICE | |||||||||
5 | 11/01/21 | MICK SAM PEDRO DISHONOURED CHEQUE | $584.10 | ||||||||||||||||||||||||
6 | 11/01 - 15/01/21 | 2479 | $6,077.00 | $1,127.00 | $1,239.70 | $1,300.00 | 64 | $1,200.00 | 61843813 | $1,250.00 | $1,375.00 | 2 | $1,200.00 | 202101W02 | $4,950.00 | $1,127.00 | $0.00 | ||||||||||
7 | 14/01/21 | MICK SAM PEDRO PAID EFT | EFT $584.10 & $610.50 | ||||||||||||||||||||||||
8 | 18/01 - 22/01/21 | 2482 | $5,608.00 | $658.00 | $723.80 | $1,300.00 | 65 | $1,200.00 | 61843814 | $1,250.00 | $1,375.00 | 3 | $1,200.00 | 202101W03 | $4,950.00 | $658.00 | $0.00 | ||||||||||
9 | 25/01 - 29/01/21 | 2486 | $4,433.00 | $473.00 | $520.30 | $1,040.00 | 66 | $960.00 | 61843815 | $1,000.00 | $1,100.00 | 4 | $960.00 | 202101W04 | $3,960.00 | $473.00 | $0.00 | ||||||||||
10 | 01/02 - 05/02/21 | 2490 | $6,153.00 | $1,203.00 | $1,323.30 | $1,300.00 | 67 | $1,200.00 | 61843816 | $1,250.00 | $1,375.00 | 5 | $1,200.00 | 202102W01 | $4,950.00 | $1,203.00 | $0.00 | ||||||||||
11 | 08/02 - 12/02/21 | 2494 | $5,809.00 | $859.00 | $944.90 | $1,300.00 | 68 | $1,200.00 | 61843817 | $1,250.00 | $1,375.00 | 6 | $1,200.00 | 202102W02 | $4,950.00 | $859.00 | $0.00 | ||||||||||
12 | 15/02 - 19/02/21 | 2497 | $4,569.00 | -$381.00 | -$419.10 | $1,300.00 | 69 | $1,200.00 | 61843818 | $1,250.00 | $1,375.00 | 7 | $1,200.00 | 202102W03 | $4,950.00 | -$381.00 | $0.00 | ||||||||||
13 | 23/02/21 | MICK SAM PEDRO ISSUED CHEQUE | $419.10 | ||||||||||||||||||||||||
14 | 22/02 - 26/02/21 | 2504 | $5,303.00 | $353.00 | $388.30 | $1,300.00 | 70 | $1,200.00 | 61843819 | $1,250.00 | $1,375.00 | 8 | $1,200.00 | 202102W04 | $4,950.00 | $353.00 | $0.00 | ||||||||||
15 | 01/03 - 05/03/21 | 2507 | $4,313.00 | -$637.00 | -$700.70 | $1,300.00 | 71 | $1,200.00 | 61843820 | $1,250.00 | $1,375.00 | 9 | $1,200.00 | 202103W01 | $4,950.00 | -$637.00 | $0.00 | ||||||||||
16 | 09/03/21 | MICK SAM PEDRO ISSUED CHEQUE | $700.70 | ||||||||||||||||||||||||
17 | 08/03 - 12/03/21 | 2513 | $4,400.00 | -$550.00 | -$605.00 | $1,300.00 | 72 | $1,200.00 | 61843821 | $1,250.00 | $1,375.00 | 10 | $1,200.00 | 202103W02 | $4,950.00 | -$550.00 | $0.00 | ||||||||||
18 | 22/03/21 | MICK SAM PEDRO ISSUED CHEQUE | $605.00 | ||||||||||||||||||||||||
19 | 15/03 - 19/03/21 | 2515 | $5,361.00 | $1,711.00 | $1,882.10 | $1,200.00 | 61843822 | $1,250.00 | $1,375.00 | 11 | $1,200.00 | 202103W03 | $3,650.00 | $1,711.00 | $0.00 | ||||||||||||
20 | 22/03 - 26/03/21 | 2518 | $5,026.00 | $336.00 | $369.60 | $1,040.00 | 73 | $1,200.00 | 61843823 | $1,250.00 | $1,375.00 | 12 | $1,200.00 | 202103W04 | $4,690.00 | $336.00 | $0.00 | ||||||||||
21 | 29/03 - 02/04/21 | 2519 | $4,162.00 | $202.00 | $222.20 | $1,040.00 | 74 | $960.00 | 61843824 | $1,000.00 | $1,100.00 | 13 | $960.00 | 202103W05 | $3,960.00 | $202.00 | $0.00 | ||||||||||
22 | 05/04 - 09/04/21 | 2525 | $4,196.00 | $1,276.00 | $1,403.60 | $0.00 | 75 | $960.00 | 61843825 | $1,000.00 | $1,100.00 | 14 | $960.00 | 202104W02 | $2,920.00 | $1,276.00 | $0.00 | ||||||||||
23 | 12/04 - 16/04/21 | 2528 | $5,749.00 | $2,099.00 | $2,308.90 | $1,200.00 | 61843826 | $1,250.00 | $1,375.00 | 15 | $1,200.00 | 202104W03 | $3,650.00 | $2,099.00 | $0.00 | ||||||||||||
24 | 19/04 - 23/04/21 | 2531 | $5,888.00 | $1,278.00 | $1,405.80 | $1,200.00 | 61843827 | $1,250.00 | $1,375.00 | 16 | $960.00 | 202104W04 | $1,320.00 | $1,200.00 | 728528 | $4,610.00 | $1,278.00 | $0.00 | |||||||||
25 | 26/04 - 30/04/21 | 2533 | $5,761.00 | $861.00 | $947.10 | $1,200.00 | 61843828 | $1,300.00 | $1,430.00 | 17 | $1,200.00 | 202104W05 | $1,320.00 | $1,200.00 | 728529 | $4,900.00 | $861.00 | $0.00 | |||||||||
26 | 03/05 - 07/05/21 | 2537 | $5,497.00 | $597.00 | $656.70 | $1,200.00 | 61843829 | $1,300.00 | $1,430.00 | 18 | $1,200.00 | 202105W01 | $1,320.00 | $1,200.00 | 728530 | $4,900.00 | $597.00 | $0.00 | |||||||||
27 | 10/05 - 14/05/21 | 2540 | $5,069.00 | $169.00 | $185.90 | $1,200.00 | 61843830 | $1,300.00 | $1,430.00 | 19 | $1,200.00 | 202105W02 | $1,320.00 | $1,200.00 | 728531 | $4,900.00 | $169.00 | $0.00 | |||||||||
28 | 17/05 - 21/05/21 | 2543 | $5,246.00 | $346.00 | $380.60 | $1,200.00 | 61843831 | $1,300.00 | $1,430.00 | 20 | $1,200.00 | 202105W03 | $1,320.00 | $1,200.00 | 728532 | $4,900.00 | $346.00 | $0.00 | |||||||||
29 | 24/05 - 28/05/21 | 2547 | $5,084.00 | $184.00 | $202.40 | $1,200.00 | 61843832 | $1,300.00 | $1,430.00 | 21 | $1,200.00 | 202105W04 | $1,320.00 | $1,200.00 | 728533 | $4,900.00 | $184.00 | $0.00 | |||||||||
30 | 31/05 - 04/06/21 | 2550 | $4,456.00 | -$444.00 | -$488.40 | $1,200.00 | 61843833 | $1,300.00 | $1,430.00 | 22 | $1,200.00 | 202105W05 | $1,320.00 | $1,200.00 | 728534 | $4,900.00 | -$444.00 | $0.00 | |||||||||
31 | 11/06/21 | MICK SAM PEDRO ISSUED CHEQUE | $488.40 | ||||||||||||||||||||||||
32 | 07/06 - 11/06/21 | 2552 | $4,856.00 | $1,156.00 | $1,271.60 | $1,200.00 | 61843834 | $1,300.00 | $1,430.00 | 23 | $1,200.00 | 202106W01 | $3,700.00 | $1,156.00 | $0.00 | ||||||||||||
33 | 14/06 - 18/06/21 | 2555 | $4,190.00 | $270.00 | $297.00 | $960.00 | 61843836 | $1,040.00 | $1,144.00 | 24 | $960.00 | 202106W02 | $960.00 | $1,056.00 | 2 | $3,920.00 | $270.00 | $0.00 | |||||||||
34 | 21/06 - 25/06/21 | 2559 | $4,439.00 | -$461.00 | -$507.10 | $1,200.00 | 61843837 | $1,300.00 | $1,430.00 | 25 | $1,200.00 | 202106W03 | $1,200.00 | $1,320.00 | 3 | $4,900.00 | -$461.00 | $0.00 | |||||||||
35 | 30/06/21 | MICK SAM PEDRO ISSUED CHEQUE | $507.10 | ||||||||||||||||||||||||
36 | 28/06 - 02/07/21 | 2561 | $5,239.00 | $339.00 | $372.90 | $1,200.00 | 61843838 | $1,300.00 | $1,430.00 | 26 | $1,200.00 | 202106W04 | $1,200.00 | $1,320.00 | 4 | $4,900.00 | $339.00 | $0.00 | |||||||||
37 | 05/07 - 09/07/21 | 2565 | $3,994.00 | -$906.00 | -$996.60 | $1,200.00 | 61843839 | $1,300.00 | $1,430.00 | 27 | $1,200.00 | 202107W01 | $1,200.00 | $1,320.00 | 5 | $4,900.00 | -$906.00 | $0.00 | |||||||||
38 | 13/07/21 | MICK SAM PEDRO ISSUED CHEQUE | $996.60 | ||||||||||||||||||||||||
39 | 12/07 - 16/07/21 | 2576 | $3,864.00 | -$1,036.00 | -$1,139.60 | $1,200.00 | 61843840 | $1,300.00 | $1,430.00 | 28 | $1,200.00 | 202107W02 | $1,200.00 | $1,320.00 | 6 | $4,900.00 | -$1,036.00 | $0.00 | -$1,036.00 | SAM PEDRO SHOULD PAY US $1139.60 | |||||||
40 | 19/07 - 23/07/21 | 2577 | $4,643.00 | -$257.00 | -$282.70 | $1,200.00 | 61843841 | $1,300.00 | $1,430.00 | 29 | $1,200.00 | 202107W023 | $1,200.00 | $1,320.00 | 8 | $4,900.00 | -$257.00 | $0.00 | -$1,293.00 | ||||||||
41 | 26/07 - 30/07/21 | 2578 | $4,730.00 | $303.00 | $333.30 | $1,200.00 | 61843842 | $1,300.00 | $1,430.00 | 30 | $1,200.00 | 202107W024 | $1,200.00 | $1,320.00 | 9 | $4,900.00 | -$170.00 | -$473.00 | -$1,463.00 | INCORRECT INVOICE AMOUNT - SAM PEDRO SHOULD PAY US $187 | |||||||
42 | 02/08 - 06/08/21 | 2579 | $4,037.00 | -$863.00 | -$949.30 | $1,200.00 | 61843843 | $1,300.00 | $1,430.00 | 31 | $1,200.00 | 202108W01 | $1,200.00 | $1,320.00 | 10 | $4,900.00 | -$863.00 | $0.00 | -$2,326.00 | ||||||||
43 | 09/08 - 13/08/21 | 2584 | $3,230.00 | -$1,670.00 | -$1,837.00 | $1,200.00 | 61843844 | $1,300.00 | $1,430.00 | 32 | $1,200.00 | 202108W02 | $1,200.00 | $1,320.00 | 11 | $4,900.00 | -$1,670.00 | $0.00 | -$3,996.00 | ||||||||
44 | 16/08 - 20/08/21 | 2587 | $3,830.20 | $230.20 | $253.22 | $1,200.00 | 61843845 | $1,200.00 | 202108W03 | $1,200.00 | $1,320.00 | 12 | $3,600.00 | $230.20 | $0.00 | -$3,765.80 | LEVY CHARGE STARTS HERE | ||||||||||
45 | 23/08 - 27/08/21 | 2591 | $4,072.20 | $472.20 | $519.42 | $1,200.00 | 61843846 | $1,200.00 | 202108W04 | $1,200.00 | $1,320.00 | 13 | $3,600.00 | $472.20 | $0.00 | -$3,293.60 | |||||||||||
46 | 30/08 - 03/09/21 | 2595 | $4,976.40 | $1,376.40 | $1,514.04 | $1,200.00 | 61843847 | $1,200.00 | 202108W05 | $1,200.00 | $1,320.00 | 14 | $3,600.00 | $1,376.40 | $0.00 | -$1,917.20 | |||||||||||
47 | 06/09 - 10/09/21 | 2596 | $4,264.70 | $4,264.70 | $4,691.17 | $0.00 | $4,264.70 | $0.00 | $2,347.50 | ||||||||||||||||||
48 | 13/09 - 17/09/21 | 2601 | $4,889.50 | $4,889.50 | $5,378.45 | $0.00 | $4,889.50 | $0.00 | $7,237.00 | ||||||||||||||||||
49 | 20/09 - 24/09/21 | 2604 | $4,356.00 | $4,791.60 | $5,270.76 | $0.00 | $4,356.00 | -$435.60 | $11,593.00 | ||||||||||||||||||
50 | 27/09 - 01/10/21 | 2609 | $4,010.00 | $4,411.00 | $4,852.10 | $0.00 | $4,010.00 | -$401.00 | |||||||||||||||||||
51 | 04/10 - 08/10/21 | 2615 | $3,810.00 | $4,191.00 | $4,610.10 | $0.00 | $3,810.00 | -$381.00 | |||||||||||||||||||
52 | 11/10 - 15/10/21 | 2660 | $3,849.00 | $4,233.90 | $4,657.29 | $0.00 | $3,849.00 | -$384.90 | |||||||||||||||||||
53 | 18/10 - 22/10/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
54 | 25/10 - 29/10/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
55 | 01/11 - 05/11/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
56 | 08/11 - 12/11/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
57 | 15/11 - 19/11/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
58 | 22/11 - 26/11/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
59 | 29/11 - 03/12/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
60 | 16/12 - 10/12/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
61 | 13/12 - 17/12/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
62 | 20/12 - 24/12/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
63 | 27/12 - 31/12/21 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||
64 | |||||||||||||||||||||||||||
65 | |||||||||||||||||||||||||||
66 | |||||||||||||||||||||||||||
67 | |||||||||||||||||||||||||||
68 | |||||||||||||||||||||||||||
69 | |||||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||
71 | |||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||
73 | |||||||||||||||||||||||||||
74 | |||||||||||||||||||||||||||
75 | |||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||
78 | |||||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||
100 | |||||||||||||||||||||||||||