Spreadsheet: 864109d1711428786-match-transactions-based-on-two-months-interval-vat-for-two-months-1-
Sheet: TAX

VAT RETURN
 |  |  |  |  |  |  | I'm kindly requesting for excel formula that can  match the VAT transactions based on two months period as in the desired solution
 | TIN |  |  | Name of Registered Operator
 | 20019000 |  |  | X PVT LTD
 | VAT Registration Number |  |  | Trading as
 | 220000 |  |  | X General Dealers
 | Period | January and February |  |  |  |  |  |  |  |  | January and February
 |  |  |  |  |  |  |  |  |  |  | March and April
 | Output Tax: | 1130.73 |  |  |  |  |  |  |  |  | May and June
 | Less Input Tax: | 187.54 |  |  |  |  |  |  |  |  | July and August
 | VAT Payable |  |  |  |  |  |  |  |  |  | September and October
 |  |  |  |  |  |  |  |  |  |  | November and December
Desired solution |  | I'm kindly requesting for excel formula that can  match the VAT transactions based on two months period as in the desired solution, using information on data worksheet.
Output VAT
Date | Invoice | Customer | VAT Number | Amount | VAT | Description
2024-01-01 00:00:00 | 244 | OK | 200100 | 200 | 30 | SALES
2024-01-18 00:00:00 | 272 | TM |  | 200 | 30 | SALES
2024-01-20 00:00:00 | 271 | Tsholotsho |  | 500 | 75 | SALES
2024-01-31 00:00:00 | 273 | Brothers High School |  | 900 | 135 | SALES
2024-02-07 00:00:00 | 275 | Heyval Pvt Ltd | 10013382 | 43.48 | 6.52 | SALES
2023-02-10 00:00:00 | 276 | OK | 200100 | 200 | 30 | SALES
2024-02-15 00:00:00 | 274 | Fools Investments | 10068109 | 391.31 | 58.69 | SALES
2024-02-28 00:00:00 | 277 | Cash sales |  | 5103.48 | 765.52 | SALES
Total
Input VAT
Date | Invoice | Customer | VAT Number | Amount | VAT | Description
2024-01-02 00:00:00 | 100 | Choppies Aaro Mart | 10061810 | 3.74 | 0.56 | Fresh Rooibos
2024-01-04 00:00:00 | BINO8816 | Mainbeam Enterprises | 10052329 | 86.96 | 13.04 | Trading stock
2024-01-05 00:00:00 | 124343 | Codeco | 10000723 | 48.67 | 7.3 | Trading stock
2024-01-06 00:00:00 | [NAME] | Mainbeam Enterprises | 10052329 | 153.9 | 23.08 | Trading stock
2024-01-08 00:00:00 | IN200 | Choppies Aaro Mart | 10061810 | 3.74 | 0.56 | Bottled Water
2024-01-19 00:00:00 | 124925 | Codeco | 10000723 | 64.4 | 9.66 | Trading stock
2024-01-20 00:00:00 | INVBY74229 | Fuser Technologies | 220260831 | 13.04 | 1.96 | USB Mouse
2024-01-24 00:00:00 | INV10391 | Cosmo Baking Supplies | 10121666 | 114.79 | 17.21 | Trading stock
2024-01-25 00:00:00 | 250559784 | City of Bulawayo |  | 414.13 | 62.1 | Licence
2024-01-26 00:00:00 | CIN0046249 | Country Choice Foods | 220024195 | 83.55 | 7.81 | ICING Sugar
2024-02-02 00:00:00 | 10973 | Rawplast Investments | 234600 | 10 | 1.5 | [NAME]
2024-02-06 00:00:00 | 404265266 | Schweppes | 220050888 | 27.4 | 4.11 | Fresh Rooibos
2024-02-06 00:00:00 | 11 | Letty's Baking Shop |  | 296 | 23 | Toppers
2024-02-19 00:00:00 |  | Schweppes | 220050888 | 69.6 | 10.44 | water
2024-02-28 00:00:00 | CIN0046461 | Counntry Choice Foods | 220024195 | 81.95 | 5.21 | Icing Sugar
Total
 | Invoice | Customer | VAT Number | Sales | VAT | Description
2024-01-01 00:00:00 | 244 | OK | 200100 | 200 | 30 | SALES
2024-01-20 00:00:00 | 271 | Tsholotsho |  | 500 | 75 | SALES
2024-01-18 00:00:00 | 272 | TM |  | 200 | 30 | SALES
2024-01-31 00:00:00 | 273 | Brothers High School |  | 900 | 135 | SALES
2024-02-15 00:00:00 | 274 | Fools Investments | 10068109 | 391.31 | 58.69 | SALES
2024-02-07 00:00:00 | 275 | Heyval Pvt Ltd | 10013382 | 43.48 | 6.52 | SALES
2023-02-10 00:00:00 | 276 | OK | 200100 | 200 | 30 | SALES
2024-02-28 00:00:00 | 277 | Cash sales |  | 5103.48 | 765.52 | SALES
Total |  |  |  | 7538.27 | 1130.73
 | Invoice | Supplier | VAT Number | Purchases | VAT | Description
2024-01-02 00:00:00 | 100 | Choppies Aaro Mart | 10061810 | 3.74 | 0.56 | Fresh Rooibos
2024-01-02 00:00:00 | 9 | [NAME] |  | 80 |  | Eggs
2024-01-02 00:00:00 | 77 | Amtech |  | 150 |  | Lenovo Desktop
2024-01-02 00:00:00 | 4569 | Arrow Chem |  | 1 |  | Dish wash
2024-01-05 00:00:00 | 124343 | Codeco | 10000723 | 48.67 | 7.3 | Trading stock
2024-01-04 00:00:00 | BINO8816 | Mainbeam Enterprises | 10052329 | 86.96 | 13.04 | Trading stock
2024-01-08 00:00:00 | IN200 | Choppies Aaro Mart | 10061810 | 3.74 | 0.56 | Bottled Water
2024-01-06 00:00:00 | [NAME] | Mainbeam Enterprises | 10052329 | 153.9 | 23.08 | Trading stock
2024-01-19 00:00:00 | 124925 | Codeco | 10000723 | 64.4 | 9.66 | Trading stock
2024-01-20 00:00:00 | INVBY74229 | Fuser Technologies | 220260831 | 13.04 | 1.96 | USB Mouse
2024-01-25 00:00:00 | 250559784 | City of Bulawayo |  | 414.13 | 62.1 | Licence
2024-01-24 00:00:00 | INV10391 | Cosmo Baking Supplies | 10121666 | 114.79 | 17.21 | Trading stock
2024-01-26 00:00:00 | CIN0046249 | Country Choice Foods | 220024195 | 83.55 | 7.81 | ICING Sugar
2024-02-06 00:00:00 | 404265266 | Schweppes | 220050888 | 27.4 | 4.11 | Fresh Rooibos
2024-02-06 00:00:00 | 11 | Letty's Baking Shop |  | 296 | 23 | Toppers
2024-02-19 00:00:00 |  | Schweppes | 220050888 | 69.6 | 10.44 | water
2024-02-28 00:00:00 | CIN0046461 | Counntry Choice Foods | 220024195 | 81.95 | 5.21 | Icing Sugar
2024-02-02 00:00:00 | 10973 | Rawplast Investments | 234600 | 10 | 1.5 | [NAME]
Total |  |  |  | 1702.87 | 187.54