2025: Easy Bank Reconciliation with this Excel add-in

Demo Files:

#excel #reconciliation #accounting #bank #bankreconciliation

00:00 Intro to Power Reconcile for Microsoft Excel
00:25 Account Statement and Details from AP System
01:02 Configure Account Statement, or datatable A
01:49 Configure Details from AP System, or datatable B
02:11 Generate Bank Reconciliation Report automatically
02:59 Use slicer to facilitate data analysis
04:07 Use Manual Match to continue to reconcile outstanding items
05:55 Handle large dataset with 10000+ records only took 10 seconds

As a financial specialist, have you spent tons of time reconciling accounts every month? Have you wondered if the reconcile job can be done as easily as 1-2-3 and you can get a report within a minute?

Here, I want to introduce a magic tool for you. That is Power Reconcile Add-In for Microsoft Excel.

Let’s walk through an example of vendor statement reconciliation.

Given we have Account Statement in one sheet, and Details from Account Payable System in another sheet.
1. Select data range in Account Statement(datatable A), confirm the range in Power Reconcile Add-in
2. Select Reference Column and Amount Column for datatable A
3. Repeat step1 and step2 for Details from AP System(datatable B)
4. Click "Report" button, a reconciliation report will be automated created in the same Excel workbook. You can easily analyze the report by using slicer to filter the data.

If you want to continue to improve the reconciliation report, "Manual Reconcile" button can help you achieve that!

Please watch the video for more details!

Thanks!

[silvestrecamposano]

❤😮 Thank you very much!.... I have been looking for this technique.... My Boss wants me to reconcile data coming from separate tables.... GOD BLESS.... Thanks a lot..

[power-reconcile]

Demo Files:

The following applications and platforms are supported:  
* Excel on Mac (Microsoft 365) 
* Excel on Windows (Microsoft 365)
* Excel on the web

[dougperkinson]

Once I complete the in-app reconciliation, I need an Excel data file that includes the list of reconciled entries so that I can upload back inti my ERP's bank register to indicate which transactions have cleared (been reconciled). Is such an downloadable file available?

[MondayIsaac-ib]

how do I add the power reconcile ico on my excel sheet

[Vikas_Bhalekar]

My office 365 power concile software not working.. error is internet explorer 11 problem use other broser and.. add ins is block sms

[jbgolf]

Nice product but this is not a bank recon, as the video title suggests.