AutoCount AutoBank Reconciliation Plugin: Unlocking Real-Time Cash Flow Insights
What Is The AutoBank Reconciliation Plugin
The AutoBank Reconciliation Plugin is a smart solution designed to automate one of accounting’s most tedious tasks—matching bank statements against your ledger. Instead of manually ticking transactions line by line, this plugin uses intelligent matching logic to reconcile hundreds of entries quickly and accurately by date and amount. Whether you upload PDF, Excel, or CSV files, it intelligently flags mismatches and streamlines your month-end closing, saving you valuable time and reducing manual 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对账插件设置
集成与配置
Why You Should Use AutoBank Reconciliation Plugin
Higher Efficiency
Switch from manual checking to automated matching. Save hours of tedious work and let the system do the heavy lifting for you.
Improved Accuracy
Eliminate human errors in bank reconciliation. Ensure your ledger and bank statements match perfectly with smart logic.
Faster Month-End Closing
Reconcile your bank accounts in minutes instead of days. Accelerate your month-end process and get your financial reports ready sooner.
Better Financial Visibility
Easily track and manage unmatched transactions. Get clear insights into your cash flow and maintain absolute financial clarity.
Key Features of AutoBank Reconciliation Plugin
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.
Who This Plugin is For
High-Volume SMEs
Perfect for Small and Medium Enterprises that handle hundreds of bank transactions every month and need a faster way to reconcile.
Retailers & Wholesalers
Designed for businesses with active daily bank movements from multiple sales channels, ensuring your cash records are always up-to-date.
Multi-Account Companies
An essential tool for companies managing multiple bank accounts. Synchronize and match all your statements in one centralized system.
Efficient Accounting Teams
Built for accounting professionals who want to stop manual ticking and reduce their month-end closing time by up to 90%.
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.
Start the process by setting up your reconciliation period and target balance.
- Go to G/L > Bank Reconciliation and click the New button.
- Enter the statement date and the ending balance found on your bank statement.
- Click OK to let the system set the correct date and amount for matching.
Pro Tip:
Accuracy is key here! Make sure the ending balance matches your bank statement exactly. This acts as the “target” for the system to reach a perfect match.
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.
Directly import your digital bank statements without any manual data entry.
- Select the bank statement file you want to upload.
- You can upload a PDF directly from your bank, or use Excel/CSV formats.
- The plugin will automatically read all transaction data from your file.
Pro Tip:
Using PDF files is the fastest and safest method. It prevents any formatting errors and ensures your transaction descriptions are imported perfectly.
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.
Let the intelligent system handle the tedious task of ticking off transactions.
- The plugin automatically matches your bank lines with your ledger entries using the date and amount.
- Matched items are grouped together so you can quickly review them.
- Check the list to ensure everything is correct before finalizing.
Pro Tip:
For any unmatched items, the system will flag them for you. This makes it easy to spot missing entries or bank errors in just a few seconds!
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.
Quickly spot any transactions that weren’t automatically paired by the system.
- Look at the Unmatched section at the bottom of the reconciliation screen.
- This list only shows the specific items that need your manual review.
- Focus only on these discrepancies instead of checking the entire statement again.
Pro Tip:
Treat the Unmatched section as your “To-Do” list. Once this section is empty, your bank statement and ledger are perfectly in sync!
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.
Fix mismatches caused by differences between your record date and the bank’s processing date.
- Go to Other > Bank Slip if a transaction doesn’t match due to a date gap.
- Select the transactions and adjust the date range to align them.
- This bridges the date gap so the system can successfully pair the items.
Pro Tip:
This is very common for weekend transactions or checks that take a few days to clear. Using the Bank Slip tool ensures your records stay accurate without messy manual adjustments.
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.
Instantly record missing bank entries, like fees or interest, without leaving the reconciliation screen.
- Use the AR, AP, or Cashbook icons located on the right side of the screen.
- Add these new entries directly to your ledger for items not yet recorded in the system.
- The system can even auto-fill details for you to speed up the process.
Pro Tip:
Don’t waste time switching between different modules. Handle bank charges and miscellaneous fees right here to finish your month-end closing much faster.
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.
Set up the mapping rules so the system knows exactly how to read your specific bank’s file format.
- Go to Auto Bank Recon > Excel CSV Setting, select your bank account, and click Edit.
- Tell the system which columns in your Excel file hold the Date and Amount (e.g., Column B or G).
- Click Save to store these mapping rules.
Pro Tip:
This mapping step is crucial! Getting it right ensures the system reads your specific bank file 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.
Once your settings are saved, the system will use your custom rules to process the data.
- Go back to the Bank Reconciliation screen and upload your Excel/CSV file.
- The plugin will now use the rules you just set to identify and read the transactions automatically.
Pro Tip:
Excel or CSV files often give even better results than PDF because the raw data is more precise. This makes the entire reconciliation process even smoother and faster!
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.
Core Benefits of the AutoBank Reconciliation Plugin
Faster Month-End Closing
Save hours of work by eliminating manual line-by-line checks. Use automation to drastically shorten your month-end closing time.
Smart Matching Accuracy
Minimize human errors and duplicate entries. Our smart matching logic ensures your bank statements and ledger match perfectly every time.
Clear Financial Visibility
Get instant insights into unmatched items. Easily track and manage discrepancies to maintain absolute financial clarity.
Easy Integration
Works perfectly with other AutoCount features for a smoother 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.