Friday, July 5, 2013

Filter the Cash Transactions made to a party which exceeds Rs. 20,000

Query

How to use the Tax Audit tool available in the Auditors’ Edition of Tally.ERP 9 to filter the Cash Transactions made to a party which exceeds Rs. 20,000?

Solution

As per section 40A(3), all the Cash Payments made to any party needs to be reported if the aggregate amount exceeds Rs. 20,000 for any day.

To find the Amounts inadmissible u/s 40A(3), follow the steps given below:

Go to Gateway of Tally > Audit & Compliance > 44AB Audit
  1. Select the option Amounts inadmissible u/s 40A(3) and press Enter
  2. The screen will display all the Cash payments made to various parties during the year
  3. Press F12: Configure and set the following option:
    1. In the field Show Aggregate Cash Payments Exceeding enter 20,000
    2. Save this screen by pressing Ctrl+A
The Cash Payments screen will be updated only with the Transactions which have aggregate amount more than 20,000 for a day.
  1. Press Enter on any party to view the Ledger Vouchers report
  2. You can select the required Vouchers by pressing Spacebar and press F9: Audit button to Audit the Voucher.
  3. All the Vouchers which are marked by the Auditor as Disallowed will be printed in the Annexure to Clause 17(h) of Form 3CD.
The Annexure can be printed and attached with Form 3CD.

Detailed steps:

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

How to use the Tax Audit tool available in the Auditors’ Edition of Tally.ERP 9 to filter the Cash Transactions made to a party which exceeds Rs. 20,000?

Solution:

As per section 40A(3), all the Cash Payments made to any party needs to be reported if the aggregate amount exceeds Rs. 20,000 for any day.

To find the Amounts inadmissible u/s 40A(3), follow the steps given below:

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

  1. Select the option Amounts inadmissible u/s 40A(3) and press Enter
  2. The screen will display all the Cash payments made to various parties during the year
  3. Press F12: Configure and set the following option:
    1. In the field Show Aggregate Cash Payments Exceeding enter 20,000
    2. Save this screen by pressing Ctrl+A
The Cash Payments screen will be updated only with the Transactions which have aggregate amount more than 20,000 for a day.

  1. Press Enter on any party to view the Ledger Vouchers report
  2. You can select the required Vouchers by pressing Spacebar and press F9: Audit button to Audit the Voucher.
  3. All the Vouchers which are marked by the Auditor as Disallowed will be printed in the Annexure to Clause 17(h) of Form 3CD.
The Annexure can be printed and attached with Form 3CD.

Detailed steps:

Go to Gateway of Tally

Note: Audit & Compliance menu will appear only in Auditors’ Edition of Tally.ERP 9.

  • Press Enter on Audit & Compliance

  • Press Enter on 44AB Audit

The Tax Audit Dashboard appears as shown:


  • Press Enter on Amounts Inadmissible u/s 40A(3)

The Cash Payments screen appears displaying the Party wise Cash Payments made during the selected period.


  • Press F12: Configure to specify the option to filter only the aggregate Cash payments that exceeds 20,000.

    • In the option Show Aggregate Cash Payments Exceeding enter 20,000
    • Press Ctrl+A to save the changes

Note: This can also be specified in F11: Tax Audit Rules

The updated Cash Payments appears displaying the Party wise Cash Payments where the Aggregate exceeds 20,000.


  • Press Enter on any party to view the Ledger Vouchers

  • Select the Voucher that needs to be Audited using Spacebar key

  • Press F9: Audit button to Audit the Voucher
  • Enter the required details as shown:


  • Press Ctrl+A to save the Audit comments.

Once the Auditing for all the Vouchers is completed, go back to the Cash Payments screen.

  • Press Alt+P to print the Annexure
  • Ensure that option Print As Annexure is set to Yes



  • Press Enter to print the Annexure

Note: if the Client has issued any bearer cheques, the same can also be brought in the above report.

Please read the detailed User Manual available at for more details on using the Tax Audit tool:

How to generate payment advice when salary for the previous month is paid in the current month?

Example: On 30th April, ABC Company accounted Salary Payable for the month of April, but later realized that balance in Bank is not sufficient for salary payment, and hence withheld the Payment. For Payroll transfer on 15th May, Company wants to generate Payment Advice by clearly indicating the Salary/Payroll period (as April month’s salary).
Solution
Follow the given steps to generate payment advice when salary for the previous month is paid in the current month

Go to Gateway of Tally > Display > Payroll Reports > Statements Of Payroll > Payment Advice
  1. The Printing Payment Advice screen is displayed.
  2. Press Backspace to enter the details to be printed on the Payment Advice.
  • From and To: In the first two date fields enter the period during which the salary payment transaction is recorded. Here, it is the current month i.e.,1-5-2011 to 31-5-2011
  • Employee Category: Select the Employee category for which the Payment Advice to be generated.
  • Employee/Group: Select a specific employee or group to generate the Payment Advice
Note: In Employee/Group Tally.ERP 9 will display only the employees/groups created under the Employee category selected in Employee Category field.
  • Bank Ledger: In this field select the Bank for which the Payment Advice is to be generated.
  • Date Range to Print: Specify the period for which salary is being paid, here ABC company is making the payment for the month of April (1.4.2011 to 30.4.2011)
  • Date of Printing: The date on which the Payment Advice is being printed has to be specified here. ABC Company is printing the Payment Advice on 15-5-2011.

  •  Press Enter to get a print preview of the Payment Advice
The Payment Advice appears as shown:

Payment Advice contains a statement that the salary is being paid for the previous month (here, April), the date of printing, and the details of the employees such as account number and salary amount.

More...Log on www.TallyERP9Book.Com