Tally Accounting
Posted by Asok K Nadhani on

Outstanding Bills Reports in Tally

Outstanding Bills Statements in Tally

Bill Reference is used to track open accounts (Bill References which has not yet squared up). A NEW Reference is created when a new Bill is created, All subsequent transactions related to the Reference are marked as AGAINST Ref, linking the earlier reference created. Until the reference gets squared up, the Balance against the reference is tracked (referred as Open Account or popularly as Open Bill)

Outstanding Bills Statement lists the details of Open Bills (Receivables & Payables). This is very useful to track and manage the Open Bills.

Reports relating to Outstanding Bills (Open Bills), commonly referred as Statement of Outstanding Bills , comprise of  Statement of Accounts Receivables (Open Bills for which amount is receivable by Creditor from Debtor, in the books of Creditors) & Payables (Open Bills for which amount is Payable by Debtor to Creditor, in the books of Debtors).

Outstanding Bills Reports Menu in Tally

All the reports related to Open Bills and their summary / analysis reports are placed under Outstandings Menu.

Outstanding Bills Reports Menu in Tally

Select Display > Statement of Accounts> Outstandings to get Party Outstandings Menu providing for following outstanding Reports.

  • Receivables menu gives you Reports for all Accounts receivables (from Customers)
  • Payables menu gives you Reports for all Accounts Payables (to Suppliers).
  • Ledger menu gives reports of outstanding reports of a selected Ledger Account of  Customer/Supplier. 
  • Group menu gives reports showing consolidated figures all ledger accounts of a selected Group Customer/Supplier.  

OverDue Bills Reports in Tally

OverDue  Bills Reports may be obtained through the respective Outastanding reports. However, they may also be quickly accessed through Exceptions Reports menu (Display>Exception Reports )

Overdue Bills Reports Menu in Tally

Bills Outstanding Reports Contents in Tally

The Bill Outstanding Report shows following principal info depending upon the various configuration options set.

  • Opening Amount : Showsoriginal bill amount (opening balance in case of previous year’s open bill) in a separate column, apart from the Pending Amount. This column appears when you set Yes at Show Opening Amount. Set No to hide the Opening Amount of the Bill.
  • Pending Amount : This column shows outstanding balance of the bill, as on the report end date.
  • Due Date : This column shows the Due Date of the Bill as per Credit days (Bill Date + Credit Days).
  • Age of Bill in Days : Shows the Number of days elapsed from the Due Date (when No is set at Show Overdue using Bill Date) / Bill Date (when Yes is set at Show Overdue using Bill date)
  • Final Balance : It shows the amount due after considering the Post Dated Cheques. This column appears when Yes is set at Include Post dated Transactions

The  reports give details of outstanding figures carried from previous period and all transactions during the report period, with balances in respect of each Bill Reference.

The contents, configuration options and buttons at both Receivable & Payable Reports are similar.

Outstanding Bills Report in Tally

Outstanding Bills Reports Printing in Tally

At Outstanding Bills Reports Display, click P:Print button to get Outstanding Reports Printing screen showing printing options similar to Display Configuration options. Set the options and type Y to get the Outstanding Statement in Print.

Outstanding Bills Reports Display Configuration in Tally

At Outstanding Bills Reports Display, Click F12:Configure to get respective Outstanding Bills Reports Display Configuration screen, to set the configuration options as follows :

Outstanding Bills Reports Configuration in Tally

At Outstanding Reports Configuration, set the options as described below.

– Post Dated Cheques : To show / hide the Post dated Cheques not yet deposited to Bank (mostly the dealers pay post dated cheques – cheques dated on due date of the Bill / mutually agreed date of payment.
The post dated cheques are banked on the cheque date only). Though in the books, the post dated cheques are not accounted for, this is Important from the view of reminding the Debtor for payment.
By paying a post dated cheque, though no real payment is made, but the Debtor is not expected for reminding in respect of outstanding appearing in the books, for which the post dated cheques are received.   

– At Include Post dated Transactions:,

  • Set Yes atto show the amount of post-dated vouchers also in a separate column (Post Dated Amount), against the related reference, at Final Balance column, showing the amount due after considering the Post dated Cheques
  • Set No  to get columns for Due Date of the Bill & Age (overdue period) of the Bill till the Report End Date

– Opening Amount : At Show Opening Amount, set Yes to show the original bill amount (opening balance in case of previous period’s open bill) in a separate column, apart from the Pending Amount. Set No to hide the Opening Amount of the Bill.

– Overdue Basis : At Show Overdue using Bill date, Set Yes to compute overdue days from the bill date (without considering the due date / credit days). Set No to compute overdue days from due date (Bill Date + Credit days)

– Open Bills Type : At Range of Bills to Show, select, Pending Bills to list all outstanding bills (whether due or not), select Overdue Bills to list only overdue bills (outstanding bills whose due date is within the report period)

– Quantity Details: This is relevant only when Inventory is activated and Stock Item quantity are entered in the Invoice. At Show Quantity Info at Detailed Format, set Yes to show the Quantity figures in Detailed format (or click F1:Detailed button at vertical button bar in the report display screen). Set No to omit Quantity details

These options are common to various reports available in Outstanding Reports menu

Outstanding Bill reports Buttons in Tally

Set the Outstanding Bills Reports buttons , as required :

  • F1: Detailed / Condensed : To switch between Condensed  / Detailed mode. Click Detailed button to see all the vouchers related to the reference
  • F4: Payable/ Receivable : To switch between Payable / Receivable Report
  • F6: Agewise : To show Age Analysis Report

Outstanding Bills Reports button Bar in Tally

These buttons are common to various reports available in Outstanding Reports menu

Outstanding Bills Age Analysis in Tally

Outstanding Bills report shows list of  Outstanding Bills. Outstanding Bills Age Analysis Report is a compact view of Outstanding Bills, analysing the Outstanding into several convenient age slab, for better control and management of Receivables & Payables, as per Aging Slab set.

Outstanding Bills Age Analysis Display in Tally

Outstanding Bills Age Analysis Report Set Up in Tally

To set up the Age Analysis slabs of Outstanding Bills, at Outstanding Bills report, Click F6: Agewise button to first specify the Ageing Method:

Outstanding Bills Ageing Method set up in Tally

Outstanding Bills Ageing Slab set up in Tally

 After selecting Ageing method , at Company Ageing Analysis screen , specify the Slab period in days, to create multiple age slabs for better control of outstanding.

  • Ageing Slab beginning value : At From field, enter the start days value of the Slab. The first slab will start from zero value
  • Ageing Slab end value  : At To field, enter the end value of the Slab. The last slab will have zero value (but represents any higher value) to indicate termination of Age Slab

Outstanding Bills Ageing Slab set up in Tally

This way, create multiple slabs for each slab range (e.g. From 0 to 30, 30-45, 45-60, 60-90, 90 to rest of days.). At last line enter 0 to end and Press Yes to show the Bill Receivable Report with specified columns for each slab.

The Ageing period (i.e Aging Slab) as specified applies to all Parties for both Receivable/Payables, until you change again. So, next time, when you print any Age Analysis report, the Age period as set by you will be carried as default, which you may change again. This helps you to dynamically set Ageing period.

Restrict the Ageing Periods in 3-4 slabs only, otherwise the Ageing report will be too wide to view in one screen and you will have to pan the screen sideways to see all the slabs.

Outstanding Bills Age Analysis Report Display in Tally

Having set the Ageing Method  & Age Slab, you get the Age Analysis Display  as per Aging Method & Age Slab set.

Outstanding Bills Age Analysis Report Configuration in Tally

At Age Analysis Statement Display , click F12:Configure to get Age Analysis Configuration screen, similar to Outstanding Reports Configuration  to set the Configuration options.

Outstanding Bills Age Analysis Report Buttons in Tally

At Age Analysis Statement Display, you get Buttons similar to Outstanding Reports

Outstanding Bills Age Analysis Statement Printing in Tally

At Age Analysis Statement Display , click P:Print button to get Outstanding BillsAge Analysis Printing screen, showing printing options similar to Outstanding Report Display Configuration screen.

Set the options and type Y to get the Age Analysis Report in Print similar to Age Analysis display

Multi Part Outstanding Bills Age Analysis Statement Printing

If too many slabs are specified, the report may be too wide and extend to multiple parts (see Report Print Preview for each part)

You may first preview the Print Preview of Age Analysis Report and then print each part of the report separately, as described earlier

Party Outstanding Bills Statement in Tally

The Age analysis Report shows separate statement of Receivables or Payables in respect of all Parties. This is useful to get the status of Receivables / Payables form all Parties for Financial Management.

Party Bills Outstanding Report (or Ledger Outstanding Report) shows the Receivables & Payables (both)  in respect of a selected Party. So, it is more useful to track a Party for outstanding Bills, and follow up the party to clear the open accounts.

Party Outstanding Bills Statement Display in Tally

At Outstanding Menu, select Ledger and then select a Party Ledger Account to get the Ledger Outstanding Report for the selected Party.

Party Outstanding Bills Statement Display in Tally

Party Outstanding Bills Configuration in Tally

At Party Outstanding Display, click F12:Configure to get Party Outstanding Bills Configuration screen,  similar to Outstanding Statement Configuration screen, to set the following options :

  • Post Dated Cheques : At Include Post dated Transaction, set Yes  to show Post dated Cheque also. Set No to omit Post Dated Cheques
  • Overdue Bills : At Show Overdue using Bill date, Set Yes to compute the Overdue Days from Bill date. Set No to compute the Overdue Days from Due Date (Bill date + Credit Period).
  • Open Bill Types  : At Range of Bills to Show, select Pending Bills to show all Outstanding Bills (whether overdue or not), select Overdue Bills to show only Overdue Bills.
  • Bills Type : At Show Bills of Following Type, select All Bills to Show all Open Bills (whether due or  not), select Due Bills only to show  Open Bills which has become Due, select Over Due Bills to show  Over due Bills (Due date has crossed)

Party Outstanding Bills Configuration in Tally

Party Outstanding Bills Statement Buttons in Tally

Party Outstanding Bills Button Bar in Tally

  • F1: Detailed / Condensed : To switch between Condensed  / Detailed mode. Click F1:Detailed button to see all the vouchers related to the reference. Click F1: Condensed to show the net outstanding of each open reference
  • F4: Ledger: To select a Party Ledger Account from the list of Party Ledgers
  • F6: Agewise : To set up Age Slab and get Age Analysis Report
  • C : Contact : To view Contact details of the Party
  • B:Bills Settlement : To create Receipt / Payment voucher for Final payment

Party Bills Outstanding Bills Printing in Tally

At Party Outstanding Display , click P: Print button to get Party Outstanding Bills Printing screen showing the printing options, like Party Outstanding Configuration.

Party Outstanding Bills Printing in Tally

 At Party Outstanding Printing , set the printing options and then type Y  (at Print Y/N ?) to get the Party Outstanding Report in print

  • Post dated Cheques : At Include Post dated Transaction, Set Yes  to show Post dated Cheque also,
  • Report Form : At Print Reminder Letter,  set Yes to print the Outstanding Report in the form of Reminder letter. Set No to print outstanding report in normal format.
  • Parent Group : At  Show Group Name,  set Yes to print the Parent Group Name (just below the Ledger Name in parenthesis).
  • Overdue Method : At Show Overdue using Bill date, Set Yes to compute the Overdue Days from Bill date,  else the Overdue Days from Due Date (Bill date + Credit Period) is shown
  • Contact Details : At Show Contact Details, Set Yes to print the Contact details of each Party just below the Ledger name (useful for follow up)
  • Open Bill Types  : At Range of Bills to Show, select Pending Bills to show all Outstanding Bills (whether overdue or not), select Overdue Bills to show only Overdue Bills.
  • Format : At Format, Select Condensed to show the net amount of the Bill, select Detailed to show all the transaction related to the Bill.
  • Bills Type : At Show Bills of Following Type, select, All Bills to Show all Open Bills (whether due or  not), select Due Bills only to show  Open Bills which has become Due, select Over Due Bills to show  Over due Bills (Bill due date has crossed)

Party Outstanding Bills in Print in Tally

Party Outstanding Bills reminder Letter in Tally

AtParty Outstanding Printing screen, set Yes at Print  Reminder letter to Print Party Outstanding Reminder letter, showing the details of Bills Outstanding for the selected Party, in  a letter form, to send to the respective Party individually.

It shows the details of outstanding bills as shown in Party Bill outstanding report. Further, it also shows a summary of opening outstanding, summary of transactions, summary of Post Dated cheques, summary of On Account Payments.

Thus it gives a complete picture of party accounts in one consolidated statement.

Party outstanding Bills Reminder Letter printing in Tally

Party Outstanding Bills Age Analysis in Tally

Like Age Analysis Report, which shows Age Analysis of  Outstanding Bills of all Parties, Party Outstanding Bills Age Analysis shows Age Analysis Statement of a selected Party.

So, Party Agewise Analysis Report is another view of Party Outstanding Bills, analysing the Outstanding into several convenient age slab, for closer control and management of Receivables /  Payables in respect of each Party.

Party Outstanding Bills Age Analysis Display in Tally

At Party Outstanding Bills Statement, click F6: Age-wise to get the Age Analysis report. You may set Ageing Method, Ageing Slab as described for Age Analysis, to get the Party Age  Analysis Report.

Party Outstanding Bills Age Analysis Display in Tally

Party Outstanding Bills Age Analysis Configuration

At Party Age  Analysis Report, click F12:Configure to get Party Age Analysis Configuration screen, similar to Outstanding Display Configuration screen

Party Outstanding Bills Age Analysis Buttons

At Party Age  Analysis Report, you get Buttons similar to Outstanding Display screen

Party Outstanding Bills Age Analysis Printing

At Party Age  Analysis Report, click P:Print button to get Party Age  Analysis Printing screen, showing printing option similar to  Party Age  Analysis Configuration screen. Set the printing options and type Y to get Party Age  Analysis Report in print.

Party Outstanding Bills Age Analysis Reminder

Like Party Outstanding Reminder, at Party  Age Analysis Printing, you may set Yes at Print Reminder Letter to print Party Age Analsyis Reminder, in letter from, showing the Agewise Analysis of ecah otstanding Bill.

Account Group Outstanding Bills Statement in Tally

In Outstanding Report, you get the Outstanding Statements in respect of All Parties. In Ledger Outstanding Report, you get the Outstanding Statements in respect of a selected  Party. The Account Group Outstanding Bills report gives report for Parties for a selected Account Group

If the Parties are numerous, then often the Parties are divided into several Groups / Sub Groups. For example, Area / Zone wise (viz North Zone, South Zone, District A, District B, etc), Registration status wise , e/.g Registered parties, Unregistered Parties, etc, or a combination of them.

The advantage of Account Group Outstanding is that you can get separate outstanding Reports for each such Group / Sub Group, and a collective reports in respect of the Parties belonging to the selected section (Group / Sub Group).

Account Group Outstanding Bills Display in Tally

To get Outstanding Bills of a specified Account Group, Select Display > Statement of Accounts > Outstandings > Group. Select a Customer / Supplier Account Group to get outstanding list in respect of all subordinate Groups & Party Ledgers for a selected Accounts Group

Account Group Outstanding Bills Display in Tally

Account Group Outstanding Bills Configuration in Tally

Account Group Outstanding Report Configuration in Tally

At Account Group Outstanding report, click F12: Configure to get Account Group Outstanding Bills Configuration screen to set the options :

  • Open Bill Types  : At Range of Bills to Show, select Pending Bills to show all Outstanding Bills (whether overdue or not). Select Overdue Bills to show only Overdue Bills.
  • Balance Type : At Show Nett Balances , set Yes to show the net balance (Net Dr / Cr) of all child ledger accounts of the selected Group. Set No to show both the Debit & Credit Balance separately in respect of the subordinate Parties / Groups
  • Contact Details : At Show Contact Details, set Yes to print the Contact details of each Party just below the Ledger name (useful for follow up). Set No, the contact details are not printed in the Report.
  • Expand all levels into Detailed Format : At Expand all levels into Detailed Format, set Yes (in Detailed Format) to show all the transactions in respect of the Open Bill. Set No  to show Balance Amount only in respect of the Open Bill.

Accounts Group Outstanding Bills Buttons in Tally

At Account Group outstanding report, you get the following buttons

Accounts Group Outstanding Bills Button Bar in Tally

  •  Select Condensed to show the net figures for each Group. Select Detailed to show the details of each Party.
  • To select an Account Group
  •  Toggle button to show Groupwise / Alphabetical Ledger Name wise report.
  • To define Age Slabs and print the Age Analysis Report for the Account Group
  • Toggle button to get Report in sequence of Bill Numbers / Partywise Net figures
  • :Bill-Partywise / Summary : Toggle button to get Report in sequence of Partywise  Bill Number wise figures

Column Options : In summary reports (i.e when F7:Billwise  / F7:Summary option is selected), the various buttons to create columns are also available, to create columnar report with Multiple Period / Multiple Companies, for comparison.

Accounts Group Outstanding Bills printing in Tally

At Account Group outstanding report, click P:Print button to get Account Group Outstanding Printing screen , showing printing option similar to  Account Group Outstanding Configuration screen. Set the printing options and type Y to get the Account Group Outstanding Report in print.

Account Group Outstanding Bills Age Analysis in Tally

Like Age Analysis Reports, Accounts Group Age Analysis Report shows the outstanding bills  in respect of all Account Groups / Ledger Accounts under the selected Account Group.

Account Group Outstanding Bill Age Analysis in Tally

  • At Account Group Outstanding report, Click F6: Agewise button. Set the Method of Age Analysis and Age Analysis Slab as explained in Age Analysis Report to get Account Group Age Analysis report, as per Age Slabs set.
  • At Account Group Age Analysis Report, click F12: Configure to get Account Group Age Analysis Configuration screen, similar to  Account Group Outstanding Report Configuration.
  • Buttons : At Age Analysis Report , you get buttons similar to  Account Group Outstanding Report Buttons
  • At Account Group Analysis Report, click P:Print button to get Account Group Age Analysis Printing screen, showing printing option similar to  Account Group Age Analysis Configuration screen. Set the printing options and type Y to the Account Group Age Analysis Report in print, with contents similar to Account Group Age Analysis Display .

Multi Account Outstanding Bills Statements in Tally

Multi Account Outstanding Bills Statement menu provides bulk Printing of Bill Outstanding & Age Analysis Reports for several Accounts (Account Group / Ledger) at a time..

Multi Account Bill Outstanding Menu in Tally

Select Multi Account Printing > Outstanding Statements to get Multi Account Outstanding Reports Printing Menu, with options similar to Outstanding Reports under Display.

Multi Account Bill  Printing in Tally

  • Multi Account  Receivables : At Multi Account Outstanding Reports Printing Menu, select Receivables to get Multi Account Receivables printing screen.
  • At Multi Account Outstanding Reports Printing Menu, select Payables to get Multi Account Payable printing screen

The options are similar for Receivable & Payables Reports

Multi Account Party Bill Outstanding in Tally

From Party Oustanding Display, you can print Bills Outstanding of only one Party Ledger account at a time, However, from Multi Account Party Ledger Bill  Outstanding, you may print Party Outstanding of a number of selected Parties in one go.

At Multi Account Outstanding Reports Printing Menu, select Ledger to get Multi Account Ledger Printing Menu, select One Account to print a selected ledger Account, select All Accounts to print All Ledger Accounts, or select Group of Accounts, to print All Ledger Accounts of one Account Group.

Multi Account Party Ledger Bill Outstanding Printing in Tally

At Party Ledger Accounts Printing screen, set  the options, many of whicgh are quite similar to Party outstanding printing screen:

  • Enter the starting date (at From) & Ending date of Report (at To), (or leave blank to start from the Accounts beginning date)
  • At Include Post dated Transaction, set Yes  to show Post dated Cheque also,  else set No to exclude Post Dated Cheques
  • At Print Reminder Letter, set Yes to print the Outstanding Report in the form of Reminder letter, else set  No to print in Normal Outstanding Report Form
  • At  Show Group Name, set Yes to print the Parent Account Group Name  also (just below the Ledger Name in parenthesis).
  • At Show Overdue using Bill date, set Yes to compute the Overdue Days from Bill date, else Overdue Days would be computed  from Due Date (Bill date + Credit Period).
  • At Show Contact Details, set Yes to print the Contact details of each Party just below the Ledger name (useful for follow up)
  • At Range of Bills to Show, select Pending Bills to show all Outstanding Bills (whether overdue or not). Select Overdue Bills to show only Overdue Bills.
  • At Format Select Condensed to show the net amount of the Bill, select Detailed to show all the transaction related to the Bill.
  • At Show Bills of Following Type, select  All Bills to Show all Open Bills (whether due or  not), select Due Bills only to show  Open Bills which has become Due, select Over Due Bills to show  Over due Bills (Bill due date has crossed)
  • At Start fresh page for Each Account , set Yes to start  each ledger account in a new page only (leaving the blank space of the page). This is useful when you distribute the Ledger Outstanding report to Parties.

The contents of Multi  Account Party Ledger Outstanding is similar to Party Ledger Outstanding printed from Display

Multi Account Party Outstanding Bills Reminder in Tally

To track and follow up the customers to pay their outstanding dues, you may Print Party Outstanding Bills Reminder, a letter like report for a Party. The contents are similar to party Age Analysis with some text embedded in it. This letter is then sent to respective Party urging them to pay outstanding bills.

At Multi Account Ledger Printing screen, set Yes at Print Reminder Letter) to print Party Outstanding Reminder .

Outstanding Bills Reminder Letter Printing in Tally

Multi Account  Group Outstanding Bills Report in Tally

At Multi Account Outstanding Reports Printing Menu, select Group to get Multi Account Group Printing screen. Set the report period and set other options, similar to Account Group Display Configuration to Print Account Group Outstanding Bills Report for all the Parties under the selected Account Group.

Multi Account Group Outstanding Bills  Report in Tally

Click here to see PDF