Trending February 2024 # How To View Kfc Computation Report In Tallyprime # Suggested March 2024 # Top 11 Popular

You are reading the article How To View Kfc Computation Report In Tallyprime updated in February 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 March 2024 How To View Kfc Computation Report In Tallyprime

 PDF

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:

You're reading How To View Kfc Computation Report In Tallyprime

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.

How To View Cash Book And Bank Book In Tallyprime

 PDF

Businesses must keep a proper track of the cash as well as the bank transactions. The Cash Book is a record of the receipts and payments of cash within a financial year. It is a book of original as well as a ledger account. Similarly, the Bank Book is a record of all the receipts and payments made through the bank. This enables you to maintain daily record of your business transactions in a chronological order. You can view the Cash/Bank Book, daily breakup of ledgers, negative cash report and compare information using the Cash/Bank Book in TallyPrime. 

The Cash/Bank Book in TallyPrime is a two-in-one report that provides you with information involving the debit balance, credit balance, closing balance and so on. The cash/bank receipts are recorded on the debit side whereas payments on the credit side. The report summarizes all the cash and bank transactions and provides you with the status of your Cash and Bank accounts. 

You can configure varied features as per your The Cash/Bank Book can be exported, printed and viewed in your Browser. 

It is important for every business to manage the cash flow efficiently and determine the cash balance on a regular basis. With the Cash Book in TallyPrime, you can view all the receipts and payments of cash in one place. It helps you in keeping a track of all your business transactions that involve cash. 

The Cash/Bank Summary screen appears, displaying the Cash and Bank transactions of your company. 

. The cash balance might be negative on varied days.

If you have more than one bank account, select the required account and drill down to view the Ledger Monthly .

The Cash/Bank Book in TallyPrime gives you the flexibility of viewing the daily break up of your cash and bank transactions for the ledger. This enables you to keep a track of your daily business transactions and determine the fund flow in the company. TallyPrime provides you the flexibility of viewing the Highest and Lowest Balance recorded in a particular month. This information can be used to record the trend of highest or lowest balance. For instance, you can make decisions like scheduling the payments or purchasing items, based on the trend of days that recorded the Highest Balance. Similarly, you can check with your debtors to receive payments on days that record the Lowest Balance. 

In the Cash/Bank Summary screen, select the Cash ledger and drill down to the required month. 

If the balance is negative for a particular date, then the closing cash balance will appear in Red. 

This will enable you to take better financial decisions to maintain proper fund flow in your company. 

When your cash expenses are more than your income, the differential amount goes into the negative cash report. Let’s say you have a cash balance of Rs. 30000, and you have made a payment of Rs. 32000. Thus, you will have Rs. 2000 as a negative cash balance with you.

This report allows you to identify in which month the negative cash was generated. Additionally, you can view the day-wise report to determine precisely when or on which date the cash fell short. The report will show you the running balance of your business. 

provides all these features, which you to identify negative cash balances that need to be corrected and take measures to fix the data.

Open Cash/Bank Book.

Press F2 (Period) to change the period of Cash/Bank Book by entering the dates in From and To fields, if needed.

When the overall transaction is positive, the Closing Balance for that month appears in Black. In this case you can view the daily transactions and be able to identify the day that reflects Negative Balance in the Cash/Bank Book.

Now you can further drill down to view the transaction details and correct the data.

To view the Negative Ledger, 

Press F2 (Period) to change the period of Negative Ledgers by entering the dates in From and To fields, if needed.

Now you can further drill down to view the transaction details and correct the data.

Using these methods, you can access the negative cash report to identify the negative cash balances that need to be corrected and take necessary actions to fix data.

You can use the Cash/Bank Book as a powerful medium for comparison. You can compare Bank Book with Cash Book, or two or more banks in multiple columns. You can view the information for multiple periods (such as yearly, quarterly, monthly, and so on) on the same screen, instead of toggling between different periods or ledgers.

For example,

Press Alt+N (Auto Column) and select Quarterly from the list of options in the Auto Column field.

The Ledger Monthly Summary screen displays the Closing Balance of both the quarters side-by-side. You can know in which quarter the company performed better by comparing the data displayed on the screen. 

How To View List Of Users And Companies With User View In Tallyprime Server

 PDF

User View in TallyPrime Server displays the list of Users and companies they are working on. For each User, number of Currently Loaded Companies, number of time Reports have been Viewed, Printed Exported, and Edited will be displayed. The number of Entries (Transactions and Masters) Created, Altered and Deleted, and number of Imported Entries Created, Altered, and Deleted will be displayed if the option Show Entries is enabled.

The companies that are currently online will appear in blue, whereas the offline companies will appear in black.

To view the last activity details of one or more companies, select the required companies and press Shift+Enter.

Press F2 to change the period of the report.

Press Alt+N (Sort Next Column) to sort the User View report by the next column. To sort by the previous column, press Ctrl+P (Sort Prev. Column).

To sort the report in the descending order, press Alt+A (Descending). This option will toggle between ascending and descending order.

Press F3 (By Company) to move to the Company View. To toggle back to User View, use the same button.

To manage TallyPrime Server, press S (Manage Server). This will open the TallyPrime Server Information screen.

If multiple TallyPrime Servers are being used, then press Alt+C (Change Server) to change from one server to another.

Press F4 (Change User) to log in as a different user.

You can also perform operations like Export, Backup, Restore, Rewrite, and Disconnect Users.

Administrators can customise the look of the report based on the requirements.

Interval for auto refresh in minutes: You can set the interval for auto-refreshing the report. This time will be in minutes. By Default, it is set to 5 minutes. The minimum time that can be set is 0.1 minutes.

Either the Total value or the break-up of the operations can be viewed, by using Show Reports (Total), Show Entries (Total), Show Imported Entries (Total), and Show Breakup, which appears below each of these options.

Sorting By: The Company Name can be sorted either in ascending or descending order. The ascending order is selected.

Configuration Path: By default, this will show the application folder path.

Export File Location: The default path for exporting files can be set in this field. By default, the Configuration Path is set as the export file location

TallyPrime Server Alerts using beeps: When this option is set to Yes, TallyPrime Server will beep for any exception messages

You can drill down from the following fields:

User Name

Reports Viewed/Printed/Exported/Edited

Entries Created/Altered/Deleted

Import Entries Created/Altered/Deleted

This report gives the details of all the Companies opened by a particular user. For each Company, number of times Reports have been Viewed, Printed, Exported, and Edited will be displayed. The number of Entries

(Transactions and Masters) Created, Altered and Deleted, and number of Imported Entries Created, Altered, and Deleted will be displayed if the option Show Entries is enabled.

Even in this report, the Administrator can drill down from Reports Viewed/Printed/Exported/Edited, Entries Created/Altered/Deleted, and Import Entries Created/Altered/Deleted.

The names of the reports which are being accessed by the user will be displayed. Against each report name, the number of companies in which the report is being accessed, Number of times the report has been accessed (including Company-wise break up), and the Time spent in the report (in Seconds) will be displayed.

When you drill down from Entries Created/Altered/Deleted for a Company, the following report will appear:

This report gives the details of Transactions and Masters Created, Altered and Deleted. A user-wise breakup of the number of Transactions and Masters created, altered, and deleted can be viewed in this report.

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

Update the detailed information about How To View Kfc Computation Report 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!