Skip to main content

Import payroll files (Saturation 3.0)

Saturation imports payroll exports as itemized timecard transactions. The import is file-based, so you do not need to connect a payroll account to import a file.

Prepare and open the import

  1. Export a payroll log from your payroll provider.

  2. Open the project that should receive the payroll.

  3. Select Transactions.

  4. Drop the file on the page or select Import.

Saturation accepts payroll CSV files from different vendors and Media Services .ULT files. Wrapbook, Hot-Budget, and CSV exports are supported formats. The import is project-scoped because account codes resolve against that project's budget.

Map a payroll CSV

CSV imports open the column mapper. Saturation matches recognized headers to payroll fields. Review the mapping and correct any fields that were not matched, then continue to the review step.

.ULT files use a fixed-width format and skip column mapping.

Review and resolve rows

The review screen groups the file into timecards by employee and pay date. Earning amounts come from the file. Employer fringe amounts are split into their own lines when the source contains them.

Contacts are matched by name and earning or fringe rows are matched by budget account code. Review unresolved or ambiguous matches and choose a contact or budget line when needed. A row with an unresolved account remains visible for correction instead of being silently assigned to another account.

Import the timecards

Confirm the review to import the timecards as transactions. Imported rows can be reviewed, categorized, and actualized from the project's Transactions page. If an import partially fails, the dialog keeps the failed rows available for retry and does not import successful rows twice.

Notes

  • Payroll imports create new timecard transactions. Importing the same file again creates another set of transactions.

  • The payroll amount in the file is authoritative. Saturation does not recalculate the earning amount from other fields.

  • Add missing contacts or budget accounts before importing again when the review reports unresolved matches.

Did this answer your question?