Tally Notes

Accounting Policies

2013-09-28T20:29:00.001-07:00

DISCLOSURE OF ACCOUNTING POLICY

Accounting policies are the specific accounting principles and the methods of applying those principles adopted by an enterprise in the preparation and presentation of financial statements.

- All significant accounting policies should be disclosed.

- Such disclosure form part of financial statements.

- All disclosures should be made at one place.

- Specific disclosure for the adoption of fundamental accounting assumptions is not required.

- Disclosure of accounting policies cannot remedy a wrong or inappropriate treatment of the item in the accounts.

Any change in accounting policies which has a material effect in the current period or which is reasonably expected to have material effect in later periods should be disclosed.

In the case of a change in accounting policies, which has a material effect in the current period, the amount by which any item in the financial statements is affected by such change should also be disclosed to the extent ascertainable. Where such amount is not ascertainable, the fact should be indicated.

Fundamental Accounting Assumption: (GCA) :

1] Going Concern

2] Consistency

3] Accrual

Major considerations governing the selection of accounting policies:

1] Prudence

2] Substance over form (Logic over Law)

3] Materiality

The following are examples of the areas in which different accounting policies may be adopted by different enterprises:

- Methods of depreciation

- Methods of translation of foreign currency

- Valuation of inventories

- Valuation of investments

- Treatment of retirement benefits

- Treatment of contingent liabilities etc.

F11: Audit Features

2013-08-03T21:21:00.001-07:00

The Auditor needs to set the following Tax Audit Rules and Payment Due dates for various clauses:

Tax Audit Rules for Amounts inadmissible u/s 40A (3) - (Clause 17(h)
Statutory Payment Due Dates for Value Added Tax and Central Sales Tax
Statutory Payment Due Dates for Service Tax
Statutory Payment Due Dates for Tax Collected at Source
Statutory Payment Due Dates for Provident Fund, ESI and Professional Tax

Tax Audit Rules for Amounts inadmissible u/s 40A (3) - (Clause 17(h)

To set the Tax Audit Rules for Amounts inadmissible u/s 40A (3) (Clause 17(h))(Cash Payments),

Go to Gateway of Tally > Audit & Compliance > 44AB Audit

Click on F11: Features or Press F11

Under Inadmissible Cash Payments U/s 40A (3),

Show Aggregate for the Day : This option should be set to Yes if the Auditor wants to view the Payment Vouchers with Aggregate amount more than specified in Show Aggregate Amounting More than field
Show the Aggregate Amounting more than :
When Show Aggregate for the Day is set to Yes, this will display only those Payment Vouchers belonging to a Ledger, which exceeds the aggregate amount as entered in this field for a day.
When Show Aggregate for the Day is set to No, this will display only those Payment Vouchers belonging to a Ledger, which exceeds the aggregate amount entered in this field for the Period.
Ignore Vouchers having Amount less than : Enter the required amount in this field. The Payments Vouchers having the amount less than entered in this field will be ignored while displaying the Cash Payments report.

Press Enter to Accept and save the changes.

Statutory Audit

To enable Audit Working Paper, tab down to Audit Documentation section

Set the option Enable Audit Working Paper to Yes

Set the option Enable Audit Working Paper? to Yes. On enabling the option Enable Audit Working Paper, a menu option Audit Working Paper will be displayed in Audit Documentation Menu.
Set the option Enable Audit Priorities and Categories? to Yes to assign priorities and categories while seeking clarification from users of the company in Tally.ERP 9.

Statutory Payment Due Dates for Value Added Tax and Central Sales Tax

To specify the Due Dates for Value Added Tax and Central Sales Tax,

Tab down to Value Added Tax & Central Sales Tax section
Enter No. of Days within which the payment is to be made against the Value Added Tax field and Months payment cycle from Period drop down
Similarly enter the No. of Days within which the payment is to be made against the Central Sales Tax field and Months payment cycle from Period drop down

Note: The system will check the Challan date with the date entered in the F11: Audit Features screen and display the status as:

On Time: When Payment is made on or before the due date.

Late: When the Payment is made past the due date.

Late (Partially): When atleast one payment is made past the due date.

Due / Late (Partially): When one payment is made past the due date and another payment is due.

Due (Partially): When at least one payment is not made and other payments are made on time.

Due: When the Payment is not made past the due date.

Statutory Payment Due Dates for Service Tax

To enter the due date for Service Tax Payments,

Tab down to Service Tax section
Enter No. of Days within which the payment is to be made against the Payment Period field

Note: The system will check the Challan date with the date entered in the F11: Audit Features screen and display the status as:

On Time: When Payment is made on or before the due date.

Late: When the Payment is made past the due date.

Late (Partially): When atleast one payment is made past the due date.

Due / Late (Partially): When one payment is made past the due date and another payment is due.

Due (Partially): When atleast one payment is not made and other payments are made on time.

Due: When the Payment is not made past the due date.

Statutory Payment Due Dates for Tax Collected at Source

To enter the Due date for TCS Payments,

Tab down to Tax Deducted at Source & Tax Collected at Source section
Enter No. of Days within which the payment is to be made against the Tax Collected at Source field. By default 7 is prefilled.

Note: The system will check the Challan date with the date entered in the F11: Audit Features screen and display the status as:

On Time: When Payment is made on or before the due date.

Late: When the Payment is made past the due date.

Late (Partially): When atleast one payment is made past the due date.

Due / Late (Partially): When one payment is made past the due date and another payment is due.

Due (Partially): When atleast one payment is not made and other payments are made on time.

Due: When the Payment is not made past the due date.

Statutory Payment Due Dates for Provident Fund, ESI and Professional Tax

To enter the Due dates for Payroll related Payments,

Tab down to Payroll section
For Provident Fund payments, enter No. of Days within which the payment is to be made against the Provident Fund field.
For ESI, payments, enter No. of Days within which the payment is to be made against the Employee State Insurance field.
For Professional Tax payments, enter No. of Days within which the payment is to be made against the Professional Tax field.

Note: The system will check the Challan date with the date entered in the F11: Audit Features screen and display the status as:

On Time: When Payment is made on or before the due date.

Late: When the Payment is made past the due date.

Late (Partially): When atleast one payment is made past the due date.

Due / Late (Partially): When one payment is made past the due date and another payment is due.

Due (Partially): When atleast one payment is not made and other payments are made on time.

Due: When the Payment is not made past the due date.

Computer Accessories

2013-08-03T21:16:00.001-07:00

Tax Audit Dashboard

2013-08-03T21:08:00.001-07:00

To view the Tax Audit Dashboard,

Go to Gateway of Tally > Audit & Compliance > 44AB Audit

The Tax Audit dashboard screen shows total number of Vouchers available for Audit, which are checked by the user, which need clarification from the Audit team or client, those to be re-audited and Audit Complete information for each Clause.

Clause No.: Displays the Clause number as it appears in Form 3CD.
Audit Type: Provides brief description on the respective Clause.
Total: Displays the total number of vouchers for each clause.

Audited: Displays the total number of Audited Vouchers for each clause.
Internal Observation: Displays the total number of Vouchers marked as Internal Observation for each Clause. Internal Observation column is divided into Pending and Clarified.
Pending: Pending column displays all those vouchers marked as Internal Observation under each clause and those not clarified.
Clarified: Clarified column displays all the vouchers clarified which are marked for Internal Observation for each clause.

External Clarification: Displays the total number of Vouchers marked for Clarification from the Client.
Pending: Pending column shows the total number of Vouchers that are pending for Clarification from the Client.
Clarified: Clarified column shows all those vouchers that are clarified from the client's side.
Altered (To be re-audited): Displays the total number of Vouchers that are Altered by the Client post Audit. The Auditor can highlight the respective column to view the Re-Audit Summary for the respective Clauses.
Audit Complete?: Displays the Audit completion status for each Clause as entered by the Auditor using the F9: Save Audit button.

Note: If the Client alters any Audited Vouchers after the Audit Complete is set to Yes. The Audit Complete status will automatically change to blank for the respective Clause.

Button options in the Tax Audit Dashboard screen

F2: Period

To change the financial year selected, click on F2: Period or press F2 key.

F9: Save Audit

To save the Audit Status for the required Clause, click on F9: Save Audit or press Alt+F9 key to mark the Audit Complete status to Yes. The same will appear in the Audit Complete Column.

Note: The Clause for which the Audit Status needs to be saved, should be selected first by using Space Bar key.

C: Clarification List

To view all the Vouchers which are marked for Client's Clarification (with Audit Status as External Clarification) and the Vouchers which are Clarified (Audit Status as Clarified) by the Client in a single report,

Click on C: Clarification List or press Alt+C keys

The Clarification List report displays all the External Clarification and Clarified Vouchers in a single screen for Auditors' reference.

F10: Audit Reports

Click on F10: Audit Reports or press Alt+F10 keys to navigate to Audit & Analysis (Statutory Audit) Reports.

F12: Configure

To view the Last Audit Details, click on F12: Configure or press F12 key.

Set option Show Last Audit Details to Yes

The Tax Audit Dashboard displaying the Last Audit Details will appear as shown:

The above screen displays the Last Audit details for each Clause.

Last audited By: Displays the User name (login name) of the Auditor who performed the last Audit
Date & Time: Displays the date and time for the last Audit
Date of Last audited voucher: Displays the Voucher Creation date of the Voucher that was audited last.

Tax Audit in Tally.ERP 9

2013-08-03T21:04:00.001-07:00

The Tax Audit feature in Tally.ERP 9 enables the user to compile information in comparatively less time with the required accuracy to form the right opinion. From the vast data available, the required information that needs to be reported can be identified and extracted precisely.

While conducting Tax Audit in Tally.ERP 9, the Auditor and other users can examine, review, analyse the books of accounts and other records with a view to compile information and data required to be reported in Form 3CD, and thereupon express an opinion wherever required.

In Tally.ERP 9, the following clauses are available as Annexures with respect to Form 3CD:

Bonus, PF, ESI Recoveries (Clause 16)
Amounts debited to P&L a/c (Clause 17)
Payments to Specified Persons (Clause 18)
Payments u/s 43B (Clause 21)
Employer’s Contribution
Tax Collected at Source
Service Tax
Value Added Tax
Loans / Deposits Accepted (Clause 24(a))
Loans / Deposits Repaid (Clause 24(b))
Tax Deducted at Source (Clause 27)

Apart from these Annexures to Form 3CD, a separate section - Verification of Vouchers is provided in Tax Audit Dashboard that covers Clauses not covered in the list specified above.

Printing Form 3CD

2013-08-03T20:58:00.002-07:00

To Print the Form 3CD from Tally.ERP 9,

Go to Gateway of Tally > Audit & Compliance > Form 3CD

Press Alt+P or click on P: Print
In the Print screen of Form 3CD,

Set the option Print Form 3CD to Yes, to print Form 3CD
Set the option Print with Signatures to Yes, to print the Form 3CD with signatures.
Set the option Print along with Annexures to Yes, to print all the Annexures along with Form 3CD
Specify the Auditor's CA Firm Name in the Firm Name field
Specify the Firm Registration Number in the FRN field
Specify the Auditor's name in the Name of Chartered Accountant field
In the Salutation filed specify Auditor's salutation
Specify the membership number of Auditor in the MRN No field
Specify the address of CA Firm in the Address field
Specify the city name in the Place field
In Date field enter the date of generating the Form 3CD
Specify the Company signatory details on the right side if required

Note: The empty fields in the Print Configuration screen will not be printed in the Form 3CD.

Press Enter to print Form 3CD and Annexures.

The printed Form 3CD Annexure I appears

Filling Form 3CD

2013-08-03T20:53:00.002-07:00

The Auditor can enter the required information for the Clauses not available in Tally.ERP 9 in Form 3CD and save the details. This information will be saved against the respective Clauses and will be available for future references.

To enter the Required information in Form 3CD,

Go to Gateway of Tally > Audit & Compliance > Form 3CD

The Form 3CD screen appears as shown below:

The Form 3CD screen is divided into four columns.

Clause No. : Displays the Clause numbers as stated under the Income Tax Act, 1961.
Particulars: Displays brief description of Clauses.
Applicability: Option to mark a clause as Applicable or Not Applicable.
Additional Details: Details regarding Annexures or any reports to be attached.

The Auditor can press Enter on the respective clause, specify the required information and save it.

Clause Applicability Details:

A Clause may be relevant or irrelevant to the companies policies and nature of business. If a particular clause is applicable or not applicable to a business, a provision to update the applicability status is provided in Form 3CD screen.

To mark a clause as Applicable or Not Applicable:

Press Spacebar to select the clause.
Press F5 or click on the button F5:Update.

A Clause Applicability Details screen appears.

Select the required status from the list.
If, Not Applicable is selected, provide Remarks, if any.

Press Enter to save the details.

On saving the details, the respective clause will appear with the status selected as shown below:

Note: If a Clause mentioned under 44AB of the Income Tax Act, 1961 is marked as Not Applicable in the Form 3CD screen, then the respective clause will not appear in the Tax Audit Dashboard under 44AB.

In the above screen, Clause 17 (a-m) is marked as Not Applicable.

Therefore, the same Clause 17 (a-m) will not appear in 44AB Tax Audit screen as shown below:

Filling Clause No. 1-6

To enter the information required for Clause No. 1-6,

Highlight the Clause No. 1-6 in the Form 3CD screen and press Enter.
In the Particulars of Assessee screen,

Enter the Company Name in the Name of Assessee field.
Enter the Company address in the Address field.
Enter the Company PAN number in the Permanent Account Number field.
Enter the type of organisation (Company, Individual, firm etc) in the Status field.
Enter the last date for previous financial year (e.g. 31-March-2012) in the field Previous Year Ended field
Enter the details of Tax Audit Assessment Year (2012-2013)details in the Clause No. 6

Note: The details for Clause No. 1, 2, 3, 5 and 6 are pre-filled with the information provided in the Company Masters.

If the Auditor alters the default information for these Clauses in this screen, then the same will be stored against these clauses in Form 3CD for future reference. This will not overwrite the Company Master details.

Press Enter to save the details.

Filling Clause No. 7 (a & b)

To enter the information required for Clause No. 7 (a & b),

Highlight the Clause No. 7 (a & b) in the Form 3CD screen and press Enter
In the Particulars of Members/Partners screen,

Specify the required details for Clause No. 7 (a) in the text field provided

Tally.ERP 9 provides the facility of using the pre-defined text templates to fill the repetitive information viz, Not Applicable, Nil etc.

To use the default text templates available in Tally.ERP 9,

Press Alt+T or click on T: Select Text button

A list of text templates appears. The Auditor can select the predefined text or provide User Defined text as required.

For example:

Select As per Annexure from the text templates.
The text As per Annexure gets filled in the Clause as shown below:

Similarly, fill in details for Clause 7 (b).

Press Enter to save the details

Likewise, an Auditor can enter all the relevant details for each Clause as per the process explained.

Provision of User Defined Text templates:

Tally.ERP 9 provides the Auditor an option to provide User Defined Text Templates.

To add an User Defined Text

Select Add User Defined Text from the list of text templates by pressing Alt+T or clicking on the button T: Select Text in the respective clause.
Specify the text in Add User Defined Text sub-screen as shown below:

Press Enter to save.

The user defined text added will now appear in the list of text templates.

To Remove User Defined Text

Select Remove User Defined Text from the list of texts by pressing Alt+T or clicking on the button T: Select Text in the respective clause..

On selection, a Remove User Defined Text sub-screen appears with the list of User Defined Texts mentioned earlier.

Select the User Defined Text created earlier to remove. For example: In the above screen, the user defined text already created is Not applicable as per the Company Policies.

Filling Annexure I

To enter the information required for Annexure I,

Highlight the Annexure I in the Form 3CD screen and press Enter
In the Particulars of Annexure -I screen, enter the required details as shown:

Press Enter to save the details entered in Annexure I.

Button Options in Form 3CD screen

F1 : Detailed

Press Alt+F1 or F1 : Detailed button to view detailed Form 3CD.

Ctrl+O: Copy From

To copy the data from Form 3CD of a different Company (or same Company for previous year), the Auditor can use Copy From button available in the Form 3CD screen.

Tally.ERP 9 provides the option to copy the information for all the Clauses or selective Clauses from one Company to another.

Note: The Form 3CD information can be copied from the previous Company in the same data or in a different data folder.

Copying entire Form 3CD

To Copy the entire Form 3CD from one Company to another, follow the steps give below:

Ensure that both the Companies are loaded in Tally.ERP 9 and the Company in which the information has to be copied should be the Active Company.

Go to Gateway of Tally > Audit & Compliance > Form 3CD

Press Ctrl+O or click on Ctrl+O: Copy From button
In the Data Configuration screen,

In the Copy From Company field select the Company in which filled Form 3CD is available

In the Copy from Financial Year select the year for which filled Form 3CD is available

Press Enter to Copy and save the details of Form 3CD

Copying individual Clauses in Form 3CD

To Copy the information Clause by Clause from one Company to another, follow the steps give below:

Ensure that both the Companies are loaded in Tally.ERP 9 and the Company in which the information has to be copied should be the Active Company.

Go to Gateway of Tally > Audit & Compliance > Form 3CD

Highlight the Clause for which the information needs to be copied and press Enter (e.g. Clause 11 (a-d) and press Enter

Press Alt+R or click on R: Copy From button.
In the Data Configuration screen,

In the Copy From Company field select the Company in which filled Form 3CD is available.
In the Copy From Financial Year select the year for which filled Form 3CD is available.

Press Enter to Copy and save details for the selected Clause

Similarly, the user can copy all the Clauses one by one.

X: 44AB Audit

While filling Form 3CD, an option X: 44AB is provided. On pressing Alt+X or clicking on X: 44AB, the list of vouchers audited under this clause will be listed or the 44AB Audit screen pertaining to this clause will appear.

Note: However, this button appears only if the pertaining Statutory feature is enabled and is covered under 44AB Audit of Tally.ERP 9.

A: Annexure

If a particular clause in Form 3CD has Annexures, then the same can be viewed by clicking on A: Annexure or pressing Alt+A.

The list of Annexures appear as shown below:

Press Enter to view the Annexure.

The Annexures can be printed from here.

If statutory features are disabled in Tally.ERP 9, then instead of Annexures, A: Report is provided. Click on A: Report or press Alt+A to view the list of Vouchers audited under the clause.

C: View Clause Ref

Clause References are the information or notes provided for a voucher or at the company level. This will act as a reference in future while filling Form 3CD. This will help an auditor in better decision making. While filling Form 3CD, the user can view the Clause references provided at the Company level and voucher level.

To view Clause references from Form 3CD,

Click on C: View Clause Ref or press Alt+C

A Clause Reference Details screen appears. The Clause Reference details screen contains Clause references specified both at the company level and the voucher level.

Company Note:

Clause References provided at the company level, i.e. those mentioned against a clause by selecting Company, appear in Company Notes.

Notes: The Clause Reference mentioned against a specific clause is displayed here.
Note By: The name of the user who has added the note is shown here.

Voucher Note:

Clause References provided for a specific voucher against a particular clause is shown here.

Date: The date on which the clause reference is provided is displayed here
Particulars: The ledger against which the clause reference is given is shown here
Voucher No.: The Voucher no. containing the ledger for which the clause reference is provided is given here
Note By: The name of the user who has added the note is shown here.
Note: The clause reference provided is shown in this column.

Button Options in Clause Reference Details screen

D: Delete

The Clause Reference provided can be deleted.

To delete,

Press Spacebar to select the clause reference
Press Alt+D key or click on D: Delete button
Press Enter to delete the clause reference.

F12: Configure

Press F12 or click on F12: Configure to change the default display.

Show Clause Reference of: The Clause Reference details screen can be filtered on the basis of notes specified for Company or Vouchers or both as shown below:

Show Date and Time: To display the date and time of the clause reference given, set this option to Yes.
Sorting Method: The Clause reference details screen can be sorted on the basis of Date and Time (Increasing or Decreasing) or Audit/Note by (Increasing or Decreasing)

Note: Show Date and Time, Sorting Method options will appear in Configurations only if Company or Voucher is selected in Show Clause Reference of field.

Show Transaction Value: Set this option to Yes to view the value of the transaction against which clause reference is stated.

Note: This option will be available only if Vouchers is selected in Show Clause Reference of.

Tax Audit in Tally.ERP 9

2013-08-03T20:47:00.002-07:00

Tax Audit process helps in ensuring that the books of accounts and other records reflect the true income of the assessee and is maintained in accordance with the provisions of the Income Tax Act, 1961.

The key features of Tax Audit tool in Tally.ERP 9 comprises of:

Printing of Form 3CD with Annexure I
Generate Annexures to Form 3CD
Printing of Form 3CA and Form 3CB
Extracting financial and quantitative information required for Tax Audit (under Sec. 44AB)
Displaying relevant data for Audit based on Clause requirement
Instant Statistics on Audit Listings (Audited Vouchers & Unaudited Vouchers)
Facility to record Audit Remarks using Audit Note
Provision to mark Vouchers for Internal Observation within the Audit Team
Provision to mark Vouchers for Verification from Clients
Facility to post corrections and reviews remotely
Tracking any alteration / modification to vouchers post Audit
Availability of ready references - Clause Reference while filling Form 3CD
Provision for Clause References at the Company or Voucher Level

Form 3CD

Tally.ERP 9 provides the facility of printing Form 3CD with the required Annexures to file the Tax Audit returns under section 44AB.
Form 3CD
Annexure I

To complete Form 3CD refer to Filling Form 3CD section.

To print Form 3CD refer to Printing Form 3CD section.

The additional Forms i.e. Form 3CA and Form 3CB can also be printed from Tally.ERP 9.

Annexures to Clause 16, 17(a-m), 18, 21, 24(a), 24(b) can be generated as explained in Printing Tax Audit Annexures section

Auditor/Firm Profile in Control Centre

2013-08-03T20:41:00.001-07:00

Chartered Accountants who are registered as BAP users of Tally.ERP 9 can now create and maintain their profile as well as the firm's profile in the Control Centre. The details provided here will be automatically captured in reports that require them, like Form 3CD.

To create auditor/firm profile,

In the Control Centre screen that appears, click on Ctrl+K: Control Centre or press Ctrl+K and log in with the Tally.NET Auditor ID

Click on Account Profile Management or press Alt+Y

The Profile Management screen appears:

Fill in the relevant details for Account ID, Firm Number, Account Nature, Name of the Firm, Account Type, Address, etc.
Under Partner Detail(s), fill in details of partners of the Firm.
Under Contact Person(s), fill in the details for the contact persons for the firm

Press Enter or Y to Accept (save) the profile details.

Audit Remotely (Anywhere)

2013-08-03T20:37:00.003-07:00

To use Audit & Compliance features remotely from anywhere, the Auditor should get authenticated on Tally.NET to obtain the Auditors’ Edition License.

The Client should authorise the Auditor to perform Audit remotely for the given company. For information on Authorisation process, refer to Authorising Tally.NET Auditors section. Or else, the main auditor should have delegated the authorised Company to the article.

To obtain Auditors’ Edition License and perform Audit remotely,

Start Tally.ERP 9
Press Alt+F1 to Shut any company that is running
Press Login as Remote User

Enter the BAP user name and Password in the Name of User and Password fields respectively

Select Remote Company screen appears displaying the Companies connected to Tally.NET for different Clients which are available for Remote Audit.

Press Enter to start the Company remotely

Press on Audit & Compliance menu
Press Enter on either Tax Audit, Statutory Audit or Statutory Compliance to use the required tool remotely.

Note: The Remote Auditing will work even in Educational version of Tally.ERP 9

Audit at Client's Office with Local Data

2013-08-03T20:31:00.001-07:00

To use the Audit & Compliance features at Client’s place, the Auditor should get authenticated on Tally.NET to obtain the Auditors’ Edition License.

The Client should authorise the Auditor to perform Audit for the relevant company. For information on Authorisation process which Client needs to follow, refer to Authorising Tally.NET Auditors. Or else, the main auditor should have delegated the authorised Company to the article.

To obtain Auditors’ Edition License and perform Audit or Compliance from Client’s place,

Go to Gateway of Tally > Click on F3: Company Info or press Alt+F3 > Select Company

Go to Gateway of Tally > Press F1

Select the company to be audited from the List of Companies

Press Enter to display the Company Login screen
Provide the BAP Username (or sub-user) and Password in the Company Login screen

Press Enter to Load the Company

Once the Company is loaded, you will be able to view the Audit & Compliance menu in the Client’s Tally.ERP 9 itself and start using the same.

Press on Audit & Compliance

Press Enter on the required menu to use the required tool at Client's place.
Tax Audit
- Form 3CD
- 44AB Audit
- Form 3CA
- Form 3CB
Statutory Audit
- Audit Documentation
- Audit & Analysis
- Audit Journals
- Financial Statements

Audit Tools of Tally.ERP 9

2013-08-03T20:25:00.000-07:00

Tally.ERP 9 offers Audit Tools, which provide various Audit and Compliance capabilities for Auditors and other Users. Audit Tools comes with the following tools for Users:

Tax Audit
Statutory Audit

AuditReady

Now you can not only maintain financial data on Tally.ERP 9, you can also make it ready for audit - AuditReady!

Tally.ERP 9 offers auditing tools which will help you ensure that your books of accounts are maintained as per statutory requirements:

Compare your business' previous year and current year data to ensure that the information you provide to your auditor is error-free
Spot and rectify data entry errors with ease
Obtain reports on receivables and payables with just a few clicks
Schedule VI Financial Statements (Balance Sheet and Profit & Loss Account) have been provided, and you don't have to switch between applications to ensure your financial reports are complete
Generate Forms to be filed with the Income Tax Department – Form 3CD, Form 3CA, and Form 3CB

AuditReady is a complete package which enables you to perform internal checks, and ensure a simplified audit cycle for your business.

Account-based capturing of Audit Details

Tally.ERP 9 Audit Tools are now available for Non-BAP customers (users who are not registered as BAP users of Tally.ERP 9) too, which means they can prepare their financial data before it is used for auditing.

With Audit Tools, users can perform internal scrutiny on their data, and audit the data with their own teams within the organisation, before the same is presented to auditors.

This way, the amount of checks to be done by the organisation's internal/external auditors is reduced, and the entire auditing process is simplified.

The audit details recorded by users while scrutinising their data will be captured and stored for their respective Account IDs. Likewise, audit details recorded by CAs who are registered as BAP Users will be captured and stored for their respective BAP Account IDs. Audit Details recorded by the customer and the BAP user will therefore, be stored separately.

Illustration 1: One customer (Non-BAP User) and one CA (BAP user)

Mr. A, a non-BAP user, uses Tally.ERP 9's Audit Tools to prepare his data which is to be audited his CA, Mr. B
Mr. A logs in with his Account ID, audits his data, and records Audit Note for a Payment Voucher.
Mr. B logs in with his BAP Account ID and audits the data provided to him by Mr. A, and records an Audit Note for the same Payment Voucher.

Here, Mr. A will be able to view the Audit Note he has recorded, but not the Audit Note Mr. B, his Auditor has recorded. Similarly, Mr. B will not be able to view the Audit Note recorded by Mr. A.

Illustration 2: One customer (Non-BAP User) and two CAs (BAP users)

If, in the above scenario, two CAs, Mr. B and Mr. C, having BAP Account IDs are involved in auditing Mr. A's data,

Mr. A logs in with his Account ID, audits his data, and records Audit Note for a Payment Voucher
Mr. B logs in with his BAP Account ID and audits the data provided to him by Mr. A, and records an Audit Note for the same Payment Voucher
Mr. C, the other Auditor, logs in with his BAP Account ID and records an Audit Note for the Voucher.

Here, Mr. A will be able to view the Audit Note he has recorded, but not the Audit Note Mr. B or Mr. C, his Auditors have recorded. Similarly, Mr. B and Mr. C will not be able to view the Audit Note recorded by Mr. A.

Illustration 3: One customer (Non-BAP User), two BAP users, and one article (BAP user)

If, in the above scenario, two CAs, Mr. B and Mr. C, having BAP Account IDs are involved in auditing Mr. A's data, and Mr. D, an article who is a part of the audit teams of both Mr. A and Mr. B,

Mr. A logs in with his Account ID, audits his data, and records Audit Note for a Payment Voucher
Mr. B logs in with his BAP Account ID and audits the data provided to him by Mr. A, and records an Audit Note for the same Payment Voucher
Mr. C, the other Auditor, logs in with his BAP Account ID and records an Audit Note for the Voucher.
When Mr. D logs in with his BAP Account ID,

The Account IDs of both Mr. B and Mr. C will be in the List of Accounts for selection:

If Mr. D selects Mr. B's Account, he will be able to view the Audit Details recorded by Mr. B, and not the Audit Details recorded by Mr. A or Mr. C.
If Mr. D selects Mr. C's Account, he will be able to view the Audit Details recorded by Mr. C, and not the Audit Details recorded by Mr. A or Mr. B.

Audit & Compliance Scenarios

Chartered Accountants can use Tax Audit, Statutory Audit and Statutory Compliance tools to Audit the Client's data in one of the following scenarios:
- At CA’s office with Local Data (using Auditors’ Edition and local data)
- At Client’s Place with Local Data (by Remotely getting Auditors’ Edition License)
- From Any where (Access data and Auditors’ Edition License Remotely)
Note: Tax Audit, Statutory Audit & Statutory Compliance are default features available with Auditors’ Edition of Tally.ERP 9.

Audit at CA’s Office with Local Data

The Auditors’ Edition includes Tax Audit, Statutory Audit and Statutory Compliance capabilities as default features without any dependency on Tally.NET subscription for authentication to perform Audit or Compliance services on Local data. The Auditor can open Auditors’ Edition of Tally.ERP 9 and access his client's data available locally and start Audit using Audit & Compliance features.

To use Audit & Compliance features locally,

Go to Gateway of Tally > Click on F3: Company Info or press Alt+F3 > Select Company

Or

Go to Gateway of Tally > Press F1
- Select the company to be audited from the List of Companies
- Press Enter to load the selected company
- Enter the Client’s Username and Password
Note: If the Client’s Company is not Password protected, then you need to enable the security features by going to Company Alteration screen as the Audit & Compliance Features will be available only when Company is password protected.
- Press Enter to Load the Company
The Gateway of Tally screen with the Audit & Compliance options appears:
- Press Enter on Audit & Compliance menu
- Press Enter on the required menu:
- Tax Audit
  - Form 3CD
  - 44AB Audit
  - Form 3CA
  - Form 3CB
- Statutory Audit
  - Audit Documentation
  - Audit & Analysis
  - Audit Journals
  - Financial Statements

TDS (Tax Deducted at Source) - Tally.ERP 9

2013-02-22T21:27:00.000-08:00

Introduction

TDS refers to Tax Deducted at Source. The concept of TDS was introduced in the Income Tax Act, 1961, with the objective of deducting tax on income, from the source of the income. It is one of the methods of collecting Income Tax, which ensures a regular flow of income to the Government.

Example: Universal InfoTech is making the payment towards Rent to the owner of the building. TDS is supposed to be deducted by Universal InfoTech from the rent that is to be given to the owner. If the rent amount is Rs.10,000/- & the TDS amount is Rs.1,000/-, Universal InfoTech deducts Rs.1,000/- and pays the owner Rs.9,000/-

TDS Certificate

TDS certificate is a proof that deductor has deducted the tax and paid the same to the government. This proof is essential to the deductee to claim the credit of tax in his Income Tax returns.

U/s 203 of Income Tax Act, any person deducting the tax as per the provisions of:

Section 192 (Salary) shall furnish a certificate of Deduction of tax in Form 16 or Form 16AA within one month from the close of Financial year in which such deduction was made.

Example: For the Financial Year 2007-2008, the TDS certificate must be issued on or before 30th April, 2008

Section 193, 194, 194A, 194B, 194BB, 194C, 194D, 194E, 194EE, 194F, 194G, 194-I, 194J, 194K, 194LA, 195, 196A, 196B, 196C and 196D shall furnish a certificate of Deduction of tax in Form 16A with one month from the end of the month during which the credit has been given or the payment has been made, as the case may be.

In case of a deductee to whom more than one TDS certificate was issued for the deductions made during the year, may on request from such deductee, a consolidated certificate in Form 16A may be issued within a period of one month from the close of such financial year.

e-TDS Returns

The Income Tax department has now notified ‘Electronic Filing of Returns of Tax Deducted at Source Scheme, 2003’. It is applicable to all deductors furnishing their TDS return in electronic form. As per this scheme,

It is mandatory for corporate deductors to furnish their TDS returns in electronic form (e-TDS return) with effect from June 1, 2003.
For government deductors it is mandatory to furnish their TDS returns in electronic form (e-TDS return) from financial year 2004-2005 onwards.
Deductors (other than government and corporates’ ) may file TDS return in electronic or physical form.

Deductors furnishing TDS returns in electronic form (e-TDS) have to furnish Form 27A. Form 27A is a control chart to be furnished in physical form along with CD/ Floppy containing the e-TDS returns. Form No 27A is required to be furnished separately for each TDS return.

Form 27A is a summary of e-TDS returns which contains control totals of ‘Amount paid‘ and ‘Income tax deducted at source’. The control totals mentioned on Form 27A should match with the corresponding control totals in e-TDS returns.

Returns and Timelines

The following Returns are required to be filed under TDS:

Financial Year	Form No.	Particulars	Periodicity
2008-09	Form 26	Annual return of deduction of tax in respect of payments other than salary	Annual
	Form 27	Annual return of deduction of tax in respect of payments other than salary made to Non-residents	Annual
	Form 27A	Physical control charts containing control totals mentioned in TDS returns furnished electronically. Form 27A in physical form to be submitted along with e-TDS annual return forms. With each e-TDS returns Form 26 and/ or Form 27.	With each e-TDS returns Form 26 and/ or Form 27.
2008-09	Form 26 Q	Quarterly return of deduction of tax in respect of payments other than salary	Quarterly
	Form 27Q	Quarterly return of deduction of tax in respect of payments other than salary made to Non-residents.	Quarterly
	Form 27A	Physical control charts containing control totals mentioned in TDS returns furnished electronically. Form 27A in physical form to be submitted along with e-TDS quarterly return forms	With each e-TDS returns Form 26Q and/or Form 27Q.

Changes in Finance Act (02) 2009
As per Finance Act (02) 2009

Surcharge and Cess is not applicable for the Financial Year 2009-10 with effect from 1-4-2009. For tax deduction only the specified TDS rates are considered.
For some of the Nature of Payments TDS rates have been changed. The changed tax rates are applicable form 1-10-2009

Changed tax rates are as follows

NEW E-TDS FVU VERSION 3.6 PERTAINING TO FY 2012- 13 AND ONWARDS

From 16-10-2012 onwards all e-TDS/TCS regular returns would have to be filed in the modified data structure using E-TDS FVU Version 3.6

Below is the screen shot of the new FVU (ver 3.6) with its field description.

1. TDS / TCS Input File Name with Path

Specify the name (with the .txt extension) of the input file (including the path) i.e. the name of the e-TDS/TCS statement generated as per file format to be validated by the FVU 3.6

2. Challan Input File name with Path

This is a field provided to specify the challan Input File Details.
Challan Input File will be available as download from NSDL’s website https://tin.tin.nsdl.com/oltas/index.html. The downloaded file will have the extension “.csi”
Downloaded Challan Input File contains the challan status inquiry for the verification of challan in TDS/TCS statement.
Challan Input file Name is a 16 Digit TAN based Alpha Numeric Number with the file extension .csi

Example: MUMM10001A051010.csi ( First 10 digits is Tax Assessment Number (TAN) and Next 6 digits indicate the date on which the file is downloaded)

3. Error/Upload & Statistics Report File Path

Specify the path where either an 'error' or 'upload & statistics report files' generated by the FVU on completion of validation should be saved. The path can be same as the input file path or different. Do not specify any filename, only provide the path
In case of an 'invalid file', an 'error file' will be generated. This will be an html file with the same filename as the input file with err appended after the file name and html as extension

4. Consolidate File Name with Path:

Specify the name (with the .txt extension) of the file (including the path) to import consolidated file for validating correction statement.

Recommended Books

2013-02-22T21:12:00.001-08:00

Earn By Sending SMS

2013-02-22T19:11:00.001-08:00

Click Here

Schedule VI Master Configuration

2012-09-29T20:11:00.001-07:00

The Schedule VI Master Configuration report provides an elaborate picture of the Schedule VI Heads to which Tally Groups have been mapped by Tally.ERP 9.
To view the Schedule VI Master Configuration report for Schedule-VI Balance Sheet,
Go to Gateway of Tally > Audit & Compliance > Financial Statements > Balance Sheet

Click on F9: Master Config or press Alt+F9

The Schedule VI Master Configuration report appears:
Groups that have been automatically classified under Schedule VI Heads by Tally.ERP 9 can be reclassified by the user under different Schedule VI Heads.
See more on Schedule VI Rule Configuration

Button options in Schedule VI Master Configuration report

F1: Detailed

Click on F1: Detailed ore press Alt+F1 to view a detailed Schedule VI Master Configuration report:

F4: Group

Click on F4: Group or press F4 to view the Schedule VI Master Configuration for a specific Group

F5: Led-wise

Click on F5: Led-wise or press F5 to view the Schedule VI Master Configuration for every Ledger

Ctrl+F9: Rename Heads

Click on Ctrl+F9: Rename Heads or press Ctrl+F9
The Configuration Schedule VI Heads report appears:

The report provides details of Schedule VI Heads and their names as displayed in the Schedule-VI Balance Sheet
Click on F1: Condensed or press Alt+F1 to view a condensed version of the report
Click on R: Rename Head or press Alt+R to Rename Schedule VI Heads
Select a Schedule VI Head using Spacebar and click on Ctrl+F10: Restore Name or press Ctrl+F10 to undo any changes made to it
Click on F12: Configure to change the default view of the report:

Set the option Show Only Renamed Heads? To Yes to view only those Schedule VI Heads for which Display Names have been changed

Ctrl+F10: Restore Def.

Click on Ctrl+F10: Restore Def. or press Ctrl+F10 to undo any reclassifications done to the Tally Groups

Ctrl+B: Bifurcate Value

Click on Ctrl+B: Bifurcate Value or press Ctr+B to view the Bifurcate Value Classification report:
To know more about Bifurcating Balances, see Schedule VI Rule Configuration

Click on F12: Configure or press F12 to change the view of Bifurcate Value Classification report:

Appearance of Names: Set the Display Name Style for the report
Expand all levels in Detailed Format: Set this option to Yes to view a detailed Bifurcate Value Classification Report
Show Closing Balance: Set this option to Yes to view the Closing Balances of the Groups displayed

C: Multi Classify

Select multiple Groups using Spacebar and click on C: Multi Classify or press Alt+C to set their Schedule VI Rule Configuration

F9: Inv Reports

Click on F9: Inv Reports or press F9 to navigate to the default Inventory Reports like Godown Summary, Movement Analysis, Stock Summary etc.

F10: Acc Reports

Click on F10: Acc Reports or press F10 to navigate to the default Accounting Reports like Balance Sheet, Cash Flow, Trial Balance etc.

F10: Audit Reports

Click on F10: Audit Reports or press Alt+F10 to navigate to the other Audit Reports within Statutory Audit and Tax Audit

F12: Configure

Click on F12: Configure or press F12 to change the default view of the Schedule VI Master Configuration report:

Appearance of Names: Set the Display Name Style for the report
Sorting Method: Select the required sorting method -Alphabetical or Default, from the list of Sorting Methods.
Expand all levels in Detailed Format: Set this option to Yes to view a detailed Schedule VI Master Configuration Report
Show Closing Balance: Set this option to Yes to view the Closing Balances of the Groups displayed.

Option to Move Tally Groups/Ledgers from one Schedule VI Head To another Schedule VI Head

2012-09-29T20:08:00.001-07:00

Tally.ERP 9 provides users with the option to Move Tally Groups/Ledgers from one Schedule VI Head To another Schedule VI Head.
Go to Gateway of Tally > Audit & Compliance > Financial Statements > Balance Sheet

Place the cursor on a Schedule VI Head and press Enter

The Note Summary report for the Schedule VI Head appears.

Click on F1: Detailed or press Alt+F1 for the detailed Note Summary
Place the cursor on the Group/Ledger that has to be Moved to a different Schedule VI Head
Click on Ctrl+X: Move or press Ctrl+X

The Group/Ledger gets selected.

Move the cursor over to the Schedule VI Head under which the Group/Ledger needs to be placed
Click on Ctrl+V: To or press Ctrl+V to move the Group/Ledger under the selected Schedule VI Head

The selected Group/Ledger appears under the selected Schedule VI Head:

Click on Ctrl+Z: Undo or press Ctrl+Z to restore the Note Summary from the last change made

Inserting and Renaming Heads In Schedule-VI Balance Sheet

2012-09-29T20:05:00.001-07:00

Tally.ERP 9 provides users with the option to rename and insert Heads in the Schedule-VI Balance Sheet as per their business needs.

Renaming Heads

To rename Schedule VI Heads,

Go to Gateway of Tally > Audit & Compliance > Financial Statements > Balance Sheet

Place the cursor on the Schedule VI Head that has to be renamed.
Click on R: Rename Head or press Alt+R

The Change Display Name sub-screen appears:

Type in the name to be given to the chosen Schedule VI Head
Press Enter

Press Enter or Y to Accept (save) the change

The Schedule VI Head appears renamed in the Schedule-VI Balance Sheet:

Inserting Heads

Users can insert Heads at lowest level of the hierarchy of Schedule VI Heads.

For e.g.: User will not be able to insert head at Current Assets (Schedule VI Head) level, but will be able to do it at Other Current Assets (Sub-head) level.

To insert a head in the Balance Sheet,

Go to Gateway of Tally > Audit & Compliance > Financial Statements > Balance Sheet

If, for instance, Interest Accrued on Investments has to be inserted under Other Current Assets,

Place the cursor under the required Schedule VI sub-head (here, Other Current Assets) and click on Ctrl+I: Insert Head or press Ctrl+I

The Create Schedule VI Head screen appears. Press Backspace to change the Head under which the new one has to be inserted

A List of Heads appears:

Select the appropriate Head (here, Other Current Assets), and press Enter
Type in the Name of the new head and press Enter

Press Enter or Y to Accept (save) the new head

The newly inserted Head (Interest Accrued on Investments) appears classified under the chosen Head (Other Current Assets)

Deleting inserted Heads

To delete an inserted Head,

Place the cursor on the (inserted) head
Click on Ctrl+D: Delete Head or press Ctrl+D
Press Enter or Y to delete the head

Note: Default Schedule VI Heads cannot be deleted. Also, Inserted Heads to which Tally Groups have been linked cannot be deleted.

Schedule-VI Balance Sheet

2012-09-29T19:59:00.001-07:00

Schedule-VI Balance Sheet provides the representation of company's financial position at any point in time in the Schedule VI format of Companies Act. The Balance Sheet displays:

Equity and Liabilities comprising of Shareholders' Funds, Share Application money pending allotment, Non-Current Liabilities, and Current Liabilities
Assets comprising of Non-Current Assets and Current Assets

To generate the Schedule-VI Balance Sheet,
Go to Gateway of Tally > Audit & Compliance > Financial Statements > Balance Sheet

The report displays the Schedule VI Heads with the respective balances. Default Tally Accounting Groups are automatically linked to their respective Schedule VI Heads. The Ledgers that are classified under these Accounting Groups, too, get linked to the Schedule VI Heads. This is a broad classification provided by Tally.ERP 9. Users can reclassify the Groups/Ledgers under other Schedule VI Heads, while keeping the Balance Sheet intact.
Schedule VI Heads consisting of Groups/Ledgers that have not been categorised by the user, will be displayed as Ungrouped and in red, to bring the same to attention.
Press Enter on the required Schedule-VI head/sub-head to view the respective Note Summary report.

Exceptions in Schedule-VI Balance Sheet

In the Schedule-VI Balance Sheet all the possible exceptions will be displayed in red for users’ attention.

Previous Year Ungrouped – Any Ledger/Group present only in Previous Year that remain unclassified under Schedule VI Groups, will be shown under this Exception.
Balance in Branch / Division – Any Ledger grouped or created under Tally.ERP 9's reserved group Branch and Division, will be shown under this Exception.
Balance in Suspense A/c – Any Ledger grouped or created under Tally.ERP 9's reserved group Suspense A/c, will be shown under this Exception.
Difference In Opening Balance – Difference in Total of Assets side or Liability side will be shown under this Exception.
Unadjusted Forex Gain or Loss – If there is any unadjusted Forex Gain or Loss from the Forex Transactions it will be shown under this Exception.
Difference in Bifurcation - This exception occurs where Ledgers have been mapped to Schedule VI Heads using the Bifurcate Balance option. If their opening balances have been modified, or transactions have been passed using these ledgers, this exception occurs, and is displayed as Difference in Bifurcated Balance

The user can regroup/reclassify these exceptions to the respective Schedule VI Groups using the Move (Ctrl+X) and To (Ctrl+V) options or using Schedule VI Rule Configuration.

Button options in the Schedule-VI Balance Sheet

F1: Detailed

Click on F1: Detailed or press Alt+F1 to view the Balance Sheet in detailed form.
The detailed view for Schedule-VI Balance Sheet displays the default Tally Groups with balances which are mapped under various Schedule VI Groups.

F2: Period

Click on F2: Period or press F2 to change the selected period for the Audit Year (Current Year). If two separate companies are loaded or if the transactions of multiple years are available in the same data, then the Period for the Previous Year is also changed accordingly.

F3: Hide Prev. Year

Press F3 or click on F3: Hide Prev. Year to display the Previous Year column while displaying report. This will be available for use only when multiple years are available in the same data.

Ctrl+O: Copy Classify

Click on Ctrl+O: Copy Classify or press Ctrl+O to copy the configurations of the Schedule-VI Balance sheet from another Company on Tally.ERP 9.

Ctrl+F3: Compare Cmp

Click on Ctrl+F3: Compare Cmp or press Ctrl+F3 to load the Company having previous years data.
Note: If the data for both the years is available in the same Company, loading of a second Company is not required.
For the Company with two years data, system will check for the Vouchers passed on any Day for the month March to determine the Audit Year.

F8: Note. No.

Click on F8: Note No. or press F8 for Note Number Configuration.

F9: Master Config

Click on F9: Master Config. Or press Alt+F9 to view the Schedule VI Master Configuration

Ctrl+F10: Restore Def.

Click on Ctrl+F10: Restore Def. or press Ctrl+F10 to undo any manual Schedule VI classification performed on the default Tally Groups/Ledgers.

A: Additional Info.

Place the cursor on a Schedule VI Head and click on A: Additional Info. or press Alt+A to go to the respective Additional Details report

Ctrl+C: Classify Helper

Click on Ctrl+C: Classify Helper or press Ctrl+C for Current and Non-Current Classification report.

F9: Inv Reports

Click on F9: Inv Reports or press F9 keys to navigate to the default Inventory Reports like Godown Summary, Movement Analysis, Stock Summary etc.

F10: Acc Reports

Click on F10: Acc Reports or press F10 keys to navigate to the default Accounting Reports like Balance Sheet, Cash Flow, Trial Balance etc.

F10: Audit Reports

Click on F10: Audit Reports or press Alt+F10 keys to navigate to the other Audit Reports within Statutory Audit and Tax Audit.
F12: Configure
Click on F12: Configure or press F12 to change the default display for the Schedule-VI Balance Sheet report.
Scale Factor for Values: Select the required Scale Factor from Crores, Hundreds, Lakhs, Millions, Ten Lakhs, Ten Millions, Ten Thousands, Thousands or Default for displaying the balances in the Schedule VI Balance Sheet.
Note: The Default Tally Group & Balances will be displayed only in the expanded mode.

Financial Statements

2012-09-29T19:47:00.001-07:00

Every company registered under the Companies Act, 1956, is required to prepare its Balance Sheet, Statement of Profit and Loss, and the notes thereto in accordance with Schedule VI of the Act. Schedule VI has now been revised by the Ministry of Corporate Affairs (MCA) in order to keep the disclosure requirements in concurrence with the objective of achieving a fair and uniform presentation of financial information.

In Tally.ERP 9, the following are the Financial Statements that can be generated in the format as per the Revised Schedule VI:

Balance Sheet
Profit & Loss A/c

To view the Financial Statements,

Go to Gateway of Tally > Audit & Compliance > Financial Statements

Table Search Capability of Tally.ERP 9

2012-09-29T19:30:00.001-07:00

Current Search Capability

The current Table Search capability in Tally.ERP 9, allows the user to highlight a particular set of Names based on the search text entered in the field. The text is searched from the beginning of the names in the list (This type of search is called “Starts with” search) and search is applicable only to the first column of the table/list.

Example: Stock Item search in Sales Voucher

In the above case names are searched based on the text entered – N, in the Name of Item field and search is applicable only to the first column (Name of Item) in the table. Even after the relevant names are searched and highlighted, all the names (not required) are also displayed in the list/Table.

Let’s take scenarios,

1. Where there are large numbers of names in the list/table and it is impossible for the user to remember the starting characters of the names. He may remember only a part of the name which he wants (required) to search.

2. After search, display only the relevant names based on the search text and not all the names in the table/list.

The current search capability doesn’t support the above scenarios. To provide Quick and flexible search, the table search capability in Tally.ERP 9 has been enhanced.

New Search Capability – “Contains” Search

The latest enhancement to table search allows the user to search a text from any part of the name which appears in the list. The table keeps on reducing and displaying only those names which fulfill the search criteria. Now it is also possible to specify whether the search criteria should be applicable only on first column or all columns of the table.

Enhanced search is based on the configuration settings. To configure table search, in Advanced Configuration (Ctrl +Atl + F12 from Gateway of Tally) Or F12: Configuration > General following Configuration options are provided

Use ‘Reducing List’ for Tables (‘Contains’ Search): To allow the user to search a text from any part of the name that appears in the list. The table keeps on reducing and displaying only those names which fulfill the search criteria.
Apply for all Columns: To specify the search criteria should be applicable on first column or all columns of the table.

Advanced Configuration (Ctrl +Alt + F12 from Gateway of Tally) - Table Configuration Screen appears as shown

By default, both the above options will be set to Yes. User can alter/change configuration settings at any point of time.

Note: The option Apply for all columns is a sub- option and is displayed only when the option Use ‘Reducing List’ for Tables is enabled.

Table Configurations can also be done form F12: Configuration > General

Let us now see the New Search Capability of Tally.ERP 9

The Name based search will display the information as shown below:

The search can also be performed in a List/Table containing multiple columns by providing the the necessary search keyword. e.g. search for Quantity of Items.

The Quantity based search (in the second column) to select required item is as shown

Tally.ERP 9 displays all the stock items containing Numeric 4

Table Search

In Tally.ERP 9, Table Search means select (identify) a company, stock Item, Ledger, Group, stock Group, Cost Centers etc. from the List.

For example:

1. Select a Company from List of Companies

List of Companies is called table (which contains names of companies in the selected path).

2. Select a Ledger from List of Ledger Accounts in a Voucher

List of Ledger Accounts is called table (which contains names of Ledgers)

3. Select a Stock Item from List of Items in a Voucher

List of Items is called table (which contains names of Stock Item)

Similarly, where ever List is displayed to select any thing say ledger, valuation methods, groups, units of Measurement, Tax Type, TDS nature of payment, Service Categories, Voucher Types, Pay head Types etc. is called Table.

Cheque Printing in Tally

2012-09-18T19:39:00.001-07:00

The Cheque Printing option in the Banking menu allows the user to print all the pending, already printed or the required cheques continuously from a single screen. It also allows to update the cheque details of a transaction, i.e., the instrument no, instrument date, cheque favouring, etc. The bank ledger needs to be enabled for cheque printing from ledger creation or alteration mode.

Click the links given below for details.

Accessing Cheque Printing

Printing Cheques / Cheque Printing Reports

Configuring Cheque Printing

Accessing Cheque Printing

To access Cheque Printing screen,

Go to Gateway of Tally > Banking > Cheque Printing.

The Select Bank screen displaying the List of Bank appears as shown:

Select All or the required Bank account from the List of Bank.
Press Enter.

The Cheque Printing screen of the selected Bank is displayed as shown:

By default, this screen displays list of pending cheques of the current date’s month.
Press F6: Show All to display all the cheques.

Note: This button toggles between Show All / Hide Printed.

Bank Not Configured for Cheque Printing

The cheque printing screen will prompt with a message Bank not configured for Cheque Printing when the bank ledger not configured for cheque printing is selected, as shown:

The bank needs to be enabled for cheque printing from ledger alteration screen.

In the Cheque Printing screen of the ledgers configured for it,

Select the required row from the Cheque Printing list to open the voucher in alteration mode.
F2: Period: Allows to change the period.
F4: Bank: Allows to select All / Other required Bank from the list.
F7: Edit Ch Details: Allows to edit/update the Favouring Name, Instrument No and Instrument Date columns, as shown:

Accept the screen to save the settings.

F12: Range: Allows to filter the Cheque printing screen. The user can filter the transactions based on the Amount, Bank Date, Date, Favouring Name, Instrument Date, Instrument No., Ledgers, Narration, Remarks and Transaction Type as shown:

Printing Cheques / Cheque Printing Reports

The user may print All or selected cheque from the Cheque Printing list.

Printing All Cheques

To Print All Cheque from the list,

Go to Gateway of Tally > Banking > Cheque Printing.
Select the required Bank account from List of Bank. To change the selection made, press F4: Bank button to select another bank.
The Cheque Printing screen is displayed.
Click Print or Press Alt+P.

The Print Report screen appears. Set the option Print Cheque to Yes as shown:

Note: The option - Print Cheque appears only if a particular bank is selected for printing cheques. On selecting All Items for displaying pending cheques of different banks in cheque printing screen, this option will not appear.

Accept to Print all the cheques.
The Cheque Printing proceeds and displays confirmation for each cheque with Cheque Details, as shown:

Confirm to print cheque one by one before printing. Additionally the facility to change the orientation and adjust the distance of top edge and left edge with flexibility to avoid printing the date on cheque is provided.

Printer Selection

Press S: Select Printer button to select the printer and the paper size. Select the paper size as A4.

Orientation

In the Sample Cheque Printing screen, press N: Orientation button (Alt+N) to select the orientation. The orientations - Vertical and Horizontal gets listed.

On selecting Vertical - centre/left/right the cheque gets printed in vertically (oriented as portrait). Using these options, the cheque can be printed by setting the orientation to:

Vertical Left: On inserting the paper in the printer tray, the cheque gets printed vertically on the left hand side of the paper.
Vertical Centre: On inserting the paper in the printer tray, the cheque gets printed vertically at the centre of the paper.
Vertical Right: On inserting the paper in the printer tray, the cheque gets printed vertically on the right hand side of the paper.

Additionally for printing the cheque face up or face down with vertical orientation, the field - Print From (for Vertical Only) gets displayed. Depending on the printer, the front or rear can be selected.

Front: In printers which print face up select Front.
Rear: For printers which print face down place the paper in reverse order and select Rear.

On selecting Horizontal the cheque gets printed horizontally (oriented as landscape).

Overall Adjustment

Using the configuration provided for overall adjustment:

The cheque dimensions pre-configured on selecting the cheque format can be adjusted such that the overall dimensions get shifted by the required 'mm' from top and left edge of cheque.
While printing the cheque, date field can be left blank if it is not required to be printed.

From the Sample Cheque Printing screen, click on F12: Configure button and change/retain the dimensions in 'mm' as per requirement.

Adjust Distance From Top Edge (in mm): To adjust the distance from top edge such that the overall measurements defined in Cheque Dimensions screen get shifted as per the 'mm' entered here.
Adjust Distance From Left Edge (in mm): To adjust the distance from left edge such that the overall measurements defined in Cheque Dimensions screen get shifted as per the 'mm' entered here.
Print Date: By default the date gets printed on the cheque. If the date is not to be printed on the cheque set this field to No.

Accept the configuration and print the cheque. The adjustments done for overall adjustment using F12: Configuration of cheque printing screen does not affect the settings of Cheque Dimensions pre-configured for the selected cheque format.

The Printed Cheque displays as shown:

Printing Selected Cheques

To Print selected Cheques from the list,

Go to Gateway of Tally > Banking > Cheque Printing.
Select All or required Bank account from List of Bank.
The Cheque Printing screen is displayed.
Press spacebar to select the required row(s).
Click Print or Press Alt+P.
The Cheque Printing screen appears.
Accept to print the cheque(s).

Cheque Report Printing

To print the Cheque report,

Go to Gateway of Tally > Banking > Cheque Printing.
Select All or required Bank account from List of Bank.
The Cheque Printing screen is displayed.
Click Print or Press Alt+P.
Cheque Report Printing screen appears confirming to print.
Click No or Press N or Esc.

Print Cheque: This option appears on selecting a particular bank. Set it to No.
Include Printed Cheques also: Set this option to Yes to display the printed cheques also in the report.
Show Forex Transactions only: Set this option to Yes in case you need only the forex transactions to be displayed in the report.

Note: This option appears only in case Multi Currency feature is enabled for the company.

Show Payment Favouring: Set this option to Yes to display Favouring Name details in the report.
Show Remarks also: Set this option to Yes to display the Remarks in the report.

On setting Print Cheque it to Yes, the options - Include Printed Cheques also, Show Payment Favouring and Show Remarks also gets set to No automatically as the user has opted to print cheque. If Print Cheque is set to No, a statement displaying all entries including details of printed cheques can be generated with information about favouring name and remarks as entered in the Bank Allocation sub-screen of payment voucher.

The Cheque Report Printing screen is displayed as shown:

Accept to Print.

The Cheque Report Printing is displayed as shown:

Configuring Cheque Printing

The user may configure the Cheque Printing screen based on his requirement.

To configure,

Press F12: Configure, the Configuration screen is displayed as shown:

Confirm each Cheque before Print

By default this is set to Yes. The cheque printing will confirm for each cheque before printing.

Include Printed Cheques also

By default, this option is set to No. Set it to Yes to display the Printed Cheques also

Note: This option is similar to the function key F6: Show All / Hide Printed.

Show Forex Transactions only

By default, this option is set to Yes. The cheque printing screen displays only the forex transaction.

Note: This option appears only in case the company is enabled with multi currency feature.

Show Payment Favouring

By default, this option is set to Yes. The cheque printing screen displays the Favouring Name column.

Note: The Favouring Name column displays only those names which are different from the Party/Ledger account names.

Show Remarks also

By default, this option is set to No. Set it to Yes to display the Remarks also.

Appearance of Name

Select the required Display Name Style from the list to display in cheque printing screen.

Scale Factor for Values

Select the required Scale Factors from the list.

Sorting Method

Select the required Sorting Methods from the list.

Import Masters (how To import Data In Tally)

2012-09-18T19:28:00.003-07:00

Import Formats

Tally.ERP 9 supports XML format to import data.

To Import Masters execute the following steps:

Go to Gateway of Tally > Import of Data > Masters

In the Import of Masters screen:
Enter the required path and filename in the Import File Name (XML) field. If the file is located in the default folder, then you need to provide the filename only.
In the field Treatment of entries already existing select the required Behaviour
Combine Opening Balances: Select this option to import data of different branches and consolidate the opening balances. You can also select this option when the opening balances of existing masters are Zero and need to be overwritten by the balances in the data being imported.
Ignore Duplicates Select this option to import new masters along with the existing masters in Tally ignoring the duplicates.
Modify with New Data Select this option to replace the existing balances with those existing in the data imported and also override the other options available in Behaviour list.

Press Enter to Import Masters.
Double click on Tally.imp file located in the Tally.ERP folder to view the import log.

Import Vouchers

To import vouchers execute the following steps:

Go to Gateway of Tally > Import of Data > Vouchers
In the Import of Vouchers screen, enter the required path and filename in the Import File Name (XML) field.

Press Enter to import the Vouchers
Double click on Tally.imp file located in the Tally.ERP 9 folder to view the import log.

Import Data in tally

2012-09-18T19:23:00.002-07:00

In Tally.ERP 9 you can import data from earlier versions of Tally, Tally.ERP 9 and any third party application using the predefined format of XML.

To Import Data

Go to Gateway of Tally > Import of Data
The Import of Data menu is displayed as shown.

To read more on the step by step procedure for importing masters, vouchers and synchronization click one of the corresponding links:

Masters
Vouchers
Synchronization

Export Tally to Excel

2012-09-18T19:19:00.003-07:00

Using the Export feature you can export Tally.ERP 9 data to Excel. Data exported to Excel can be e-mailed as an attachment, used to generate graphs for better presentation and further analysis.

Go to Gateway of Tally > Balance Sheet

In the Balance sheet screen click E : Export or press Alt+E.
Select the required language from the list of Languages displayed.
Select a format from the list of Formats displayed.
By default, the exported file will be stored in C:\Program Files\Tally.ERP 9 for Windows 7 and C:\Tally.ERP 9 for Windows XP operating systems
Press Enter to accept the default Output Filename or type the filename of your choice in order to save the file with a different name.
Press Enter to accept the default Output Sheet Name.
To update the existing file select Yes in Update Existing File.
To format the contents of the file select Yes in Excel (Spreadsheet) formatting.
Select Yes for the Field with Colour, to retain the background colour in the exported file.

Accept to export the Balance Sheet to an excel file.

The exported file is saved in the default Tally.ERP9 or the specified folder, you can use this file for further analysis.

Tally Notes

Accounting Policies

F11: Audit Features

Computer Accessories

Tax Audit Dashboard

Button options in the Tax Audit Dashboard screen

F2: Period

F9: Save Audit

To view all the Vouchers which are marked for Client's Clarification (with Audit Status as External Clarification) and the Vouchers which are Clarified (Audit Status as Clarified) by the Client in a single report,

Tax Audit in Tally.ERP 9

Printing Form 3CD

Filling Form 3CD

Clause Applicability Details:

Filling Clause No. 1-6

Filling Clause No. 7 (a & b)

Filling Annexure I

Button Options in Form 3CD screen

F1 : Detailed

Press Alt+F1 or F1 : Detailed button to view detailed Form 3CD.

Ctrl+O: Copy From

To copy the data from Form 3CD of a different Company (or same Company for previous year), the Auditor can use Copy From button available in the Form 3CD screen.

Copying entire Form 3CD

Copying individual Clauses in Form 3CD

Button Options in Clause Reference Details screen

Tax Audit in Tally.ERP 9

Form 3CD

Auditor/Firm Profile in Control Centre

Audit Remotely (Anywhere)

Audit at Client's Office with Local Data

Audit Tools of Tally.ERP 9

AuditReady

Account-based capturing of Audit Details

Illustration 1: One customer (Non-BAP User) and one CA (BAP user)

Illustration 2: One customer (Non-BAP User) and two CAs (BAP users)

Illustration 3: One customer (Non-BAP User), two BAP users, and one article (BAP user)

Audit & Compliance Scenarios

Audit at CA’s Office with Local Data

TDS (Tax Deducted at Source) - Tally.ERP 9

e-TDS Returns

Recommended Books

Earn By Sending SMS

Schedule VI Master Configuration

Button options in Schedule VI Master Configuration report

F1: Detailed

F4: Group

F5: Led-wise

Ctrl+F9: Rename Heads

Ctrl+F10: Restore Def.

Ctrl+B: Bifurcate Value

C: Multi Classify

F9: Inv Reports

F10: Acc Reports

F10: Audit Reports

F12: Configure

Option to Move Tally Groups/Ledgers from one Schedule VI Head To another Schedule VI Head

Inserting and Renaming Heads In Schedule-VI Balance Sheet

Schedule-VI Balance Sheet

Exceptions in Schedule-VI Balance Sheet

Button options in the Schedule-VI Balance Sheet

F1: Detailed

F2: Period

F3: Hide Prev. Year

Ctrl+O: Copy Classify

Ctrl+F3: Compare Cmp

F8: Note. No.

F9: Master Config

Ctrl+F10: Restore Def.

A: Additional Info.

Ctrl+C: Classify Helper

F9: Inv Reports

F10: Acc Reports

F10: Audit Reports

Financial Statements

Table Search Capability of Tally.ERP 9

Current Search Capability

New Search Capability – “Contains” Search

Let us now see the New Search Capability of Tally.ERP 9

Cheque Printing in Tally

Bank Not Configured for Cheque Printing

Printing All Cheques