Timesheet collection · MTT Collect

Timesheet collection, without the re-keying

Half your consultants don't fill in your timesheet. They fill in the client's — in a VMS, a portal, a spreadsheet the client's manager likes. What reaches you is a file. MTT Collect is timesheet collection for staffing firms: it reads that file, extracts the hours, and holds them for you to review and confirm. Nobody types them in again.

Collect is switched on per account. Ask us: hello@getmtt.com

The problem

The hours are signed off. They're just in the wrong place.

The consultant entered the week on the client's system. The client's manager signed off. The work of getting those hours approved is finished — and then the timesheet arrives at your firm as an attachment, and the typing starts.

One client sends a VMS report export with forty consultants in it. Another sends a PDF per person. A third forwards a screenshot of a portal page. Someone in your back office opens each one and copies the numbers into the sheet payroll and billing run from: Monday 8, Tuesday 8, Wednesday 9.5, and was that half hour overtime or not.

It is the dullest job in the building and the one with the worst failure mode. A slipped digit is an underpaid consultant or an invoice the client disputes, and you find out weeks later. It also never gets faster, because it grows with placements — every new consultant on a client's timesheet system is another file to re-key, every week.

How it works

Send the file. MTT reads it. You confirm.

Three steps. The middle one is the part you used to do by hand.

01

Send it in

Forward the email to your firm's Collect address, or upload the file. Each firm gets its own address, switched on once from the Collect screen. Forward the same email twice and the second copy is ignored.

02

MTT reads the file

AI reads PDFs, scans and images and pulls out the days and hours. For a spreadsheet export, MTT proposes which column is which; you okay the mapping once, and the same layout is recognized the next time it shows up.

03

You review and confirm

You see what was extracted, check it against the original, and post. Nothing posts on its own. The original file stays attached to the hours as proof.

Matching people. MTT matches each name on the file to a consultant you already have. Anyone it doesn't recognize is flagged as new for you to add — it won't guess at a near-match. Consultants who only ever appear on client timesheets don't need an MTT login.

Billable or not is your call. MTT never infers it from a project name. Where a timesheet lists project or task rows, you tick the ones that aren't billable when you confirm. In a spreadsheet export, you tell MTT which pay codes to leave out.

Already approved, so no approval step. A collected timesheet was approved at the source before it reached you. MTT doesn't approve it and doesn't ask you to. What you're confirming is that the hours were read correctly.

Formats

Whatever the client sends. Within reason.

Collect reads the file types client timesheets actually arrive in. Here is exactly what works today, and what doesn't.

Format How MTT reads it
Excel (.xlsx, .xls) and CSVReport exports covering one consultant or the whole roster — one row per consultant per week, or one row per day per pay code. In a multi-sheet workbook MTT reads one sheet: the fullest by default, or the one you pick.
PDF, including scansRead by AI, one consultant per document. A monthly or multi-week timesheet is split into weeks ending Sunday.
Images (PNG, JPG, WEBP, GIF)Screenshots and photos of a timesheet, read the same way as a PDF.
VMS exportsWhatever file the VMS produces — Beeline, Fieldglass or another — in one of the formats above. No login to the VMS, no API connection.
.zipAccepted when it holds a single timesheet file.

Files can be up to 25 MB. Not read today: iPhone HEIC photos (save as JPG or PNG first), Word documents, and hours typed into the body of an email with no attachment.

When the file is messy

It stops and shows you. It doesn't guess.

Real timesheets are crooked scans, merged cells and pay codes nobody documented. Collect is built to hold a file rather than post a number it isn't sure of.

Totals

Hours that don't add up.

If the hours MTT read don't match the total printed on the timesheet, you see the mismatch and have to acknowledge it before anything posts. Rows it couldn't read are listed, not skipped quietly.

Pay codes

A code it hasn't seen.

An earning code MTT doesn't know holds the whole file until you say what it is — regular, overtime, double-time, sick, vacation, a premium, or leave it out. Nothing is assumed.

Duplicates

A week that's already in.

If a file covers a week MTT already holds for that consultant, you choose per week: overwrite or skip. Weeks you've already invoiced default to skip.

After you confirm

One set of hours. The whole roster.

Collected hours sit beside the timesheets your consultants submit in MTT — same reports, same payroll export, marked "Collected" so you can tell which is which.

Every collected week keeps a link to the file it came from. When a client questions an invoice line or a consultant questions a paycheck, you open the original — the client's own document, not a re-typed copy of it.

Regular, overtime and double-time on collected hours stay exactly as the client's timesheet recorded them. MTT's multi-state overtime split applies to hours entered in MTT; it does not recalculate a timesheet the client already signed off.

What Collect doesn't do

FAQ

Timesheet collection, common questions.

How do timesheets get into MTT Collect?
Two ways. Forward the email carrying the timesheet to your firm's Collect address — one address for the whole firm, switched on from the Collect screen — or upload the file yourself. One file at a time: one attachment per email, one file per upload. A single spreadsheet export can cover your whole roster. Forward the same email twice and MTT ignores the second copy.
What timesheet formats does MTT Collect read?
Excel (.xlsx and .xls), CSV, PDF — scanned PDFs included — and images: PNG, JPG, WEBP and GIF. Files up to 25 MB. A .zip works if it holds a single file. In a multi-sheet workbook MTT reads one sheet: it picks the fullest one, and you can switch it. Not read today: iPhone HEIC photos (save as JPG or PNG first), Word documents, and hours typed into the body of an email.
Does MTT Collect connect to Beeline or Fieldglass?
No. There is no login to any VMS, no API connection and no scraping. Collect works from the file the VMS gives you — the report export or the timesheet PDF. You export it or it gets emailed to you; MTT reads it.
Do I approve collected timesheets?
No. A collected timesheet was already approved at the source — by the client, in their system — before it reached you. MTT doesn't approve it and doesn't ask you to. You review the hours MTT extracted, confirm they match the file, and post. That's a read-check, not an approval.
Who decides which hours are billable?
You do, when you confirm. MTT never works it out from a project name or a label. On a timesheet with project or task rows you tick the ones that aren't billable; MTT remembers that choice for the same label and client next time and shows it to you again before you post. In a spreadsheet export, you tell MTT which pay codes to leave out.
What if the file is messy or MTT misreads it?
MTT stops and shows you, instead of guessing. If the hours it read don't add up to the total printed on the timesheet, you see the mismatch and have to acknowledge it before anything posts. Rows it couldn't read are listed. A pay code it hasn't seen holds the file until you say what it is. A week that's already in MTT asks whether to overwrite or skip. The original file is kept, so any number can be checked against it.
Can it read a monthly timesheet?
Yes, for PDFs and images. MTT reads the days and splits a monthly or multi-week timesheet into weeks ending Sunday, one weekly timesheet each. Spreadsheet exports need a week-ending date on each row.

Timesheet collection, without the typing.

30-day free trial of MTT. No credit card. Collect is switched on per account — tell us you want it.

Start your free trial →
M
Ask anything about MTT