Two AI-powered tools automating the full payroll-to-NetSuite pipeline: journal entry generation and multi-module cost reallocation, underpinned by a unified employee master data layer and deterministic GL mapping engine.
Systems UKG + Metabase + NetSuiteDelivery Iterative AI build
Impact at a glance
6
JE outputs automated
$0.00
Variance across all entries
2
Tools built & delivered
4
Data sources integrated
Tools built
Tool 1
Payroll JE Automation
Converts UKG Payroll Register CSVs into three balanced NetSuite journal entries (Earnings, Benefits, and Taxes) per payroll run.
Tool 2
Cost Allocation Engine
Three-module allocation tool covering cross-location hours worked, career development training time, and cost distribution, each producing a balanced NetSuite JE.
Foundations
Foundation
Employee Master Data
Single source of truth for NS Location, Class, and Department: exported from Tool 1 and consumed by Tool 2, eliminating duplicate data maintenance.
Foundation
GL Code Mapping Engine
Deterministic account resolution by GL Code Type and Code, with zero conflicts validated across all mapping rows and explicit DR/CR location-swap logic per module.
Payroll JE Automation: key outcomes
Four-tab HTML tool generating Earnings, Benefits, and Taxes JEs, all balanced to the penny per payroll run
Timezone fix, MMYY external ID format, debit-before-credit sort, grand totals row, and scrollable unmapped-error export with downloadable CSV
Employee Master export feeds the Cost Allocation tool; one update propagates to both workflows automatically
Technology stack
HTML / JavaScriptUKG Payroll RegisterUKG Timesheet DetailNetSuite JE CSVGL Code MappingEmployee Master DataFinance Automation