Cheque Register helps users to manage their cheque books for various banks, give information about Cheques which do not belong to any cheque range available and also the status of all the cheques. This report gives the values of the total number of cheques for each bank (Cheque Book wise), that are Available, Unreconciled, Reconciled, Blank and Cancelled.
The advantages of the Cheque Register:
User will know how many cheques are available for use.
Used cheques are classified as Unreconciled and Reconciled.
Unreconciled cheques can be reconciled from the Cheque Register itself.
Cheque Register has an option to Search for Cheque Numbers.
Report can be viewed either Bank-wise or Cheque Range wise or drill-down to Cheque numbers.
Users are allowed to change the status of cheques (Available) to Cancelled or Blank and make cancelled cheques available.
Report can be viewed period-wise, hence makes it easier to filter the cheques that are issued on particular date or during a particular period.
For more information, click on the links below:
To view the Cheque Register:
Go to Gateway of Tally > Banking > Cheque Register
The Cheque Register report screen will appear as shown:
The first level of the Cheque Register displays all the Banks and gives the number of total cheques which are Available, Unreconciled, Reconciled, Blank and Cancelled.
Users can drill down from any of the fields.
To view the break-up of the statics based on the Cheque Ranges, press F1: Detailed.
The period of the report can be changed using the F2: Period option.
Using F5: Reconcile button, users can go to the Bank Reconciliation screen for a particular bank.
To search for a particular cheque’s details, press S: Quick Search. Part of the cheque number can be used to search for a cheque. The search results will have all the cheques which have the search string as shown:
To view all the Cheques that belong to a particular status like Available, Blank Cheque, Cheque Cancelled, Reconciled and Unreconciled, irrespective of banks and Cheque Ranges, users can press Ctrl+S (Show All) and select the Status.
When Enter is pressed from a Bank, Cheque Register shows the statistics of all the Cheque Ranges of that bank, as shown:
When the cursor is on a Cheque Range, to reconcile the cheques that are used in that range, press F5 or click on F5: Reconcile. Tally.ERP 9 will list out all the transactions corresponding to the Cheques in that range that have to be reconciled.
S: Quick Search option can be used in this screen as well.
Ctrl+S (Show All) option can be used to view all the cheque numbers of a particular status, irrespective of the Cheque Ranges, for the selected bank.
To toggle between banks press F4 or click on F4: Bank button.
To view all the transaction details of all the Cheques in the Bank press F7 or click on F7: Transactions. All the details of every cheque for that bank will be displayed as shown:
Note: To view all the transactions of all the cheques in a particular range, press Enter from that range.
To view the cheques for a particular period, press F2 or click on F2: Period.
To toggle between the different Cheque Ranges in a bank from the same screen, press Ctrl+C (Cheque Range).
To reconcile the unreconciled cheques, press F5 or click F5: Reconcile.
Press Alt+F5 or click on F5: Status wise, to get a Status wise statistics of the cheque range.
To view all Cheques of a particular status, press F6 or click on F6: Status. A new screen will appear where user can choose among the different statuses of cheques.
To change the status of a cheque, select the Cheque Number and press Alt+A or click A: Alter Status. The status of Available cheques can be updated as Blank or Cancelled. The Status of Cancelled cheques can be changed to Available.
For Available Cheque Numbers, users can create a voucher from this screen itself. Press Alt+C or click on C: Create Voucher to record a transaction for a selected cheque number. The Payment Voucher Creation screen will appear, where you can record the transaction.
Note: This option will be highlighted only if cheques are selected.
For cheques that are already used and are not a part of any cheque range, users can define a Cheque Range in the Bank ledger, and can add these Cheque numbers to the new book (Cheque Range) created using the Alt+R (R: Refresh Range) option.
To change the status of a cheque from Cheque Register:
Select the Cheque Number and press Alt+A or click A: Alter Status.
The status of Available cheques can be updated as Blank or Cancelled.
The status of Cancelled Cheques can be changed to Available.
To update a cheque’s status as Blank,
The options Use Reversing Journals & Optional Vouchers and Allow Zero valued entries to Yes in F11: Features (F1: Accounting Features).
Select an Available Cheque Number and press Alt+A or click A: Alter Status.
Select Blank Cheque from Cheque Status as shown:
You will be taken to Payment Voucher Creation screen as shown:
The voucher will be marked as Blank Cheque.
User can change Voucher Number and Amount field. No other field is allowed to be altered.
If Amount field is left blank and the voucher is accepted, the status of the cheque in the Cheque Register will be Blank.
Once the value is entered in Amount field, the Blank Cheque tag will disappear. The status of the cheque in the Cheque Register will be Unreconciled.
To update a Cheque's Status as Cancelled,
Cancelling a Voucher will automatically change the Status of the Cheque(s) used in that voucher to Cancelled.
In case a new cheque has to issued for a transaction for which the issued cheque cannot be used due to various reasons like - lost in transit, torn cheque etc., the previously used Cheque has to be cancelled. You will have to follow the below procedure:
Go to Voucher Alteration screen of the Cheque which has to be cancelled, and change Cheque number
In Cheque Register, the status of Cheque number which was changed, will be under Available.
Press Alt+A or click on A: Alter Status, and select Cheque Cancelled, give a Date on which the Cheque was cancelled and enter the reason for cancellation in Remarks field.
Accept the screen. The Cheque’s status in the Cheque Register will be Cancelled.
To update a cheque’s status as Available,
Select a Cancelled Cheque Number and press Alt+A or click A: Alter Status.
A message - Reuse the Cancelled Cheque? will appear as shown:
Press Enter or click on Yes to reuse the Cancelled Cheque.
To configure the Cheque Register,
Press F12 or click on F12: Configure, the Configuration screen will appear:
The cheque numbers that are entered manually by the user and which do not belong to any Cheque Range can be brought to the Cheque Register report by setting this option to Yes. This way all the cheques used can be managed from a single place.
Cheque Books that are completely used, i.e., the Status of all the cheques is other than Available, can be ignored while viewing Cheque Register by setting this option to Yes.
Cheque Book Names defined in the Bank ledger can be viewed along with the Cheque Ranges by setting this option to Yes. This way it is easier to identify the Cheque Ranges.
