1040 - Export a Client List
- Brandon Bellamy
- Zac Crites
This article demonstrates how to export a list of taxpayers. This can be used for creating mailing labels.
Follow the instructions below to successfully export a client list:
Method 1: Export Records
1. Open CrossLink 1040.
2. Click Utility, then click Export Records.
3. From the Export Name drop down, select Complete Mailing List.
4. Click the "…" button to open the Save As window.
5. Click Desktop and type a File name, then click Save.
6. Click Export. Once the export has finished, click OK and then Close.
The column headers in this report are:
First Name – Taxpayer’s First Name
Middle Initial – Taxpayer’s Middle Initial
Last Name – Taxpayer’s Last Name
Suf – Taxpayer’s Name Suffix
First Name – Spouse’s First Name
Middle Initial – Spouse’s Middle Initial
Last Name – Spouse’s Last Name
Suffix – Spouse’s Name Suffix
Care of/etc. – In Care of Address
Street Address – Taxpayer’s Street Address
City – Taxpayer’s City
State – Taxpayer’s State
Zip Code – Taxpayer’s Zip Code
EFIN – EFIN that is on return
Site – Site ID that is on return
Primary SSN – Taxpayer’s SSN
Receipt Number – Receipt Number that is on return
If the client list is to be used to create mailing labels, the client may want to customized the fields to remove the SSNs and other non-essential data for mailing labels prior to exporting. Otherwise, see the related "Printing Mailing Labels" articles below.
Method 2: Export Extended Report (requires Microsoft Excel)
1. Open CrossLink 1040.
2. Click Lookup > Extended > Reports
3. Click Mailing Labels by Site and then click Load.
4. Click OK.
5. Click Export.
6. In Microsoft Excel, from the Home tab menu, click on the "Find & Select" icon located near the far right of the icon bar. Select "Replace".
7. In the Find what box, type “0000-000”. Leave the Replace with box empty and click Replace All.
8. Click on the Close button.
9. If necessary remove any blank rows. You can do this by:
Clicking on the first cell on the spreadsheet, A-1
Click on the "Data" tab
Select to Sort by descending (down arrow) order A-Z
10. Click on File.
11. Click Save As. In the Save as type list, choose “Excel Workbook”.
12. Browse to the desktop and click Save (if a File Format warning dialog appears, click Ok).