Add to Favourites

Map Top and Bottom Voucher Entries from Excel using Fixed Ledger Columns

You may have entered the details of the sales vouchers in multiple columns in your Excel file. You may have also entered the top ledger and bottom ledger details of the sales vouchers in different columns in your Excel sheet. If the ledger names are the same across vouchers, you can use fixed values to map the ledger names during import.

Let’s say you have entered the sales voucher details in Excel as shown below.

In the Mapping Template Creation screen:

1. Save Mapping Template for:  Select All Companies.
2. Name: Enter a name for the mapping template, for example, Sales Q2.
3. Type of Voucher: Select Accounting Vouchers.
4. Set Excel Data has column headers to Yes and Row no. for column headers to 1.
5. Import Data from row: Enter 2.
6. Under Field (TallyPrime), map the following fields with their corresponding column headers in Excel:
   1. Voucher Date with Date.
   2. Voucher Number with Invoice Number.
7. Select Top Ledgers (Party, Cash, Bank, & so on), map Ledger Name with Party Name and Ledger Amount with Invoice/Voucher Nett Amount.
8. Select Bottom Ledgers (Tax, Discount, & so on), select Ledger Name and, under Column Header (Excel), select Specify Fixed Field Value.
   • Enter Sales under Fixed Value.
9. Select Bottom Ledgers (Tax, Discount, & so on) again and map the following fields with their corresponding column headers in Excel:
   1. Ledger Amount with Value.
   2. Item Name with Item Name.
   3. Billed Quantity with Quantity.
   4. Item Rate with Rate.
   5. Item Amount with Value.
10. To map the CGST ledger,
    1. Under Bottom Ledgers (Tax, Discount, & so on), select Ledger Name and choose Specify Fixed Field Value under Column Header (Excel).
    2. Enter Tax – CGST @ 9 % under Fixed Value.
    3. Map Ledger Amount with Tax – CGST @ 9 %.
11. Similarly, to map the SGST ledger,
    1. Under Bottom Ledgers (Tax, Discount, & so on), select Ledger Name and choose Specify Fixed Field Value under Column Header (Excel).
    2. Enter Tax – SGST @ 9 % under Fixed Value.
    3. Map Ledger Amount with Tax – SGST @ 9 %.
       
12. Press Ctrl+A to save the mapping template and import the data using the saved template.

You can view the Day Book to view the imported transactions in TallyPrime.