Software Import Index

The following index contains the full list of supported software imports, supported versions and prerequisites you must complete prior to the import.

To perform an import, see Import from Accounting Software or Import from Working Paper Software.

Note: To search this page for your software package, press CTRL + F on your keyboard, then enter the software package name in the search field.

Accounting Software

Accounting Software Supported Versions Import Prerequisites
+Vantage

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.
1C: Enterprise [Russian version]

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.
Access Accounting

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.
Access Accounting Dimensions

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.
Accountant's Drill

7.12

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

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.
AccountView

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.
Accpac (Advantage Series)

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.
Accpac (DOS)

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.
Acomba X

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.
Adagio Ledger

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.
AgExpert

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.
Attache Business Partner

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.
ATX Client Accounting Office

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.
ATX Total Accounting Office

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.
ATX Total Command

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.
AVANTAGE Progression

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.
Banklink

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.
Bedford Simply Accounting DOS

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.
Belgium

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.
Big Red Book

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.
Blue Link Solutions

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.
Brilliant Accounting

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.
BusinessVision

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.
BusinessVision (Legacy)

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.
C&LAS

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.
Concorde

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.
Connected Accounting & ERP

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.
Creative Solutions Accounting

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.
DacEASY

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.
DATEV

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.
DATEV (Direct)

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.
DYNACOM

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.
E-conomic Online Accounting

All

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

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.
EXACT Online All versions
  • 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.
Expert Comptable

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.
EZEBiz Company Manager

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.
Finax v2*

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.
Finax v9*

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.
Fortune1000 Acomba

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.
Fortune1000 DOS

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.
Great Plains

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.
IRIS Accounts Production

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.
KHK

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.
King Dee

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.
MAS 90 for Windows

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.
Microsoft Dynamics C5 Inventio - Native

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.
Microsoft Dynamics C5 Inventio - √Örsafslutning

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.
Microsoft Dynamics C5 Inventio - MSSQL

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.
Microsoft Dynamics GP

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.
Microsoft Dynamics NAV (Norriq Accounting)

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.
Microsoft Office Accounting

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.
MoneyWorks

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.
MS Small Business Accounting

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.
Multi Express Business & Accounting

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.
MYOB (Direct)

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.
MYOB Accounting

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.
MYOB AccountEdge

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.
MYOB AccountRight

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.
MYOB AccountRight Live

2013 - 2019

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

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.
Palladium Accounting

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.
Pastel Evolution

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.
Pastel Partner

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.
Peachtree (DOS)

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.
Pegasus Capital

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.
Pegasus Opera

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.
Platinum

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.
Proven Solutions Acc. (PSA)

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.
PwC SIF

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

QuickBooks Online

Australia

2003 - 2013, 2016 - 2019

8.x

7.x

Canada

1999 - 2019

2008 Multicurrency

6.0

5.0

UK

1999 - 2008, 2010, 2012 - 2019

6.0

5.0

USA

1999 - 2019

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 USA:
    • Install an applicable version of QuickBooks on your workstation.
    • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
QuickBooks (Export from QB)

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.
RealBroker

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.
Reviso Online Accounting All
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
Sage 300 ERP

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.
Sage 50 Accounts

Line50 v2007 - v2020

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.
Sage 50 Accounting (Peachtree-WIN)

2012 - 2020 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.
Sage 50 Accounting CDN Edition (Simply)

2019.1 - 2019.3

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.
Sage Accpac ERP

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.
Sage BusinessVision

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.
Sage One Accounting

All versions

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

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.
SAP

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.
Settler GOLD Farm Software

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.
SigaFinance

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.
Simply Accounting Windows

2019.1 - 2019.3

2008 - 2019

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.
Simply Accounting Windows (Export)

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.
SYBIZ Vision Accounting

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.
Tally Accounting

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.
Tally Accounting (Export)

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.
Ufsoft

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.
VersAccounts

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.
Viztopia Accounts Production

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.
Windward System Five

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.
WinLedge

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.
Xero

2013

  • Manually set your engagement properties before attempting the import as it contains no client profile information.
  • Create export files in Xero. This can be performed by a user with the Adviser role via Adviser | Export.
  • For each product, specify the corresponding options to ensure a functional import into Working Papers:
    • Lacerte - Year End Date: CSV
    • Xero - Date Range: TXT
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
Xyntax Native Systems

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.

Working Paper Software

Accounting Software Supported Versions Import Prerequisites
Accountant's Dream

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.
Ace

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.
AICPA's ATB (DOS)

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.
AICPA's ATB (WIN)

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.
AICPA's Prog. Gen. (DOS) 2.0
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
AICPA's Prog. Gen. (WIN) 1.0
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
Auditman II (DOS) 6.41
  • 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.
Auditvision AV1999.c
  • 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.
Avantage PRO 8.0 - 16.5
  • 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.
Client Strategist (3&6)

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.
Client Strategist (8) 8.0
  • 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.
Engagement CS 2006 - 2015
  • 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.
ePace ENGAGEMENT

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.
FAST!

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.
FAST! Advantage

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.
FAST / CPA 4.2
  • 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.
GoSystem Audit

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.
GoSystem Fund 2.3.0
  • Install the DAO import update.
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
PPC Engagement Manager 2009
  • Import File: EngrFile.eng
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
PPC's Program Generator 1.0
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
ProSystem fx Engagement

6.1 / 6.5 / 6.8 / 6.9 / 6.11 / 7.0 / 7.1 / 7.2 / 7.5 / 2017.2

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.
ProSystem fx GLC All versions
  • 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.
ProSystem fx Trial Balance / Audit

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.
TB+ All versions
  • Import File: filename.EYT
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
Unit 4 Audition

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.
Win EWP -
  • If Protection is activated in the Working Papers file, the Import file permission is required to perform this operation.
WISPR (DOS)

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.
WISPR (WIN) 1.0
  • 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.
WPG

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.