Voraussetzungen für den Import aus Desktop-Buchhaltungssoftware
You can import client data from most third-party desktop accounting software for use with a variety of Caseware Cloud apps or IDEA. Before you import, ensure you complete the prerequisite steps for your software. To learn more about importing client data, see Import data from a desktop accounting software.
Access Accounting Dimensions
-
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.)
-
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 Relief
-
Import File: filename.mdb
AccountView
-
Importdateien:
-
Financial Periods: Periods.txt
-
GL Detail: Transactions.txt
-
Year End Balances: Yearend.txt
-
Non-Financial Data: NFD.txt
-
Accpac (Advantage Series)
-
Install the ODBC Engine and Driver.
-
Install Pervasive SQL (Btrieve) or Microsoft SQL.
-
Importdateien:
-
Profile Information: CSCOM.DAT / CSCOM.RECCSFSC.DAT / CSFSC.REC
-
Kontenplan: 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.
Accpac (DOS)
-
Importdateien:
-
Profile Information: GLGLOB
-
Kontenplan: GLDATA
-
GL Detail: GLPST
-
Accounting Dates: GLDATE'I
-
Adagio Ledger
-
Importdateien:
-
Profile Information: GLGLOB
-
Kontenplan: GLMAST'R / GLDATA
-
Accounting Dates: GLDATE'I
-
GL Import: GLPST
-
Period Date Settings: GLFISC'R
-
Budget Data: GLNBUD'R
-
AgExpert Analyst
-
Create an export file in AgExpert using the export module.
-
Import Files: filename.cwe
Attache Business Partner
-
Importdateien:
-
Profile Information: SYSFILE.DAT
-
Kontenplan: GLMAST.DATGLMASTLY.DAT
-
GL Detail: GLTRAN.DAT
-
Bedford Simply Accounting DOS
-
Importdateien:
-
Profile Information: SN3.REC / SN4.REC
-
Hauptabschlussübersicht: GN3.REC / GN4.REC
-
GL Detail: JOURNAL3.REC / JOURNAL4.REC
-
Blue Link Solutions
-
Import File: filename.txt
Brilliant Accounting
-
Importdateien:
-
Consolidated Trial Balance: cwctb1.txt
-
Unconsolidated Trial Balance: cwunctb1.txt
-
GL Movements: cwglmov1.txt
-
BusinessVision
-
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.
-
Importdateien:
-
Kontenplan: GL-CHART.TXT
-
GL Detail: GL.TXT
-
Profile Information: BVCON.FIL
-
C&LAS
-
Importdateien:
-
Chart of Accounts: filename.TXT
-
GL Detail: filename.TXT
-
Concorde
-
Importdateien:
-
Kontenplan: PRIMO.TXT
-
GL Detail: FINANS.TXT
-
Creative Solutions Accounting
-
Installieren Sie DAO Import-Update.
-
Importdatei: dateiname.WSW
DacEASY
-
Install the Pervasive SQL 2000 Database Engine.
-
Importdateien:
-
GL Detail: DEAGLTD.DB
-
Profile Information: DEAGNRL.DB
-
Hauptabschlussübersicht: DEAGLTH.DB
-
DATEV
-
Importdateien:
-
Salden: DatevexportKMVZ.txt
-
Kontonamen: DatevexportKTSKI.txt
-
Firmen-Info: DatevexportMADMPD.txt
-
Hauptabschlussübersicht: SKR*.csv
-
DYNACOM
-
Installieren Sie DAO Import-Update.
-
Importdateien:
-
6.4 - 7.0: dateiname.mdb
-
8.0 - later: dateiname.ddb
-
Expert Comptable
-
Use the export module in Expert Comptable to create an export file.
-
Import File: filename.txt
EZEBiz Company Manager
-
Use the export module in EZEBiz Company Manager to create an export file.
-
Import File: filename.csv
Finax v2.x
-
Importdateien:
-
Date Information: MUMBU.ext
-
Profile Information: PARBU.ext
-
GL Detail: BUNIDET.ext
-
Hauptabschlussübersicht: ACCOUNTS.ext
-
Finax v989.x
-
Importdateien:
-
Kontenplan: 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.)
-
Fortune1000 Acomba
-
Importdateien:
-
Kontenplan: SCHARTE.FDW
-
Journal Entries: GJOURNAL.FDW
-
# of Accounting Periods: GCTRL.FDW
-
Detailed Postings: GPOST.FDW
-
Client Information: SINFOCIE.FDW
-
Fortune1000 DOS
-
Importdateien:
-
Kontenplan: GGL.FDA
-
GL Detail: GJOURNAL.FDA
-
Profile Information: GCIE.FDA
-
Budget Figures: GPOST.FDA
-
Great Plains (Dynamics)
Pervasive SQL (Btrieve)
-
Install the Pervasive SQL 2000 Database Engine.
-
Importdateien:
-
Company List: Dynamics \ SY02100.BTR
-
Firmen-Info: Dynamics \ System \ SY01500.BTR
-
Account Number Structure: Dynamics \ System \ SY00302.BTR
-
Period Dates: Dynamics \ <Client> \ Company \ SY40101.BTR
-
Kontenplan: Dynamics \ <Client> \ finance \ GL00100.BTR
-
Account Numbers: Dynamics \ <Client> \ finance \ GL00105.BTR
-
Budget Balances: Dynamics \ <Client> \ finance \ GL00201.BTR
-
Hauptabschlussübersicht: Dynamics \ <Client> \ finance \ GL10110.BTR
-
GL Detail: Dynamics \ <Client> \ finance \ GL20000.BTR
-
C-Tree Plus
-
Importdateien:
-
Company List: Dynamics \ SY02100.DAT
-
Firmen-Info: Dynamics \ System \ SY01500.DAT
-
Account Number Structure: Dynamics \ System \ SY00302.DAT
-
Period Dates: Dynamics \ <Client> \ Company \ SY40101.DAT
-
Kontenplan: Dynamics \ <Client> \ finance \ GL00100.DAT
-
Account Numbers: Dynamics \ <Client> \ finance \ GL00105.DAT
-
Budget Balances: Dynamics \ <Client> \ finance \ GL00201.DAT
-
Hauptabschlussübersicht: Dynamics \ <Client> \ finance \ GL10110.DAT
-
GL Detail: Dynamics \ <Client> \ finance \ GL20000.DAT
-
Great Plains (DOS)
Pervasive SQL (Btrieve)
-
Install the Pervasive SQL 2000 Database Engine.
-
Importdateien:
-
Company List: Dynamics \ SY02100.BTR
-
Firmen-Info: Dynamics \ System \ SY01500.BTR
-
Account Number Structure: Dynamics \ System \ SY00302.BTR
-
Period Dates: Dynamics \ <Client> \ Company \ SY40101.BTR
-
Kontenplan: Dynamics \ <Client> \ finance \ GL00100.BTR
-
Account Numbers: Dynamics \ <Client> \ finance \ GL00105.BTR
-
Budget Balances: Dynamics \ <Client> \ finance \ GL00201.BTR
-
Hauptabschlussübersicht: Dynamics \ <Client> \ finance \ GL10110.BTR
-
GL Detail: Dynamics \ <Client> \ finance \ GL20000.BTR
-
C-Tree Plus
-
Importdateien:
-
Company List: Dynamics \ SY02100.DAT
-
Firmen-Info: Dynamics \ System \ SY01500.DAT
-
Account Number Structure: Dynamics \ System \ SY00302.DAT
-
Period Dates: Dynamics \ <Client> \ Company \ SY40101.DAT
-
Kontenplan: Dynamics \ <Client> \ finance \ GL00100.DAT
-
Account Numbers: Dynamics \ <Client> \ finance \ GL00105.DAT
-
Budget Balances: Dynamics \ <Client> \ finance \ GL00201.DAT
-
Hauptabschlussübersicht: Dynamics \ <Client> \ finance \ GL10110.DAT
-
GL Detail: Dynamics \ <Client> \ finance \ GL20000.DAT
-
KHK
-
Importdateien:
-
Kontenplan: AUDITAGT.TXT
-
GL Detail: AUDITGLT.TXT
-
MAS 90 für Windows
-
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
Microsoft Office Accounting
-
Install Microsoft SQL Server 2005 locally on the machine performing the import.
-
Import File: filename.sbb
MoneyWorks
-
Use the export module in MoneyWorks to create an export file.
-
Import File: filename.txt
MS Small Business Accounting
-
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.
Multi Express Business & Accounting
-
Verwenden Sie das Exportmodul in Multi Express Business & Accounting, um eine Exportdatei zu erstellen.
-
Import File: filename.txt
MYOB Accounting
-
Create an export file in MYOB by clicking File | AccountantLink | Send to Caseware.
-
Import File: filename.txt
MYOB AccountEdge
-
Create an export file in MYOB by clicking File | AccountantLink | Send to Caseware.
-
Import File: filename.txt
MYOB AccountRight
-
Create an export file in MYOB by clicking File | AccountantLink | Send to Caseware.
-
Import File: filename.txt
Orchard
-
Importdateien:
-
Kontenplan: 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.)
-
Pastel Evolution
-
Export the transactions in Pastel Evolution to create an export file.
-
Importdateien:
-
Consolidated Trial Balance: cwctb1.txt
-
Unconsolidated Trial Balance: cwunctb1.txt
-
GL Movements: cwglmov1.txt
-
Peachtree (DOS)
-
Importdateien:
-
Kontenplan: 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.)
-
Pegasus Capital
-
Importdateien:
-
Profile Information: SYSTEM.DBF
-
Hauptabschlussübersicht: NLNAME.DBF
-
GL Detail: NLTRAN.DBF
-
Pegasus Opera
-
Importdateien:
-
Profile Information: _NPARM.DBF
-
Kontenplan: _NACNT.DBF
-
Budget Balances: _NBUDG.DBF
-
GL Detail: _NTRAN.DBF
-
Platinum
-
Importdateien:
-
Kontenplan: NLCHART
-
Period Dates: NLPDATES
-
Period Balances: NLBAL
-
Firmen-Info: NLCOSUB
-
Journal Batch Details: NLTXD
-
History Batch Details: NLTXDH
-
PwC SIF
-
Importdateien:
-
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.
-
RealBroker
-
Use the export module in RealBroker to create an export file.
-
Importdatei: dateiname.TXT
Sage 50 Accounts (Sage-Line50)
-
Importdateien:
-
Profile Information: ACCDATA\ACCOUNT.DTA
-
Kontenplan: ACCDATA\NOMINAL.DTA
-
CoA Index: ACCDATA\NOMINDEX.DTA
-
GL Detail: ACCDATA\SPLITS.DTA
-
Firmen-Info: ACCDATA\SETUP.DTA
-
Account Types: ACCDATA\COA
-
Bank Information: ACCDATA\BANK.DTA
-
Ledger Index: ACCDATA\HEADER.DTA
-
Department Information: DEPARTM.DTA
-
Sage 50 Accounting CDN Edition (Simply)
-
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.
Settler GOLD Farm Software
-
Verwenden Sie das Exportmodul in Settler GOLD Farm Software, um eine Exportdatei zu erstellen.
-
Importdatei: dateiname.cwe
SigaFinance
-
Verwenden Sie das Exportmodul in SigaFinance, um eine Exportdatei zu erstellen.
-
Import File: filename.TXT
Tally Accounting (Export)
-
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)
-
Ufsoft
-
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).
-
Importdateien:
-
Version 8.2 / 8.5: Ufdata.bak
-
Version 8.11: Copy Ufdata.mdp and Ufsystem.mdp to another folder.
-
Windward System Five
-
Use the export module in Windward System Five to create an export file.
-
Importdatei: dateiname.TXT
WinLedge
-
Use the export module in WinLedge to create an export file.
-
Importdatei: dateiname.TXT