Financial Reporting & Automation
Automated Financial Reporting Workbook
An Excel workbook that updates reports from changes in source data without rebuilding the reports manually.
Advanced ExcelSUMIFSEOMONTHLinked Worksheets
View workflow Accounting Portfolio
Projects and workflows I have worked on, covering financial reporting, reconciliation, month-end closing, tax, Power Query, and Excel-to-Accurate automation.
Accounting Automation
Excel → Accurate XML Journal Converter
A tool that reduces re-entry by converting structured Excel journals into XML used in an Accurate import workflow.
ExcelXMLAccurateJournal Migration
View workflow Closing & Controls
Month-End Closing Workflow & Control
A closing workflow connecting reconciliations, adjustments, Trial Balance review, and financial reporting.
Month-End ClosingExcelReconciliationControls
View workflow Reconciliation
Bank & Account Reconciliation Workflow
A reconciliation workflow that separates matched items, timing differences, and transactions requiring follow-up.
Bank ReconciliationExcelGeneral LedgerException Review
View workflow AP & AR
AP & AR Aging Monitoring
An aging workflow that turns invoice data into a clearer list of outstanding items for prioritization.
AP & ARExcelAgingOutstanding Monitoring
View workflow Tax & Coretax
Tax Reconciliation & Coretax Workflow
A PPN and PPh 21/23/25 workflow focused on document matching, reconciliation, and Coretax administration.
PPNPPh 21PPh 23PPh 25Coretax
View workflow Budgeting
Budget vs Actual Monitoring
A monitoring workflow connecting the budget master with actual spending and variance review.
BudgetingExcelVarianceMonitoring
View workflow Power Query & Data
Power Query Accounting Automation
A Power Query workflow that reduces copy-paste, cleans data, and keeps recurring source structures consistent.
Power QueryExcelData TransformationAutomation
View workflow