-
AutoCount Accounting Features
-
- Approval Workflow
- Audit Trail
- Auto Save in Draft Folder
- AutoCount Contra Account
- AutoCount Feature Stock Take
- AutoCount License Setting Guide
- Column Chooser
- Deposit Tracking & Management
- Documents Numbering Format
- Full Transfer and Partial Transfer
- Import Data to AutoCount Accounting Using Excel
- Informative Charts and Analytical Data
- Layout Customization
- Multi Pricing
- Sales and Services Tax
- Schedule Backup
- Search Lookup Edit
- View Documents Flow
- Show Remaining (3) Collapse
-
AutoCount Cloud Accounting
-
AutoCount E-Invoice
- AutoCount E-Invoicing Tutorial
- E-Invoice Guide and Preparation for AutoCount Users
- Employee Handbook Template for E-Invoicing
- How E-Invoice Works in AutoCount Accounting?
- How to Enable and Submit SVDP e-Invoices in AutoCount 2.0
- How to Use AutoCount Accounting for LHDN e-Invoice
- What is E-Invoicing?
-
AutoCount Payroll & HRMS
-
- Coming soon
-
- Coming soon
-
AutoCount Modules
-
- Activity Stream
- Advanced Financial Report
- Advanced Item
- Advanced Multi-UOM
- Advanced Quotation Module
- AutoCount Bonus Point Module User Guide
- AutoCount Scripting Module User Guide
- AutoCount Service Management Plugin User Guide
- AutoCount SST Hidden Functions
- AutoCount SST Submission - Service Tax
- Basic Multi-UOM
- Budget Module
- Consignment
- Filter By Salesman
- FOC Quantity
- Formula
- Item Batch
- Item Package
- Landing Cost
- Multi-Currency
- Multi-Dimensional Analysis
- Multi-Location
- Project Account
- Recurrence
- Remote Credit Control Module
- Stock Assembly
- User Defined Fields (UDF)
- Show Remaining (12) Collapse
-
AutoCount Plugins
-
- AutoCount Car Tint Film Plugin
- AutoCount Credit Memo Plugin User Guide
- AutoCount Easy Recurrence Plugin
- AutoCount Lock Price Plugin
- AutoCount Pick List Plugin User Guide
- AutoCount Production order
- AutoCount Progressive Billing
- Batch Update Unit Price Plugin
- DMS Import Plugin
- Fixed Assets Management
- Goldsmith
- TD Ordering Mobile Apps
- TD Stock Mobile Apps
- Universal Import Plugin
-
- AutoCount Advance Aging Format Plugin
- AutoCount Advance Deposit Plugin
- AutoCount Advanced Credit Term Plugin User Guide
- AutoCount Advanced Stock Assembly Plugin User Guide
- AutoCount Agent Validation Plugin User Guide
- AutoCount AutoBank Reconciliation Plugin User Guide
- AutoCount Barcode Generator Plugin User Guide
- AutoCount Batch Transfer SO DO Plugin
- AutoCount Bill Remark Plugin User Guide
- AutoCount Cage Management Plugin User Guide
- AutoCount Centralized Kitchen Management Plugin
- AutoCount Daily Collection Summary Plugin User Guide
- AutoCount Easy Batch Number Entry Plugin User Guide
- AutoCount Easy Deposit Plugin User Guide
- AutoCount Easy Knock Off Plugin
- AutoCount Easy Payment Plugin User Guide
- AutoCount Easy Photo 2.0 User Guide
- AutoCount Email & WhatsApp Plugin User Guide
- AutoCount Event Management System Plugin User Guide
- AutoCount Fruit Basket Plugin Guide
- AutoCount GridToExcel Plugin
- AutoCount Historical Outstanding DO Listing Plugin
- AutoCount IC Checker Plugin
- AutoCount Integrator Plugin
- AutoCount InterCompany Billing Plugin
- AutoCount Item Visibility Control Plugin User Guide
- AutoCount Migrator Plugin
- AutoCount MRP Order Plugin
- AutoCount Multi Company Knock Off Plugin
- AutoCount Optical Plugin
- AutoCount Pain Tracker Plugin User Guide
- AutoCount Payment Request Plugin
- AutoCount Procurement Planning Plugin User Guide
- AutoCount Project Department Visibility Control Plugin
- AutoCount Recurrence Late Interest Plugin
- AutoCount Recurring Invoice Plugin User Guide
- AutoCount Referral Management Plugin User Guide
- AutoCount Rental Management
- AutoCount RMA Plugin
- AutoCount Sales Commission Plugin
- AutoCount Scale Barcode Plugin User Guide
- AutoCount Service Contract Plugin User Guide
- AutoCount Shipment Plugin User Guide
- AutoCount Smart Analysis Plugin User Guide
- AutoCount Stock Availability Report Plugin
- AutoCount Timber Log Plugin User Guide
- AutoCount To-Do List Plugin User Guide
- AutoCount Tour Plugin User Guide
- AutoCount Vege Basket Plugin User Guide
- AutoCount Vehicle Master Plugin User Guide
- AutoCount Vehicle Plugin
- AutoCount Warranty 2.0 Plugin User Guide
- Batch Transfer SODO Plugin
- Intercompany Billing Plugin User Guide
- Lead Management 2.0 Plugin
- SL AutoCount API
- Show Remaining (41) Collapse
-
-
Form Template
-
Report Template
-
- Advance Quotation
- Cash Sale
- Consignment
- Consignment Movement
- Credit Note
- Debit Note
- Delivery Order
- FOC Quantity Analysis By Document Report
- Invoice
- Item Package Sales Report
- Monthly Sales Analysis
- Outstanding Sales Order Listing
- Profit And Loss Of Documents
- Quotation
- Sales Agent Contribution Report
- Sales Order
- Top/Bottom Sales Ranking
- Show Remaining (2) Collapse
-
- Available Stock Status Report
- Expired Item Batch Listing
- Inventory Physical Worksheet
- Stock Adjustment
- Stock Aging Report
- Stock Assembly
- Stock Assembly Order
- Stock Balance By Location
- Stock Balance Report
- Stock Card Report
- Stock Disassembly
- Stock Issue
- Stock Item Profit Margin
- Stock Movement Report
- Stock Receive
- Stock Take
- Stock Transfer
- Stock Write Off
- Show Remaining (3) Collapse
-
B2B ORDERING
-
AutoCount AI Agent
-
AutoCount FAQ & Troubleshooting
-
AutoCount F&B
-
- How to Accept or Reject QR Orders in AutoCount F&B POS
- How to Connect AutoCount POS Backend to QR Ordering Using an API Key
- How to Create a Restaurant in AutoCount QR Ordering Backend
- How to Customize AutoCount QR Ordering Customer View and Operating Hours
- How to Print and Test AutoCount F&B Table QR Codes
- How to Publish Menu Items to AutoCount F&B QR Ordering
- How to Set Up AutoCount F&B QR Ordering: Complete Guide
- How to Set Up Table QR Codes in AutoCount F&B
-
-
AutoCount Unicart Integration
- How Customer, Supplier and Order Field Mapping Works
- How Does a SiteGiant iSKU Map to an AutoCount Item Code?
- How Does the System Check Duplicate iSKU Mapping?
- How Is the Stock Sync Quantity Calculated?
- How Shipping, Discounts, Vouchers and Marketplace Charges Post to AutoCount?
- How Should a New AutoCount Item and SiteGiant iSKU Be Created?
- How SiteGiant Members and Bonus Points Sync with AutoCount POS
- How SiteGiant Orders Sync to AutoCount: Manual or Automatic
- How SiteGiant Purchase Flow Posts to AutoCount GRN
- How to Auto Sync AutoCount Price & Cost to SiteGiant Inventory
- How to Choose the Stock Master in SiteGiant and AutoCount
- How to Connect SiteGiant ERP to AutoCount and Confirm the Connection
- How to Handle Cancelled, Returned or Refunded Online Orders?
- How to Handle Fulfilled by Shopee Stock in AutoCount
- How to Handle SiteGiant Bundle / KIT Items
- How to Map Different UOMs for the Same Item?
- How to Reconcile Marketplace Settlements Using Bulk Knock Off
- How to Set the Posting Rules for Each Sales Channel
- How to Sync Stock from AutoCount to SiteGiant: Manual or Automatic
- Show Remaining (4) Collapse
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.
In this guide
- Before you begin
- 1. Configure PDF Bank Statement Settings
- 2. Configure Excel Bank Statement Columns
- 3. Set the Automatic Matching Date Window
- 4. Open Bank Reconciliation and Load a Statement
- 5. Create a Document for an Unmatched Transaction
- 6. Manually Match an Unmatched Bank Transaction
- 7. Check and Complete the Reconciliation
- Video tutorials (English and Chinese)
- Troubleshooting
- Frequently asked questions
- Related guides and technical assistance
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
- Open the plugin Setting window.
- Select the relevant bank account on the left.
- Choose the PDF tab.
- Under Default Bank, select the bank format that matches your statement.
- Review the displayed statement preview and click Save.
Check: The selected bank format should correspond to the statement supplied by your bank.
Figure 1. Configure the default PDF bank format for the selected account.
2. Configure Excel Bank Statement Columns
- Select the required bank account in Setting.
- Open the Excel tab.
- Enter the Excel column letter for Date, Description, Debit, Credit and Balance.
- Enter the First row where transaction data begins.
- 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.
Figure 2. Map the bank statement columns and starting row.
3. Set the Automatic Matching Date Window
- Choose the bank account and open the Setting tab.
- Find Date setting.
- Specify the permitted difference under Within days.
- 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.
Figure 3. Configure the permitted date difference for automatic matching.
4. Open Bank Reconciliation and Load a Statement
- Open the AutoCount Bank Reconciliation window and create a new reconciliation.
- Check the Bank Account No., Description, Currency Code and Statement Date.
- Review the filters: Show All Date, Show unticked transactions only and Show transactions cleared at other date.
- Under Load Statement Options, review Auto re-match statement.
- Click Load Statement and select the appropriate statement using the available file dialog.
- 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.
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.
- Locate the unmatched transaction.
- Select the appropriate accounting document action.
- In this example, the A/R Refund screen is shown.
- Review the Debtor, Paid To, Description, Date, Payment Method and Payment Amount.
- 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.
Figure 5. Example A/R Refund document entry.
6. Manually Match an Unmatched Bank Transaction
- Find an unmatched statement transaction and open the available manual matching action.
- In Manual Match Bank Statement, review Transaction Date, Description, Cheque No. and Amount.
- Compare the accounting document candidates using Doc. Date, Doc. No., Description, Debit and Credit.
- Select the appropriate document and check Selected Amount.
- 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.
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.
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.
Why are my transactions not matched automatically?
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.
What does Within days mean in the settings?
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.
Can I manually match an unmatched bank transaction?
Yes. In Manual Match Bank Statement, compare the bank transaction with the candidate accounting document and select Match only after checking the document details.
Why is there still a difference in Bank Reconciliation?
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.
What should I check before contacting support?
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.
Related resources and technical support
Continue exploring AutoCount or get assistance with the steps in this guide.
Explore AutoBank Reconciliation Plugin
Review the features and business workflows supported by AutoCount AutoBank Reconciliation Plugin.
Browse the Knowledge Base
Find practical instructions for other AutoCount functions, modules and plugins.
TECHNICAL SUPPORT
Need help with AutoBank Reconciliation Plugin?
Send the details below so our team can understand the issue and review the relevant workflow.
Have these details ready
- AutoCount and AutoBank plugin versions
- Bank account and statement format
- Statement date and relevant transaction details
- Exact error or balance difference
Before sharing a screenshot or statement: hide bank account numbers and other sensitive details.