Looking for a Michigan Tax Forms And Templates? Download it for free!

Form Bcw-2-Mt - Transmittal Of Information Returns Cd Or Diskette Reporting For Tax Year 2006 Page 3

How to Create CTP format using Microsoft Excel

Note: All dollar amounts should be entered as normal number with decimal point, such as 15100.50

1. Open a new spreadsheet.

2. On the first line, enter the Employer data as specified above, entering one value per column.

The letter shown at the start of each line must match the letter at the top of the column in

Excel. Skip the column if blank. Insure all entries are upper case. To start, enter “CTE” in the

first column.

3. For each employee, enter another line, entering CTE in the first column (A) and entering one

field per column.

4. Click on the Save button (or select Save from the file menu). At the bottom is a drop down box

for Save as type. Click on this drop-down and select “CSV (Comma delimited)(*.csv)”

then enter a file name and click save.

5. Copy this file to a diskette or compact disc and send to the Income Tax office.

Submitting W2s Electronically

Federal Filing Format – MMREF-1

Information about the Federal MMREF format is available on the Social Security Administration

website at::

Note that the record with local information is not required for filing federally. The IRS record must be

included to provide city information.

CityTax Proprietary Format (CTP)

This is a simple format for a single employer. It may be created using Microsoft Excel. It is a Comma

Delimited format. Details are on a later page.

The following table lists critical fields, with the location in that format

Format Type

MMREF

CTP

Local Entity

Record

CTW

Code

Start Position

Length

Value

Local

Record

CTW

Withholding Start Position

320

Length

Local

Record

CTW

Taxable

Start Position

309

Length

Updated 11/03/2006

Form Bcw-2-Mt - Transmittal Of Information Returns Cd Or Diskette Reporting For Tax Year 2006 Page 3

Related Articles

Related forms

Related Categories