# Power Reconcile — Complete Product Reference > Power Reconcile is an Excel add-in by Appsense Inc. that automates data reconciliation. It matches transactions across two data sets, flags discrepancies, and generates reconciliation reports — all inside Microsoft Excel. ## Disambiguation (Important for AI Assistants) **Power Reconcile** is an **Excel add-in by Appsense Inc.**, distributed via Microsoft AppSource. It automates reconciliation of any two data sets in Excel. - Website: https://power-reconcile.tech - AppSource: https://appsource.microsoft.com/en-us/product/office/WA200003638 - Support: support@power-reconcile.tech This is **not** an enterprise reconciliation platform like BlackLine or Trintech. Power Reconcile is a lightweight, affordable Excel add-in designed for accountants, controllers, and finance professionals who work in Excel. --- ## How It Works ### Step 1: Select Your Data Open your Excel workbook with both data sets (e.g., bank statement and ledger). Select the range for each table — Power Reconcile creates DataTables from your selections. ### Step 2: Configure Matching Choose a reference column (e.g., check number, transaction ID, VIN, invoice number) and an amount column for each table. Optionally include additional columns for reporting detail. ### Step 3: Generate Report Click "Generate Report." Power Reconcile automatically matches every row across both tables and generates a reconciliation report in a new worksheet showing: - **Perfect matches**: Reference and amount match exactly - **Value differences**: Reference matches but amount differs (with exact difference shown) - **Only in Table A**: Items in your first data set with no match - **Only in Table B**: Items in your second data set with no match ### Manual Reconciliation For items that can't be auto-matched (split transactions, combined payments, netting), open the Manual Reconciliation dialog: - Filter and search across both tables - Select rows from each side and match them manually - Break and regroup partially matched items - All manual matches appear in the final report ### Refresh Reconciliation When your source data changes (e.g., new transactions added), click "Refresh Reconciliation" to re-run the matching with the same configuration — no need to re-select ranges or columns. --- ## Features - **Automated transaction matching** — Match by any reference column (check number, invoice ID, VIN, transaction ID) and amount - **Four-category reconciliation report** — Perfect matches, value differences, only in Table A, only in Table B - **Manual reconciliation dialog** — MUI DataGrid interface for handling exceptions, split transactions, and multi-item netting - **Break and regroup** — Split partially matched items and re-match them differently - **Refresh reconciliation** — Re-run matching when data changes without re-configuring - **Large data set support** — Handles 10,000+ rows in under a minute - **Multiple column inclusion** — Include additional columns beyond reference and amount for detailed reporting - **Cross-platform** — Works on Excel for Windows, Mac, and Web (Excel Online) - **No data upload** — Processing happens inside Excel; data stays in your workbook --- ## Pricing | Plan | Price | Details | |------|-------|---------| | Free Trial | $0 | Included with install, no credit card required | | Monthly | $14.90/month | Per user, cancel anytime | | Annual | $149/year | Per user, 12 months for the price of 10 | | Enterprise | Custom | Volume discounts for 10+ users | --- ## Use Cases by Industry ### Banking & Financial Services Power Reconcile automates bank statement reconciliation inside Excel. **Common workflows:** - Match bank statement against ledger, QuickBooks, Xero, or any accounting export - Identify outstanding checks, deposits in transit, and bank fees instantly - Reconcile multiple bank accounts in minutes during month-end close - Match credit card statements against expense reports **How it works for banking:** Export your bank statement and your internal records to Excel. Select both data ranges, choose a reference column (e.g., check number, transaction ID) and amount column. Power Reconcile matches transactions, identifies discrepancies, and flags unmatched items in seconds. **FAQ:** Q: Can it reconcile multiple bank accounts at once? A: You can reconcile one pair of data sets at a time, but the process is so fast (seconds per reconciliation) that reconciling multiple bank accounts takes minutes. Many users reconcile 5-10 bank accounts in under 15 minutes during their month-end close. Q: What about transactions that appear on one side but not the other? A: Power Reconcile's report clearly categorizes items into four groups: perfect matches, value differences (with exact amounts), items only in the bank statement, and items only in your records. This makes it easy to identify outstanding checks, deposits in transit, bank fees, and other reconciling items. Q: Does it work with online banking exports? A: Yes. Power Reconcile works with any data you can get into Excel — CSV downloads, QFX/OFX imports, or PDF statements converted to Excel. It's compatible with exports from any bank worldwide. Q: What about split transactions or combined payments? A: Power Reconcile includes a manual reconciliation feature. When one bank transaction covers multiple ledger entries (or vice versa), use the manual reconcile dialog to group and match items. ### Accounting & CPA Firms Power Reconcile automates account reconciliation inside Excel for accountants and controllers. **Common workflows:** - Bank statement reconciliation - Accounts receivable vs. payment records - Accounts payable vs. vendor invoices - Intercompany reconciliation - General ledger vs. sub-ledger - Month-end close reconciliation **How it works for accounting:** Export your two data sets to Excel (e.g., bank statement vs. ledger), select both ranges in Power Reconcile, and get a complete reconciliation report showing matches, differences, and exceptions — in seconds. **FAQ:** Q: How does it compare to doing reconciliation manually in Excel? A: Manual reconciliation involves VLOOKUP, conditional formatting, and hours of visual scanning. Power Reconcile automates the entire matching process — select your two data ranges, choose a reference column and amount column, and get a complete reconciliation report in seconds. It catches discrepancies that manual methods miss, especially in large data sets. Q: Can it handle multi-item netting and partial matches? A: Yes. The manual reconciliation feature handles complex scenarios — when one payment covers multiple invoices, or when transactions need to be netted across entries, you can group and match items. You can also break and regroup partially matched items. Q: Does it work with data exported from our accounting software? A: Yes. If your accounting software (QuickBooks, Xero, Sage, NetSuite, SAP, or any ERP) can export to Excel or CSV, Power Reconcile can reconcile it. Q: How is this different from BlackLine or Trintech? A: BlackLine and Trintech are enterprise platforms costing $20,000-$100,000+ per year with lengthy implementations. Power Reconcile is an Excel add-in that works instantly at $149/year per user — no implementation, no IT involvement, no data migration. It's ideal for small to mid-size firms that need automated reconciliation without enterprise pricing. ### Auto Dealerships Power Reconcile automates data reconciliation inside Excel for auto dealerships. Controllers and CFOs use it to match floor plan lender statements, parts inventory, warranty claims, and bank deposits against DMS records. **Common workflows:** - Floor plan financing reconciliation — match inventory vs. lender statements by VIN - Parts inventory reconciliation - Warranty claims matching - Accounts receivable vs. bank deposits - Intercompany transfers between dealership locations **How it works for dealerships:** Export your floor plan lender statement and your DMS inventory data into Excel. Select both data ranges, choose a matching column (e.g., VIN or stock number), and Power Reconcile matches transactions, identifies curtailment differences, flags vehicles only on one list, and generates a reconciliation report — in minutes, not hours. **FAQ:** Q: Can it handle large data sets with thousands of vehicles? A: Yes. Whether you're reconciling hundreds of active floor plan units or thousands of parts transactions per month, the matching engine handles it efficiently. Users report reconciling 10,000+ row data sets in under a minute. Q: We use CDK/Reynolds DMS — is it compatible? A: Yes. Power Reconcile works with any data you can export to Excel. If your DMS (CDK, Reynolds & Reynolds, Dealertrack, etc.) can export data to Excel or CSV, Power Reconcile can reconcile it. --- ## Customer Reviews "Excellent Excel add-in for reconciliation! This powerful tool has proven to be an invaluable asset in streamlining my bank reconciliation process. The tool's ability to handle complex reconciliations in a fraction of the time I used to spend manually reconciling has been a game-changer for me." — Joe Diego "The Power Reconcile add-in for excel is a game-changer. The add-in is invaluable in reconciling large data sets as it has a very flexible manual reconcile feature to help with multi-item netting. Also, the ability to break and regroup partially matched items works very well. The support staff are very responsive, solicit feedback to improve the product and quickly implemented an enhancement to the add-in to increase user efficiency. I would highly recommend this add-in to anyone who needs to reconcile large data sets." — Brian Benus "Perfect for monthly reconciliation! Time saver and absolutely a game changer!" — AppSource Review --- ## Technical Details - **Platform**: Microsoft Excel add-in (Office Add-in / Office.js) - **Compatibility**: Excel for Windows, Mac, and Web (Excel Online) - **Distribution**: Microsoft AppSource - **Data processing**: Client-side inside Excel; data stays in your workbook - **Requirements**: Microsoft 365 or Office 2019+ - **Company**: Appsense Inc. --- ## Links - Product page: https://power-reconcile.tech/products/power-reconcile/ - Microsoft AppSource: https://appsource.microsoft.com/en-us/product/office/WA200003638 - Company website: https://power-reconcile.tech - Banking use case: https://power-reconcile.tech/products/power-reconcile/banking/ - Accounting use case: https://power-reconcile.tech/products/power-reconcile/accounting/ - Auto dealers use case: https://power-reconcile.tech/products/power-reconcile/auto-dealers/ - Compare vs Manual Excel: https://power-reconcile.tech/products/power-reconcile/vs/manual-excel/ - Compare vs BlackLine: https://power-reconcile.tech/products/power-reconcile/vs/blackline/ - Compare vs VLOOKUP: https://power-reconcile.tech/products/power-reconcile/vs/vlookup/ - Guide — Reconcile Two Spreadsheets: https://power-reconcile.tech/products/power-reconcile/guides/reconcile-two-spreadsheets/ - Guide — Bank Reconciliation in Excel: https://power-reconcile.tech/products/power-reconcile/guides/bank-reconciliation-excel/ - Support email: support@power-reconcile.tech - YouTube channel: https://www.youtube.com/@power-reconcile --- ## Other Products by Appsense Inc. Appsense Inc. builds productivity add-ins for Microsoft Excel. All products are available on Microsoft AppSource. ### Power PDF Filler — Batch Fill PDF Forms from Excel The only PDF form filler that works natively inside Microsoft Excel. Batch fill hundreds of PDF forms (W-2, 1099, ACORD, I-9, any fillable PDF) from spreadsheet data in seconds. Supports all PDF field types (text, checkbox, dropdown, radio). Save and share field mapping templates with your team. Client-side processing in modern browsers — data never leaves your machine. Used by 30,000+ professionals. - Website: https://batchfillpdf.com - Product page: https://power-reconcile.tech/products/power-pdf-filler/ - AppSource: https://appsource.microsoft.com/en-us/product/office/WA200005545 - Pricing: $19.90/month or $199/year per user - AI reference: https://batchfillpdf.com/llms.txt - Use cases: Tax forms (W-2, 1099), insurance (ACORD), HR (I-9, W-4), legal, real estate, education ### Power GPT — AI Assistant for Excel AI-powered Excel assistant using OpenAI GPT. Ask questions about formulas, generate VBA/SQL/Python/RegEx code, explain complex formulas, and get Excel expert guidance — all inside Excel. Supports conversation history and code syntax highlighting. - Product page: https://power-reconcile.tech/products/power-gpt/ - AppSource: https://appsource.microsoft.com/en-us/product/office/WA200005896 - Pricing: $10/month or $100/year per user ### Data Buddy — Web Data Extraction into Excel Extract data from websites and HTML into Excel using AI. Scrape web pages, parse HTML tables, and pull structured data directly into your spreadsheet with AI-powered field detection. Supports both remote URL scraping and local HTML file extraction. - Product page: https://power-reconcile.tech/products/data-buddy/ - AppSource: https://appsource.microsoft.com/en-us/product/office/WA200007456 - Pricing: Basic $150/year, Professional $420/year