You are reading the article How To Use Exception Resolution In Tallyprime (Vat) updated in November 2023 on the website Bellydancehcm.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested December 2023 How To Use Exception Resolution In Tallyprime (Vat)
With Exception Resolution in TallyPrime, you can view the exceptions related to masters and transactions, and resolve them.
This section in Exception Resolution in TallyPrime displays the count of total vouchers with exceptions. Drill down from this row to view all the vouchers with exceptions, number of exceptions in each voucher, and type of exception.
To resolve all exceptions without having to go from one exception type to another
Select No. of voucher with incomplete/mismatch in information.
Note: Based on the state specific TIN code, the first two digits are prompted in the message displayed under Validation Rules.
Select or enter required information for the first exception type. Further, you can press Alt+W (Recompute) or Alt+J (Accept as is) to recompute or accept the details, respectively.
Press Enter to navigate to next exception type.
Resolve the exceptions by providing details or using the buttons provided.
Press Enter after all exceptions in the voucher are resolved to view the next voucher with respective exceptions.
Continue resolving the exceptions voucher by voucher, or press Esc to return to Exception Resolution screen.
Press Alt+H (Exclude Vouchers) in the Exception Resolution screen to exclude the voucher from forms and annexures.
Displays the count of transactions where,
Country/state is not selected in the party ledger master,
State selected in transaction and party ledger are different, or
Nature of transaction is not derived.
To resolve this exception
Select the exception Country, state and dealer type mismatch/not specified.
Press Enter. All the transactions of the exception type are displayed.
Select the country, state or dealer type for each transaction.
Accept the screen. As always, you can press Ctrl+A to save.
Press Alt+H (Exclude Vouchers) to exclude the voucher from forms and annexures.
Ladakh is listed in the State field in Release 6.5.5 and later versions.
Dadra & Nagar Haveli and Daman & Diu is listed in State field in Release 6.6.3 and later versions.
Displays the count of transactions for which the rate or tax type is not selected in the item/ledger master. To resolve this exception:
Select the exception Tax rate/tax type not specified.
Note: Based on the state specific tax structure, the columns are displayed. The column: ♦ Addl. Tax Rate appears for Gujarat and Uttar Pradesh. ♦ Surcharge appears for Punjab and Haryana. ♦ Cess for Kerala VAT.
Select the Nature of transaction, if not provided.
Enter Rate of Tax, as required for each transaction.
Accept the screen. As always, you can press Ctrl+A to save.
Press Alt+H (Exclude Vouchers) to exclude the voucher from forms and annexures.
Displays count of transactions in which the Nature of transaction, assessable value or rate of tax defined in the ledger master has been changed in the transaction. To resolve this exception:
Select the exception Nature of transaction, assessable value, rate of tax modified in voucher.
Note: Based on the state specific tax structure, the columns are displayed. The column: ♦ Addl. Tax Rate appears for Gujarat and Uttar Pradesh. ♦ Surcharge appears for Punjab and Haryana. ♦ Cess for Kerala VAT.
Select the required voucher.
Note: Based on the state specific tax structure, the columns are displayed. The column: ♦ Addl. Tax Rate appears for Gujarat and Uttar Pradesh. ♦ Surcharge appears for Punjab and Haryana. ♦ Cess for Kerala VAT.
Press Enter to accept.
Similarly, accept the required vouchers.
Accept the screen. As always, you can press Ctrl+A to save.
Displays count of transactions in which type of duty is invalid. To resolve this exception:
Select the exception Incorrect tax type selected in tax ledger.
Note: Based on the state specific tax structure, the columns are displayed. The row: ♦ Additional Tax appears under each taxable transaction for Gujarat and Uttar Pradesh. ♦ Surcharge appears under each taxable transaction for Punjab and Haryana. ♦ Cess under each taxable transaction for Kerala VAT.
Select the tax type for each transaction.
Note: Based on the state specific tax structure, the columns are displayed. The row: ♦ Additional Tax appears under each taxable transaction for Gujarat and Uttar Pradesh. ♦ Surcharge appears under each taxable transaction for Punjab and Haryana. ♦ Cess under each taxable transaction for Kerala VAT.
Accept the screen. As always, you can press Ctrl+A to save.
Press F12 (Configure) in Vouchers with incomplete/mismatch in information screen.
Set Round-off margin value, as required.
Accept the screen. As always, you can press Ctrl+A to save.
In case the difference in tax amount is within the given Round-off margin, the transaction is by default included for returns, and not set as an exception.
Select the exception Mismatch due to tax amount modified in voucher.
Press Enter. All the transactions of the exception type are displayed.
Note: Based on the state specific tax structure, the columns are displayed. The row: ♦ Additional Tax appears under each taxable transaction for Gujarat and Uttar Pradesh. ♦ Surcharge appears under each taxable transaction for Punjab and Haryana. ♦ Cess under each taxable transaction for Kerala VAT.
Press Alt+W (Recompute) to recalculate the tax amount.
Accept the screen. As always, you can press Ctrl+A to save.
Select the exception Mismatch due to tax amount modified in voucher.
Press Enter. All the transactions of the exception type are displayed.
Press Alt+S (Create Adjustment).
Record journal voucher by assigning the difference amount to VAT ledger and save the voucher.
Similarly, adjustment transactions can be created for all vouchers with difference in tax amount.
Select the exception Mismatch due to tax amount modified in voucher.
Press Enter. All the transactions of the exception type are displayed.
Select the required transaction.
Select the transaction, and press Alt+B (Save).
Similarly, vouchers with exception can be linked to other vouchers.
Select the exception Mismatch due to tax amount modified in voucher.
Press Enter. All the transactions of the exception type are displayed.
Select the required transaction.
Press Alt+R (Resolve). You can :
Or
Note: Based on the state specific tax structure, the columns are displayed. The row: ♦ Additional Tax appears under each taxable transaction for Gujarat and Uttar Pradesh. ♦ Surcharge appears under each taxable transaction for Punjab and Haryana. ♦ Cess under each taxable transaction for Kerala VAT.
Accept the screen. As always, you can press Ctrl+A to save.
To resolve this exception
Select the exception Mismatch due to tax amount modified in voucher.
Press Enter. All the transactions of the particular exception are displayed.
Press Enter to accept.
Similarly, accept the required vouchers.
Accept the screen. As always, you can press Ctrl+A to save.
Displays the count of journal transactions in which Nature of adjustment is not selected.
To resolve this exception
Select the exception Voucher with incomplete/incorrect adjustment details.
Select the Nature of adjustment and Additional details for each voucher.
Accept the screen. As always, you can press Ctrl+A to save.
Displays the count of transactions excluded from annexures due to incomplete information required for annexures. The button Exception Types is provided to resolve all party ledger level or voucher level corrections from a single screen.
To resolve all exceptions without having to go from one exception type to another
Select Information required for generating annexure not provided.
Note: Based on the state specific tax structure, the columns are displayed. The column: ♦ Additional Tax appears for Gujarat and Uttar Pradesh. ♦ Surcharge appears under each taxable transaction for Punjab and Haryana. ♦ Cess under each taxable transaction for Kerala VAT.
Note: Based on the state specific TIN code, the first two digits are prompted in the message displayed under Validation Rules.
Enter the missing information or update the incorrect details, and press Enter to return to the Exception Resolution screen.
Select the next voucher to update the details required for annexures and continue.
Using this option you can resolve exceptions from a common screen by grouping all annexure related exceptions into ledger-wise exceptions, item-wise exceptions and voucher-wise exceptions. Exceptions in each group can be resolved from a single screen without having to move voucher by voucher.
Voucher-wise exceptions: The voucher-wise exceptions appear when you press Enter from Incomplete/mismatch in information (to be resolved) row of VAT report. If you are viewing the item-wise or ledger-wise exceptions, press Ctrl+F8 (Voucher-wise Exceptions) to view the voucher-wise exceptions.
Select the required count in the columns and press Enter to resolve the exceptions.
Accept the screen. As always, you can press Ctrl+A to save.
Drill down from this column to view information missing/mismatch in item at master level. You can provide the required details at stock group level to update all items in the group or at individual item level. By providing required information at item master level, all voucher level exceptions resulting from that item are resolved.
Navigate to required exception type and press Enter from Total Masters column to display Multi Stock Alteration screen.
Note: Based on the state specific tax structure, the columns are displayed. The column: ♦ Addl. Tax Rate appears for Gujarat and Uttar Pradesh. ♦ Surcharge appears under each taxable transaction for Punjab and Haryana. ♦ Cess under each taxable transaction for Kerala VAT.
Enter Commodity Name, Commodity Code, and Rate of tax.
Select Tax Type and enter the Effective date.
Accept the screen. As always, you can press Ctrl+A to save.
Drill down from this column to view information missing/mismatch in the items at voucher level. You can provide the required details for each transaction.
Note: Based on the state specific tax structure, the columns are displayed. The column: ♦ Addl. Tax Rate appears for Gujarat and Uttar Pradesh. ♦ Surcharge appears under each taxable transaction for Punjab and Haryana. ♦ Cess under each taxable transaction for Kerala VAT.
Select Nature of transaction.
Enter Rate of Tax.
Accept the screen. As always, you can press Ctrl+A to save.
Drill down from this column to view information missing/mismatch at ledger master level. You can provide the required details at ledger group level to update all ledgers in the group or at individual ledger level. By providing required information at leger master level, all voucher level exceptions resulting from that ledger are resolved.
Navigate to required exception type and press Enter from Total Masters column to display Multi Ledger Alteration screen.
Provide the required details
Accept the screen. As always, you can press Ctrl+A to save.
Drill down from this column to view information missing/mismatch in the ledger at voucher level. You can provide the required details for each transaction.
Navigate to required exception type and press Enter from Total Vouchers column to display Exception Resolution screen.
Provide the required details.
Accept the screen. As always, you can press Ctrl+A to save.
You're reading How To Use Exception Resolution In Tallyprime (Vat)
How To Use Edit Log In Tallyprime
Edit Log in TallyPrime allows you to keep a trail of each activity performed in transactions and masters to help you have a better internal control over your Company data. Irrespective of the nature of changes made in the data – financial, functional, or internal, the Edit Log feature keeps a trail of the activities in Company data.
Edit Log enables:
Regular monitoring of the actions such as creation, alteration, and deletion in transactions and masters in your Company data.
Simplicity in auditing your account books.
A practice of making well-informed decisions in terms of working with Company data.
The Edit Log feature is introduced in TallyPrime Edit Log Release 2.1 and TallyPrime Release 2.1.
Audit trail is intended to ensure that all the activities related to your transactions and masters are logged and available for viewing, according to MCA notification for businesses. Considering this aspect, the Edit Log feature in TallyPrime has been designed with the necessary controls in place, by default, to eliminate any scope of tampering the trail of your transactions.
Edit Log is a view-only (display) report that maintains track of all activities with your vouchers and masters, like creation, alteration, deletion and so on, without the need for any additional controls to restrict the access. The design principle applied in building the Edit Log feature makes the log of your data more reliable, secure, and completely tamper-proof, in compliance with the MCA requirements. This means, at any given point a user can ONLY view the Edit Log report to understand the trail of activities.
The underlying design principle of Edit Log enables you to view the logs and compare with its previous version, thereby providing more specific insights on the updates done to the vouchers and masters. Additionally, if a user attempts to open the Edit Log using a TallyPrime non-Edit Log version, a log gets created keeping a track of this activity. This helps auditors to check if any user had opened the Edit Log in any other non-Edit Log version of TallyPrime. Such inbuilt controls designed in TallyPrime makes the Edit Log data much more reliable and tamper-proof.
Moreover, if you would not want any user to view or create Edit Log as per your business need or policy, TallyPrime already has the robust and powerful Security feature at the company level to restrict creation or alteration of vouchers, as needed.
With Release 2.1, we are giving you the flexibility to choose between the following products:
By default, TallyPrime does not track activities in your transactions and masters. You can enable or disable Edit Log, when needed.
TallyPrime Edit Log and TallyPrime have the same set of features to run your business, including Edit Log. However, only TallyPrime Edit Log meets the Audit Trail compliance requirements.
If you want to continue using TallyPrime, then you can upgrade to the latest release. To know how to do it, refer to Update a Release.
I , then you can upgrade your existing TallyPrime or chúng tôi 9 application. Alternatively, you can install TallyPrime Edit Log in a separate folder.
You can use TallyPrime Edit Log with either your existing TallyPrime license or a new license.
You can download TallyPrime Edit Log from the Tally Solutions website. To know how to install TallyPrime Edit Log, refer to Install TallyPrime Edit Log.
If you are using TallyPrime or Tally.ERP 9, then you will need to migrate data to TallyPrime Edit Log. To know more, refer to Migrate Data to TallyPrime Edit Log.
The facility of Edit Log to track all the activities such as creation, alteration, and deletion is provided for all transactions that you enter in TallyPrime, irrespective of the type of voucher. To know how to view Edit Log for transactions, refer to the View Edit Log for Transactions section in the Accounting Entry in TallyPrime topic.
Edit Log is provided for three masters: Ledgers, Stock Items, and Groups, as the activities such as creation, alteration, and deletion in these masters can change the financial reports in your Company data. know more about the Edit Log for each master, refer :
Edit Log report for transactions and masters
The Edit Log report for transactions and masters provide you with an idea of the nature of activity that was performed by a particular user at a specific time. This helps you monitor the activities and have a better internal control over your Company data.
The Edit Log reports for transactions and masters are similar, and a sample report is shown .
Nature of Activity
Activity Label in Edit Log
Creation
Created: When you create a transaction or master, the activity is logged.
Created due to Import: When
you import transactions or masters to the Company data, the activity is logged.
Created due to Sync:
Alteration
Note
: You may re-accept a voucher or master by pressing
Ctrl+A
. However, the Activity may be displayed as Altered due to internal changes in application that occurred due to the activity of resaving.
Altered due to Split: Changes made to the masters such as
Opening Balances, Bill-wise during Split will create Edit Log.
Altered due to Sync: Edit Log is created if there are any changes between the transaction or master in the client system and server system.
due to Migration: Transactions and masters that are altered to support the new or improved functionality provided in that release will have Edit Log.
Deletion
Deleted:
When you delete a master, the activity is logged.
Deleted due to Sync: When a deleted master is synchronised from the client system to server system, TallyPrime creates an Edit Log for the activity.
Resave
Resaved due to Import (No changes): When
a transaction or master gets resaved at the time of import without any changes, the activity gets logged.
Resaved due to Sync (No changes): After synchronisation, i
f there is no change in the master in the server system as compared to the client system, then the activity is logged.
When a Company data for which Voucher Type with method of voucher number as
Automatic (Manual Override) is migrated and
it is changed to
Automatic
or
Multi-User Auto.
Thereafter, if the voucher numbers do not change,
then the vouchers get resaved
.
Previous Record
You may make a lot of changes in a transaction or a master when Edit Log is disabled in the Company.
Previous Record the consolidated data of the activities performed in TallyPrime when the Edit Log is disabled or in a migrated Company data where Edit Log was not enabled.
Previous Record gets logged in transactions and masters when they are altered, resaved, deleted for the first time after:
in .
The data is from TallyPrime with Edit Log disabled to TallyPrime Edit Log Release 2.1 or later.
The data is migrated from TallyPrime Release 2.0.1 or earlier or chúng tôi 9 to
Does not contain Username and Date & Time, as Edit Log was disabled when the activity was performed
Note:
When you perform the first activity in the imported transaction or master, two activities will get logged.
Previous Record
Activities with Status: Optional and Status: Cancelled
such as creation, resaving, or alteration with Status: Optional and Status: Cancelled.
The statuses are provided for such vouchers because these transactions do not affect your financial reports, until they are made regular.
If the Security Control is not enabled in your Company, username as Unknown (Security not enabled).
When you drill down on a version in the Edit Log report for any transaction or master, you can view the differences between the selected version and the immediate previous version.
The values in the reports are organised based on the fields and their hierarchy.
The field values that have changes between the versions are marked in red, regardless of the users changing the values or internal changes.
Keys/Action
Result
+/– Move between the next and previous versions
PgDn/PgUp
Scroll within the report
Shift+F5 View the details of the changes Explode a line F12
Configure the report
A few special cases of the diff report
Activity: Created
The version on the left-hand side is empty and no field value is shown in red.
Activity: Deleted
The version on the right-hand side is empty and no field value shown in red.
Activity: Resaved (No changes)
Other cases in Differences Between Edit Log Versions report
Type
Action/Reason
Impact
User action Voucher Type changed during alteration Order of fields in the Differences Between Edit Log Versions report will change. Change in order of ledgers Order of ledgers in the Differences Between Edit Log Versions report will change. Altered ledgers and then altered vouchers Changes due to ledger alteration will be shown in the report for the transaction in which the ledger is used. For example, if you change the address in a particular party ledger and then alter a transaction with the ledger, then the values affected due to ledger alteration will start appearing in the Differences Between Edit Log Versions report of the transaction. Changed the number of decimal places for units Field values get marked in red, even when the value remains the same. This happens because even if you set the number of decimal places to 2, TallyPrime internally calculates the values with 4 decimal places. Configuration-based values Occurrence of disabled field in report . For example, even if you have not enabled , then also you
will see fields related to GST or VAT. This happens because, irrespective of the status of the feature – enabled or disabled, transactions and masters have those values as a part of the data.
Use of TDLs Display of User-Defined Fields If there is any TDL that modifies the field labels and the TDL is not present when loading the report, then the values will be shown without labels. Data behaviour Values that are only shown in the voucher but not part of the data A few fields such as
discount percentage and alternate units shown on the voucher for reference are not included in the report.
Nature of Data
Data presentation in the report
T
he way you see data in the report may change from the way you see in the voucher or master screen. This happens because the way data stored in TallyPrime differs from the way it is presented.
When using TallyPrime with the Edit Log feature, you might be using third-party integrations or TDLs that allows import of third-party data into your company. In addition, depending on your day-to-day transactions, you might need to insert or delete vouchers in your company data.
For TallyPrime 2.1 with Edit Log or TallyPrime Edit Log 2.1: If you have set the voucher numbering method to Automatic, it is recommended to alter it as Automatic (Manual Override).
Avoid making frequent changes to your masters and vouchers once they are created. Each time you alter your data, edit log data is created for each alteration, thereby increasing the over all data size.
Ensure that the vouchers to be imported have the appropriate voucher numbers, as expected, to avoid creation of any unwanted edit log data.
The Edit Log report under Company consists of all the activities in the Company data that may affect the existing Edit Logs for transactions and masters. This report is not to view the changes made on the Company screen.
The report is similar in TallyPrime and TallyPrime Edit Log. However, the list of activities will have minor differences.
To view the Activities Affecting Edit Log report:
A report in TallyPrime appears as shown .
TallyPrime Edit Log
TallyPrime
Company Data migrated from TallyPrime: Migration from
TallyPrime to TallyPrime Edit Log Release 2.1 or its successors.
Company Data migrated: Migration from a TallyPrime Edit Log release to another TallyPrime Edit Log release.
Company Data migrated from chúng tôi 9 or earlier: Migration
from chúng tôi 9 or an older version to TallyPrime Edit Log Release 2.1 or its successors.
Company Data migrated: Migration
from a release of TallyPrime Edit Log to later releases of TallyPrime Edit Log.
Company Data moved from TallyPrime: Moved f
rom TallyPrime Release 2.1 to TallyPrime Edit Log Release 2.1, irrespective of the status of the Edit Log feature – enabled or disabled.
Company Data split: Splitting of Company data will be logged.
Company Data migrated from chúng tôi 9 or earlier (Not fully recovered): P
artial loss of data due to data corruption while migrating data from chúng tôi 9 to TallyPrime Edit Log Release 2.1 or its successors.
Company Data repaired (Not fully recovered): P
artial loss of data during data repair.
Edit Log enabled during Company creation: When enabling Edit Log at the time of Company creation.
Edit Log enabled: When enabling Edit Log at the time of Company alteration.
Edit Log disabled: When disabling Edit Log at the time of Company alteration.
Company Data migrated from TallyPrime Edit Log: Migration
from TallyPrime Edit Log to a lower version of TallyPrime.
Company Data migrated:
Migration from a TallyPrime release to another TallyPrime release.
Migration
from chúng tôi 9 or an older version to TallyPrime Release 2.1 or its successors
Company Data migrated: When the data is migrated from earlier versions of TallyPrime (
Company Data moved from TallyPrime Edit Log:
Migration from TallyPrime Edit Log Release 2.1 to TallyPrime Release 2.1.
Company Data split: Splitting of Company data will be logged.
Company Data migrated from chúng tôi 9 or earlier (Not fully recovered): P
artial loss of data due to data corruption while migrating data from chúng tôi 9 to TallyPrime Release 2.1 or its successors.
Company Data repaired (Not fully recovered): P
artial loss of data during data repair.
If the Security Control is not enabled in your Company, then the activities will be logged with username as Unknown (Security not enabled).
How To Import Data In Tallyprime
In your business, you record all your transactions depending on your activities. If you have created a company in TallyPrime, you might want to use the same data in the company and continue to use them. If you are already using TallyPrime and have created your masters and transactions, you can export the data to any location and import it back to a new company in TallyPrime. The Import feature in TallyPrime enables you to import your external data seamlessly. What’s more!
As per your business policy, if your payment transactions are connected to any bank, you will certainly need to reconcile your bank-related payments from time to time. TallyPrime facilitates importing the bank statements in the application and the payment transactions all from a single screen. Additionally, if your business is under the GST regime, using TallyPrime Release 3.0 or later, you can reconcile your GST Returns with the GST data available from the portal GST Returns before filing the same.
The data to be imported needs to be available in the formats that are supported by TallyPrime.
Masters and transactions:
Bank Statement: Excel (xlsx)
GST Returns: JSON
Before importing any data into TallyPrime, it is recommended that you take a of your Company Data to avoid any risk of data loss or data .
When you need to reuse any existing business records in your company in TallyPrime or want to reconcile your Company Books with bank details or Returns, the import feature in TallyPrime comes in handy. The imported data seamlessly integrates with your existing company data depending on your business needs. TallyPrime provides the flexibility to not only import the data but also make the required changes to the imported data the way you would alter the existing data.
Before you import masters or transactions, you can configure the Import process as per your needs.
Location of Import/Export Files: You can predefine the path where the that you want to import is available. This helps you to directly select the file that you want to import, without having to browse for the file location every time.
Stop Import at First Exception: This ensures that the Import process stops immediately the moment it encounters any data exception. This means, until that point the data gets imported.
Record Exceptions and Import: This ensures that all exceptions get recorded and the remaining data imported successfully. You can refer to the report and resolve them as needed.
If you are on TallyPrime Release 2.1 or earlier, you will see the following option: Ignore errors during import: Yes/No
There are a few other configurations that you can explore and set as per your requirements.
You can import only XML files. When you export any data from other company or software, and want to import the same data into TallyPrime, ensure to save it in XML file format.
Note: The company features that were enabled while exporting the data should be enabled in the company in which the data is imported. Let us consider that you want to import masters created in National Enterprises (Bangalore) to a new company – National Enterprises (Chennai). The options Maintain stock categories and Maintain batch-wise details must have been en in National Enterprises (Bangalore) before exporting the masters. To import masters into National Enterprises (Chennai), you need to ensure that both the options Maintain stock categories and Maintain batch-wise details are enabled in National Enterprises (Chennai) before importing.
Fill in the Import Masters or Import Transactions screens.
File path: Your data file must be saved in XML file format. Enter the location of the file.
Behaviour of import if master already exists: (Not applicable if you are importing transactions) It is possible that your existing company data has the same set of masters as in the XML file. In this situation, you can choose to
Combine opening balance of existing master and imported master.
Ignore duplicates so that TallyPrime does not import any masters from the XML file.
where the master in the XML file replaces the existing master.
Depending on the Import configurations you have set, TallyPrime imports the data.
You also have the choice to either stop of the data if there is any exception or import only appropriate data – to avoid any risk of corrupting your existing data.
If TallyPrime identifies exceptions in the data during migration, it classifies them into the following based on the nature of the exceptions:
Exceptions that require of new masters or transactions are logged under the Import Exceptions report. You can resolve the Import exceptions from:
For more information, refer to the Data Exceptions & Resolutions topic.
Exceptions that require alteration of the existing masters or transactions are logged under the Event Log report. You will need to alter the specific masters or vouchers to resolve the errors listed in Log.
When you record day-to-day transactions, there are times when you will need to reconcile your company books with the data available externally. This helps you keep a track of any discrepancy in your data and take corrective actions when needed. TallyPrime enables you to import bank statements and GST Return files (not applicable in Release 2.1 or earlier) and use them for reconciliation.
In this section
You might need to import Bank Details for reconciliation with your payment records. Before importing the Bank Statements, you can configure their data paths without having to choose the path every time you need to import the bank statements.
Folder Path for new Bank Statements
Folder Path for imported Bank Statements
Folder Path for new Intermediate Files
Folder Path for imported Intermediate Files
Once you have configured the data paths, you can import the Bank Details into TallyPrime.
For more information on importing bank details and bank reconciliation, refer to the topic.
If you are on TallyPrime Release 2.1 or earlier, this is not applicable.
Once you have uploaded your invoices to the GST Portal, your invoices or added some missing transactions done in the past. Therefore, it is best to reconcile your company books with the portal data. In TallyPrime Release 3.0, you can download the JSON file from the GST Portal and import it into TallyPrime to compare with the Company data and reconcile as needed.
In the Import GST Returns screen, provide the required details to import the GST details.
GST Registration: The GST Registration for the company is selected by default. If you have created multiple GST registration for the company, you can select the GST Registration, as needed.
Type of Return: Select the return for which you need the GST details from the portal.
File Path: Location of the return file.
Importing GST Returns helps you compare the same with the data in your returns and reconcile as needed to keep your data up-to-date and accurate.
For more information, refer to the GSTR-1 topic.
If you are on TallyPrime Release 2.1 or earlier, this is not applicable.
In case you had imported GST Returns into TallyPrime to reconcile the portal data with your return data, you might need to remove especially if:
You have already reconciled the data and no longer need the imported data.
The imported data is corrupted and cannot be used.
You have imported an incorrect JSON file.
In such situations, you can easily remove the unwanted GSTN data using the Reset GSTN Data feature in TallyPrime for any selected period depending on your need.
Provide details of the company and period from which you need to remove the GSTN data.
Company Name: If you have loaded more than one company, you can select the company for which you want to reset the GSTN Data.
GSTIN/UIN: Based on the selected company, this will get prefilled. However, if you have created multiple registrations for the selected company, you can select the GSTIN/UIN.
Period: You can update the From date from when you wish to reset the GSTN Data. However, the To date is prefilled and you will not be able to change it.
Books beginning from date of the company
Financial year beginning date of the company
GST applicability date (01-Jul-2023) as per Department
GST applicability date as specified by you for the respective GSTIN
The To date is prefilled as per the latest date of any stat data available for the vouchers. If no such date is available, TallyPrime will prefill the To date with the Books beginning from date of the company. This field cannot be changed.
Select Backup details: It is recommended that you take a of the company data before you reset the data.
Set Backup Company Data before Reset to Yes.
Provide the
Accept the screen. As always,
Resetting GSTN data ensures that any unwanted GSTN data imported from the portal is removed from TallyPrime data.
In Marg, you have an option to export the masters and transactions in Marg to TallyPrime.
The data available in masters and transactions from Marg will be exported in XML format.
You can import the same XML file to TallyPrime. Refer to the Import Masters & Transactions section for more information.
Import master and transaction XML files using Master Import and select Ignore Duplicates.
You can check the statistics after importing masters and transactions.
How To Generate Tds Reports In Tallyprime
You can generate and view a few MIS reports required for TDS.
While filing e-TDS returns, the correct PAN should be defined in the party ledgers configured for TDS deduction. The report Ledgers without PAN displays the list of all the party ledgers configured for TDS deduction for which PAN is not defined. You can configure it to view the list of all ledgers for which PAN is defined, and the PAN can be corrected, if required. Additionally, you can view information on the Deductee Type, Contact Person, and Contact Number defined in the party ledger.
In this section
Accept the screen. As always, you can press Ctrl+A to save and return to the TDS Return menu.
Press Enter on Ledgers without PAN in the TDS Reports menu.
Press F8 (All Ledgers) to view the list of ledgers for which PAN is defined.
Select the PAN/IT No. that needs to be corrected.
Modify the PAN/IT No., as required.
Accept the screen. As always, you can press Ctrl+A to save. The corrected PAN gets updated in the party ledger master.
A brief explanation on the fields and columns provided in this report is given below:
Field/Column Name
Description
No. of Deductees
Displays the total count of party ledgers configured for TDS deduction (the option Is TDS Deductable is set to Yes in party ledger). This field appears when you press F8 (All Ledgers) in the Ledgers without PAN report.
PAN Empty
Displays the percentage of party masters for whom PAN is not defined. This field appears when you press F8 (All Ledgers) in the Ledgers without PAN report.
Supplier Ledger Name
Displays the Name of the party ledger configured for TDS deduction.
Deductee Type
Displays the Deductee type selected in the party ledger.
Contact Person
Displays the name of the Contact person entered in the party ledger.
Contact Number
Displays the Phone no. entered in the party ledger.
PAN/IT No.
Displays the PAN/IT No. entered in the party ledger.
The TDS Outstanding report displays all the pending TDS payments. You can view the pending details party-wise, or based on resident or non-resident status.
In this section
A brief explanation about the fields in the report is given below:
Field Name
Description
Nature of Payment
Company
Non Company
Total Pending
Displays the total outstanding amount of all TDS payment from all parties.
Press F12 (Configure) in the TDS Nature of Payment Outstandings report.
By default the report appears category-wise, you can change it to party-wise by pressing F5 (Party-wise).
Press F5 (Party-wise) to view the party-wise details.
Press F12 (Configure) to change the display of report in terms of the following options:
Format of Report
Sorting Method
A brief explanation about the report fields is given below:
Field Name
Description
Date
Displays the date of recording payment, journal or purchase voucher.
Ref. No.
Displays the reference number entered in the payment, journal or purchase voucher.
Party’s Name
Displays the party name from where TDS is deducted and the payment for the same are yet to be made.
Opening Amount
Displays the opening amount of TDS.
Pending Amount
Displays the pending amount of payment to be made to the government.
Due On
Displays the last date of payment.
Overdue By Days
Displays the number of days passed after the due date.
The TDS Reconciliation report displays the all the reconciled TDS payments.
Press F8 (Show All) to show all or pending challan.
Press Alt+R (Reconcile).
As per NSDL department file validation tool, challan number and challan date are not mandatory. In case of online TDS duty payment, user can provide the challan number and challan date or leave the fields blank, and validate E-TDS file successfully.
Column Names
Description
Date
Displays the payment voucher date.
Particulars
Displays the duty ledger selected in the voucher.
E-TDS Quarter Period
Displays the From and To dates entered at the Statutory Payment Details screen. If TDS duty payment is recorded manually, the quarterly period has to be entered manually here.
Section No.
Deductee Type
Resident Type
Cheque/DD No.
Displays the cheque or DD number which were entered manually at the time or reconciliation.
Cheque/DD Date.
Displays the cheque or DD date which were entered manually at the time or reconciliation.
BSR Code
Displays the BSR Code of the bank which was entered manually at the time or reconciliation.
Challan No.
Displays the challan number provided by the bank which was entered manually at the time of reconciliation.
Challan Date
Displays the challan date provided by the bank which was entered manually at the time of reconciliation.
Vch No.
Displays the payment voucher number.
Amount
Displays the amount paid recorded in the TDS payment voucher.
How To View Ratio Analysis In Tallyprime
Analysis in TallyPrime is a powerful tool for financial analysis, where the analysis of a financial statement is made possible by the use of financial ratios. It helps you compare different sets of financial data. Along with the ratio of your assets with respect to your liabilities, cash in hand, stock in hand, and so on, you can also understand the payment performance of your debtors which indicates the average time the customers take to actually pay their bills irrespective of the outstanding balance on the statement date. All these comparisons and observations give an understanding of the financial position of a business unit.
Ratio Analysis report is mostly sought after by business owners, auditors, and stakeholders who want to have clarity about the course of their business for a particular financial year. By referring to the Ratio Analysis report, they can understand their accounts better and take much informed decisions according to the current fiscal scenario.
In TallyPrime, the Ratio Analysis report consists of Principal Groups and Principal Ratios. The Principal Groups are the key figures that give meaning to the ratios. Principal Ratios compare two pieces of financial data for a meaningful comparison.
You can view Ratio Analysis report in the browser.
Analysis in TallyPrime helps you compare different sets of financial data. It consists of Principal Groups and Principal Ratios, that you know about the overall standing of your business. While Principal Groups showcase your Working Capital, Cash-in-hand, Bank Accounts, along with the data related to Sundry Debtors, Sundry Creditors, Stock-in-hand, Nett Profit, and Inventory Turnover, Principal Ratios display the data related to Current Ratio, Quick Ratio, Gross Profit %, Nett Profit %, Return on Investment %, and more. Apart from the data regarding your current business scenario, TallyPrime allows you to drill down further from the Principal Groups and Ratios to access other primary reports such as Balance Sheet, Profit and Loss A/c, Funds Flow report, and many more. For example, Current Ratio takes you to Balance Sheet and Gross Profit % takes you to Profit & Loss A/c.
The following are the key features that summarize the Principal Groups in the Ratio Analysis report.
Working Capital: The Working Capital is calculated by subtracting Current Liabilities from Current Assets. Financial analysts often consider the total Current Assets as the Working Capital. This serves as a measure of how far the firm is protected from liquidity problems.
d and Bank Accounts: This data provides another view of the liquidity position where you can get the details of the finances.
Sundry Debtors (due till today): This is the list of all the debtors and total debts due as of the date of the statement.
Sundry Creditors (due till today): This is the list of all the creditors and total credits due as of the date of the statement.
Sales and Purchase Accounts: The Sales and Purchase Accounts, which represent the trading activity for the period, are displayed.
Stock-in-Hand: The Stock-in-Hand is displayed as on the date of the report. Together with Cash and Bank Balances and Debtors, this completes the Current Assets aspect of the Working Capital.
Nett Profit: This is derived from the Profit & Loss Account, and is the profit that remains after direct and indirect expenses.
Wkg. Capital Turnover (Sales Accounts/Working Capital): This is an activity or efficiency ratio that shows the number of times the working capital has been rolled over during a particular period. It depicts how effectively the firm is using its working capital.
Inventory Turnover (Sales Accounts/Closing Stock): This is an activity or efficiency ratio that shows the number of times the stock has been rolled over during the report period. It depicts how effectively the firm is using its inventories.
The following are the key features that summarize the Principal Ratios in the Ratio Analysis report.
: It is the ratio between the Current Assets and Current liabilities. The current ratio helps you to understand whether your business is able to pay the liabilities with its current assets.
Quick Ratio: This ratio displays the difference between your Current Assets and Stock-in-Hand with respect to your Current Liabilities. Quick Ratio indicates the company’s ability to instantly use its near-cash assets, which can be converted quickly to cash, to pay down its current
This ratio tells you how much debt you have taken as compared to the company’s equity. A high Debt equity ratio means that your company relies on debt financing.
Nett Profit %: The percentage of earnings remains with you after all the operating and non-operating expenses are from the gross profit. Nett Profit % demonstrates how well you handle your indirect expenses.
Operating Cost %: It is the percentage of operating cost with respect to the total turnover. Operating Cost % helps you check certain areas of your business, such as cost control and cost reduction.
Recv. Turnover in days: Through this data, you can analyze your payment performance. Identifying the customers who are yet to pay their bills, you can plan the receivables collection process through Recv. Turnover in days.
Return on Investment %: It is used to evaluate the efficiency of an investment or different investments. Return on Investment percentage is the benefit drawn from an investment or Nett Profit with respect to your Capital Account and Nett Profit combined together. Expressed in percentage, Return on Investment directly measures the amount of return on a particular investment, with respect to the cost incurred on the investment.
Return on Wkg. Capital %: It is the ratio of Nett Profit with respect to Working Capital. Return on Working Capital percentage highlights the relation between the investments done towards the operation of a business and the revenues it generates to continue its operation and make profit.
Payment Performance of Debtors (Receivable Turnover in days) is the average time the customers take to pay their bills, irrespective of the outstanding balance on the statement date. It is possible that the receivable turnover is low and the payment performance is high, indicating that the customers cleared their outstanding, but took a long time to do it.
To get group-level and customer-level performance reports and a detailed position of debt collection, you have to drill down from the ratios. Use a customer statement that shows both the receivable turnover in days and the customer’s actual payment performance.
The Ledger Payment Performance statement displays the receivable turnover in days. This is the balance outstanding in relation to the total sales made, multiplied by the total number of days in the period. This ratio should be used in combination with the Average Performance of actual payments and the payment history of the customer to assess how long they might take to pay the outstanding balance.
The actual payment history is given in the table for each invoice that was paid by the customer. It shows when the invoice was paid, how long it was due, and what was the delay in payment. The customer’s average performance is shown at the bottom of the screen.
The Ratio Analysis report gives you insights the , liquidity, operational efficiency, and financial stability of your business. It tells you how your business has been performing for particular period and guides you to take convenient decisions.
How To View Kfc Computation Report In Tallyprime
The KFC Computation report in TallyPrime provides you with a collective view of business transactions recorded during a period. The information in the report is further organized into number of transactions and transaction values. This organization helps you to check the transactions list, analyse the transactional values, make necessary changes wherever required, and finalise the data for computation of KFC-A returns.
How does this report help? Can I file KFC-A return from TallyPrime, or is this a computation report that will help me file KFC-A?
This report displays the values only from the transactions you have recorded in TallyPrime for the return period. Currently, KFC-A is a physical form for which offline or online updates are not available.
KFC Computation gives you the confidence that all your records are being considered. It collects all the information required for filing the KFC-A form at one place. The report focuses on accumulating details of all transactions where KFC is applied or was applicable. The values from KFC transactions are grouped based on the GST rate applied, and the taxable amount, KFC rate, and KFC payable are displayed for each GST rate. Once you have all the details at one place, you can verify the information and quickly fill the returns form.
Transactions in which KFC was applicable but not applied are also listed separately in the report allowing you to take the necessary action. You can make correction or even decide to exclude the transaction from returns, both options are provided in the report.
Further, it helps you check details such as:
Vouchers that are included in the returns computation
Vouchers that are excluded from the returns computation as they are not relevant
Vouchers that need updates for inclusion in returns computation as they have incomplete or incorrect KFC information
List of supply categories based on the different GST rates on which KFC is applicable. Taxable value, KFC tax percentage, and KFC payable for different supply categories.
It also allows you to include, exclude or alters vouchers with real time changes to the taxable value and KFC amount. Once all the exceptions are resolved, you can use the values shown in the computation report as the base for filling the KFC-A form.
This part of the report displays the statistics for all vouchers recorded in the period. It gives you a fair idea about the amount of business conducted during a month. Apart from providing the details of total number of transactions recorded for the period, this section further divides the information into number of vouchers included in the computation, excluded, and pending for correction. You can drill down from any line to get voucher level information, where you can include or exclude the vouchers after examining.
The different kind of information displayed in this section, are:
Total number of voucher for the period: As the title suggests the number of vouchers recorded in the report period is shown here. It includes all the vouchers and not only KFC vouchers or financial vouchers.
Drill down from this line to view the Statistics screen with details of account types and voucher types used to record the total number of vouchers.
Included in Reports: The number of vouchers that are included in the computation out of the total vouchers are displayed here. This includes all those transactions that have complete and correct KFC details, and also those transactions that you have included using the Include Voucher option.
Drill down from this line to view voucher type-wise break up of all the included vouchers. When you further drill down from any voucher type, the list of vouchers included is displayed.
In this Included Vouchers screen, you can select any voucher and press Alt+H (Exclude Vouchers) option to exclude it from KFC Computation.
Not relevant for this Report: The vouchers that have no KFC implication or are manually excluded from KFC computation by you are listed here.
Drill down from this line to view the voucher type-wise list of vouchers excluded. You will also find the categories Non-KFC Transactions and Excluded by User.
Under Non-KFC Transactions the transactions that do not have any KFC implications are listed voucher type wise. You will find the sales return transactions also under this list in case the option Consider Sales Returns for computation is disabled in F12 (Configure).
Under Excluded by User category, you can select a voucher and press Alt+H (Include Voucher) to include the selected voucher in the KFC computation.
Uncertain Transactions (Corrections needed): The number of vouchers that have KFC implication but are not included in the computation due to incomplete or incorrect KFC details are displayed here. These vouchers need updates to be included in KFC computation. All such vouchers are separated into different categories based on the type of incomplete or incorrect details. Drill down from this line to view the different categories and resolve the exceptions.
This is the section where the KFC computation is displayed for reporting period. The taxable value and KFC payable from all the vouchers included in the KFC computation is displayed here.
By default the net taxable value and tax amount is displayed under different categories. However, you can use the detailed mode to view the sub-categories with respective values.
You can get list of vouchers when you drill down from any line. From the Voucher Register, you can open an voucher in alteration mode using the drill down function. In case you make any changes to a voucher, the values are updated in real time in the computation.
The details of type of transaction captured in each category of KFC computation report is given below:
TallyPrime magic lies in the way it allows you to dig deeper to get more information. While the financial values displayed in the KFC computation report are for period selected, you can always drill down from any line to get voucher-wise break-up and continue to go down to voucher level.
The report along with providing a lot information with respect to KFC computation for the selected period, it also provides other options to change the report view and navigate.
F2 (Period): Use this option to change report period. You can generate the report from a single day to a financial period.
F3 (Company): You can open the KFC computation report of another company using this option. This option is active only when more than one company is opened.
Ctrl+B (Basis of Values): You can configure the values in your report for that instance, based on different business needs.
Similarly, you can mention Allow Tax Value Difference up to value. Set a value to ignore tax mismatch in the report up to the given value.
Ctrl+J (Exception Reports): You can view the exceptions related to the data displayed in the current report by pressing Ctrl+J(Exception Reports), without closing the report.
Alt+V (Open KFC Portal): You this option to open the KFC portal. Internet connection is required to open portal from this report.
Ctrl+A (View Accepted As Is)
: You can view the list of vouchers that have been manually included in the KFC computation without resolving the exceptions that existed in the vouchers. This will help you make any corrections in vouchers accepted to avoid any complications in the future.
F12
(Configure): The options to configure the computation report are provided here
Consider Sales Returns for computation
: Enable this option to include the values from sales return in computation. This means net sales values after deducting the sales return amount is displayed in the computation. This option is enabled by default. In order to show gross value of sale without deducting sales return amount disable this option. This option is enabled by default, if the Warn if Kerala Flood Cess is not applied? is enabled in Credit Note.
When you have vouchers that are not included in KFC computation due to incomplete or incorrect KFC details, a part your KFC transactions are not included. This will lead to incorrect KFC computation. TallyPrime does not only identify these transactions and categorise them based on the type of exception, but allows you to make the necessary corrections to include them in computation.
Drill down from the Uncertain Transactions (Corrections needed) line to view the exceptions grouped into different categories.
No. of vouchers with incomplete/mismatch in information: Drill down from this line to view the list of all vouchers with exceptions along with description of the exception. Select any voucher and press enter to view the Voucher Details Screen. In this screen you can provide the required details to resolve the exception. Once the exception is resolved, the voucher is included in the KFC computation. In case voucher has multiple exceptions, it will move to the next category of exception.
You can view exceptions arising out of incomplete or incorrect details in item masters by pressing F8 (Item-wise Exceptions). Also, use the F8 (Ledger-wise Exceptions) option to view only exceptions resulting from ledger with incomplete details.
Use the Alt+H (Exclude Vouchers) option to exclude any voucher from KFC computation. Such voucher will move to Excluded by Users bucket in the Not relevant for KFC Computation vouchers.
Country and state not specified: Drill down from this line to view the vouchers of dealers with no information of country and state details.
You can resolve the exception by recording the missing information in the respective columns and saving the changes.
You can exclude the voucher from KFC computation using the Alt+H (Exclude Vouchers)option.
Tax rate/tax type not specified: Drill down from this line to view the vouchers where tax type or rate of tax is missing.
You can resolve the exception by selecting the Nature of transaction to identify the tax type and by recording the tax rate.
You can exclude the voucher from KFC computation using the Alt+H (Exclude Vouchers)option.
Nature of transaction, Taxable value, rate of tax modified in voucher: Drill down from this line to view vouchers in which nature of transaction, assessable value or rate of tax defined in the ledger master was changed during recording of the transaction.
You can use the option Alt+R (Resolve) option and select required nature of transaction, enter taxable value and tax rate.
You can exclude the voucher from KFC computation using the Alt+H (Exclude Vouchers) option.
You can also include the voucher in KFC computation with the existing GST details using the Alt+J (Accept as is) option.
Vouchers having conflicting nature of transactions: Drill down from this line to view the vouchers that have two or more nature of transactions.
You can select an voucher and drill down to open the voucher alteration screen. Make the changes to ensure only one nature of transaction is applied in the voucher and save the voucher.
You can exclude the voucher from KFC computation using the Alt+H (Exclude Vouchers) option.
Mismatch due to tax amount modified in voucher: Drill down from this line to view the vouchers in which tax amount was modified during recording of the transaction.
You can use the option Alt+R (Resolve) option to enter tax amount.
Alt+W (Recompute): Use the recompute option to recalculate the tax amount and accept the same.
You can exclude the voucher from KFC computation using the Alt+H (Exclude Vouchers) option.
You can also include the voucher in KFC computation with the existing GST details using the Alt+J (Accept as is) option.
The KFC Computation report can be printed with or without the Computation Summary. To print only the particulars section and not the computation summary, disable the option Print Computation Summary using the Configure option.
The KFC Computation report printed without Computation Summary appears as shown below:
Update the detailed information about How To Use Exception Resolution In Tallyprime (Vat) on the Bellydancehcm.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!