To export Client Manager data to a Microsoft Excel® workbook:
Go to theList Returnsview. See theClient Manager Views help topic. When you export to Excel®, TaxCycle uses the same columns in the same order as they appear on the screen. Change the column layout or the order of columns before you export. (See theColumn Layouts help topic.)
Click the Excel® icon at the top right of the table to get to see the following options:
Export to an Excel® Workbook—Export exactly what you see on the screen, the columns and rows in the current view.
Export to a detailed Excel® Workbook—Export exactly what you see on the screen, plus additional information you can’t see about the file status, invoice and taxpayers.
Export Return Status to an Excel® Workbook—Export details of the return status for the returns currently listed on the screen.
Export Contact Information to an Excel® Workbook—Export the contact information for the list of clients you see on the screen. This includes mailing address, email address and phone information along with names and family information. It’s great for creating a mail merge in Microsoft Word®.
Full Data Export—Export all the database information to a CSV file. Note that this is the information stored in the database index and not that in the TaxCycle files themselves.
Click the Excel®icon with the envelope next to it to export a workbook and attach it to an email message. This contains the same columns as appear in theExport to an Excel® Workbook option, above.