Accrual Automation & Journal Entry System
Redesigned a fragmented, spreadsheet-driven accrual submission process into a centralized, structured intake system to improve data consistency, reduce manual consolidation, and accelerate the month-end close cycle.
Role
Consultant - Finance Systems
Industry
Power Apps · Power Automate · SharePoint · Excel · NetSuite · Process Automation Design
Scope
End-to-end redesign of accrual intake, validation, and data capture into a centralized, automated workflow supporting month-end close.
Overview
Designed and built an end-to-end accrual management system to replace manual tracking and journal entry preparation. The solution standardizes data capture, enables structured review, and automates journal entry generation for accounting systems.
Problem
Accruals were being tracked manually across departments using spreadsheets and emails, leading to:
Inconsistent data formats across teams
Lack of visibility into submission status and ownership
Manual consolidation of 50–100+ line items per cycle
High risk of errors during journal entry preparation
No reliable audit trail for approvals and timestamps
Solution
Built a centralized system using Power Apps and Power Automate to streamline the full accrual lifecycle:
Key Components
1. Accrual Entry Application (Power Apps)
Structured input form for multi-line accrual submissions
Dynamic dropdowns powered by master data (Vendor, Account, Department)
Real-time validation for required fields and amounts
Standardized memo formatting and submission tracking
2. Data Model (SharePoint)
Accrual_Header: submission-level data (month, department, submitter, timestamp)
Accrual_Line: line-level detail (vendor, account, amount, stakeholder)
Accrual_AP_Review: flattened dataset for finance review and approval
3. Automation Layer (Power Automate)
Submission flow to validate and store structured data
Sync flow to create AP-ready review records
Journal entry generation flow:
Groups by submission
Maps vendor, account, department to internal IDs
Cleans and standardizes data
Generates NetSuite-ready CSV output
4. Mapping Engine
Vendor, Account, Department mapped via reference tables
Handles 300+ vendors and multi-entity structures
Ensures compatibility with ERP import requirements
Systems Thinking (Beyond This Project)
This project highlights broader opportunities to improve finance systems infrastructure, including:
Concur → NetSuite integration gaps (e.g., missing service date)
Lack of unique identifiers for cross-system reconciliation
Salesforce ↔ NetSuite data inconsistencies
Manual support workflows (e.g., Freshdesk ticket routing)
These represent opportunities to reduce manual effort and improve data integrity across the finance stack.
Impact
Reduced manual journal preparation time by ~70–80%
Eliminated spreadsheet-based tracking for accruals
Standardized submissions across departments (100% structured inputs)
Improved data accuracy and reduced reconciliation issues
Enabled audit-ready tracking with submitter and timestamp visibility
Scaled to handle 100+ line items per cycle without manual consolidation
Technical Highlights
Built multi-step flows with conditional logic and nested loops
Implemented JSON parsing and dynamic data handling from Power Apps
Designed normalized data structure for scalable finance operations
Resolved cross-system data type issues (Choice → Text migration)
Created export pipeline aligned with NetSuite journal import format
Result
Delivered a finance operations system that transforms accrual processing from a fragmented, manual workflow into a structured, automated pipeline with clear ownership, validation, and ERP-ready outputs.
Other projects
Accrual Automation & Journal Entry System
Redesigned a fragmented, spreadsheet-driven accrual submission process into a centralized, structured intake system to improve data consistency, reduce manual consolidation, and accelerate the month-end close cycle.
Finance Systems Automation & Governance
Using Microsoft Power Automate to Strengthen Financial Controls and Scale Operations
Enterprise Travel Policy Cost Governance Model
Strategic Finance Initiative - 2,069+ Annual Travel Legs