Tax export to ProSystem fx
Use the Export Client Data Wizard to export client tax data to your ProSystem fx tax application from
Accounting CS
. Exporting client tax data to ProSystem fx Axcess is currently unavailable. You can specify the export file (or files), tax year, balance type, and format of the data to export. The tax code assignments that you make for specific general ledger accounts in Accounting CS
enable ProSystem fx to carry account balances to the proper lines on the appropriate tax forms.Before you transfer account balances from
Accounting CS
to ProSystem fx, verify that the data paths are set up correctly in both applications. To do this in Accounting CS
, select Setup
> File Locations
> Export
tab to set up file locations for ProSystem fx and other applications.Pre-export steps in Accounting CS
Accounting CS
Assign the appropriate tax codes for the selected client in either of the following screens.
- In the Tax information section of theChart of Accountsscreen.
- In the data-entry grid in theEnter Trial Balancescreen. If the data-entry grid doesn’t include aTax Codecolumn, selectView Maintenanceat the top of the screen, and then add a column for tax codes.
note
- Accounting CScreates and saves the export data as an ASCII file, as required by ProSystem fx.
- If a file of the same name already exists in the specified location for the export file, the application overwrites the existing file.
- If client data does not exist for the selected tax year,Accounting CScreates the export file but includes only header information.
- During the creation of the export file, theAccounting CStax codes are converted to the ProSystem fx tax codes.
- You can create custom tax codes inAccounting CS. When a custom tax code is assigned to an account, the standard Accounting CS tax code is mapped to the appropriate ProSystem fx tax code.
- Accounting CSalways exports custom tax codes in a summary format, which means that it combines all accounts assigned to the same custom tax code into a single record in the export file.
Process steps in ProSystem fx
Complete these steps in ProSystem fx to import the data you exported from
Accounting CS
in the procedure.- SelectFile>Import>GL Bridge.
- Select the Accounting system from the dropdown list.
- SelectImport Fileto select a file.
- Select the drive, folder, and filename extension for the file to use as the interface file.
- Select the file and selectOK. The application imports data from the export file into the ProSystem FX Return.
Fields and buttons
Source Data
- Client name:Select a client from the dropdown list or to export data for multiple clients at the same time, select thePerform batch export of client datacheckbox.
- Export to program:SelectProSystem fx.
- File Location:Enter the path or go to the client data file. (The default data file location for each export type can be defined in the Export Data tab of theSetup>File Locationswindow.)
- Balance Type: Choose the balance type for which to export data —TaxorAdjusted.
- Tax Year:Select the tax year for which to export client data.
- Format:Select the format to the export balance sheet information -Detailfor itemized format orSummaryfor a condensed format.
Source Data - Clients
When you mark the
Perform batch export of client data
checkbox in the Source Data
screen and select Next
, the wizard opens this screen to enable you to select the clients whose data you want to export.- Search and Filter:Use these fields to filter the list of clients in the Clients grid.
- Clients grid:Mark the checkbox for each client to include in the export file. (The application creates a single export file for each selected client.)