Release 4.0 Quiz-2: Excel Import

A business is using the default template provided by Tally to maintain records, but now he wants capture some additional info, for which column I not present, how this can be addressed

• User can simply copy paste the field referring from read me sheet
• User can add the field in mapping template
• User can't add additional field in default template
• Can be achieved through TDL customization

How duplication of mapping can be avoided when there is a need of mapping for similar excel sheet

• By copying .TSF file
• By copying company files
• By using Duplicate button
• By using F12:Configuration

An E-commerce operator getting sales transaction in very complex format, how this complex excel sheet can be imported

• Tally provides the mapping file for major e-commerce platforms
• By copy and pasting data in Tally provided sample formats
• E-commerce operators will provide TDL files
• By importing the .TSF file from Import menu

What advantages a business will have if it uses the default templets provided by Tally

• No mapping required, can save time and effort
• Can avoid data errors
• There is no advantages
• All of these

Which behaviour should choose for record the exception and resolve later?

• Record exception and import
• Stop import at first exception
• Ignore exception and record
• Reject and resolve later

What is the functionality of "Preview import summary" option

• It allows user to preview the summary of records before the import
• It allows user to stop the import
• It allows user to take print of summary
• It provides just a report

How user can identify the mandatory fields in Tally provided default templets.

• Mandatory fields are in bold black colour
• Mandatory fields are marked in Blue colour
• Mandatory fields are in Italic font
• Mandatory fields are marked in red colour

What if the user wants to import only Payment vouchers from a sheet which has both Receipts and Payment transactions

• Can exclude using "Exclude Rows in Excel" option in mapping screen
• Can exclude by mentioning row numbers
• Can exclude using F12 configurations option
• by deleting the rows in excel sheet

What is the best method user should follow if the import process terminates in between

• Starting row can be mentioned during next import
• Delete all imported data in Tally and reimport
• Delete the imported rows in excel
• F12:Configure--> Re-import

Which are the two mandatory fields to mapped while creating mapping template for Ledger master import

• Name, Group Name
• Name, Ledger Opening Balance
• Name, Ledger opening balance Dr/Cr
• Name, Amount