TDS on Expenses-with Inventory (Purchase Voucher)



However in day-to-day business transactions, some times you have to face some complex cases e.g. a sales or purchase transaction where both Vat and TDS  is charged so how you will account this ?
This article will help you to record such transactions, where TDS on Expenses with Inventory applied for purchase vouchers
Example: On 2-8-2009 ABC Company received the bill for Rs. 52000 (for the supply of 1000 cartons @ 50 per carton and VAT @ 4%) from AK Enterprises. Cartons are printed with the company logo and other information as required on which (including the VAT amount) TDS is applicable.
The above transaction will be recorded in a Purchase Voucher

Step 1: Create Stock Item

Go to Gateway of Tally > Inventory Info. > Stock Item > Create
·        In the Name field enter the Stock Item Name e.g. Cartons
·        In the Under field select Primary group
·        In the Unit field select Nos
·        In the Rate of VAT (%) field enter 4%
·        Press Enter to save

Step 2: Create Party Ledger

Go to Gateway of Tally > Accounts Info. > Ledgers > Create
·        In the Name field enter the Ledger Name e.g. AK Enterprises
·        In the Under field select Sundry Creditors group
·        Set Maintain balances bill-by-bill to Yes
·        Enter the Default Credit Period if any
·        Set Is TDS deductible to Yes
·        In Deductee Type field select Company-Resident
·        Enter the Mailing Details and  Tax Information
·        Press Enter to save

Step 3: Create Purchase Ledger

Go to Gateway of Tally > Accounts Info. > Ledgers > Create
·        In the Name field enter the Ledger Name e.g. Purchase @ 4%
·        In the Under field select Purchase Accounts group
·        Set Inventory values are affected to Yes
·        Set Used in VAT Returns to Yes
·        In the VAT/TAX Class filed select  Purchases @ 4%
·        Set Is TDS deductible to Yes
·        In the Default Nature of Payment field select Payment to Contractors (Other Than Advertisement)
·        Set Use for Assessable Value Calculation to No
·        Press Enter to save

Step 4: Create VAT Duty Ledger

Go to Gateway of Tally > Accounts Info. > Ledgers > Create
·        In the Name field enter the Ledger Name e.g. Input VAT @ 4%
·        In the Under field select Duties & Taxes group
·        In the Type of Duty/Tax field select VAT
·        In the VAT/TAX Class select Input VAT @ 4%
·        Set Inventory values are affected to No
·        Set Rounding Method as Not Applicable
·        Set Is TDS Applicable to Yes
·        In the Default Nature of Payment field select Payments to contractors Other Than Advertisement
·        Press Enter to save

Step 5: Create TDS Duty Ledger

Go to Gateway of Tally > Accounts Info. > Ledgers > Create
·        In the Name field enter the Ledger Name e.g. TDS – Contractor Other Than Adv.
·        In the Under field select Duties & Taxes group
·        In the Type of Duty/Tax field select TDS
·        In the Nature of Payment field select Payments to contractors (Other Than Advertisement)
·        Press Enter to save

Step 6: Create Purchase Voucher

Go to Gateway of Tally > Accounting Vouchers > Press F9: Purchase
In F12: Configure
·        Ensure the option Use Common Ledger A/c for Item Allocation to Yes
1.    Ensure the Purchase Voucher is in Item Invoice Mode
2.    Press F2 and change the date to 2-8-2009
3.    In the Supplier Invoice No. field enter the reference number as 4587
4.    In party A/c Name field select AK Enterprises
5.    In the Purchase Ledger field select Purchase @ 4%
6.    In the VAT/Tax Class field Purchases @ 4% will be defaulted automatically as defined in the ledger master
7.    In the Name of Item field select Cartons from the List of Items
8.    Enter 1000 in the Quantity field
9.    In the Rate field enter the Rs.50
10.  Rs.50000 will be automatically updated in the Amount filed
1.    In the TDS Nature of Payment Details screen accept the default details
Note: The TDS Nature of Payment screen will be displayed to only when the option Allow Alteration of TDS Nature of Payment in Expenses in F12: Configure (Voucher Entry Configuration)
1.    Select Input VAT @ 4% ledger from the List of Ledger Accounts.
2.    VAT amount of Rs.2000 will be updated automatically in the Amount filed and press enter to view the TDS Nature of Payment Details screen
Note: TDS Nature of Payment Details screen is displayed even for the VAT ledger as the Vat amount is also considered for TDS calculation.
1.    Select TDS – Contractor Other Than Adv ledger  and press enter to view TDS Details screen
2.    In the TDS Details screen
3.    In Type of Ref field select New Ref
4.    In the Name field the reference number is defaulted as Purc / 4-1
5.    In the Nature of Payment select Payments to Contractors (Other Than Advertisement)
6.    Assessable Amount and TDS Amount is defaulted automatically
Note: The TDS amount of Rs. 1040 will be displayed with negative sign.
1.    Set Show Statutory Details to Yes to view the duty calculation
2.    In the Bill-wise Details screen
3.    In Type of Ref field select the New Ref as the Method of Adjustment
4.    In the Name field enter Bill-897
5.    In the Amount and Dr/Cr field keep the default allocation
6.    In the Type of Ref field select New Ref
7.    In the Name field enter Bill-897
8.    In the Amount and Dr/Cr filed keep the default allocation
1.    Enter the Narration if required

If you have any question, please post the same on Support forum only

PDF FILE TO YOUR EMAIL IMMEDIATELY

PURCHASE NOTES & PAPER SOLUTION.

@ Rs. 50/- each

SSC ENGLISH BOARD PAPERS.

ENGLISH WRITING SKILL

SCIENCE

ALGEBRA

GEOMETRY

ENGLISH KUMAR BHARA.

HISTORY & POLI.

GEOGRAPHY & ECO.

ICT SOLUTION

ACCOUNTS

OCM NOTES

ECONOMICS NOTES

SECRETARIAL PRACTICE

BUY FROM PLAY STORE

DOWNLOAD OUR APP

HOW TO PURCHASE?



SSC 10TH BOARD PAPERS


ENGLISH

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


SCIENCE

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016 PART ONE, MARCH 2016 PART TWO, JULY 2016 PART ONE, JULY 2016 PART TWO.


ALGEBRA [HOTS] HIGHER ORDER THINKING SKILL

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


GEOMETRY [HOTS] HIGHER ORDER THINKING SKILL

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


GENERAL MATHS ALGEBRA

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


GENERAL MATHS GEOMETRY

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


HISTORY

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


GEOGRAPHY [MAP]

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


ICT

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


HSC 12TH BOARD PAPERS


ENGLISH

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016 SET A, MARCH 2016 SET B, MARCH 2016 SET C, MARCH 2016 SET D, JULY 2016.


HINDI

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


MARATHI

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


ACCOUNTS

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


ECONOMICS

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


OCM

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


S.P.

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


MATHS [COMMERCE]

MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


MATHS [SCIENCE]

MARCH 2013, OCTOBER 2013, MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


PHYSICS

MARCH 2013, OCTOBER 2013, MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


CHEMISTRY

MARCH 2013, OCTOBER 2013, MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.


BIOLOGY

MARCH 2013, OCTOBER 2013, MARCH 2014, OCTOBER 2014, MARCH 2015, JULY 2015, MARCH 2016, JULY 2016.





BOARD TIME TABLES 2017


AP Board SSC Time Table 2017

AP Board (BIEAP) Intermediate Time Table 2017

Assam Board HSLC Date Sheet 2017

Assam Board AHSEC HS Date Sheet 2017

Bihar Board Matric Time Table 2017

Bihar Board Intermediate Time Table 2017

CBSE 10th Class Exam Schedule 2017

CBSE 12th Class Exam Schedule 2017

CG Board 10th Schedule 2017

CG Board 12th Schedule 2017

ICSE 10th Time Table 2017

ISE 12th Time Table 2017

Goa Board SSC Time Table 2017 [Expected]

Goa Board HSSC Time Table 2017

Gujarat Board SSC Time Table 2017 [Expected]

Gujarat Board HSC Time Table 2017 [Expected]

Haryana Board 10th Time Table 2017

Haryana Board 12th Time Table 2017

HP Board Matric Date Sheet 2017

HP Board 12th Date Sheet 2017

JAC Matric Time Table 2017

JAC Intermediate Time Table 2017

JKBOSE 10th Exam Scheme 2017

JKBOSE 12th Exam Scheme 2017

Karnataka Board SSLC Exam Routine 2017

Karnataka Board PUC II Exam Routine 2017

Kerala SSLC Exam Schedule 2017 [Expected]

Kerala HSE Exam Schedule 2017 [Expected]

Maharashtra SSC Date Sheet 2017

Maharashtra HSC Date Sheet 2017

Manipur Board HSLC Time Table 2017 [Expected]

Manipur Board Higher Secondary Time Table 2017 [Expected]

Meghalaya Board SSLC Routine 2017

Meghalaya Board HSSLC Routine 2017

Mizoram Board HSLC Schedule 2017 [Expected]

Mizoram Board HSSLC Schedule 2017 [Expected]

MP Board 10th Exam Schedule 2017

MP Board 12th Exam Schedule 2017

Nagaland Board HSLC Date Sheet 2017 [Expected]

Nagaland Board HSSLC Date Sheet 2017 [Expected]

NIOS 10th Time Table 2017 [Expected]

NIOS 12th Time Table 2017 [Expected]

Odisha Board HSC Exam Routine 2017 [Expected]

Odisha CHSE Exam Routine 2017 [Expected]

Punjab Board Matric Time Table 2017

Punjab Board 12th Time Table 2017 [Expected]

Rajasthan Board 10th Class Time Table 2017

Rajasthan Board 12th Class Time Table 2017

TN Board SSLC Exam Routine 2017

TN Board HSC Exam Routine 2017

Tripura Board Madhyamik Routine 2017

Tripura Board Higher Secondary Routine 2017

TS Board SSC Date Sheet 2017

TS Board Inter Date Sheet 2017

UK Board 10th Time Table 2017

UK Board 12th Time Table 2017

UP Board High School Time Table 2017

UP Board Intermediate Time Table 2017

West Bengal Madhyamik Schedule 2017

West Bengal Higher Secondary Schedule 2017