Question 1

What types of accounting reconciliation does Power Reconcile handle?

Accepted Answer

Power Reconcile handles any reconciliation where you need to match two data sets in Excel. Common accounting use cases include: bank statement reconciliation, accounts receivable vs. payment records, accounts payable vs. vendor invoices, intercompany reconciliation, general ledger vs. sub-ledger, credit card statement matching, and month-end close reconciliation.

Question 2

How does it compare to doing reconciliation manually in Excel?

Accepted Answer

Manual reconciliation in Excel 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.

Question 3

Can it handle multi-item netting and partial matches?

Accepted Answer

Yes. Power Reconcile includes a manual reconciliation feature for complex scenarios. When one payment covers multiple invoices, or when transactions need to be netted across entries, you can use the manual reconcile dialog to group and match items. You can also break and regroup partially matched items.

Question 4

What does the reconciliation report look like?

Accepted Answer

Power Reconcile generates a detailed report directly in Excel showing four categories: perfect matches (reference and amount match), value differences (reference matches but amount differs, with the exact difference), items only in Table A, and items only in Table B. The report is ready to share with management or attach to your month-end close package.

Question 5

Can it handle thousands of transactions?

Accepted Answer

Yes. Power Reconcile is designed for large data sets. Users routinely reconcile 10,000+ row data sets in under a minute. Whether you're matching a full year of bank transactions or reconciling thousands of invoices, the engine handles it efficiently.

Question 6

Does it work with data exported from our accounting software?

Accepted Answer

Yes. Power Reconcile works with any data in Excel. If your accounting software (QuickBooks, Xero, Sage, NetSuite, SAP, or any ERP) can export to Excel or CSV, Power Reconcile can reconcile it. The tool works inside Excel itself, so it's compatible with any data source.

Question 7

What's the pricing for accounting firms?

Accepted Answer

Power Reconcile costs US$14.90/month or US$149/year per user (12 months for the price of 10). Enterprise plans with volume discounts are available for firms with 10+ users. A free trial is included — no credit card required.

Question 8

How is this different from BlackLine or Trintech?

Accepted Answer

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.

Account Reconciliation in Excel — Done in Minutes

Accounting Reconciliation — At a glance

Reconcile accounts in Excel in 3 steps

Frequently Asked Questions

Get it from Microsoft and start your free trial today!