List of Accounting can be import to SQL Accounting: Difference between revisions
From eStream Software
No edit summary |
No edit summary |
||
Line 107: | Line 107: | ||
|} | |} | ||
* EMAS Chart of Account - will only assign bank account special type if detected. The rest of accounts need customer re-check. | * EMAS Chart of Account - will only assign bank account special type if detected. The rest of accounts need customer re-check. | ||
==See also== | |||
*[[Data Import]] |
Revision as of 08:11, 29 December 2022
Product | File Type | File/Table Name | File Type Extention | Master File 90% Accurate | Opening Balance 70%-80% Accurate | Current Transactions 70%~80% Accurate |
---|---|---|---|---|---|---|
Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 | Paradox | AutoCount Backup | B01 | Y | Y | Y (Except Sales & Purchase Outstanding Information) |
Autocount Enterprise 2005 | MSSQL | AutoCount Backup | A06 | Y | Y | Y (Except Sales & Purchase Outstanding |
UBS Accounting | Foxpro | UBS Backup | ACC | Y | Y | N |
UBS Stock | Foxpro | UBS Backup | STK | Y | Y | N |
QnE | Firebird |
Creditor |
GDB |
Y (Except GL Maintain Account) | N | N |
QnE (MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
Mr Accounting(MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
3A Accounting (Windows) | MS Access |
Crdat.mdb DbDat.mdb Stdat.mdb |
MDB | Y (Except GL Maintain Account) | N | N |
Emas | Foxpro | Emas Backup | EMS | Y* | Y | N |
Smart Accounting |
AcStk.DB |
DB | Y (Except GL Maintain Account) | N | N | |
Smart Accounting(MSSQL) | MSSQL |
MSSQL Backup
AcStk |
BAK | Y (Except GL Maintain Account) | N | N |
AccSys Business Information System | MSSQL |
MSSQL Backup
Company |
BAK | Y (Except GL Maintain Account) | N | N |
Million Business Software | MSSQL |
MSSQL Backup
Customer |
BAK | Y (Except GL Maintain Account) | N | N |
ICS Accounting | MS Access |
Cred6000 |
MDB | Y (Except GL Maintain Account) | N | N |
APlus | DBase |
Customer |
DBF | Y (Except GL Maintain Account) | N | N |
MYOB | MYO |
addr.csv |
DBF | Y | N | N |
Master Accounting | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
ESoft Accounting | MYSQL |
MySQL Backup in .sql & zip |
sql | Y (Except GL Maintain Account & Stock) | N | N |
* EMAS Chart of Account - will only assign bank account special type if detected. The rest of accounts need customer re-check.