How to import data from Excel to CheqMate?

Tutorial 2

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.

import data file format

Click here to download “customer payments” sample csv file

Importing data using CSV file format is easy and fast. The column order is as follows;

  1. Date
  2. Payee
  3. Amount
  4. CheqNo
  5. Crossed
  6. Account No.
  7. Remarks

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.

Sharing with your network!

Leave a Reply

Your email address will not be published. Required fields are marked *