AutoCount Plugin: AutoBank Reconciliation Plugin
Automate & Accelerate Your Bank Reconciliation
The AutoCount AutoBank Reconciliation Plugin drastically simplifies one of accounting’s most tedious tasks — matching ledger entries with your bank statement. Instead of manually comparing transactions line by line, this plugin uses smart matching logic to reconcile hundreds of transactions quickly and accurately. Whether you upload PDF or Excel files, the plugin intelligently matches by date and amount, flags mismatches, and helps you handle exceptions with ease — saving you time and reducing errors.
AutoCount AutoBank Reconciliation Plugin Video Guide
Watch this step-by-step video guide on how to use the AutoCount AutoBank Reconciliation Plugin to automate bank reconciliation.
- AutoCount AutoBank Reconciliation Plugin (EN)
AutoBank Setup
Integration & Configuration
- AutoCount AutoBank Reconciliation Plugin (CN)
AutoBank对账插件设置
集成与配置
Key Features & Capabilities
Automatic Matching
Automatically match AutoCount transactions with bank statements by date and amount. Supports both PDF and Excel files
High Matching Accuracy
Get up to 90% auto-match rate. View matching transactions side-by-side for easy checking
Unmatched Transactions Displayed Clearly
Transactions that don’t automatically match are shown below the matched list for fast follow‑up.
Flexible Correction Tools
Easily adjust dates or merge entries. Supports manual posting to AR/AP or Journal when needed.
Upload PDF Bank Statement
1. Create New Reconciliation
Go to G/L > Bank Reconciliation and click the New button. Enter the statement date and ending balance from your bank statement. This step is important because it sets the correct date and amount for the system to start matching.
2. Upload Bank Statements
Select your bank file to upload. You can use a PDF directly from your bank, or use Excel/CSV if you want more control. This allows the plugin to read your bank’s transaction data automatically.
3. Review Auto-Matched Transactions
The plugin will automatically match your bank lines with your ledger entries using the date and amount. It will group the matched items together so you can quickly check if everything is correct without manual work.
Handling Exceptions & Unmatched Transactions
1. Identifying Unmatched Items
Check the “Unmatched” section at the bottom of your screen. This list shows all transactions that the system could not pair automatically. This helps you focus only on the items that need your attention, so you don’t have to check everything manually.
2. Correcting Date Errors with Bank Slip
If a transaction doesn’t match because the bank date and your record date are different, go to Other > Bank Slip. Select the transactions and adjust the date range. This function fixes the date gap so the system can successfully match the items.
3. Manual Posting for Remaining Items
For items like bank fees that are not recorded yet, use the AR, AP, or Cashbook icons on the right side. You can add these entries directly from this screen. The system will even try to auto-fill the details for you to save time.
Using Excel/CSV Bank Statements
1. Configure Excel CSV Settings
Go to Auto Bank Recon > Excel CSV Setting, select your bank account, and click Edit. You need to tell the system which columns in your Excel file hold the Date and Amount (e.g., Column B or G). This mapping step is crucial because it ensures the system reads your specific bank file format correctly for a 100% match rate.
2. Upload and Reconcile
Once the settings are saved, go back to the Bank Reconciliation screen and upload your Excel file. The system will now use the rules you just set to read the file. This usually gives much better results than PDF because the data is more precise.
Integration with AutoCount
While this plugin automates reconciliation uploads and matching, AutoCount’s core bank reconciliation tool also lets you reconcile your bank account balance against the actual bank statement, adjust transactions, and produce reconciliation reports.
Unlike traditional tools that require manual ticking of transactions, this plugin reduces your workload by doing much of that work automatically.
Best Practices
Standardize bank statement formats — consistent formats deliver higher auto match rates.
Use bank shift for date adjustments when deposit dates differ from transaction dates.
Check unmatched transactions regularly to catch exceptions or data errors early.
Benefits & Business Value
Time savings — no more manual line by line checks.
Improved accuracy — smart matching reduces human error.
Clear visibility into unmatched items — helps identify issues faster.
Supports PDF and Excel — flexibility for your workflow.
Conclusion
The AutoCount AutoBank Reconciliation Plugin simplifies and speeds up the process of matching bank statements to accounting records. With automatic bank feed imports, intelligent matching by date and amount, and support for both PDF and Excel files, this plugin is an essential tool for businesses looking to streamline their bank reconciliation process.
By eliminating manual tasks, this plugin helps businesses reduce errors and save time, making month‑end closes faster and more accurate.
Frequently Asked Questions
What file formats does the AutoBank Reconciliation Plugin support?
The plugin supports PDF and Excel files for bank statement imports.
How accurate is the automatic matching?
The system achieves a 90% match rate by date and amount. If there’s a discrepancy, you can manually correct it or use the Bank Shift function to adjust dates.
Can I manually reconcile transactions?
Yes, unmatched transactions will be clearly marked for you to review and manually reconcile.
Is the plugin compatible with all banks?
Most major banks are supported. However, check with your AutoCount dealer for compatibility with specific banks.
Which bank statement formats are supported?
PDF and Excel uploads are supported for automatic reconciliation.
What happens if a transaction doesn’t match?
Unmatched items appear below the auto‑matched list, and you can either correct them manually or post them to AR/AP/Cashbook.
Why didn’t a matching transaction show up automatically?
This can happen if there’s an issue in the bank statement, such as incorrect totals — ensure bank data is accurate before upload.
Interested in Getting AutoCount for your Business?
Contact our sales team today to explore pricing options and get started with the perfect solution for you.