Maintain bill wise detail for receivable and payable in Tally

Dear Friends, You know very well about the Tally software and today we are talking about Maintain bill wise detail for receivable and payable in Tally. At present time Tally is one only most popular accounting cum inventory software that handles the day to day all routine operations of any business unit very effectively. It is widely accepted by the different accounts for its user friendly nature. Without using maintain bill wise detail for any receivable and payable you will not able to view bill wise details of sundry debtors and sundry creditors.

Tally provides different accounting and inventory features that allow any user to maintain his company accounts effectively. Today we talk about How to use Accounts Receivable and Accounts Payable Option in Tally. Accounts Receivables is the amount to be received from Sundry Debtors while’s  Accounts Payable is the amount to be paid to Sundry Creditors.

Must Read: How to use (BOM) Bill of Materials in Tally

Tally software provides complete bill wise information of amounts receivable as well as payable either Party wise or Group wise. This feature can track bills, payments/receipts including advances one-to-one.You have to take the following steps given below:

How to maintain bill wise detail for receivable and payable in Tally or Tally.ERP9 ?

Step 1. Press F11 (Company Features)- > F1 (Accounting Feature) -> Maintain Bill Wise
Details – YES.

Step 2. Now Create a Party (Ledger A/c) under the group ‘Sundry Debtors’ as well as one under group ‘Sundry Creditors’, and also activate ‘Maintain balances bill by bill’ for all the Parties while you are in Ledger creation mode.

Step 3. Make a Voucher Entry from ‘Gateway of Tally’ -> Select Sales or Purchase Voucher.
Now, while entering the transaction, the user can specify a Ref. no with due date for the amount or break it up by giving multiple ref no with different due dates. There are four types of reference given below:

Types of Reference

New Reference:

It is used when you make any purchases or sales entry.

Against Reference:

It is used when you have to pay or receive amount against credit bill.

Advance Reference:

Use this option when you paid or received amount as an advance from or to party. In other words, It is used in case of advance receipt or payment entry.

On Account:

It is used when you don’t have any idea of any bill wise detail.

Step 4. To view the reports follow the procedure given below:

Select ‘Display’ (in Gateway of Tally menu) -> Select ‘Statement of Accounts’ -> Select ‘Outstanding’ -> Select ‘Receivables’ (in case you want to see amount due to the company) -> Select any particular group. The report displays bill by bill outstanding for all parties along with the pending amount as well as the due date.

In case user wants to see the amount payable by the company then select the option ‘Payable’ under the menu ‘Outstanding’. The user, once he has selected either Payable or Receivables can toggle between the two reports by clicking F4 function key.

Step 5. For individual Party wise outstanding Report:

Select ‘Display’ (in Gateway of Tally menu) -> Select ‘Statement of Accounts’ -> ->Select ‘Ledger’ option under ‘Outstanding’. This report gives a bill-by-bill display of all outstanding for the concerned party along with the total outstanding amount.

For a display of total outstanding for all parties -> select ‘Group’ in the menu ‘Outstanding’ and then select any particular group or sub-group.

Step 6. Tally gives Age wise Analysis Reports and hence keeps the user informed for the range of period the bills have been outstanding. The user has the luxury of defining the Ageing periods as per his needs. e.g. 0 to 30 days, 30 to 45 days, 45 to 60 and so on. The procedure for displaying the report is given below. The aging analysis gives flexibility to do ageing by due date or bill date.

Select ‘Display’ (in Gateway of Tally menu) -> Select ‘Statement of Accounts’ -> -> Select ‘Outstanding’ under Display menu -> select ‘Receivables ‘ or ‘Payable’ press F5 (age wise) -> select method of ageing -> specify the periods.

Must Read: Debit Note and Credit Note Voucher with Vat, Rate Difference

I hope you like this Maintain bill wise detail for receivable and payable in Tally post. Give your important suggestions in comment box regarding this post. Thanks.

44 response on “Maintain bill wise detail for receivable and payable in Tally

  1. ikhlas

    Hello Sir ,
    please help me i am not getting bill wise bill details in purchase and sales voucher but it coming in receipt and payment voucher i want to make interest rates entry in sales but its not showing bill wise bill details i had on all the bill wise details option in ledger also and in activation also
    Tally erp9 vesion 5.4.8

    Reply
  2. chandara mohan

    dear sir
    i activated billwise details in feature and also in ledger creation still it is not coming whilw making sales invoice. pl help me.
    thankyu
    chandra mohan

    Reply
    1. Amit Sharma Post author

      Dear Chandara Mohan

      First thanks for writing… During making entry in sales voucher you have to press Ctrl+V to change the mode then you will get billwise reference detail in Tally software.

      Reply
  3. Hiten Rajkotia

    Dear Sir,
    Tally shows Purchase Bills to come and sales bills to make , even my previous audited balance sheet shows difference in opening balance.
    what must have happened ?
    please guide me at the earliest

    Reply
  4. lingam

    Sir/Madam,

    On receivable report certain debtors details are not showing on the report though the debtors bills are not paid. Please advise.

    Lingam

    Reply
    1. Amit Sharma Post author

      Hi Lingam,

      If you watching the outstanding report of receivables from GOT> Display> Statement of Accounts> Outstandings > Receivables then you will get only those debtors list whose amount is due rest of the debtors detail does not shown from this report.

      Thanks for writing… I hope your problem resolved..

      Reply
  5. Dipti Shah

    Hi,

    How to Apply the bill by bill entries in one shot, as I have got 50 to 60 entries on both debit & credit side & want to apply in one shot.

    Reply
  6. vinu

    last year advance payment amount showing outstanding in this year. but ledger account showing zero balance. how to clear that outstanding amount

    Reply
  7. DJ

    I have not set maintain bill wise details and recorded all the entries for the year. Now I want to alter it and set bill wise details. How can I do this?

    Reply
  8. preeti

    sir custmer (debtor), ko bill dena hai pr kisi custmer ka pahale ka amount (priveus amu.) to kisi ne advance diye rahta hai to mai jounral me bill ki entri karu to in dono me se koi aye to kaise adjustment karu plz entri aur ledar,under bhi bataye

    Reply
  9. Pervez Mahmood

    Good Evening Dear Sir,

    I do hope to find you well.

    I have difficulty to manage bill wise clients & suppliers ledger where I activate multi-currency for clients & suppliers ledger. I already activate multi-currency & maintain bill wise details. I noticed if I kept clients & suppliers ledger in BASE CURRENCY then I can manage bill wise details without issue but when I change clients & suppliers ledger other than BASE CURRENCY then I’m unable to maintain bill wise details. Could you please explain how I can maintain bill wise details also in multi-currency enable ledgers?

    Thanks in advance for your support.

    Reply
  10. Priyanka

    Dear Experts,

    Please tell me ,I don’t have receipt s papers but who can i entry my expenses .
    Exe: Tea bill, Watchmen extra service bill ect..

    Reply
    1. Prince

      Just use the words as Bill Reference as:
      Tea bill, Watchmen, etc. etc.

      This way you can easily keep a Bill-by-bill status.

      Please confirm is your problem resolved or not.
      If NOT, please explain more about what is troubling you.

      Reply
  11. Abdul khadar TA

    Hi Expert,

    I have few queries in tally 9

    Sub : Advance Receipt and Its adjustment

    1-7-2016 I received advance AED 1000/- from customer , good not deliverd
    10-7-2016 Prepared invoice to credit value of AED 5000/-(invoice in the name of customer) and good deliverd
    22-7-2016 Received balnce amount fully AED 4000/-
    How pass entries and adujsment entry in Tally ERP ?

    Reply
  12. Hitesh

    Hi Expert,

    I have few queries in tally 9

    1. I have one sale entry which was on credit in the month of May 2016 and now there is sales return of 50% material in the month of July 2016 so I passed the credit note entry and ledger is not showing any balance. However when I checking the outstanding as receivables from display button it is still showing outstanding for which I have already passed the sales return entry in client ledger. Please tell me why because it is effecting the balance sheet values also by showing the particular amount as receivables.

    2. For the same entry I have query regarding it’s stock value. The actual value of stock is 520 at the time of sale but now it is not showing value as 520 instead it is showing as 233.3 something because of average price. I have kept stock valuation method as LIFO and Average Price. Please tell me how to modify the value of stock in the month of July 2016.

    Reply
    1. Amit Sharma Post author

      Hi Hitesh,
      First thanks for writing.
      First you have to turn on maintain Maintain bill by bill option from your party ledger account. If you don’t turn on this option you are not able to view the Outstanding receivable report.
      After do this you will get the proper report either in account or stock level. I hope your problem is resolved. Keep in touch… 🙂

      Reply
  13. janardan bhardwaj

    Sir
    Mera Readymade garment ka business he or me accounting ke liy erp9 ko lagu karna sahta hu lekin mere ko kuch chije samaj me nahi aa rahi he jese ki
    1. Mene 15150 ka rm garment karida udhar me or jub wo seller rupaye lene ke liy aaya to mene usko 15100 hi diye iss tarah mera 50 rupaye ka fayada ho gya iski entry erp kese karenge

    Waiting for ans

    Reply
    1. DHIRAJ

      YOU HAVE TO CREATE AN ACCOUNT DISCOUNT RECEIVED IN WHICH YOU SHALL ENTER THOSE BENEFIT RECEIVED

      Reply
    2. Amit Sharma Post author

      Hi Janardan,

      First of all thank for writing. You have to create a discount received ledger account under the Indirect Income and then make entry in the Receipt (F6) voucher which is given below:
      Dr. Party (Creditor) 15150
      Cr. Cash 15100
      Cr. Discount Received 50
      (Received discount against credit purchases via bill no……………..)

      Reply
  14. revathi

    dear sir,

    one problem for me , tally bill wise details pending bills last year bill no: 498 rs. 4000/- payment paid 4 month after received, but current year same bill no: 498 entered in part rs. 10500/-, but billwise datails view on overdue date for last year running in total days for till date , how can solve this problem ( but over due days for only running date )

    Reply
    1. Prince

      Hi Ms. Revathi, I think you can resolve this problem by a simple step:
      Suffix Bill Date with current year bill number.
      I.e., your bill number reference will look like this, if the bill date is 12-6-2016: 498/12-6-2016

      Please confirm your status.

      Reply
  15. Priyanka

    When I done bank reconciliation and after than how to I see cheque payment date with clearing date?

    Reply
    1. Roshan Jagyasi

      Respected Experts ,

      In Tally ERP9

      Whenever I Start to make bills entry of sales as voucher than it is accepting that… but as I do a entry as invoice it’s not accepting. It’s Suggesting ERROR ! OVERDUE BILLS OF RS…

      Sir please help look after this situation as soon as possible because due tho this my work is being stuck..kindly cooperate

      Thanks And Regards

      Reply
  16. Amit Sharma Post author

    Dear Bharti,

    If you doesn’t received the bill and party need advance payment then you must have to make payment entry and choose Advance reference during the entry:

    Dr. Sundry Creditor 25000
    Advance Adv 25000 Dr.
    Cr Bank 25000

    Reply
  17. abhijeet gogoi

    sir/madam
    Q/suppose the hotel room rental is 5000. and the we received 3000 as a advance payment from party. so what will be the entry for the pending amount receivable. please kindly state me the groups too.
    thank you sir

    Reply
    1. Mohamed

      Dear,
      In accounting,
      3000 will be consider as advance received it will be credit balance on customer ledger.

      once you make the invoice for 5000 for rental service under customer ledger, the rest will come under receivable debit balance otherwise the 3000 will remain as credit balance on customer ledger.

      Reply
  18. nabin

    Credit note makes a bill of outstanding?
    why? if i pay this payable bill the purchase amount increases.

    Reply
  19. nabin

    why credit note shows as bill outstanding in Tally erp9?

    please somebody help me.
    i will be really greatfull

    Reply
  20. Cedric Duarte

    I am not getting Supplier Invoice No. and date in Purchase Voucher entry. Only ref no. How do I get Invoice date if Voucher entry date and Invoice date is different.

    Reply
  21. Keddies

    I have found some Fixed assets which were purchased and payments were done on Proforma invoices ( advance Payments? and now i have also got Tax invoices. how do i get t clear the advance payments with the Tax invoices? coz i Made entry

    DR – Fixed asset account ……..inv 1234 new ref
    Cr – advance Account …….inv 1234 new ref

    This invoice is to clear the Entry

    Dr advance account Proforma 5555 new ref
    CR Bank Account Proforma 5555 new ref at time of entry

    Maintaning by bill wise, this makes me remaing with Invoice 1234 outstanding

    if I try to enter inv against proforma,, that lives me with no Invoice number entered in ref

    how do i Clear this kind of transaction and Entries..

    Reply
  22. Vishnu B N

    Dear Experts

    Plz clarify my problem

    In tally erp 9 im not getting receipt and payment, Banking option plz guide me as soon as possible…………….

    Thanks and Regards

    Reply
    1. Amit Sharma Post author

      Dear Vishnuji,

      If you are not able to get payment and receipt voucher in your Tally ERP9 then you must have to scan your computer with Antivirus and then again reinstall the Tally ERP soft. If you have same issue then write us…… again… We will definitely helps your.

      Reply
  23. NAVEEN GK

    ok you can proceed in that way.
    if you get any doubt regarding the FIFO basis you please contact the author.

    Reply
  24. saranya

    Sir I need a help ,
    I m in starting stage of tally erp9. While doing billwise entries I dont find the refrence dialog box. Already I changed the maintain bill wise details as YES in F11.what should I do???I did al changes in configuration.while selecting purchase entry debitor I dont find any dialog box coming for me??? Plz help me

    Reply
    1. Amit Sharma Post author

      Dear Saranya thanks for writing. You have to read step no: 1. Press F11 (Company Features)- > F1 (Accounting Feature) -> Maintain Bill Wise Details – YES.

      After that when you create or edit any party ledger account either Sundry Debitor or Sundry Creditor you will get the reference dialog box.

      Reply
  25. Prateek lunawat

    sir in my business i dont receive payment bill wise. bulk payment is received and i have to manually allot payment bill wise. I am trying to `do this in erp 9 but not finding any feature regarding this. I am hoping to set some FIFO base receipt system for my ledger accounts in tally so that i can see which bill date wise are due.

    Reply
    1. Amit Sharma Post author

      Dear Prateek, thanks for writing.

      In that situation you have to use on account reference facility. If you did not satisfy with first method then you have to change the payment voucher from GOT>Account Info> Voucher Type > Edit > Choose Payment Voucher and set the required option as per your need.

      I think your problem will be solved. If not then write us again…

      Reply
      1. seema tople

        dear sir,

        please talk to me how to make all partis sales pending bills in tally erp-9 mansion.

        Reply

Leave a Reply

Your email address will not be published. Required fields are marked *