Table of Contents

 

Use Draft Transactions Report in TallyPrime

Apart from enabling you to create vouchers on the go, the Draft Transactions report also helps you resolve exceptions such as missing masters, master mismatch, and date mismatch with the current period.

With the Draft Transactions report, you can:

You can view this report with transactions that are either ready to convert or for which there are actions required.

  • Press Ctrl+B (Basis of Value).
  • Press Enter on Show Report for.
  • In the Report Details screen, under Show Report for, select Action Required, Ready to Convert, or All, as needed.
    Basis of Values for Draft Transactions in TallyPrime

Before you Begin | Prerequisites

Before you can use the Draft Transactions report, ensure that you have:

Review Transactions by Viewing the Imported File

  1. In the Draft Transactions report, select the transaction.
  2. Press Alt+I (Show Imported File).
    Show Imported File from the Draft Transactions Report
    The imported file opens.

    You won’t be able to view the imported file from the TallyPrime after the voucher is created.

View File Import Summary

Using the Draft Transactions report, you can view a summary of the files imported using the Docs by Ira. If there are files pending for import, you get to know on the top right corner of the Draft Transactions report. To know the status of import, you can navigate to the File Import Summary.

  1. From the Draft Transactions report, press F6 (File Import Summary).
    File Import Summary Button in the Draft Transactions Report in TallyPrime
  2. If you have imported a folder, then press Shift+Enter on the folder.
    File Import Summary in TallyPrime
    The files inside the folder will get displayed along with the corresponding statuses.
  3. Press Esc to go back to the Draft Transactions report.
    If the draft transactions don’t appear, then wait for a while and then press F7 (Refresh Details).

View Files Based on the Status of Import

  1. Press F12 (Configure) and set the options:
    1. Show files with Status as Successful: Yes/No.
      By default, this option is set as No.
    2. Show files with Status as In Progress: Yes/No.
    3. Show files with Status as Failed: Yes/No.
      File Import Summary Configuration in TallyPrime
  2. Press Ctrl+A to save the configurations.

    The File Import Summary shows the information only once after the import. Once you view the files along with the statuses, the information gets removed for those files.

Identify Potential Duplicates

  1. From the Draft Transactions report, press Ctrl+S (Potential Duplicates).
    Potential Duplicates Button in Draft Transactions in TallyPrime
    The duplicate vouchers are here with the remarks.
    You can choose to delete these vouchers.
  2. Select the vouchers and press Alt+D (Delete).
    Delete the Duplicate Transaction from the Potential Duplicates Report in TallyPrime

In the Potential Duplicates, you can identify such vouchers based on the Reference No., Amount, Party Name, and other details. You get to know if the voucher is in the books or available in the Pending Transactions report.

You can further configure this report to view the Potential Duplicates with specific values.

  • Press Alt+S (Potential Duplicate Config.)
  • Match Against: Voucher Type Name or Parent Voucher Type Name, as needed.
  • Include values in the report, as needed.
    You can choose to view the report with Party Name, Reference No., Total Amount, and Date, as needed.
    Potential Duplicates Configuration in TallyPrime

You can also choose to include Optional and Post-dated Vouchers available in the books.

  • Press Ctrl+B (Basis of Values).
  • Include Optional Vouchers: Yes.
  • Include Post-date Vouchers: Yes.
    Potential Duplicates Configurations in TallyPrime

Resolve Exceptions in Bulk and Create Vouchers

In the Draft Transactions report, you can resolve exceptions right from the report without even drilling down to the individual transactions.

Map Masters in bulk to the extracted values

You can map the masters all at once.

  1. In the Draft Transactions report, select all the transactions with missing masters.
  2. Press F8 (Update Mapping).
    Mapping Masters from the Draft Transaction Report in TallyPrime
    You can see the extracted value that you can map to the relevant masters available in the TallyPrime.
    Map as many masters as you want to.
  3. Once mapped, press Ctrl+A to save.
    Mapping Masters in the Draft Transactions Report in TallyPrime
    The vouchers are now in the Ready to Convert section.

All the mapped masters are saved for the future transactions. This means that whenever you import a transaction document value with the masters that are mapped to those available in the TallyPrime, you can readily save the vouchers.

Change Date if not matching the Current Period

  1. In the Draft Transactions report, select the transaction.
    You can select multiple transactions.
  2. Press F9 (Set Date).
  3. Enter the date of the transaction and press Enter.
    Set Date in the Draft Transactions Report of TallyPrime
    The transaction gets resolved and moves to the Ready to Convert section.

Set a Common Accounting Ledger

If you imported transactions for purchase vouchers belonging to the same purchase ledger, then you can assign that ledger to all of them at once.

  1. Select the transactions.
  2. Press Alt+F9 (Set Accounting Ledger).
  3. Select the relevant purchase ledger and press Enter.
    Set Accounting Ledger in Draft Transactions in TallyPrime

Resolve Exceptions in Individual Transactions

From Draft Transactions report, you can:

  • Drill down to the voucher and resolve exceptions.
    • Create masters simply by saving the voucher.
    • Create masters from the extracted value.
    • Map masters to those available in TallyPrime.
  • View mappings saved in TallyPrime in the Master Mapping Report.

Create all masters by saving voucher

  1. In the Draft Transactions report, open the transaction.
    Vouchers with Missing Masters - Docs by Ira in TallyPrime
  2. Press Ctrl+A to save the voucher.
    The masters get created along with the voucher.

Create master with the extracted value

  1. In the Draft Transactions report, open the transaction.
  2. When the cursor is on a missing master, select the extracted value and press Enter.
    Creating Masters with Extracted Values Using Docs by Ira in TallyPrime
  3. Verify the values and press Ctrl+A to save the master.
    Ledger Creation Using Docs by Ira in TallyPrime
  4. Press Ctrl+A to save the voucher.

Map master value with master available in TallyPrime

In case the master is available in the TallyPrime with a different name, then you can map inside the voucher.

  1. In the Draft Transactions report, open the transaction.
  2. When the cursor is on a missing master, select the matching master available in TallyPrime.
    Mapping Masters Inside the Voucher in TallyPrime
    The AI‑powered smart search places the most likely match at the top, followed by other possible matches. Once you map a master, the mapping is saved for future transactions with the same extracted value.
  3. Press Ctrl+A to save the voucher.

Use Master Mapping Report

  1. Press Alt+O (Import) > Manage > Master Mapping.
    Navigation to Master Mapping Report in TallyPrime
  2. From the List of Categories, select the master type, say, Party Ledger.
    Select Category Master While Opening the Master Mapping Report in TallyPrime
  3. Select the stock item for which you want to view Master Mapping.
    Select Ledger for Which you want to View the Master Mapping Report in TallyPrime
    Here are the extracted values mapped to the master.
  4. Enter more values available in your PDF and images, if needed.
    Master Mapping Report for a Party Ledger in TallyPrime
  5. Press Ctrl+A to save the mapping.
    All the values get mapped to the master available in TallyPrime.

Possible Errors While Creating Vouchers and Resolutions

Sl No. Nature of Error Description of Error Resolution
1 Voucher Amount mismatch The total amount in the voucher does not match the amount in the transaction imported as a PDF or image. Check the entry in the imported file and revalidate the values. If the values are correct, then open the voucher and press Ctrl+A to save it.
TallyPrime recalculates the values correctly and saves the voucher.
2 Voucher Date doesn’t belong to the Current Period of the Company The imported document has a date earlier than the Current Period.

You can set the voucher date in the date in the Draft Transactions report.

Refer to the Change Date if not Matching with Current Period section in this topic.

3 Voucher Date missing The date is either missing or not legible in the document.

You can set the date of the voucher.

Refer to Change Date of Draft Voucher.

4 One or more masters missing There are a few masters missing in the imported transactions that you may want to add. Either create master or create new master with extracted value.
5 Mismatch in the master values such as Party Ledger, Accounting Ledger, Additional Ledger, Stock Item, Unit, and GST Registration. There are master values that do not match the masters in TallyPrime.

The masters are available in TallyPrime but with different values.

In such a case, you need to map the field values to that available in TallyPrime.

Refer to the following sections in this topic:

  • Map Master Value with Master Available in TallyPrime
  • Map Masters to the Extracted Value from the Draft Transactions Report

Questions and Answers

  1. Do I have to map the masters all the time?
    No, you just have to map the master only once. When you map the extracted value to the master available in TallyPrime, the mapping gets saved. In the future, when you import a transaction document with the mapped masters, the transaction can be saved.

  2. My files are taking time to import. What should I do?
    You can wait, while on the other hand, you can continue to work. You can check the status of import in the File Import Summary at any point in time.
Is this information useful?
YesNo
TallyHelpwhatsAppbanner
Is this information useful?
YesNo
TARA