Each time you need to collect data from a client, your team likely spends hours manipulating that data in Excel to get it in the proper format just so they can start the work.
​
Strongbox Data Transformation does this step for you.
Normalization
Data Model
Regardless of the accounting system connected to, Strongbox Normalization creates a common data model – preserving the differences between systems while mapping fields and values across each.
With Strongbox there’s no need to train your team on the intricacies of outputs from each system.
​
Flat Data Tables
Strongbox delivers data in a clean, flat data table so you can easily pivot, sort, filter, or run your formulas without the hassle of reformatting data. What used to take hours can now happen in seconds.
​
Account Mapping
No more manual mapping of GL accounts to a standard model. Use the Strongbox output and mapping tables to generate new financials in minutes.
Validation
​
50+ Data Screens Per Month of Data
Each month of data collected is run through completeness, reliability, and forensic checks. Any failed checks are available to you in a results table in XLSX or can be generated by the Strongbox API.
​
Validation Check Examples:
Trial Balance
Accounting Equations
Continuity (period-over-period rolls)
Missing Figures, Activity, and Correlations
Benford's Law
​
Report-to-Report Tie-Outs:
When multiple data reports are collected (i.e., GL data, financials, AR/AP), full report totals are tied-out for completeness so you can be sure you are working with a complete dataset.
Enrichment
KPI & Ratio Calculations
Both common financial ratios and your own customized formulas are performed on the raw data.
​
Comparison & Trend Analysis
Period-over-period dollar and percentage variance, available by month, quarter, annual or custom periods.
​
Proprietary Cash Flow Analysis
Built using transaction-level detail from the accounting system, the Strongbox one click cash flow analysis returns categorized cash flows by type (operating, financing, investing) to prepare a direct-method cash flow statement.
​
With both detail and summarized reports, you can trace any cash movement to individual transactions in the GL.
