01
Automation
Payroll Posting Automation
Excel and Power Query workflow to prepare and standardize payroll journal entries for posting into SAP Business One.
ExcelPower QuerySAP Business One
Financial Accountant making finance operations cleaner and more useful through automation and analytics.
I’m Divine Shalom Panotes, a Financial Accountant based in Dubai, United Arab Emirates.
I specialize in financial reporting, payroll accounting, reconciliations, fixed asset accounting, cash flow analysis, and continuous improvement. My work combines accounting discipline with Excel and Power Query automation to make finance operations simpler and reporting more reliable.
Working across a multi-branch operation has sharpened my analytical thinking and reinforced my belief that finance is not only about recording numbers, but about helping people understand what they mean.
I’m learning Power BI and SQL so I can move beyond spreadsheets into richer business intelligence.
Dr. Filemon C. Aguilar Memorial College of Las Piñas
Built a strong foundation in financial management, accounting, financial analysis, investments, and business operations through a multidisciplinary business education.
What I use in daily practice, and what I’m actively learning. No inflated levels.
Real workflows I built or maintain in my current role. Descriptions kept factual — outcomes and details available on request.
Excel and Power Query workflow to prepare and standardize payroll journal entries for posting into SAP Business One.
Automated validation of commission calculations to identify discrepancies before payroll is finalized.
Reconciliation templates and Power Query steps to streamline bank reconciliations and surface unmatched transactions.
Recurring cash flow analysis prepared to support financial review and planning.
Variance analysis comparing actuals to budget, prepared to support financial review.
Maintenance of the fixed asset register and depreciation schedules in line with IAS 16.
SAP Business One is where the underlying accounting work lives — postings, reconciliations, fixed assets, and reporting extracts.
I use SAP Business One daily for financial reporting, journal postings, reconciliations, payroll accounting, and fixed asset management.
Full experience, tools, and responsibilities — open the up-to-date PDF.
I enjoy conversations about finance automation, analytics, and roles that bridge accounting with business intelligence.