Skip to main content

AutoCount AutoBank Reconciliation Plugin User Guide

This AutoCount AutoBank Reconciliation Plugin User Guide explains how to configure PDF and Excel bank statements, set matching date rules, load statements, match bank transactions and check reconciliation balances in AutoCount Accounting.

Typical workflow: choose the bank account → configure PDF or Excel settings → set the matching window → load the bank statement → review automatic matches → manually match unmatched records → verify balances.

Before you begin

  • Confirm that the AutoBank Reconciliation Plugin is installed and the relevant bank account is available in AutoCount.
  • Prepare the correct PDF or Excel bank statement, statement date and actual closing balance.
  • Check that you have access to the Bank Reconciliation and related accounting functions.
  • For a new bank statement layout, verify its format and test the import in a sample or test account book before processing live transactions.

1. Configure PDF Bank Statement Settings

  1. Open the plugin Setting window.
  2. Select the relevant bank account on the left.
  3. Choose the PDF tab.
  4. Under Default Bank, select the bank format that matches your statement.
  5. Review the displayed statement preview and click Save.

Check: The selected bank format should correspond to the statement supplied by your bank.

AutoBank PDF default bank setting and bank statement preview

Figure 1. Configure the default PDF bank format for the selected account.

2. Configure Excel Bank Statement Columns

  1. Select the required bank account in Setting.
  2. Open the Excel tab.
  3. Enter the Excel column letter for Date, Description, Debit, Credit and Balance.
  4. Enter the First row where transaction data begins.
  5. Enter the correct Sheet name and click Save.

Example shown: Date A, Description B, Debit C, Credit D, Balance E, First row 2, Sheet1. This is an example, not a universal template. The window notes that Excel import columns are shared by account across bank formats.

AutoBank Excel import settings showing columns and sheet name

Figure 2. Map the bank statement columns and starting row.

3. Set the Automatic Matching Date Window

  1. Choose the bank account and open the Setting tab.
  2. Find Date setting.
  3. Specify the permitted difference under Within days.
  4. Click Save.

The example uses 3 days for same-amount matching. A matching amount alone does not prove that two transactions are related, so check the date and accounting context.

AutoBank same amount auto match date setting within three days

Figure 3. Configure the permitted date difference for automatic matching.

4. Open Bank Reconciliation and Load a Statement

  1. Open the AutoCount Bank Reconciliation window and create a new reconciliation.
  2. Check the Bank Account No., Description, Currency Code and Statement Date.
  3. Review the filters: Show All Date, Show unticked transactions only and Show transactions cleared at other date.
  4. Under Load Statement Options, review Auto re-match statement.
  5. Click Load Statement and select the appropriate statement using the available file dialog.
  6. Review imported lines and their matching status.

Important: The available file dialog and exact menu route should be confirmed against your installed plugin version. Do not finalise matches without checking them.

AutoCount Bank Reconciliation screen showing load statement and transaction grid

Figure 4. Bank Reconciliation screen showing imported bank transactions, matching controls and balance comparison.

5. Create a Document for an Unmatched Transaction

The reconciliation grid shows accounting actions including Cash Book, Payment, Refund and Journal. Choose the accounting entry that correctly represents the bank transaction.

  1. Locate the unmatched transaction.
  2. Select the appropriate accounting document action.
  3. In this example, the A/R Refund screen is shown.
  4. Review the Debtor, Paid To, Description, Date, Payment Method and Payment Amount.
  5. Complete any applicable knock-off details and verify the accounting treatment before saving.

Caution: An A/R Refund is only appropriate for applicable refund transactions; do not use it indiscriminately for every unmatched payment.

AutoCount A/R Refund entry payment amount and method

Figure 5. Example A/R Refund document entry.

6. Manually Match an Unmatched Bank Transaction

  1. Find an unmatched statement transaction and open the available manual matching action.
  2. In Manual Match Bank Statement, review Transaction Date, Description, Cheque No. and Amount.
  3. Compare the accounting document candidates using Doc. Date, Doc. No., Description, Debit and Credit.
  4. Select the appropriate document and check Selected Amount.
  5. Click Match only after verifying the document relates to the bank transaction.

Example: The screenshot matches a RM13,233.00 bank transaction dated 01/12/2024 with a RM13,233.00 accounting document dated 13/11/2026. The significant date difference makes independent verification especially important.

AutoCount Cloud bank reconciliation: matching an accounting document to a bank statement

Figure 6. Select the corresponding accounting document for a manual match.

7. Check and Complete the Reconciliation

Review the Actual Bank Statement Balance, System Bank Statement Balance and Difference displayed at the bottom of Bank Reconciliation. If a difference remains, review missing documents, incorrect amounts, duplicated or unmatched transactions, and the entered closing balance.

Check the relevant transactions before using the final reconciliation action. A zero difference is a useful check but does not by itself validate every document match.

AutoCount AutoBank Reconciliation Plugin Video Guide

Watch these step-by-step video tutorials to learn how to set up and use the AutoCount AutoBank Reconciliation Plugin.

▶ AutoCount AutoBank Reconciliation Plugin (EN)

AutoBank Setup

▶ AutoCount AutoBank Reconciliation Plugin (CN)

AutoBank对账插件设置

Troubleshooting

Use these checks alongside the documented workflow. If the issue continues, provide the exact message and relevant statement or transaction details to support.
Bank statement cannot be imported: Check that the selected PDF bank format matches your statement. For Excel, verify the sheet name, date and amount column letters, first data row and bank account.
Transactions are not matched automatically: Compare the amounts and dates in the bank statement with the accounting documents. Review the account’s Within days setting and check that the related document exists.
An incorrect transaction appears matched: Verify the bank statement line, accounting document number, amount and date. Follow your approved reconciliation correction procedure; do not assume an automatic undo is available.
Bank reconciliation still has a difference: Compare Actual Bank Statement Balance with System Bank Statement Balance. Look for missing, duplicate or unmatched entries and check the entered closing balance.

Frequently asked questions

Can I import both PDF and Excel bank statements?

Yes. You can configure supported PDF bank formats under the PDF tab and Excel column mapping, the starting row and worksheet name under the Excel tab. Check that the selected format matches your actual statement.

Compare transaction amounts and dates with the related AutoCount documents. Check the account’s Within days setting and confirm that the corresponding accounting document exists.

It specifies the allowed date difference for same-amount auto-matching. The screenshot shows an example setting of 3 days. Always review the matched document rather than relying on the amount alone.

Yes. In Manual Match Bank Statement, compare the bank transaction with the candidate accounting document and select Match only after checking the document details.

Compare Actual Bank Statement Balance and System Bank Statement Balance. Check for unmatched, missing or duplicated transactions, incorrect amounts and the entered statement closing balance.

Review the bank account, selected PDF or Excel format, Excel column mapping, statement date, Within days setting and outstanding transaction matches. Provide relevant screenshots and a redacted statement sample if further help is needed.