This is also part of the Bulk Printing process of ChequeMan. The common features will apply to this which has been explained under Overview. Using this module you can import data from an Excel sheet for bulk printing of cheques.

In order to do this, select from the Menu

Excel Bulk Printing - Step 1

The following screen will be displayed:

Excel Bulk Printing - Step 2

Provide a unique name for the List that will be imported in the field labeled ‘List Description’. To import the excel click on browse and select the Excel file from your local system and after excel file is selected click on the button . The limit for the number of records that can be imported in a single lot is 100. The data in the Excel sheet must be provided in a structured format, which can be downloaded by clicking on .

After the data is successfully imported, the payees with the corresponding amounts are displayed in the grid. You have the option to change the Cheque Amount.
Before proceeding to the next screen, you should properly check the Payees and the corresponding Cheque Amounts as these cannot be altered in the subsequent steps. The* ‘Status’* column by default is empty. If part of the data has already been printed, the ‘Status’ column for the relevant rows will display ‘Printed’. This would imply that the rest is still in queue for printing.

Excel Bulk Printing - Step 3

Once you are ready, click on the button ‘Next’ and the next screen appears as shown below:

Figure - Excel Bulk Printing – Step3

Select the Account and the Cheque Book ID (this is identified as the starting Cheque No. and the date of receipt of the Cheque Book) against which the cheques need to be printed. The Default Date for Cheques is taken in as the current date which can be modified.

The number of grid rows in the grid is limited to the least of the following:

  • available number of cheque leaves on the cheque book
  • the total number of cheques to be printed for the Batch
  • total number of grid rows as set up in the menu Utilities – Preferences

The grid contains the following columns:

Cheque No. : The Cheque No. is already displayed. It is recommended to physically verify its presence in the Cheque Book before proceeding further.

Payee Name : The name of the Payees as carried forward from the previous screen is displayed here.

Cheque Amount : The amounts as specified for each payee is carried forward here and displayed.

Cheque Date : This is the default date value as specified above the grid. The cursor does not wait here. In case you want to change the date, take the cursor on the cell and click to make changes.

Remarks : This field is optional to record any remarks against the cheque for future reference.

A/c Payee : This is the Account Payee flag which if checked will accordingly print on the cheque. In case you wish to remove this, click on the cell and remove it. If you wish to permanently remove this status for a Payee, it can be done from the menu option Setup – Payee Details.

Now you are all set to print the cheques.

Other features & Options

List of Previous Cheques
By clicking on this all the previously issued cheques from this account can be viewed.

View Cheque Design
One can click on the button to check if the correct design has been mapped to the Cheque Book. There is also an option to test print to check out the print parameters.

Calculator
In case for any help in arithmetical calculations, click on the icon

Totals
The total amount of all the cheques populated in the grid is displayed at the bottom of the grid for reference and verification.

The bottom of the screen has buttons which are explained in details below:

Print Preview : To preview the cheque details that have been super-imposed on the scanned cheque image, click on this option. It gives a fair idea as to how the printed cheque will appear. However, it should be noted that minor difference is possible. The display window has scroll buttons to view cheques one by one with options to move to first or the last cheque.

Print Cheques : Place the Cheque leaves on the printer in the correct order and direction, and then click on this button. After confirming in the subsequent dialogue box, the cheques are printed.

Back : On clicking this, the control is shifted to the summary of the print queue.

Cancel : After selecting information on the header, the information on the grid is displayed pertaining to the selected Cheque Book. The header information cannot be altered once the grid is displayed. Click on ‘Cancel’ which will again allow you to again select the Account, Cheque Book, etc. In case of change in the Cheque Book, the system allows to carry forward the data in the grid (if any) to the grid for the new Cheque Book.

Exit : The control is shifted to the main screen of the software.

Verification & Confirmation of proper printing of Cheques

After the ‘Print Cheque’ command is given, subsequently, in the next interface screen a grid appears containing the cheque nos. used for printing with corresponding details as provided in the previous screen. This interface is illustrated below:

Excel Bulk Printing - Step 4

For each Cheque on the grid – there are three possibilities:

  • If the Cheque is printed successfully then the print status will be ‘Printed’
  • If the Cheque is damaged while printing then the print status will be ‘Damaged’
  • If the Cheque is not printed at all then the print status will be ‘Not Printed’

Now, specify the status of cheque printing under the column ‘Print Status’ as displayed in the screen above. By default ‘Printed’ is selected assuming that in most cases cheques is print successfully. After confirming for each cheque, click on .

If cheques are still present in the queue, you are again back to the previous screen for continue printing of the pending cheques in the same way.

Need more help with this?
ChequeMan - Support

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.