Monthly Sage Intacct import preparation reduced from a full working day to around 10 minutes
A UK multi-site business was spending almost an entire working day each month preparing operational data for import into Sage Intacct.
The source data came from another business system and could not be imported directly. Before finance could upload it, the spreadsheet had to be cleaned, reformatted, checked and enriched using a series of business-specific rules and lookup tables.
The challenge
The preparation process included:
- mapping customer and location IDs
- applying fixed Intacct values
- formatting dates
- creating calculated fields
- applying tax details
- checking required values
- restructuring columns into the correct import format
- identifying records that needed manual attention
Because the process relied on multiple manual spreadsheet steps, it was time-consuming and easy to get wrong.
The Rekeyless workflow
The existing process was configured once inside Rekeyless.
Finance now uploads the monthly source file and runs the workflow.
Rekeyless automatically applies the required transformations and validation rules before producing the finished Sage Intacct import file.
Any records that cannot be processed correctly are separated as exceptions, with a clear reason, rather than being allowed into the final import unnoticed.
The result
Before Rekeyless
Approximately one full working day each month
With Rekeyless
Approximately 10 minutes
The finance team still remains in control of the final Sage Intacct import, but the repetitive spreadsheet preparation has effectively disappeared.
From a full day of spreadsheet manipulation to an Intacct-ready file in around 10 minutes.
Could Rekeyless do the same for your process?
If your finance team regularly manipulates spreadsheets or CSV files before importing them into Sage Intacct, send us the original file and the finished version. We’ll review the process and tell you what can be automated.