List of Accounting can be import to SQL Accounting: Difference between revisions
No edit summary |
No edit summary |
||
Line 2: | Line 2: | ||
|- | |- | ||
! Product !! File Type !! File/Table Name !! File Type Extention !! Master File 90% Accurate !! Opening Balance 70%-80% Accurate !! Current Transactions 70%~80% Accurate | ! Product !! File Type !! File/Table Name !! File Type Extention !! Master File 90% Accurate !! Opening Balance 70%-80% Accurate !! Current Transactions 70%~80% Accurate | ||
|- | |- | ||
| style='background: #f0fff0' | Autocount Enterprise 2005 || align="center" |MSSQL || AutoCount Backup || align="center" |A06 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding | | style='background: #f0fff0' | Autocount Enterprise 2005 || align="center" |MSSQL || AutoCount Backup || align="center" |A06 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding |
Latest revision as of 08:33, 6 June 2024
Product | File Type | File/Table Name | File Type Extention | Master File 90% Accurate | Opening Balance 70%-80% Accurate | Current Transactions 70%~80% Accurate |
---|---|---|---|---|---|---|
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 |
MDB | Y (Except GL Maintain Account) | N | N |
Emas | Foxpro | Emas Backup | EMS | Y* | Y | N |
Emas(MYSQL) | MYSQL |
MySQL Backup in .sql & zip |
sql | Y (Except GL Maintain Account & Stock) | N | N |
Smart Accounting |
AcStk.DB |
DB | Y (Except GL Maintain Account) | N | N | |
Smart Accounting(MSSQL) | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
AccSys Business Information System | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
Million Business Software | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
ICS Accounting | MS Access |
Cred6000 |
MDB | Y (Except GL Maintain Account) | N | N |
APlus | DBase |
agent.dbf |
DBF | Y (Except GL Maintain Account) | N | N |
MYOB | MYO |
addr.csv |
MYO | 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 |
iFAS Accounting | MSSQL |
MSSQL Backup |
BAK | Y (Except GL Maintain Account) | N | N |
Remicle | PostgreSQL |
Remicle PostgreSQL database dump backup in .sql & zip |
sql | Y (Except GL Maintain Account) | N | N |
* EMAS Chart of Account - will only assign bank account special type if detected. The rest of accounts need customer re-check.
Highlighted with background mean direct import to SQL Database else will export to Excel or CSV file