Ledger accoounts

No required to maintain bank ledger account seperately. But in case if you're maintaining accounts in Tally then bank entries should be maintained

Agreed

NOt required. bank statement is enough for the year.

It's a general practice to maintain bank ledgers ,since the inception of double entry book system, It will provide you quick access about balance in bank acs, and you don't need to get statement everytime ,the main reason is for BRS purpose ,you can track any discrepancy in bank statement only when you do proper recording of txn at your end .although it's not a prima facie evidence but help you internally ,else how you wu make position statement /BS

Thanks 

can someone tell me what is minimum amount of cash payment attract TDS  and what if patty doesn’t have PAN no if cash is made above limit 

You can pay upto 10000 rupees in cash above it will be disallowed

I fully agreed to Mr Chirag...
If maintain bank book then we can easily check out BRS and it's uncleared transactions...

Hi 

I transferred my  ledger data on excel 

when I try to add formula to the entire Colom and row  of creditor ledger  (debit , credit , and opening balance ) it’s doesn’t work 

E.g.  opening balance - 1000  , purchase 5000 , paid 2000   If I drag entire colum and row 

 

I 

Since your query is not clear, but I understood you would like to know the ending balance of creditor in excel, also note creditor always has credit balance ( except in case of overpaid /retuns / or any charges owed by him to you/ business), For your query, you can just add simple formula, of by selecting the requisite cell by +/- sign, just for example if your opening balance ,purchases and paid cell is B1,C1,D1, then in cell E1 you have to use following formula ( =B1+C1-D1),that's it you will balance reflects which Rs. 4000 credit balance, ( copy paste it for all below cell), dragging rows will work if you use (-) before paid, then in cell E1 you can use =sum(B1:D1) ,if you have big data say, 100s of accounts than you can also use excel pivot to get the data, but before that you have to use negative sign before Payment, index + match or vlookup can also be used to get account specific details, filters and slicers may also used... if you are using sum formula with negative sign then you can use Iferror also or if you forget to add negative before paid, then (if) may helpful like =If(D1>0,"",sum(B1:D1)) like that.. hope it helps

Thank u very much u made it very easy 

I have few queries on TDS 

when the TDS return is filed ( quarterly half yearly or annual)

what rate TDS to b deducted and what is the lower limit set for TDS 

and what if we make payment and person eligible for TDS and doesn’t have PAN 

TDS should be filed quarterly.

TDS should be deducted as per the nature of payment and as per applicable rates per payment.

If person doesn't have PAN then TDS should be deducted @ 20% irrespective of nature of payment.

TDS should be filed quarterly.

TDS should be deducted as per the nature of payment and as per applicable rates per payment.

If person doesn't have PAN then TDS should be deducted @ 20% irrespective of nature of payment.

TDS should be filed quarterly.

TDS should be deducted as per the nature of payment and as per applicable rates per payment.

If person doesn't have PAN then TDS should be deducted @ 20% irrespective of nature of payment.