Joshua Guiao

Results-driven Accounting Professional with over 3 years of comprehensive experience in Shared Services operations at The Bistro Group. Expert in the full accounting cycle, transitioning from high-volume General Ledger management to Financial Planning and Analysis (FP&A). Specializes in Brand Financial Performance using Power BI and Microsoft Business Central (NAV) to deliver strategic insights and data-driven recommendations for international restaurant concepts.

Proven track record in streamlining period-end processes, managing complex accruals, and bridging the communication gap between finance and operations.

FINANCIAL REPORTING ANALYST at THE BISTRO GROUP SHARED SERVICES INC. (2023-07 – Present)

End-to-End Accounting & Financial Analysis

• Manages the full-cycle accounting for multiple restaurant concepts, ensuring all financial transactions align with internal controls and shared standards of service.
• Performs monthly brand performance analysis for Watami, interpreting financial data to identify trends and providing management with actionable conclusions on store profitability.
• Reviews automated dashboards in Power BI to streamline the reporting process, reducing the time spent on manual data consolidation from Microsoft Business Central (NAV).
• Handles the end-to-end period-end closing process, including the preparation and posting of accruals and reversals for rent, utilities, and R&M to ensure accurate expense matching.
• Reviews and reconciles complex ledger accounts across various store locations, resolving discrepancies through detailed transaction audits and coordination with store operations.
• Serves as the primary finance point-of-contact for non-accounting personnel, explaining financial reports and variances in a simplified manner to improve operational decision-making.
• Utilizes advanced Excel functions and Business Central to maintain high data integrity across high-volume transaction environments.

Bachelor of Science in Management Accounting – POLYTECHNIC UNIVERSITY OF THE PHILIPPINES - Manila (2023)