Software import index

All versions

• Ensure that the chart of accounts and the year end date have been properly set up since +Vantage only imports adjusting journals.

  During the import process, if any account numbers are found in the +Vantage file but not in the current chart of accounts, the associated adjusting journals are ignored and an error message will display when the import is completed.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

8.2 / 8.3

• Set the operating system language to Russian.
• Install 1C: Enterprise [Russian version] accounting software on the machine performing the import.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.00C / 4.00G / 4.00I

• Install the ODBC Engine and Driver.
• Import File: database.df1
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2.41 / 2.43 / 2.50

• Install Microsoft Windows SQL Server locally on the machine performing the import.

• Import File: filename.bak

  (Obtained by launching Accounting Dimensions and performing a whole data back-up operation.)

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
• Store a backup copy of your database using the Access Dimensions Administrator (ADA) tool supplied with the software package.
• If the import is running on the same machine where the original Access Accounting Dimensions file is active, ensure that the backup database file name is different from the active database name, and the database file is in a different directory than the active database. Otherwise the original database must be removed from SQL server prior to importing.

7.12

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

7.52

• Import File: filename.mdb
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• Import Files:
  • Financial Periods: Periods.txt
  • GL Detail: Transactions.txt
  • Year End Balances: Yearend.txt
  • Non-Financial Data: NFD.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

6.0A / 6.1

5.4A / 5.5A / 5.6A

5.1A / 5.2A / 5.3A

5.0

4.2A

4.1B

2.x / 3.x / 4.0

• Install the ODBC Engine and Driver.
• Install Pervasive SQL (Btrieve) or Microsoft SQL.
• Import Files:
  • Profile Information: CSCOM.DAT / CSCOM.RECCSFSC.DAT / CSFSC.REC
  • Chart of Accounts: GLAMF.DAT / GLAMF.RECGLAFS.DAT / GLAFS.RECGLABK.DAT / GLABK.RECGLABRX.DAT / GLABRX.REC
  • GL Detail: GLPOST.DAT / GLPOST.REC
  • Divisional Information: Files with the extensions .dap, .dfe, and .eap
• Ensure that account structures in Accpac contain unique sequences of account segments and different total lengths. Working Papers is unable to import the division number correctly when these two structures are not defined properly. Use the ACCPAC Account Structure Configuration window to change the structures.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

PLUS 7.0

6.1 / PLUS 6.5

6.0

5.0

• Import Files:
  • Profile Information: GLGLOB
  • Chart of Accounts: GLDATA
  • GL Detail: GLPST
  • Accounting Dates: GLDATE'I
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• Install Microsoft Windows SQL Server locally on the machine performing the import.
• In the SQL Server Configuration Manager, right-click the SQL server and click Properties | FILESTREAM, then select Enable FILESTREAM for Transact-SQL access. This must be enabled before you start the server.
• Caseware Working Papers requires your database backup to be in .bak file format.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

9.2A

9.0 - 9.1A

6.x - 8.x

• Import Files:
  • Profile Information: GLGLOB
  • Chart of Accounts: GLMAST'R / GLDATA
  • Accounting Dates: GLDATE'I
  • GL Import: GLPST
  • Period Date Settings: GLFISC'R
  • Budget Data: GLNBUD'R
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2004 / 2005 / 2006 / 2009 / 2012 / 2013 / 2014 / Cloud

• Create an export file in AgExpert using the export module.
• Import Files: filename.cwe
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

1.0

• Import Files:
  • Profile Information: SYSFILE.DAT
  • Chart of Accounts: GLMAST.DATGLMASTLY.DAT
  • GL Detail: GLTRAN.DAT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• Ensure that the ATX Client Accounting Office database server/engine is running.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• Ensure that the ATX Client Accounting Office database server/engine is running.
• Use the e-bridge Export to Caseware plug-in component in ATX Total Accounting Office to create an export file.
• Import Files: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• Use ATX Total Command's e-Bridge program to create an export file.
• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

11.x - 24.5

8.x / 9.0 - 9.3

• The following files should be under a single directory:
  • Ecrsup.dbf
  • Banque.dbf
  • Pybbil.dbf
  • glsup.dbf
  • Rcvbil.dbf
  • Identif.dbf
  • livre.dbf
  • ??Solde.dbf (Where ?? is the Avantage 2-digit client number used as an identifier for the file.)
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.0

• Use the Export module in Banklink to create an export file.
• Import File: filename.CSV
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.0

3.3

• Import Files:
  • Profile Information: SN3.REC / SN4.REC
  • Trial Balance: GN3.REC / GN4.REC
  • GL Detail: JOURNAL3.REC / JOURNAL4.REC
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

Fiscalc

Accon

• Import File:
  • Client Information (Fiscalc): filename.csv / filename.fsc
  • Client Informaton (Accon): filename.txt / filename.acc
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.0x

• Install Microsoft Windows SQL Server locally on the machine performing the import.

• Import File: bigredbook_nnn.zip

  (nnn represents the number assigned to the client file.)

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

8.6 and higher

• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

11.0.0

• Import Files:
  • Consolidated Trial Balance: cwctb1.txt
  • Unconsolidated Trial Balance: cwunctb1.txt
  • GL Movements: cwglmov1.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

32 v2019(7.9.2) / v2018(7.9) / v2017(7.8) / v2014(7.7) / v2013(7.6)

32 v2009(7.3) / v2010(7.4)

32 v7.2

32 v7.x

32 v6.x

32 v5.x

32 v4.x

32 v2.x / v3.x

2000 v5.x / 6.x

Encore v3.x

Encore v2.x

Delta v5.x

Turbo v5.x

II v4.2

II v4.1

• Install the Pervasive SQL 2000 Database Engine.
• Use the export module in BusinessVision to export the chart of accounts and general ledger detail as comma-delimited ASCII files.
• Import Files:
  • Chart of Accounts: GL-CHART.TXT
  • GL Detail: GL.TXT
  • Profile Information: BVCON.FIL
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

3.1

3.0

1.33

DELTA 3.1

DELTA 3.0

DELTA 1.33

TURBO 4.4

TURBO 4.3

TURBO 4.24

• Use the export module in BusinessVision to export the chart of accounts and general ledger detail as comma-delimited ASCII files.
• Import Files:
  • Chart of Accounts: GL-CHART.TXT
  • GL Detail: GL.TXT
  • Profile Information: BVCON.FIL
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

1.0

• Import Files:
  • Chart of Accounts: filename.TXT
  • GL Detail: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

C4

• Import Files:
  • Chart of Accounts: PRIMO.TXT
  • GL Detail: FINANS.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.2.73 / 6.3

• Install the ODBC Engine and Driver.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2006 - 2015

5.x - 6.x, 7.1, 7.3

• Install the DAO import update.
• Import File: filename.WSW
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

Win v13.0

Win v9.0 - v12.0

6.0

4.4

4.3

4.2

• Install the Pervasive SQL 2000 Database Engine.
• Import Files:
  • GL Detail: DEAGLTD.DB
  • Profile Information: DEAGNRL.DB
  • Trial Balance: DEAGLTH.DB
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.6 / 5.61 and higher

• Import Files:
  • Balance Records: DatevexportKMVZ.txt
  • Account Name Records: DatevexportKTSKI.txt
  • Company Information: DatevexportMADMPD.txt
  • Trial Balance File: SKR*.csv
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.6 / 5.61 and higher

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

v10.0 - v11.0

v9.0

v8.0

v6.4 - v7.0

v4.0.3

• Install the DAO import update.
• Import Files:
  • 6.4 - 7.0: filename.mdb
  • 8.0 - later: filename.ddb
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

7.0

6.5

• Install Satellite Server by Sumatra (available for purchase at: www.sumatra.nl).
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Enable Internet Information Services (IIS) on the workstation performing the export (Control Panel | Programs | Turn Windows features on or off, select Internet Information Services).
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.6

• Use the export module in Expert Comptable to create an export file.
• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2.0

• Use the export module in EZEBiz Company Manager to create an export file.
• Import File: filename.csv
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2.6

2.3

2.2

2.1

2.0

• Import Files:
  • Date Information: MUMBU.ext
  • Profile Information: PARBU.ext
  • GL Detail: BUNIDET.ext
  • Trial Balance: ACCOUNTS.ext
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

989.1

987.2

• Import Files:

  • Chart of Accounts: CODEINDX.xxx
  • Extended Account Descriptions: LANCO.xxx
  • Prior Year Figures: FIGZZZZZ.xxx
  • Budget Figures: GLTOTS.xxx
  • Date Information: MUMBU.xxx
  • Profile Information: PARBU.xxx
  • GL Detail: BUNIDET.xxx

  (xxx is the three-digit Finax extension. ZZZZZ is the five character comparative identifier.)

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.0x - 6.0x, 6.15, 6.21, 7.x, 8.2, 9.53

3.2x - 3.5x

2.1x

2.0x

• Import Files:
  • Chart of Accounts: SCHARTE.FDW
  • Journal Entries: GJOURNAL.FDW
  • # of Accounting Periods: GCTRL.FDW
  • Detailed Postings: GPOST.FDW
  • Client Information: SINFOCIE.FDW
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

9.0

6.0

5.2

• Import Files:
  • Chart of Accounts: GGL.FDA
  • GL Detail: GJOURNAL.FDA
  • Profile Information: GCIE.FDA
  • Budget Figures: GPOST.FDA
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

Dynamics 8.0 / 9.0 Export

Dynamics 7.5

Dynamics 6.0

Dynamics 5.5

Dynamics 5.0

(Dos) 6.1 / 8.2

Pervasive SQL (Btrieve)

• Install the Pervasive SQL 2000 Database Engine.
• Import Files:
  • Company List: Dynamics \ SY02100.BTR
  • Company Information: Dynamics \ System \ SY01500.BTR
  • Account Number Structure: Dynamics \ System \ SY00302.BTR
  • Period Dates: Dynamics \ <Client> \ Company \ SY40101.BTR
  • Chart of Accounts: Dynamics \ <Client> \ finance \ GL00100.BTR
  • Account Numbers: Dynamics \ <Client> \ finance \ GL00105.BTR
  • Budget Balances: Dynamics \ <Client> \ finance \ GL00201.BTR
  • Trial Balance: Dynamics \ <Client> \ finance \ GL10110.BTR
  • GL Detail: Dynamics \ <Client> \ finance \ GL20000.BTR
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

C-Tree Plus

• Import Files:
  • Company List: Dynamics \ SY02100.DAT
  • Company Information: Dynamics \ System \ SY01500.DAT
  • Account Number Structure: Dynamics \ System \ SY00302.DAT
  • Period Dates: Dynamics \ <Client> \ Company \ SY40101.DAT
  • Chart of Accounts: Dynamics \ <Client> \ finance \ GL00100.DAT
  • Account Numbers: Dynamics \ <Client> \ finance \ GL00105.DAT
  • Budget Balances: Dynamics \ <Client> \ finance \ GL00201.DAT
  • Trial Balance: Dynamics \ <Client> \ finance \ GL10110.DAT
  • GL Detail: Dynamics \ <Client> \ finance \ GL20000.DAT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

8.8.5 / 10.2.0 / 10.4 / 10.6 / 10.9

• Install Microsoft Windows SQL Server locally on the machine performing the import.
• Set up access to IRIS data on a remote SQL server.
• Import Files:
  • IRIS.mdf
  • IRIS_log.ldf
• Caseware Working Papers requires your database backup to be in .bak file format.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

1.0

• Import Files:
  • Chart of Accounts: AUDITAGT.TXT
  • GL Detail: AUDITGLT.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

K / 3 V10.x

Hong Kong 2003

• Use the export module in King Dee to create an export file.
• Install Microsoft Windows SQL Server locally on the machine performing the import.
• Import Files:
  • K/3 V10.x: filename.bak
  • Hong Kong 2003: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.5

4.4

4.2 / 4.3

3.61 / 3.71 / 4.0

3

• Create a new folder outside of your MAS 90 directory. In MAS 90, select a company ID and export the Trial Balance to a fixed ASCII file in the new folder. Inside the folder, create a sub-folder, then copy the SY0CTL.SOA file from the MAS 90 SOA folder into the sub-folder.
• Export the the data that you would like to import (Trial Balance, General Ledger Detail, Prior Year Data or Budget data).
• Import File: GL_FiscalYearDetail.m4t
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2010

• Install the Dynamics C5 ODBC driver.

  Note: When ODBC driver accesses Dynamics C5 data files, it will authenticate the access right. You must login Windows with the same user as you operate Dynamics C5.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2010

• Install the Dynamics C5 ODBC driver.

  Note: When ODBC driver accesses Dynamics C5 data files, it will authenticate the access right. You must login Windows with the same user as you operate Dynamics C5.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2010

• Install SQL Express or MS SQL Server locally on the machine performing the import.
• Create a backup of the MSSQL database.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

8.0 / 9.0 / 10.0 / 2010 / 2013 / 2015 / 2016

• Install SQL Server 2005 (Express Edition) Service Pack 2 locally on the machine performing the import
• Create two database backup files from Microsoft Dynamics GP, copied to the same local folder:
  • A system database backup file named DYNAMICS.BAK.
  • A company database backup file with the extension BAK, for example, MyCompany.BAK.

  Note: The .BAK files must be placed in a local folder that the program (CWIN32.EXE) has full access rights to. For example, do not put the import files into the C:\Documents and Settings\%UserName% folder as Working Papers does not have full access rights to this directory.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• You must have an active internet connection.
• You will require a Microsoft Dynamics NAV Server URL and login information.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2008 UK / 2008 US / 2009 US

2007

• Install Microsoft SQL Server 2005 locally on the machine performing the import.
• Import File: filename.sbb
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.2.3 and higher

• Use the export module in MoneyWorks to create an export file.
• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2006

• Install Microsoft Windows SQL Server locally on the machine performing the import.
• The only required Microsoft Small Business Accounting file is a .zip backup file created by MS_SBA obtained by doing a whole data back-up operation. For details on how to perform a data backup, see Microsoft Small Business Accounting's online help.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

8.3

• Use the export module in Multi Express Business & Accounting to create an export file.
• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

Premier 10.x.x Australia

• Install the ODBC Engine and Driver.
• Import File: filename.MYO
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

17.x.x - 18.x.x Australia

14.x.x - 17.x.x UK

11.x.x - 13.x.x

10.x.x

9.x.x

7.0.9 - 8.x.x

7.0.0 - 7.0.8

Premier 11.x.x - 12.x.x Australia

Premier 5.x.x

Premier 4.x.x

Premier 3.x.x

Premier 2.x.x

Premier 1.x.x

• Create an export file in MYOB by clicking File | AccountantLink | Send to Caseware.
• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2010(v19) / 2011(v20) / 2014(v23)

• Create an export file in MYOB by clicking File | AccountantLink | Send to Caseware.
• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

19

• Create an export file in MYOB by clicking File | AccountantLink | Send to Caseware.
• Import File: filename.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2013 - 2021

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.03

5.02

5.0

• Import Files:
  • Chart of Accounts: CODEINDX.xxx
  • Extended Account Descriptions: LANCO.xxx
  • Prior Year Figures: FIGyyyyy.xxx
  • Budget Figures: GLTOTS.xxx
  • Date Information: MUMBU.xxx
  • Profile Information: PARBU.xxx
  • GL Detail: BUNIDET.xxx

  (xxx represents the 3-digit extension of the Orchard file. yyyyy represents the five character comparative identifier.)

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2017 / 2013 / 2012

• Install Microsoft Windows SQL Server 2008R2 Express locally on the machine performing the import.
• Import File: filename.palbk (obtained by launching Palladium Accounting, and performing a whole data back-up operation)
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.01.36 / 6.80.xx / 6.81.xx / 6.82.xx / 7.xx

3.05.20

• Export the transactions in Pastel Evolution to create an export file.
• Import Files:
  • Consolidated Trial Balance: cwctb1.txt
  • Unconsolidated Trial Balance: cwunctb1.txt
  • GL Movements: cwglmov1.txt
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

14.0.x / 14.1.x / 17.1.x / 18.2.x / 19.1.x

2009(10.2.4) / 11.1.0 / 11.2.2 / 12.0.1 / 12.1.1 / 12.1.4 / 12.1.6

2009(10.2.3)

2007(9.3.x) / 2009(10.0 / 10.1.x)

2007(9.2.x)

2005(8.0) / 2007(9.1.x)

6.0 / 6.2 / 2004(7.0)

5.2

5.00a

4.04

3.03

• Import Files:
  • Chart of Accounts: ACCMAS.DAT
  • GL Detail: ACCTRN.DAT
  • Profile Information: ACCPRMGL.DAT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

12.0

11.0

6.0

• Import Files:
  • Chart of Accounts: GLxx MST7.Dyy
  • GL Detail: GLxxTRN7.Dyy
  • Year End/Period Dates: GLOPTS.Dyy

  (xx represents the current period number for the Peachtree file. yy represents the two-character client code (Company ID) for the Peachtree file.)

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

1.1.00

• Import Files:
  • Profile Information: SYSTEM.DBF
  • Trial Balance: NLNAME.DBF
  • GL Detail: NLTRAN.DBF
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

6.8

2.40

2.04

• Import Files:
  • Profile Information: _NPARM.DBF
  • Chart of Accounts: _NACNT.DBF
  • Budget Balances: _NBUDG.DBF
  • GL Detail: _NTRAN.DBF
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.1 / 5.2 / 5.3 (Windows)

5.01 (Windows)

3.0

• Import Files:
  • Chart of Accounts: NLCHART
  • Period Dates: NLPDATES
  • Period Balances: NLBAL
  • Company Information: NLCOSUB
  • Journal Batch Details: NLTXD
  • History Batch Details: NLTXDH
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.1 - 15.0

• Use the export module in Proven Solutions Accounting to create an export file.
• Import File: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

1.0

• Import Files:
  • Trial Balance: filename.xxx
  • Cash Flow: filename.xxx

  You can import either one or both of these files. There is no set format for the file name and extension for these files.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

QuickBooks Online

Australia

2003 - 2013, 2016 - 2023

8.x

7.x

Canada

1999 - 2023

2008 Multicurrency

6.0

5.0

UK

1999 - 2008, 2010, 2012 - 2023

6.0

5.0

US

1999 - 2023

6.0

5.0

• QuickBooks Online:
  • Install Microsoft .NET Framework 4.0 on your workstation.
  • Install the QuickBooks Export Utility on your workstation. You can download it from MyCaseware on the Support Downloads page.
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
• QuickBooks Canada / UK / Australia:
  • Install an applicable version of QuickBooks on your workstation.
  • Install the QuickBooks Export Utility on your workstation. You can download it from MyCaseware on the Support Downloads page.
  • In QuickBooks, you must permit the QuickBooks Export Utility access to the file. On the ribbon, click Edit | Preferences... | Integrated Applications | Company Preferences and deselect Don't allow any applications to access this company file.
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
• QuickBooks US:

  A recent change to QuickBooks US disabled functionality used by the Working Papers Import dialog. As a workaround, you can continue to import data using the same process and prerequisites as QuickBooks Canada / UK / Australia.

  Note: Due to formatting differences between QuickBooks US and QuickBooks Canada / UK / Australia, the import process can cause unnumbered accounts to duplicate. We recommend that you check these accounts to ensure the data is imported correctly and not duplicated.

4.0

• Create an export file from QuickBooks using the Export Module, then import that file into Working Papers using the QuickBooks (Export From QB) option.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

0.91 and higher

• Use the export module in RealBroker to create an export file.
• Import File: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2012 - 2017

• Install the ODBC Engine and Driver.
• Install Pervasive SQL (Btrieve) or Microsoft SQL.
• Import Files:
  • Profile Information: CSCOM.DAT / CSCOM.RECCSFSC.DAT / CSFSC.REC
  • Chart of Accounts: GLAMF.DAT / GLAMF.RECGLAFS.DAT / GLAFS.RECGLABK.DAT / GLABK.RECGLABRX.DAT / GLABRX.REC
  • GL Detail: GLPOST.DAT / GLPOST.REC
  • Divisional Information: Files with the extensions .dap, .dfe, and .eap
• Ensure that account structures in Accpac contain unique sequences of account segments and different total lengths. Working Papers is unable to import the division number correctly when these two structures are not defined properly. Use the ACCPAC Account Structure Configuration window to change the structures.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

Line50 v2007 - v2021

Line50 v10 - v12

Line50 v5.x - v9.x

Sterling (3.1 / 4.0), Line50 v4

Financial Controller (Dos) v9

Financial Controller (Dos) v7

Financial Controller (Dos) v6 / v5

Accountant Plus v6 (Dos)

Bookkeeper v6 (Dos)

• Import Files (Sage Sterling, Line 50):
  • Profile Information: ACCDATA\ACCOUNT.DTA
  • Chart of Accounts: ACCDATA\NOMINAL.DTA
  • CoA Index: ACCDATA\NOMINDEX.DTA
  • GL Detail: ACCDATA\SPLITS.DTA
  • Company Information: ACCDATA\SETUP.DTA
  • Account Types: ACCDATA\COA
  • Bank Information: ACCDATA\BANK.DTA
  • Ledger Index: ACCDATA\HEADER.DTA
  • Department Information: DEPARTM.DTA
• Import Files (DOS):
  • Profile Information: ACCDATA\ACCOUNT.DTA
  • Chart of Accounts: ACCDATA\NOMINAL.DTA
  • CoA Index: ACCDATA\NOMINDEX.DTA
  • GL Detail: ACCDATA\POSTING.DTA
  • ReadRecs: ACCDATA\CATEGORY.DTA
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2012 - 2021 Direct

2007 / 2008 / 2009 / 2010 / 2011 Direct

2004 / 2005 / 2006 Direct

8.0 - 10.0(2003) Direct

9.0(2002) Export

8.0 Export

7.0 Export

• Install Pervasive SQL version v9.1 or later.
• Remove the read-only attribute from all files in the client data folder (right-click the files, click Properties | General, then deselect Read-only).
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2019.1 - 2019.3 / 2020 / 2021 / 2022 / 2023

2008 - 2019.0

2005 Premium / 2006 / 2007

2003 / 2004 / 2005 Direct

8.5 / 9.x Direct

8.0 Direct

8.0 / 8.5 Export

2.0 - 7.0

• Install either Sage 50 Accounting (CDN Edition) or the Sage 50 Connection Manager utility from MyCaseware. You must have one of these applications to perform the import; however, do not install both.
• If you are importing data from a version older than 2008, install the DAO import update.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

6.0A / 6.1

5.4A / 5.5A / 5.6A

5.3A

• Install the ODBC Engine and Driver.
• Install Pervasive SQL (Btrieve) or Microsoft SQL.
• Import Files:
  • Profile Information: CSCOM.DAT / CSCOM.RECCSFSC.DAT / CSFSC.REC
  • Chart of Accounts: GLAMF.DAT / GLAMF.RECGLAFS.DAT / GLAFS.RECGLABK.DAT / GLABK.RECGLABRX.DAT / GLABRX.REC
  • GL Detail: GLPOST.DAT / GLPOST.REC
  • Divisional Information: Files with the extensions .dap, .dfe, and .eap
• Ensure that account structures in Accpac contain unique sequences of account segments and different total lengths. Working Papers is unable to import the division number correctly when these two structures are not defined properly. Use the ACCPAC Account Structure Configuration window to change the structures.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

32 v2019(7.9.2) / v2018(7.9) / v2017(7.8) / v2014(7.7) / v2013(7.6)

32 v2009(7.3) / v2010(7.4)

32 v7.2

32 v2.x - v7.x

2000 v5.x / 6.x

Encore v3.x

Encore v2.x

Delta v5.x

Turbo v5.x

II v4.2

II v4.1

• Install the Pervasive SQL 2000 Database Engine.
• Use the export module in BusinessVision to export the chart of accounts and general ledger detail as comma-delimited ASCII files.
• Import Files:
  • Chart of Accounts: GL-CHART.TXT
  • GL Detail: GL.TXT
  • Profile Information: BVCON.FIL
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

6.0

• Import Files:
  • Company Information: aDb.dbf
  • Chart of Accounts: aNomCd.dbf
  • Journal: aJrnl.dbf
  • Year End Dates: apex.ads
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

R / 3

• Import File: filename.DAT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.0 and higher

• Use the Export module in Settler GOLD Farm Software to create an export file.
• Import File: filename.cwe
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

8.2 and higher

• Use the Export module in SigaFinance to create an export file.
• Import File: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2019.1 - 2019.3 / 2020

2008 - 2019.0

2005 Premium / 2006 / 2007

2003 / 2004 / 2005 Direct

8.5 / 9.x Direct

8.0 Direct

8.0 / 8.5 Export

2.0 - 7.0

• Install either Simply Accounting Windows or the Sage 50 Connection Manager utility from MyCaseware. You must have one of these applications to perform the import; however, do not install both.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2008

• Download and run the Sage 50 Connection Manager utility from MyCaseware to create a Simply Accounting 2008 export file.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2.0.0 - 4.0.0

• Import Files:
  • Client Information: SYSTEM.DBF
  • Profile Information: PERIOD.DBF
  • Trial Balance: ACCOUNT.DBF, EXRATES.DBF
  • GL Detail: LEDGER.DBF, TRANS.DBF
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

9

• You must have an activated and licensed version of Tally Accounting (installed locally or on a computer accessed by a network).
• In the Advanced Configuration menu:
  • Confirm that Tally is acting as the Server or Both
  • Ensure that Enable ODBC Server as is set to Yes
  • Confirm the Port (default is 9000)
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

9

• In Tally Accounting 9, use the standalone export utility (Export utility for Tally.ERP9) to create the following client data files:
  • companyID.yyyymmdd.Company.dat
  • companyID.yyyymmdd.Chart.txt
  • companyIDyyyymmdd.TBal.txt
  • companyIDyyyymmdd.Budget.txt (optional)
  • companyIDyyyymmdd.Forex.txt (optional)
  • companyIDyyyymmdd.GL.txt
  (companyID represents the Company ID, yyyymmdd represents the Year Begin Date)
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

8.2 / 8.5

8.11

• Install Microsoft Windows SQL Server locally on the machine performing the import (if you do not have the Ufsoft application installed or have access to its database).
• Import Files:
  • Version 8.2 / 8.5: Ufdata.bak
  • Version 8.11: Copy Ufdata.mdp and Ufsystem.mdp to another folder.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

All versions

• Import File: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

3.0.4000 / 7.2

• Install the DAO import update.
• Import File: filename.MDB
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.32

• Use the export module in Windward System Five to create an export file.
• Import File: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

1.9

• Use the export module in WinLedge to create an export file.
• Import File: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2013

• Manually set your engagement's properties before attempting the import as it contains no client profile information.
• Export transaction data into a .txt file. In the Adviser | Export menu, click the Select product drop-down menu and select XERO. Specify the date range of the data and click Download.
• Export the chart of accounts into a .csv file. In the Adviser | Export menu, click the Select product drop-down menu and select Lacerte Tax (even if you do not use Lacerte Tax). Specify the year end date and click Download.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

7.02 and higher

• Use the export module in Xyntax Native Systems to create an export file. The components of the export file determine what is able to be imported into Working Papers.

  Note: Make sure that you specify no conversion or binary in the file transfer. If you do not, you may not be able to import the general ledger or Trial Balance successfully. If you encounter a situation where the general ledger or Trial Balance doesn't seem to be imported correctly, repeat the export from Xyntax specifying binary or no conversion.

• Import File: filename.TXT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

5.0 / 6.0 / 6.5 / 7.0 / 7.5

4.0

2.1 / 3.0

• Install the DAO import update.
• Import Files:
  • CIE.DAT
  • CIE.MDB
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

Audit Plus 2.0

Audit / Audit Plus 1.0

7.2

7.0

4.5

4.0

3.0

• Install the Pervasive SQL 2000 Database Engine.
• Import Files:
  • Prior Year Figures: HISTORY.DAT
  • Profile Information: CLIENT.ID
  • Chart of Accounts: CHART.DAT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

96.01 / 98.02

3.0h

3.0

2.1

• Import Files:
  • Chart of Accounts: C*.DBF / filename.DBF
  • Client Information: M*.DBF
  • GL Detail: T*.DBF
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

3.03 - 3.05

2.xx

1.3

1.0

• Import Files:
  • Client Profile: filename.SER
  • Prior Year Data: filename.PRI
  • Chart of Accounts: filename.CHT
  • Transactions: filename.TRN
  • Journal Descriptions: filename.MRN
  • Grouping Information: filename.GRP
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Import Files:
  • Client Index: MLIST.C00
  • Trial Balance: CLIDATA.C00
  • Client File Information: HEADINGS.C00
  • Client File Information: NOTES.C00
  • Journal Entries: POSTINGS.C00
  • Client File Information: POSTYPES.C00
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Ensure the NTRPRISE.DBD file is in the same directory as the Auditvision data files.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Install the DAO import update.
• Import Files:
  • CIE.AVP
  • CIE.MDB
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

6.01

3.0

• Import Files:
  • Profile Information: filename.GLM
  • Trial Balance: filename.GLA
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Import Files:
  • Profile Information: GLCONTRL.DBF
  • Period Dates: GLFISCAL.DBF
  • Trial Balance: GLACNO.DBF
  • GL Detail (Current period): GLTRCUR.DBF
  • GL Detail (Ealier periods): GLTRHST.DBF
  • GL Detail (Later periods): GLTRFUT.DBF
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Install the DAO import update.
• If the client file you want to import is compressed (file extension .WSZ), open it in Engagement CS to automatically uncompress it to a .WSW file.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

3.0

2.5x

• Microsoft Windows SQL Server installed locally on the machine performing the import.
• Ensure the Bnd.dbf and Clnt.dbf files are in the ePaceENGAGEMENT data folder.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

95.01

94.02

93.1

91.1

90.2

89.3

88.0

• Import Files:
  • Trial Balace: ACCTFILE.DBF
  • Profile Information: CLIENT.DBF
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2.04 / 2.05 / 2.06

2.02

• Import Files:
  • Profile Information: CLIENT.DAT
  • Trial Balance: ACCOUNT.DAT
  • Trial Balance Index: ACCOUNT.K02
  • Tax Entity & Codes: TAX.DAT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Import Files:
  • Trial Balance: CHART
  • Profile Information: CLIEN
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.3 / 4.4.x / 4.5.0

3.x / 4.2

• Install the DAO import update.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Install the DAO import update.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Import File: EngrFile.eng
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

6.x / 7.x / 2017 / 2018 / 2019

4.x / 5.0 / 5.5 / 5.7

3.5 / 3.7

• Install and configure a SQL Server instance on your workstation to facilitate the conversion.
• Ensure you have a local installation of ProSystem fx Engagement on your workstation.
• Synchronize your Binders by selecting a Binder then clicking Tools | Synchronize Binder.....
• For basic bulk imports, download the profxgroup.zip file and extract it in your Working Papers program folder.
• For advanced bulk imports, download the CCHExcelConfig2.xlsx file and move it to your Working Papers program folder.
• For advanced imports, create a bulk autofill and a mapping/grouping initialization file.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
• If applicable, after the import, convert ProSystem fx Engagement links in Word or Excel documents to Caseware Connector links.

• Import Files:

  (x represents the year to import, y represents the type of corporation.)

  • Company Data: *.xyC
  • Tax Data: *.xyT
  • Chart of Accounts*.xyA
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

2008.A00

2004.A01 - 2007.A00

2003.A00 / A01

2001.B00

2001.A01

2000.B00

• Ensure the NTRPRISE.DBD file is in the same directory as the ProSystem fx data files.
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Import File: filename.EYT
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

11.0

8.0

7.0

5.2

• Import Files:
  • Trial Balance: filename.adm
  • Template File: filename.csv
  • Company Information: filename.prj
  • Company Name: filename.org
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.0a / 4.1

3.2

2.0

• Import File: TRANSFER.xxx

  (xxx represents the transfer file name extension of the WISPR export file.)

• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

• Install the DAO import update.
• Copy the Client.mdb file to a designated directory and save the file for import.
• Import File: filename.mdb
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.

4.1

3.3

• Import File: clientIDDBF
• If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.