Trending March 2024 # How To Use Edit Log In Tallyprime # Suggested April 2024 # Top 9 Popular

You are reading the article How To Use Edit Log In Tallyprime updated in March 2024 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 April 2024 How To Use Edit Log In Tallyprime

 PDF

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).

You're reading How To Use Edit Log In Tallyprime

How To Use Exception Resolution In Tallyprime (Vat)

 PDF

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.

How To Import Data In Tallyprime

 PDF

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-2024) 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 Edit Pdf Files In Microsoft Word

Portable Document Format (PDF) is a common format for sharing final versions of files. The format is most used for viewing and not editing. But if you need to edit PDF files, Microsoft Word 2023/2024/2013 brings a multitude of features to the word-processing table, one being the capability to edit PDFs.

Office 2010 provided the option to save a document as PDF, but Microsoft Word 2013 even allows editing of the content before sending it to the final recipient, as a PDF file. Although the full version of Adobe Acrobat allows users to modify PDFs, it’s more cumbersome than editing the original document in MS Office. Why so? PDF is technically an image file, converting this image file back to text needs sophisticated OCR like Adobe Acrobat X Pro or other tools. Adobe Free Reader, therefore, does not allow you to modify the content in a PDF. With Word 2013, however, you can convert a PDF into a Word document and edit the content.

In this post, we will see how to edit PDF files in Word.

Edit PDF Files in Word

When you install Office, you will notice that the context menu for any PDF file, has an option to open a PDF file in Microsoft Word, along with your other PDF Readers like Adobe Reader or Foxit and Windows Reader, if you are on Windows 10/8.

Microsoft PDF Reflow will convert all the files contents, including its formatting like paragraphs, lists, headers, columns, footnotes, tables, etc, into Word content. You will be able to edit even the tables. I tried with various smaller PDF documents and it kept all its formatting, even after the conversion. Then I also tried bigger-sized PDF’s like e-books (sized ~30MB). It took a bit of time to convert – but it did its job. So, you can try large files too if you have some newer systems with more memory.

Anyway, next, a dialog box with a message “Word will convert your PDF to an editable Word document. The resulting Word document will be optimized to allow you to edit the text, so it might not look exactly like the original PDF, especially if the original file contained lots of graphics.” should appear on your computer screen.

To maintain your changes, it is essential you save the document with a new name or to a different location.

So, if you get a pop bearing the same message do not be surprised. Try saving the PDF with a different name or save the file in Word or PDF format.

Depending on the situation, one option may work better than the other:

PDF: If you don’t want to make any more changes to the document, save the edited document as a PDF file.

Word document: If you want to continue making changes to the document (or if you need a second pair of eyes for approving the changes), save it as a Word document. You can always save it as a PDF file later on.

This is a great feature in Microsoft Word, among many other cool features of Microsoft Office.

Hope you find this tutorial useful.

TIP: You can convert, compress, sign PDF documents using free Acrobat Online tools.

How To Generate Tds Reports In Tallyprime

 PDF

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

 PDF

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.

Update the detailed information about How To Use Edit Log In Tallyprime 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!