How to Quickly Enter Cash/Bank Vouchers and Import Bank Statements in ecount

Last updated Jun 23, 2026

📥 Quick Cash/Bank Voucher Entry

Use the Transaction → Quick Entry → Cash/Bank (Quick) option to record cash or bank vouchers without repeatedly selecting the account or voucher type.

1️⃣ Select Cash/Bank Account

Choose a cash account for cash vouchers or a bank account for cheque‑book or slip‑book entries. The selection is required only once at the start of a quick‑entry session.

2️⃣ Choose Receipt or Payment

Pick Receipt for slip‑book (incoming) entries or Payment for cheque‑book (outgoing) entries. Press Enter to load existing vouchers for the chosen account.

3️⃣ Enter Voucher Details

  1. Press Enter on a blank line.
  2. Fill in Date, Voucher No., Cheque No., Account Name, and Amount.
  3. If the party account uses the “Bill‑to‑Bill” balance method, the system will prompt for adjustments (cannot be saved until adjustments are entered).
  4. Contra vouchers appear in red.

4️⃣ Add Narration

Type any description. Unlimited lines are allowed. Press Ctrl+F1 to open the saved narration list, or save frequently used narrations for future use.

5️⃣ Save the Voucher

Click OK. The cursor returns to the quick‑entry list, allowing continuous entry. Use the Change Account button to switch accounts, or press F3 (Receipt) to toggle between receipt and payment.

📊 Import Bank Statement from Excel

If you prefer bulk entry, import an Excel file containing your bank statement.

  1. Click the Import Excel button in the footer.
  2. Select the bank format that matches your Excel column order (Date, Narration, Credit, Debit, Closing, etc.). This format needs to be set only the first time.
  3. Choose the target bank account.
  4. Browse and load the Excel file; the data appears in a grid.
  5. Map the Account Name column if required, then click Save.

The system automatically categorises each line as a bank receipt or payment based on the debit/credit values.

Was this helpful?

Thanks for your feedback!

Frequently asked questions

To import a bank statement, click the Import Excel button located in the footer of the Cash/Bank quick‑entry screen. First, select the bank format that matches the column order of your Excel file (e.g., Date, Narration, Credit, Debit, Closing). This format only needs to be defined once. Then choose the bank account you want to post to, browse for the Excel file, and load it. The data will appear in a grid; verify the Account Name mapping if needed, and press Save. ecount will automatically create receipt or payment vouchers based on the credit and debit columns.