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.
Key Features
Automatic Matching
- Automatically matches your AutoCount transactions with the bank statement using date and amount logic — the most accurate method to avoid mismatches.
- Supports both PDF and Excel bank statement uploads, giving you flexibility.
High Matching Accuracy
- Up to approximately 90% automatic match rate on standard bank statements.
- Automatically places matching transactions side‑by‑side for quick review.
Unmatched Transactions Displayed Clearly
- Transactions that don’t automatically match are shown below the matched list for fast follow‑up.
Flexible Correction Tools
- Use AutoCount’s built‑in bank shift function to adjust dates or combine multiple entries into one when needed.
- Allows manual posting to AR/AP, Cashbook, Journal if automatic matching isn’t appropriate.
Upload PDF Bank Statement
Step 1:
- Select PDF upload mode.
Step 2:
- Upload the bank statement file.
Step 3:
- The system begins auto matching based on date and amount from both sides.
Review Unmatched Transactions
Step 1:
- Any transactions that don’t match are listed below the matched list.
Step 2:
- Review for discrepancies in amounts or dates.
Fix Errors Using Bank Shift
Step 1:
- Use the Bank Shift feature to adjust transaction dates or combine entries.
Step 2:
- Select the proper date range and save.
Step 3:
- Rerun reconciliation to see updated matches.
Manual Posting for Remaining Items
Step 1:
- For unmatched entries, post directly to Accounts Receivable (AR), Accounts Payable (AP), Cashbook, or Journal.
Step 2:
- If AutoCount detects a debtor or creditor, it will pre‑select them for you.
Using Excel Statements
Step 1:
- Select Excel upload.
Step 2:
- Define the column mapping (e.g., A = list, B = description, C = debit, etc.).
Step 3:
- Save and upload the completed Excel file.
Step 4:
- The plugin will perform 100% accurate matches based on your mapped ranges.
Step 5:
- Close any open Excel files to avoid upload errors.
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.