Get it from Microsoft Store: https://appsource.microsoft.com/enus...
Demo Files:
https://powerreconcile.tech/resource...
https://powerreconcile.tech/resource...
#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 123 and you can get a report within a minute?
Here, I want to introduce a magic tool for you. That is Power Reconcile AddIn 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 Addin
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!