[AIT]
Difference in TDS (Tax Deduction at Source)
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S
SL | Supplier Name | Item Description | Accounting Month | Year | FY | Invoice Amount in BDT | TDS Rate | Actual TDS Amount In BDT | TDS amount Paid in BDT | Difference in TDS amount in BDT | Account Book No. | Section | Tax Deposit Code No. | Chalan No. | Chalan Date | Deposti Mode | Deposit Bank and Branch | Remarks on column "J'"
1 | Ocean Motors | Car TOYOTA NOAH | February | 2020 | 2019-2020 | 2,804,124 | 3.00% | 84,123.71 | 84,123.71 | 0 | 30 | 52 | 1-1141-0090-0101 | T134 | 7/23/20 | Cheque | Sonali Bank Limited, Banani Branch
2 | Rangs Limited | Car MITSUBISHI Double Cabin white | March | 2020 | 4,948,454 | 3.00% | 148,453.61 | 148,453.61 | -0 | 3 | 52 | 1-1141-0090-0101 | T134 | 7/23/20 | Cheque | Sonali Bank Limited, Banani Branch
3 | Rangs Limited | Car MITSUBISHI Double Cabin brown | October | 2020 | 2020-2021 | 5,104,167 | 4.00% | 204,167 | 0 | 204,167 | 17 | 52 | 1-1141-0090-0101
4 | Speedco | NISSAN X-Trail Black for the Engineer① | September | 2020 | 4,568,421 | 5.00% | 228,421 | 40,509 | 187,912 | 130 | 52 | 1-1141-0090-0101 | T13 | 10/12/20 | Cheque | Sonali Bank Limited, Banani Branch | Total AIT in flat rate is BDT 130,200 but in Import stage AIT paid amount is BDT 89,691. So remaining AIT amount is BDT 40,509 after deducting the AIT of Import Stage
5 | Speedco | NISSAN X-Trail Pearl for the Engineer② | October | 2020 | 4,526,316 | 5.00% | 226,316 | 76,894 | 149,422 | 5 | 52 | 1-1141-0090-0101 | T170 | 11/15/20 | Cheque | Sonali Bank Limited, Banani Branch | Total AIT in flat rate is BDT 172,000 but in Import stage AIT paid amount is BDT 95,106. So remaining AIT amount is BDT 76,894 after deducting the AIT of Import Stage
6 | Speedco | NISSAN X-Trail Premium Metallic Green | November | 2020 | 4,515,789 | 5.00% | 225,789 | 119,464 | 106,325 | 8 | 52 | 1-1141-0090-0101 | T69 | 12/13/20 | Cheque | Sonali Bank Limited, Banani Branch | Total AIT in flat rate is BDT 214,500 but in Import stage AIT paid amount is BDT 95,036. So remaining AIT amount is BDT 119,464 after deducting the AIT of Import Stage
7 | Speedco | TOYOTA Harrier Pearl for the Engineer | February | 2021 | 7,584,211 | 5.00% | 379,211 | 261,717 | 117,494 | ATS000000011 | 52 | 1-1141-0090-0101 | N 170610013 | 3/10/21 | Cheque | Sonali Bank Limited, Madhabdi Branch | Total AIT in flat rate is BDT 360,250 but in Import stage AIT paid amount is BDT 98,533. So remaining AIT amount is BDT 261,717 after deducting the AIT of Import Stage
8 | Speedco | TOYOTA Hiace | April | 2021 | 2,600,000 | 5.00% | 130,000 | 12,078 | 117,922 | APS000000305 | 52 | 1-1141-0090-0101 | N170610002 | 5/6/21 | Cheque | Sonali Bank Limited, Madhabdi Branch | Total AIT in flat rate is BDT 74,100 but in Import stage AIT paid amount is BDT 62,022. So remaining AIT amount is BDT 12,078 after deducting the AIT of Import Stage
Difference in AIT | 883,242
[VAT]
Difference in VDS (VAT Deduction at Source)
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R
SL | Supplier Name | Item Description | Invoice Amount in BDT *Incl Tax | VDS Rate | Actual VAT amount in BDT | VAT amount paid in BDT | Difference in VDS Amount in BDT | VDS Month | Year | Accounts Book No. | Account Code | VAT deposit Code No | Chalan No. | Chalan Date | Deposti Mode | Deposit Bank and Branch | Remarks on Column "H"
1 | Ocean Motors | Car TOYOTA NOAH | 2,804,124 | 7.50% | 210,309 | 0 | 210,309 | February | 2020 | 401330005 | 1-1141-0090-0101
2 | Rangs Limited | Car MITSUBISHI Double Cabin white | 4,948,454 | 7.50% | 371,134 | 0 | 371,134 | March | 2020 | 401330005 | 1-1141-0090-0101
3 | Rangs Limited | Car MITSUBISHI Double Cabin brown | 5,104,167 | 7.50% | 382,813 | 0 | 382,813 | October | 2020 | 401330005 | 1-1141-0090-0101
4 | Speedco | NISSAN X-Trail Black for the Engineer① | 4,568,421 | 7.50% | 342,632 | 0 | 342,632 | September | 2020 | 401330005 | 1-1141-0090-0101
5 | Speedco | NISSAN X-Trail Pearl for the Engineer② | 4,526,316 | 7.50% | 339,474 | 0 | 339,474 | October | 2020 | 401330005 | 1-1141-0090-0101
6 | Speedco | NISSAN X-Trail Premium Metallic Green | 4,515,789 | 7.50% | 338,684 | 0 | 338,684 | November | 2020 | 401330005 | 1-1141-0090-0101
7 | Speedco | TOYOTA Harrier Pearl for the Engineer | 7,584,211 | 7.50% | 568,816 | 0 | 568,816 | February | 2021 | 401330005 | 1-1141-0090-0101
8 | Speedco | ToYOTA Hiace | 2,600,000 | 7.50% | 195,000 | 0 | 195,000 | April | 2021 | 401330005 | 1-1141-0090-0101
Difference in VAT | 2,748,862