Export adjusting entries
You can export adjusting entry data to a variety of different accounting software packages. The export file's name and file type are specific to the target software package.
Software | Export file |
---|---|
<Generic> | cwadj.txt |
CaseWare | cwadjust.caj |
Exact | exactadj.txt |
MYOB | cwmyob.txt |
Pastel Partner | caseweg.csv |
QuickBooks (2019 and earlier) | cwquickbb.iif |
Sage 50 | cwsage.csv |
Simply Accounting | cwsimply.txt |
Venice | cwvenice.txt |
To export adjusting entries:
- On the ribbon, click Engagement | Export | Adjustments.
-
The Export Adjustments dialog displays. Complete the dialog as required.
Option Description File Format
Select the export file format that you want to export.
Export File
Type or click Browse to enter a directory path to where the file should be exported.
Entity Specific Export
Select to export information about a single entity only. Only available in consolidated client files.
Include Sub Entities
Select to export associated sub entities along with the entity. When selected, a consolidated total of the parent company and its subsidiaries is exported.
Note: The parent company name and address will be included for all tax exports. If exporting entity specific data from a consolidated file, company name and address for sub entities must be modified in the tax software once data has been imported.
Calculated adjusting entries only
Select to export only calculated adjusting entries.
Use Extended Description for Account Name
Select to use the extended description as the account name.
All dates inclusive / From / To
When selected, all adjusting entries in the period are exported. If cleared, specify the date range of adjusting entries to be exported.
Date Format
Only available for MYOB exports. Select the date format used in your version of MYOB The default format is MMDDYY.
Period / Adj.Type / Balance / Misstatements / Accounts / Apply to
Select from the applicable fields to filter on the type of adjustments to be exported.
Click OK.
Adjusting Entry data is exported to a file in the specified destination.
Notes:
- For MYOB exports, select the date format used in your version of MYOB. The default format is MMDDYY.
- For QuickBooks exports, if you imported a QuickBooks file with Import Account Name into Extended Description selected, you must select Use Extended Description for Account Name when exporting adjusting entries.