Financial Transformation at a Top Restaurant Group: A Journey from Manual to Modern
Executive Summary
When I joined this restaurant group as an Accountant in 2018, the hospitality group (largest privately owned F&B entity in Hong Kong) was experiencing rapid growth, operating dozens of venues across Hong Kong including several Michelin-starred restaurants. However, this culinary success brought with it significant financial complexity. The group's accounting processes, particularly its month-end closing and payment systems, were struggling to keep pace with the organization's expansion. I knew as a support function, we could do better - Through the help of automation, I was able to refine commodity tasks, and rework processes for posterity.
Initial Challenge
The initial landscape was challenging, with the surge of restaurant openings and project viability analyses consuming most of the team's time and focus. Within Gartner's Run-Grow-Transform framework for digital strategy, we were so focused on the Grow and Transform aspects that commodity tasks were often neglected. Along with a traditional double-entry book keeping method, month-end close drug up to three months after each period. Transactions and reconciliations, often went a week without being checked, leading to a doubled workload for the payables team.
However, with month-end dragging on for three months after each period, weekly creditor payments of over $4.5 million USD being processed manually, and financial reporting across the group's portfolio required extensive human intervention. The herald of the solution was the move to Xero, a cloud-based accounting system, pitched as having the flexibility and scale to accommodate rapid expansion. Not a ubiquituous panacea, I recognized an opportunity to transform core financial processes through strategic automation and cloud adoption.
Key Initiatives & Solutions
Month-End Closing Optimization
My first major initiative targeted the month-end closing cycle. By implementing cloud accounting solutions and restructuring our financial planning and analysis (FP&A) processes, we achieved what many thought impossible: reducing the closing cycle from three months to just two weeks post month-end. This dramatic improvement didn't just save time - it completely transformed the organization's ability to make data-driven decisions with current financial information.
Payment System Automation
The next challenge was tackling the massive weekly creditor payment system. Using my background in VBA, I was aware that custom macros could be created to interface with web portals. As such, I stumbled across MacroRecorder, a no-code platform allowing for the replication of human inputs (The UIPath of its time) to automate the bank reconciliation process and create ACH's from a static spreadsheet of payment terms. The impact was immediate and substantial: we optimized workflow by over 16 man-hours per month while handling weekly creditor payments exceeding $4.5 million USD. This automation not only reduced errors but freed up skilled finance team members to focus on strategic analysis rather than manual processing.
Invoice Verification
To streamline invoice verification, we implemented Dext, an automated invoice scanning tool that significantly reduced manual data entry and reconciliation errors. By creating a Standard Operating Procedure (SOP), we established a clear workflow: restaurant staff were required to immediately acknowledge receipt of invoices and upload them to Dext in real time. This eliminated delays caused by misplaced or late submissions, ensuring that all expenses were accounted for promptly. The system extracted key invoice details, which were then reviewed in a single validation check by the finance team before being uploaded into Xero, our cloud-based accounting platform. This process reduced invoice processing time by over 40%, freeing up valuable hours that were previously spent on manual entry and reconciliation.
By integrating Dext with Xero, we achieved real-time financial visibility, allowing management to monitor expenses across multiple restaurant locations without waiting for end-of-month reconciliations. The structured SOP ensured consistency across teams, minimizing errors and preventing duplicate payments. With all invoices verified and categorized before entry into Xero, financial reports became more accurate and timely, allowing for better cash flow management and strategic decision-making. This automation not only improved operational efficiency but also strengthened financial controls, making audits and vendor negotiations significantly more seamless.
Portfolio Management
Working with a portfolio that spanned from fast casual to luxury establishments brought unique reconciliation challenges. I took charge of verifying daily transactions, merchant dealings, and bank reconciliations for a third of the group's diverse portfolio (14 entities). This role required developing scalable processes that could accommodate both high-volume casual operations and complex luxury venue transactions.
Project Costings
Working closely with the group systems, design teams, and vendors, I structured milestone-based payment schedules to align with project budgets and cash flow forecasts. By mapping out key deliverables with the design team and validating costs with vendors, we ensured that payments were tied to project progress rather than arbitrary deadlines. This approach minimized financial strain, allowing for better liquidity management while ensuring that suppliers and contractors were paid on time. Additionally, by integrating this framework into Xero’s reporting functions, we gained real-time visibility into outstanding liabilities and upcoming expenses, helping finance and leadership teams make informed decisions.
With this structured approach, I was able to execute complex payment plans for senior management's review without fail. By maintaining clear approval workflows and ensuring that all invoices were validated against contract terms before processing, we were able to curate a discipline in budgeted disbursements strengthened relations with vendors, realizing my vision of the finance team as a strategic team, not only a support function.
Impact & Metrics
- $4.5M+ Weekly Payments Managed
- 16+ Man-Hours Monthly Savings
- 75% Reduction in Closing Time
- Multi-Entity Reconciliation
- Portfolio-Wide Implementation
Core Competencies
Management Skills
- Project Management
- Vendor Negotiations
- Accountability
- Continued Learning
- Adaptability
- Time Management
- Teamwork/Collaboration
- Change Management
- Process Optimization
Financial Transformation
- Cloud Accounting Implementation
- Financial Process Automation
- Portfolio Management
- Month-End Closing Optimization
- Payment Processing Systems
- Financial Planning & Analysis (FP&A)
- Scenario Planning/Project Costings
Technical Innovation
- Advanced VBA Automation Solutions
- Custom Macro Development/Integration through MacroRecorder and UI Path
- Automated Invoice Scanning through 'Dext'
- End-to-End Process Optimization
- API & Webhook Development for Bank Reconciliation
- Multi-Scenario Planning Tools through 'Fathom'