If the cheque is not print accurately in intended places, you need to fine tune template margins. Here you can adjust print location of each element.
Each account has it’s own printing template. Most of the time when you setup a template for one bank account, you can apply the same settings for other accounts in the same bank. But some times, even in the same bank, different cheque books have different layouts. In this case, you need to adjust each account even in the same bank to match with cheque book layout.
Go to “Accounts”
Click on “Manage Accounts”
Click on the “Template” icon to access the account print template.
This is a very simple template. Every element of the cheque book has it’s own top and left margin. When you increase or decrease a value, that element moves. See the following example:
Example: To adjust the date;
To move the date up, decrease the top margin. Do it very little at a time (few decimals at a time).
To move the date down, increase the top margin
To move the date right, increase the left margin
To move the date left, decrease the left margin
This is apply for all elements. You only have to change few decimals to get the element move to the desired position.
When you done with one account template, you can easily apply the same settings for other accounts in the same bank. To apply another account’s settings, click on the drop down menu at the bottom of the template page under “Copy from Existing Template”. Select the account you want to import settings, click on the “Import” button. Current account template will be updated with the imported settings. Click on “Save” to save changes to the current template.
Please be noted that these templates are for the version 5.1 and up only. Older versions use different template settings.
Click on “Create rubber seal (Seal Setup)” button. You will take to a simple word editor program. Create your rubber seal in the editor. You can preview the seal upon saving the seal. This is a very simple word editor and you only can create basic rubber seals using this option. If your rubber seal is more graphical or complex, you cannot use this option.
Please be noted that the designer and preview is different. Click on “Save” to update the preview. What you see in the preview is the correct image.
You can add deposit to an account and get account report similar to bank reconciliation. Click on “Add Deposit” button to add a new deposit to the selected account.
Following details required in adding a deposit record.
Deposit type – here you can select Cash, Cheque or Other. You may select other for entering opening balance, other transfers to the account, etc.
Effective date – you need to select a date that this amount needs to be adding to the account. Generally for Cash and other deposits, this is the current date. For cheque deposits, generally this is the cheque date.
Remarks – you can save a special note here, such as “Opening Blanace”
After create account, click on “Manage Accounts” under “Accounts” menu. All accounts in selected bank shows here. There are six icons displayed for different actions.
Here you can add deposit to the selected account, edit account details, create or change rubber seal for this account, adjust print margins, get account deposits and payments report (account report) and view deposit report for the selected account.
After you create your banks, you can create accounts under each bank. You can have maximum of 100 accounts in total of all banks. To create a bank account;
Click on “Accounts” menu
Click on “Manage Accounts” in front of the bank you want to create an account
Click on “+Add New Account” button
Enter following details:
Account No – Enter the full account number
Account Name – Branch name or other name to identify the account purpose
Company – if you have more than one company profile, select the company this account belongs to;
Print with counter foil – Default option is “no”. If you want to print the cheque with the counter foil attached, select “yes” for this option.
Print company seal – default is “yes”. If you select this option, all cheques print from this account will print with company rubber stamp (director seal). You need to create this seal in another option under manage accounts. If you don’t want rubber stamp to be printed in all cheques, select “no” for this option.
Print A/C Payee Only? – default is “Optional”, means you can select whether you want to print “A/C Payee Only” or not at the time you write cheques. If you select “Mandatory” for this option, all cheques write from this account will have “A/C Payee Only” seal and you can’t write cheques without this.
A/C Payee Only (Additional Text) – If you want to include other terms such as “Valid for 60 days only, Not Negotiable”, etc., you can type those optional conditions here. One condition per line. These conditions will be printed below the “A/C Payee Only” condition.
A/C Payee Only Seal Color – If you are using a color printer, you can select “Red” or for other printers, this should be “Black”.
Full Date – if you want to print the full date in the cheque (including 20 in the year). Default option is “No” because most cheques comes with “20” printed in the date boxes. If your cheque book don’t have “20” printed in the date boxes, select “Yes” for this option.
Print Logo? – Default option is “No” means, your logo will not print on the cheque. If you want your company logo to print on all cheques of this account, select “Yes”. You should save logo in “Company Profile” for this option to work.
After entering all above details, click on the “Save” button.
Company profiles use to identify different companies or departments. If you have more than one company or different accounts are managed in different departments, you need this option. At least one company profile is need to operate accounts. A company profile includes following details:
Company Name – Enter the name of the company (this name will be used in payment vouchers)
Address – postal address, telephone and other details. These details will be used in the payment voucher.
Font size – Font size of all cheques write under this company. Default is 14. Recommended range is 12 –
Font type – Default font type is “Arial”. You can only use given font types. You cannot add other font types to this software. Only accepted and clear font types are included in the software.
Allow back dated cheques? – If you select “yes” for this option, you can write back dated cheques from this company. If you select “no”, you can only write on dated and postdated cheques from this company.
Logo – If you want to print your logo in cheques and payment vouchers, you need to add a logo. If you don’t want any logo in either documents, you can leave this option.
Payment voucher number – Enter the starting number of payment vouchers from this company.
To create a new company;
Click on “Settings” menu
Click on “+New Company Profile” button
Enter all details required
Click on “Save” button
How to edit a company profile?
Click on “Settings” menu
Click on “Edit” in front of the company you want to edit (Under company profiles)
This video explain how to import data from Excel to CheqMate? Using this method you can import data from Quick Book or any other accounting software to CheqMate.
CSV is the common file format use to export and import data between different software programs. Unlike XML (which is another format use to exchange data between software) CSV is more familiar to users, because it is basic Excel.
All you need to do is create an excel file according to the given format, fill data and save it as a CSV file. Then that CSV file can be imported in to CheqMate Pro software. The format of the excel file is given below with some sample data.
You can download this sample file using the link given below.
Importing data using CSV file format is easy and fast. The column order is as follows;
Date: is the date you want to print on the cheque.
Payee: is the name you want to print on the cheque.
Amount: is the amount of the cheque. Please don’t format it. It should be a plain number. 26000 is a valid number whereas 26,000.00 is not a valid format. Don’t include thousand separator or decimal places unless there are decimal values in the amount.
CheqNo: is the cheque number of the cheque.
Crossed: If you want to print the “A/C Payee Only” on the cheque, you need to put “Y” in the column, or put “N” to print nothing. You can not keep this column empty.
Account No: this is the most important column of all. This number should be matched with an account number created in the CheqMate software. Only accounts created under Accounts section in the CheqMate software is able to import data.
Remarks: you can put any description here to identify the purpose of the payment.