Question 1

What types of dealership reconciliation does Power Reconcile handle?

Accepted Answer

Power Reconcile handles any reconciliation where you need to match two data sets in Excel. Common dealership use cases include: floor plan financing reconciliation (comparing your inventory records against lender statements), parts inventory reconciliation, warranty claims matching, accounts receivable vs. bank deposits, and intercompany transfers between dealership locations.

Question 2

How does it work for floor plan reconciliation?

Accepted Answer

Export your floor plan lender statement and your DMS inventory data into Excel. Select both data ranges in Power Reconcile, choose a matching column (e.g., VIN or stock number), and the tool automatically matches transactions, identifies discrepancies like curtailment differences, flags vehicles only on one list, and generates a reconciliation report — all in minutes instead of hours.

Question 3

Can it handle large data sets with thousands of vehicles?

Accepted Answer

Yes. Power Reconcile is designed for large data sets. 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.

Question 4

What about partial matches and manual exceptions?

Accepted Answer

Power Reconcile includes a manual reconciliation feature for complex scenarios. When the automatic matching can't resolve an item (e.g., a VIN typo, split transactions, or netting across multiple entries), you can use the manual reconcile dialog to match items yourself. This is common in dealership reconciliation where one lender transaction may correspond to multiple inventory entries.

Question 5

Does it generate reports I can share with my controller or GM?

Accepted Answer

Yes. Power Reconcile generates a detailed reconciliation report showing: perfect matches, value differences (with the exact difference amounts), items only in Table A, and items only in Table B. The report is generated directly in Excel, making it easy to share, print, or attach to your month-end close package.

Question 6

What's the pricing for a dealership?

Accepted Answer

Power Reconcile costs US$14.90/month or US$149/year per user (12 months for the price of 10). For dealer groups with multiple locations and users, enterprise plans with volume discounts are available. A free trial is included — no credit card required.

Question 7

We use CDK/Reynolds DMS — is it compatible?

Accepted Answer

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. The tool works inside Excel itself, so it's compatible with any data source that produces spreadsheet output.

Auto Dealer Reconciliation in Excel — Done in Minutes

Dealership Reconciliation — At a glance

Reconcile dealership data in 3 steps

Frequently Asked Questions

Get it from Microsoft and start your free trial today!