[Sheet1]
Technical & Management Fee Statement (Rizwan)
AIT | VAT
Inv. Date | Period | Invoice No. | Particulars | Payable Amount | Paid Amount | Balance Amount
4/26/18 | 201705~201803 | 180209 | Technical & Management Fee | 2,427,351.00 | 2,427,351.00 | 485,470.00 | 364,103.00
3/4/19 | 201705~201803 | 180209 | 20% TDS on TMF (201705~201803) | 485,470.00 | 1,941,881.00
2/25/20 | 201705~201803 | 180209 | Technical & Management Fee | 1,941,881.00 | -
6/26/19 | 201804~201903 | 190263 | Technical & Management Fee | 4,252,491.00 | 4,252,491.00 | 850,498.00 | 637,874.00
15% VAT on TMF (Invoice no. 190263) | 637,874.00 | 4,890,365.00
7/10/20 | 201904~202003 | 200249 | Technical & Management Fee | 3,362,695.00 | 8,253,060.00 | 672,539.00 | 504,404.00
15% VAT on TMF (Invoice no. 200249) | 504,404.00 | 8,757,464.00
8/20/20 | 201804~201903 | 190263 | 20% TDS on TMF (201804~201903) | 850,498.00 | 7,906,966.00
10/8/20 | 201904~202003 | 200249 | 20% TDS on TMF (201904~202003) | 672,539.00 | 7,234,427.00
5/21/23 | 201804~201903 | 190263 | Technical & Management Fee | 3,401,993.00 | 3,832,434.00
5/21/23 | 15% VAT on TMF (Invoice no. 190263) | 637,874.00 | 3,194,560.00
5/21/23 | 201904~202003 | 200249 | Technical & Management Fee | 2,690,156.00 | 504,404.00
5/21/23 | 15% VAT on TMF (Invoice no. 200249) | 504,404.00 | -
7/30/21 | 202004~202103 | 210349 | Technical & Management Fee | 3,951,082.00 | 3,951,082.00 | 790,216.00 | 592,662.00
6/12/23 | 202004~202103 | 210349 | 20% TDS on TMF (202004~202103) | 790,216.00 | 3,160,866.00 | 592,662.30
7/18/22 | 202104~202203 | INV202200626 | Technical & Management Fee | 5,700,591.00 | 8,861,457.00 | 1,140,118.00 | 855,089.00
7/20/23 | 202204~202303 | INV230700101 | Technical & Management Fee | 7,452,266.00 | 16,313,723.00
202304~202403 | 7,995,394.33 | 24,309,117.33 | 133,256,572.18 | 7,995,394.33
24,309,117.33 | Payable according to Rizwan
## Note: | Other Payable MTC
Paid to Govt. for VDS of Technical & Management Fee (201705~201803) | (364,102.60) | No Provisition
(1,814.00) | TDS (1903)
1,813.00 | Sales & TDS Adjusted
3,160,868.00 | Payable-2103
5,700,591.00 | Payable-2203
22,303.00 | 7,429,963.00 | Payable-2303 | 2301 TMF is not 6% of sales.
7,147,466.00 | Payable-2403
Payable to MTC According to Accounts | 23,074,784.40
1,234,332.93
MTC's technical management fee | 23,074,784.40
9,427 | General Journal | 31/05/2023 | 10520 | Vat provision for Technical consulting fee payment | 1.19 Technical and Management F | 1,043,459.00 | Need Breakup of sales amount
Vat provision for Technical consulting fee payment | VAT Payable | 1,043,459.00
6,956,393.33
[Sheet2]
April 22 | May 22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | January 2023 | February 2023 | March 2023 | TOTAL
Sales (PL) | 7,709,196.03 | 7,659,517.93 | 9,876,096.50 | 9,489,367.11 | 11,539,681.00 | 8,415,515.00 | 10,884,890.00 | 15,422,078.00 | 11,542,444.85 | 10,770,547.00 | 11,002,255.00 | 9,875,003.57 | 124,186,591.99
TMF (PL) | 462,552.00 | 459,571.00 | 592,566.00 | 569,362.00 | 692,381.00 | 504,931.00 | 653,093.00 | 925,325.00 | 692,547.00 | 623,931.00 | 660,135.00 | 593,569.00 | 7,429,963.00
6% of sales | 462,552.00 | 459,571.00 | 592,566.00 | 569,362.00 | 692,381.00 | 504,931.00 | 653,093.00 | 925,325.00 | 692,547.00 | 646,233.00 | 660,135.00 | 592,500.00 | 7,451,196.00
Difference | - | - | - | - | - | - | - | - | - | 22,302.00 | - | (1,069.00) | 21,233.00
Apr 23 | May 23 | Jun 23 | Jul 23 | Aug 23 | Sep 23 | Oct 23 | Nov 23 | Dec 23 | Jan 24 | Feb 24 | Mar 24 | TOTAL
Sales (PL) | 19,345,686.97 | 7,406,725.30 | 7,908,532.46 | 7,846,075.83 | 10,686,137.57 | 10,996,376.86 | 12,555,089.67 | 13,096,999.88 | 9,737,101.91 | 9,041,706.66 | 11,426,014.57 | 13,210,124.50 | 133,256,572.18
TMF (PL) | 319,313.00 | 1,487,863.00 | 474,512.00 | 462,125.00 | 641,168.00 | 659,783.00 | 753,305.00 | 785,820.00 | 586,365.00 | 542,503.00 | 685,561.00 | 792,607.00 | 8,190,925.00
6% of sales | 1,160,741.00 | 444,404.00 | 474,512.00 | 470,765.00 | 641,168.00 | 659,783.00 | 753,305.00 | 785,820.00 | 584,226.00 | 542,502.00 | 685,561.00 | 792,607.00 | 7,995,394.33 | -
Difference | 841,428.00 | (1,043,459.00) | - | 8,640.00 | - | - | - | - | (2,139.00) | (1.00) | - | - | (195,530.67) | -
VAT Payable | 1,043,459.00
Payable to MTC | 7,147,466.00
7,995,394.33
847,928.33