The Stale Cheques/Instruments report provides the details of Bank-wise Total Amount and Count of Stale Cheques/Instruments. To filter the transactions in this report, by default 6 months has been set as Validity Period for Cheques/Instruments. The Stale Cheques/Instruments report displays the instruments for which the Validity Period has been exceeded, by comparing Bank Date with Instrument Date of the transactions.
To view the Stale Cheques/Instruments report
● Go to Gateway of Tally > Analysis & Verification > Data Analysis > Stale Cheques/Instruments .
Note: This report can also be used to list the transactions which are not cleared with in the specified Validity Period.
In Stale Cheques/Instruments report, a facility has been provided to change the Validity Period. To change the validity period click F6 : Validity Period or press F6 .
The Validity Period screen is displayed as shown below:
You can define Validity Period as Months or Days. When the period selected is Months, validity is restricted to 12 and 365 for Days.
Note: The changed/altered Validity Period for Stale Cheques will be retained till you navigate to the Data Analysis dashboard (Main screen). After navigation out of Data Analysis dashboard, the Validity Period will again get set to the Default Period - 3 months.
To view the ledger wise Stale Cheques/Instruments report
● Select a Bank and press Enter .
The above report displays the details of the Stale Cheque/Instrument transactions along with Voucher Type, Voucher Number, Transaction Value, Instrument Date, Bank Date, Age by Days, Verification Status and Verification Note.
The Age by Days is the difference between the instrument date and the bank date. Any cheque which exceeds the validity period will appear in this report.
Click F1 : Condensed or press Alt+F1 keys to view the condensed Stale Cheques/Instruments report.
Click F2 : Period or press F2 to change the selected period.
Click F5 : Reconcile or press F5 to reconcile the cheques/Instruments by specify the Bank Date if the vouchers are not reconciled.
Click F8 : Show Ledger or press F8 to display the default Ledger Vouchers report for the selected Bank along with the details of the Opening Balance, Current Total and Closing Balance.
Click F9 : Verify or press Alt+F9 to verify the selected vouchers.
Note: The F9 : Verify button will be highlighted only when one or more vouchers are selected for verification using the Spacebar key.
Click Ctrl+F10 : Remove Verify or press Ctrl+F10 to change the Verify Status for the selected vouchers as not verified.
Click S : Set Manual Sampling or press Alt+S to mark the selected Vouchers (using spacebar) as sampled. The manual sampling method will get applied to all such Vouchers and they will appear under the sampled column on the dashboard.
Click D : Delete Manual Sampling or press Alt+D to delete the Manual sampling method already applied for the selected Vouchers (using the Spacebar).
Click W : Working Note or press Alt+W to specify the working note details at Company or Group or Ledger or Voucher level. The details provided in working note will be captured in Working Paper along with the details of User Name, Working Note Date and Time, Status, Note and so on.
To view the Working Paper during analysis, click Ctrl+W : Wkg Paper or press Ctrl+W . The details displayed in Working Paper will be relevant to report from where it is triggered.
Click F9 : Inv Reports or press F9 to navigate to the default Inventory Reports.
Click F10 : Acc Reports or press F10 to navigate to the default Accounting Reports.
Click F10 : Analysis Reports or press Alt+F10 to navigate to the other Analysis Reports.
Click F12 : Configure or press F12 to change the default view for the above report.
● Show Narrations also : Set this option to Yes to display the Narration entered by the Client during the Voucher entry.
● Define Validity Period Valid for : In this field alter the valid for period for the bank selected, by defining the validity period as months or days.
● Show Transaction Type : Set this option to Yes to display the Transaction Type - Inter Bank Transfer, Cheque deposit etc selected during voucher entry.
● Show Instrument No : Set this option to Yes to display the Instrument Number entered during Voucher entry/reconciliation.
● Show Verification Status : Set this option to Yes to display the Verification Status as selected by the user during the verification. This option is set to Yes by default.
● Show Verification Note : Set this option to Yes to display the Verification Note as entered by the user during the verification. This option is set to Yes by default.
● Show Client's Clarification : Set this option to Yes to display the Clarification Note entered by the user for the Vouchers marked as Need Clarification by the user.
● Show Date and Time : Set this option to Yes to view the date on which, and time at which, clarification was provided for the listed Vouchers.
● Show Verified By : Set this option to Yes to view the person who has performed analysis on the Vouchers.
● Show Clarification from : Set this option to Yes to view the user who has provided clarification, if any, for the Vouchers.
● Show Verification Status : Select a Verification Status and the vouchers that have been marked with the chosen Verification Status will be filtered and displayed.
● Sorting Method : Select the required sorting method -Alphabetical, Amount-wise or No of Days Delayed, for the transactions from the list of Sorting Methods.
Click F12 : Range or press Alt+F12 to use the Range Filter option to search the specific vouchers from the list of vouchers under each Voucher Type.
Click Ctrl+F12 to filter the vouchers and calculate the balances as per the specified conditions.