Shruti Tiware Patil
Excel & Power Query Automation | MIS Reporting | Power BI Dashboards ·
Hire
I recently developed an Excel-Based DM to DMS Ledger Reconciliation Workflow using Power Query.
The objective of this project was to simplify monthly reconciliation between DM memo data and DMS ledger records.
Key Features:
- Monthly memo data processing
- Automated data cleaning and transformation using Power Query
- Comparison of memo records with ledger… I recently developed an Excel-Based DM to DMS Ledger Reconciliation Workflow using Power Query.
The objective of this project was to simplify monthly reconciliation between DM memo data and DMS ledger records.
Key Features:
- Monthly memo data processing
- Automated data cleaning and transformation using Power Query
- Comparison of memo records with ledger transactions
- Identification of matched and unmatched records
- Detection of transaction amount differences
- Month-wise matching history tracking
- Final ledger output with matched month details
Tools & Skills Used:
- Microsoft Excel
- Power Query
- Data Cleaning & Transformation
- Data Reconciliation
- Data Matching
Business Value:
The workflow makes repetitive monthly reconciliation more structured, helps identify discrepancies, and reduces manual checking efforts.
This project gave me practical experience in building data-processing solutions for financial and accounting workflows.
I believe even repetitive Excel tasks can be made more organized and efficient with the right approach.
#ExcelAutomation #PowerQuery #DataReconciliation #Excel #MISReporting #DataManagement #ProcessAutomation #mywork #freelance #opentowork
The objective of this project was to simplify monthly reconciliation between DM memo data and DMS ledger records.
Key Features:
- Monthly memo data processing
- Automated data cleaning and transformation using Power Query
- Comparison of memo records with ledger… I recently developed an Excel-Based DM to DMS Ledger Reconciliation Workflow using Power Query.
The objective of this project was to simplify monthly reconciliation between DM memo data and DMS ledger records.
Key Features:
- Monthly memo data processing
- Automated data cleaning and transformation using Power Query
- Comparison of memo records with ledger transactions
- Identification of matched and unmatched records
- Detection of transaction amount differences
- Month-wise matching history tracking
- Final ledger output with matched month details
Tools & Skills Used:
- Microsoft Excel
- Power Query
- Data Cleaning & Transformation
- Data Reconciliation
- Data Matching
Business Value:
The workflow makes repetitive monthly reconciliation more structured, helps identify discrepancies, and reduces manual checking efforts.
This project gave me practical experience in building data-processing solutions for financial and accounting workflows.
I believe even repetitive Excel tasks can be made more organized and efficient with the right approach.
#ExcelAutomation #PowerQuery #DataReconciliation #Excel #MISReporting #DataManagement #ProcessAutomation #mywork #freelance #opentowork
DM_DMS_LinkedIn_Carousel (2).pdfPDF · 0.9 MB
1 appreciations
Comments
Log in to comment.