Excel to Tally Import with multiples Cost categories

Question

In Tally, I want to import Journal vouchers. I need to provide numerous Cost Categories for each ledger in the voucher, and I need multiple Cost Centers for each Cost Category.

Here's an example.

Ledger named Ledger-1

• Manufacturing Cost Category-1
• Cost Centre1 - Rs 500
• Cost Centre2 - Rs 300

• Cost Centre3 - Rs 200
   

• Location Cost Category-2

• Cost Centre1 - Rs 400
• Cost Centre2 - Rs 600

As you can see, there are two cost categories, and then each cost category has a number of cost centers associated with it. To transfer this data into Tally, I'm seeking an excel tally import tool or Tally XML tags.

Please state the name of the Excel template.