Spreadsheet: 864127d1711440369-match-transactions-based-on-two-months-interval-a-vat-for-two-months-xlsx-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 | March and April |  |  |  |  |  |  |  |  | January and February
 |  |  |  |  |  |  |  |  |  |  | March and April
 | Output Tax: | 1091.48 |  |  |  |  |  |  |  |  | May and June
 | Less Input Tax: | 213.3200000000001 |  |  |  |  |  |  |  |  | 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.
Date | Invoice | Customer | VAT Number | Sales | VAT | Description
2024-03-01 00:00:00 | 278 | [NAME] | 10011734 | 465.22 | 69.78 | SALES
2024-03-14 00:00:00 | 279 | Bitterwood Investments |  | 278.26 | 41.74 | SALES
2024-03-25 00:00:00 | 280 | D. Ranching P/L | 10003958 | 278.26 | 41.74 | SALES
2024-04-10 00:00:00 | 281 | fawcett Security | 10000794 | 260.87 | 39.13 | SALES
2024-04-17 00:00:00 | 282 | [NAME] |  | 1109.57 | 166.43 | SALES
2024-04-25 00:00:00 | 283 | fawcett Security | 10000794 | 173.91 | 26.09 | SALES
2024-04-30 00:00:00 | 284 | Cash sales |  | 4710.43 | 706.57 | SALES
Total |  |  |  | 7276.52 | 1091.48
Input VAT
Date | Invoice | Supplier | VAT Number | Purchases | VAT | Description
2024-03-07 00:00:00 | INV10965 | Cosmo Baking Supplies | 220260504 | 114.79 | 17.21 | Choc sponge
2024-03-03 00:00:00 | 12377/ | Holiday Inn | 10016036 | 111.11 | 18.89 | Accomodation
2024-03-03 00:00:00 | 12379/ | Holiday Inn | 10016036 | 111.11 | 18.89 | Accomodation
2024-03-02 00:00:00 | 125526 | Codchem | 10000723 | 53.5 | 8.03 | lemon paste
2024-03-28 00:00:00 | 125812 | Codchem | 10000723 | 55 | 8.25 | lemon paste
2024-03-09 00:00:00 | 273189 | F. Neil & Sons | 220020028 | 34.78 | 5.22
2024-03-12 00:00:00 | US949 | [NAME] | 10086897 | 91.41 | 1.56
2024-03-13 00:00:00 | INV11595 | Cosmo Baking Supplies | 220260504 | 114.79 | 17.21 | Baked Choc Sponge
2024-03-31 00:00:00 | 274583 | F. Neil & Sons | 2000002314 | 11.32 | 1.7
2024-04-03 00:00:00 | 206470 | Counntry Choice Foods | 10000668 | 189.6 | 12.39
2024-04-04 00:00:00 |  | [NAME] | 10086897 | 87.1 | 3.05 | VINEGAR
2024-04-05 00:00:00 | 689 | Codchem |  | 65.3 | 9.79 | lemon paste
2024-04-06 00:00:00 | INV11795 | Cosmo Baking Supplies | 220260504 | 116.53 | 17.47 | Baked Choc Sponge
2024-04-10 00:00:00 | CIN0046988 | Counntry Choice Foods | 220024195 | 111.08 | 9.91
2024-04-11 00:00:00 | 273287 | F. Neil & Sons | 220020028 | 53.85 | 8.08
2024-04-20 00:00:00 | 1000145461 | [NAME] | 10086897 | 67.48 | 1.26
2024-04-22 00:00:00 | INBY78184 | Fuser Technologies | 220260831 | 17.39 | 2.61
2024-04-24 00:00:00 | 275107 | F. Neil & Sons | 220020028 | 47.81 | 7.18
2024-04-25 00:00:00 | [NAME] | Cosmo Baking Supplies | 220260504 | 114.79 | 17.21 | Baked Choc Sponge
2024-04-26 00:00:00 | 1000165281 | [NAME] | 10086897 | 56.4 | 1.14
2024-04-27 00:00:00 | CIN0048497 | Country Choice Foods | 220024195 | 139.56 | 20.93
2024-04-11 00:00:00 | 5152905695 | Schweppes | 2200660 | 37.38 | 5.34 | water
Total |  |  |  | 1802.08 | 213.3200000000001