Report Options

Report options

Report Options

Using the report options (under “Report” menu), you can generate various type of reports.

report options

Company Option:

If you have more than one company profile, you can select the company you want to generate report. If you want to get a report for all companies, select “All” option.

Bank:

If you have more than one bank, all are listed here. To get a report for a specific bank, you can select the bank from this list. If you want to get a report for all banks, select “All” option.

Account:

After selecting a bank, all accounts in the selected bank listed here. To create a report for a specific account, select the account you want report. To get a report for all accounts, select option “All”.

Status:

When you write a cheque, its initial status is “Pending” means not paid (realized) yet. After making the payment from the bank, cheque status becomes “Paid”. If you cancelled a cheque, its status should be “Cancelled”. If your cheque returned, status should be “Returned”. You can update the status of a cheque after creating a report.

Date Type:

System records two date types for a cheque. The date cheque is saved (written) in the system and the date of the cheque (cheque date). To get a report for all the cheques written in a specific date range, you should select “Written Date”. To get a report for all the cheques according to cheque date, select “Cheque Date”.

Date Range:

Select the date rage you want your report.

Payee:

If you want to get a report for a specific supplier (saved in suppliers list), you can select the supplier here. To get a report for all suppliers, leave this option blank.

After selecting required filters, click on Next button to view the report according to your selected options.

Account and Deposit Reports

Account and Deposit Reports

Account Report

This report shows all deposits (credits) and payments (debits) from your account for a given period.

  • Click on “Accounts”
  • Go to “Manage Accounts”
  • Click on “Deposit Report” icon
  • Give a date range for the report and click on “Submit” to view the report

Deposit Report

This report shows only deposits to your account for a given period.

  • Click on “Accounts”
  • Go to “Manage Accounts”
  • Click on “Account Report” icon
  • Give a date range for the report and click on “Submit” to view the report

How to adjust print margins?

How to adjust print margins

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.

normal printer template

template for laser printers

Please be noted that these templates are for the version 5.1 and up only. Older versions use different template settings.

How to print the rubber seal on a cheque?

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.

print seal

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.

How to edit account details?

How to edit account details

If you want to edit any account details you entered during creating an account, you can change all options by clicking on “Edit” button in “Manage Accounts”.

  • Click on “Accounts” menu
  • Click on “Manage Accounts”
  • Click on “Edit” button to edit account details.

 

Add deposit to an account

Add deposits

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.
  • Amount
  • 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”

add deposits

Bank Account Options

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.

account options

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.

How to create bank accounts?

how to create a bank 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.

How to add and edit banks?

how to add a new bank

How to create a new bank?

  • Click on “Accounts” menu
  • Click on “+Add New Bank” button
  • Enter the name of the bank
  • Click on “Save” button

You can create up to 100 different banks. (Only local banks).

How to edit bank name?

  • Click on “Accounts” menu
  • Click on “Rename” in front of the bank name you want to rename
  • Enter the new bank name
  • Click on “Save” button

You need to create at least one bank and one bank account to start writing cheques.

How to create and edit company profile?

how to create a new company profile

How to create a new company profile?

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)
  • Edit details as necessary
  • Click on “Save” button