Export Data for TRAMS

The file created is a tab delimited file, which can be read using the TRAMS import function. (TRAMS is software used by travel agencies.)

Since Medlin Payroll has more deduction and income fields than tracked in TRAMS, some of the fields in Medlin, if used, will be combined into one TRAMS field.

Column / Field	Medlin Data	TRAMS Import Field Name	Description
1	Employee Memo	Interface ID	Up to 10 characters long
2	Employee First Name		Up to 20 characters long
3	Employee Last Name		Up to 20 characters long
4	Paycheck FWH	Fed Tax G/L
5	Paycheck SWH	State Tax G/L
6	Paycheck Social Security WH	FICA G/L
7	Paycheck Medicare WH	Medicare G/L
8	Not Used
9	Not Used
10	Paycheck Deduction Pos 5	Misc Deduct 1 G/L
11	Paycheck Deduction Pos 6	Misc Deduct 2 G/L
12	Paycheck Deduction Pos 7	Misc Deduct 3 G/L
13	Paycheck Deduction Pos 8	Misc Deduct 4 G/L
14	Paycheck Deduction Pos 9	Misc Deduct 5 G/L
15	Paycheck Deduction Pos 10 - 14	Misc Deduct 6 G/L
16	Employee Department "EMP" Total/Gross Pay	Compensation 1 G/L
17	Employee Department "OWNER" Total/Gross Pay	Compensation 2 G/L
18	Employee Department "COMMIS" Total/Gross Pay	Compensation 3 G/L
19	All Other Employee Departments Total/Gross Pay	Compensation 4 G/L
20	Not Used
21	Not Used
22	Not Used
23	Paycheck Date
24	Paycheck Number
25	Method of Payment
26	Employer's Social Security
27	Employee's Additional Medicare		Not presently used by TRAMS. Only needed if an employee earns over $200,000 in a year.

•Medlin Payroll handles employee (payroll) data/payments/reporting only. To pay non employees, use TRAMS directly.

•It appears TRAMS assumes the emplyoer and employee Medicare liability is always the same. This is NOT true once an emplyoee earns over $200k in a year. If you have any employee who has earned over $200k in a year, after importing into TRAMS, make some sort of manual adjustment, in TRAMS, to lower the employer Medicare liability as needed. Use the Medlin Payroll Tax Summary report to see an accurate total of the liabiliities.

•The image below is our recommendation for setup within TRAMS. We cannot help with specific TRAMS setup as to how to post your payroll costs - that is a bookkeeping decision the employer must make.