Tax Audit Report in Form No. 3CD

1. Method of Stock Valuation and effect of change in the valuation

 a) To use this feature, we need to activate first Integrate Accounts and Inventory option to Yes in Features (press F1 1)

 b) Now go to Balance Sheet. You will see Option in the right hand side panel F7: Valuation. Press F7 and select the method you desire

 c) To add a new column with another method of valuation, select New Column or press Alt + C and make the selection of another column.

 d) This will help you to disclose the effect of change in the method of valuation of stock

 2.         Finding out any expenses paid by way of penalty. fine. club or advertisement expenses

 a)   Go to Profit & Loss A/c.

 b)   Select option F12 : Value by pressing Ctrl + F12

 c)   Select voucher having Narration Containing Fine or voucher having narration Containing Penalty

 d)   This will give you the information about any expenses paid by way of penalty or fine under any head of expenses.

 e)   Please make it sure by selecting appropriate vouchers that it is really expenses in the nature of penalty or fine

 f)    The above procedure may be used for getting advertisement expenditure

 3. Expenditure in cash above Rs.20,000 in cash

 a) Go to ledger of cash A/c. (either selecting by pressing Enter Key from Balance Sheet, Current Assets, Cash‑in‑Hand and Cash A/c. or Display ‑ Account Books ‑ Cash or Bank Book [DAC1 and Select Cash A/c.

 b)  Go list of payment Vouchers Display ‑ Statements of Accounts ‑

     Statistics (DSSI, Select Type of Vouchers ‑ Payment

 c) Enter any month and Press Alt + F2 for selecting period from 01/04 to 31/03

     Press Alt + F12 : Range ‑ Voucher having Ledger Amount greater than 20000

     This will give the list of all the payments above Rs.20,000

     But if the payment of Rs.20,000 has been split into vouchers below        Rs.20,000 and recorded on the same day, the same will not get reflected in the above list. Similarly, it may give list of vouchers where we have            made payment for issue of Demand Draft. This may be requires case to case basis different approach.

 4. Particulars of Loans and Deposits above Rs.20,000

 a) You have activate Feature Interest Calculations by pressing F11

     Features and activate interest calculation to yes

b) For the individual ledger accounts, you have to select the option of Interest Calculation

c) Go to Balance Sheet ‑ Loans Liabilities

d) Select F1: Detailed

e) Select F12 : Configure and set options Opening Balance, Transaction to Yes

f)  Select Individual Ledger Account

g) Press F8 : Other Report and Select Interest Calculation

h) Select option Contact by pressing Alt + C. This will give details of the party like address as well as PAN

i)   Similarly we can also check interest calculations. To give interest calculation parameters press CtrI + Enter on the individual ledger account and activate interest calculation parameter to yes and give the required details.

j)    To find out maximum balance outstanding during the year, press Enter on Individual Ledger Account, then press F12 : Configure and Set option High/Low Details to Yes

5. Details of TDS and Provident Fund Contributions.

a) First Activate F1 l : Features and set following options to Yes

Maintain Billwise Details Yes

(for non trading A/c. Also) Yes

Activate Interest Calculation Yes

(use advance parameters) Yes

b) In the ledger account of TDS A/c. or PF? A/c. (Accounts Info. ‑ Ledger ‑

Alter) (ALA) and select the ledger account. Set the following parameters to Yes ‑

Maintain bill‑by‑bill Yes

Activate interest calculation Yes

c) In interest parameters specify:

        Calculate Interest Transaction by Transaction to Yes

Rate : 1 % per 365 days ye on credit balances only

Applicability Always Calculate from Due Date of Invoice

Rounding Not Applicable

d) While entering the transaction give the details and references with correct due dates

c) To get the details of delayed payments and also interest payable

Go to relevant ledger account Display ‑ Account Books ‑ Ledger (DAL)

and type name of the ledger account and press Enter

Press F2 Period and type 01/04 To 31/03

Press F8 Other Report ‑ Select Interest Calculations

This will now show interest at specified rates where the payment has been delayed.

To get further details, press F1: Detailed and it will give all details, date of credit, due date, date of payment and delay in no. of days

6. Quantitative Details

     To get these details, first quantitative details of stock should be maintained by activating various features.

a)     Press F3: Cmp Info

b)     Select Alter

c)      Select the name of the company to alter

d)     Go to option no. 10 ‑ Maintain and Select Accounts with Invento

e)     Go to option of Inventory Info and create various stock groups, stock items and units of measurement

f)        To get quantitative information, go to Stock Summary

g)     To get itemized details of all items, press F1 : Detailed

h)     To get other details, like opening balance, inwards and outwards, press

     F12: Configure and select following options to yes

     Show Opening Balance Yes

     Show Goods Inwards Yes

     Show Goods outwards Yes

7. Ratios ‑ There are various ratios as per predefined formulas calculated by the Tally. Select Ratio Analysis and    you will get various ratios calculated with details of formulas used.

8. Transactions with related parties