Advertisement

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 (GST extra)

SUBJECTS

HINDI ENTIRE PAPER SOLUTION

MARATHI PAPER SOLUTION

SSC MATHS I PAPER SOLUTION

SSC MATHS II PAPER SOLUTION

SSC SCIENCE I PAPER SOLUTION

SSC SCIENCE II PAPER SOLUTION

SSC ENGLISH PAPER SOLUTION

SSC & HSC ENGLISH WRITING SKILL

HSC ACCOUNTS NOTES

HSC OCM NOTES

HSC ECONOMICS NOTES

HSC SECRETARIAL PRACTICE NOTES

2019 Board Paper Solution

HSC ENGLISH SET A 2019 21st February, 2019

HSC ENGLISH SET B 2019 21st February, 2019

HSC ENGLISH SET C 2019 21st February, 2019

HSC ENGLISH SET D 2019 21st February, 2019

SECRETARIAL PRACTICE (S.P) 2019 25th February, 2019

HSC XII PHYSICS 2019 25th February, 2019

CHEMISTRY XII HSC SOLUTION 27th, February, 2019

OCM PAPER SOLUTION 2019 27th, February, 2019

HSC MATHS PAPER SOLUTION COMMERCE, 2nd March, 2019

HSC MATHS PAPER SOLUTION SCIENCE 2nd, March, 2019

SSC ENGLISH STD 10 5TH MARCH, 2019.

HSC XII ACCOUNTS 2019 6th March, 2019

HSC XII BIOLOGY 2019 6TH March, 2019

HSC XII ECONOMICS 9Th March 2019

SSC Maths I March 2019 Solution 10th Standard11th, March, 2019

SSC MATHS II MARCH 2019 SOLUTION 10TH STD.13th March, 2019

SSC SCIENCE I MARCH 2019 SOLUTION 10TH STD. 15th March, 2019.

SSC SCIENCE II MARCH 2019 SOLUTION 10TH STD. 18th March, 2019.

SSC SOCIAL SCIENCE I MARCH 2019 SOLUTION20th March, 2019

SSC SOCIAL SCIENCE II MARCH 2019 SOLUTION, 22nd March, 2019

XII CBSE - BOARD - MARCH - 2019 ENGLISH - QP + SOLUTIONS, 2nd March, 2019

HSC Maharashtra Board Papers 2020

(Std 12th English Medium)

HSC ECONOMICS MARCH 2020

HSC OCM MARCH 2020

HSC ACCOUNTS MARCH 2020

HSC S.P. MARCH 2020

HSC ENGLISH MARCH 2020

HSC HINDI MARCH 2020

HSC MARATHI MARCH 2020

HSC MATHS MARCH 2020


SSC Maharashtra Board Papers 2020

(Std 10th English Medium)

English MARCH 2020

HindI MARCH 2020

Hindi (Composite) MARCH 2020

Marathi MARCH 2020

Mathematics (Paper 1) MARCH 2020

Mathematics (Paper 2) MARCH 2020

Sanskrit MARCH 2020

Sanskrit (Composite) MARCH 2020

Science (Paper 1) MARCH 2020

Science (Paper 2)

Geography Model Set 1 2020-2021


MUST REMEMBER THINGS on the day of Exam

Are you prepared? for English Grammar in Board Exam.

Paper Presentation In Board Exam

How to Score Good Marks in SSC Board Exams

Tips To Score More Than 90% Marks In 12th Board Exam

How to write English exams?

How to prepare for board exam when less time is left

How to memorise what you learn for board exam

No. 1 Simple Hack, you can try out, in preparing for Board Exam

How to Study for CBSE Class 10 Board Exams Subject Wise Tips?

JEE Main 2020 Registration Process – Exam Pattern & Important Dates


NEET UG 2020 Registration Process Exam Pattern & Important Dates

How can One Prepare for two Competitive Exams at the same time?

8 Proven Tips to Handle Anxiety before Exams!

BUY FROM PLAY STORE

DOWNLOAD OUR APP

HOW TO PURCHASE OUR NOTES?

S.P. Important Questions For Board Exam 2022

O.C.M. Important Questions for Board Exam. 2022

Economics Important Questions for Board Exam 2022

Chemistry Important Question Bank for board exam 2022

Physics – Section I- Important Question Bank for Maharashtra Board HSC Examination

Physics – Section II – Science- Important Question Bank for Maharashtra Board HSC 2022 Examination

Important-formula



THANKS