Import file for ADP

ADP timesheet import file from approved hours

Start from the import file your ADP payroll gives you. Vaultime fills it with approved hours, including code-and-hours pairs, padded employee numbers and your codes.

How it works

  1. Get ADP's sample file

    Download the timesheet import template or sample from ADP. Layouts with code-and-hours pairs (Hours 3 Code, Hours 3 Amount) and padded employee numbers are supported.

  2. Start from it in Vaultime

    Payroll → Exports → New export → Start from your payroll's file. Vaultime reads the columns, separator, date style and encoding, and suggests what goes in each. You check every suggestion.

  3. Add your codes

    Type the code each kind of hours has in your payroll (ordinary, overtime, Saturday…) beside your kinds.

  4. Check and download on pay day

    Pick the pay period. The check lists anything to fix (a missing ID, a kind with no code) with the fix right there; then download the file.

  5. Import it into ADP

    Import the file in ADP as you would any timesheet import, and check it there before you pay.

What it does

  • Builds code-and-hours pairs, a column per kind, or a row per kind.
  • Pads and shapes values (000104), with fixed-width files if your ADP needs them.
  • Checks for missing IDs and codes before you download, and keeps every file in History.

What it doesn't do

  • It isn't a live connection: Vaultime makes the file, you import it into ADP.
  • It calculates no pay: no rates, wages, tax, super or payslips.
  • It suggests no rules: the kinds and rules are yours.

Questions

Which ADP products?

Any ADP payroll that imports a timesheet file. Start from its sample so the file matches it exactly.

Can Ask Vaultime tell me our ADP codes?

Yes, with payroll access: ask “What's the code for overtime in our ADP export?”

ADP is a trademark of its owner. Vaultime isn't affiliated with or endorsed by it.

Try Vaultime free for 14 days

No card needed. Then US$5 a month for up to 5 people, and US$1 for each person after that.