List of Accounting can be import to SQL Accounting: Difference between revisions
From eStream Software
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
! 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 | ||
|- | |- | ||
| Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 || align="center" |Paradox || AutoCount Backup || align="center" |B01 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding Information) | | style='background: #f0fff0' | Autocount - Acc 2000, XP, Professional, Premier30 & Premier35 || align="center" |Paradox || AutoCount Backup || align="center" |B01 || align="center" |Y || align="center" |Y || Y (Except Sales & Purchase Outstanding Information) | ||
|- | |- | ||
| 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 | ||
|- | |- | ||
| UBS Accounting || align="center" |Foxpro || UBS Backup || align="center" | ACC || align="center" | Y || align="center" | Y || align="center" | N | | style='background: #f0fff0' | UBS Accounting || align="center" |Foxpro || UBS Backup || align="center" | ACC || align="center" | Y || align="center" | Y || align="center" | N | ||
|- | |- | ||
| UBS Stock || align="center" |Foxpro || UBS Backup || align="center" | STK || align="center" | Y || align="center" | Y || align="center" | N | | style='background: #f0fff0' | UBS Stock || align="center" |Foxpro || UBS Backup || align="center" | STK || align="center" | Y || align="center" | Y || align="center" | N | ||
|- | |- | ||
| QnE || align="center" |Firebird || | | QnE || align="center" |Firebird || | ||
| Line 44: | Line 44: | ||
| align="center" | MDB || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | | align="center" | MDB || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |- | ||
| Emas || align="center" |Foxpro || Emas Backup || align="center" | EMS || align="center" | Y* || align="center" | Y || align="center" | N | |style='background: #f0fff0' | Emas || align="center" |Foxpro || Emas Backup || align="center" | EMS || align="center" | Y* || align="center" | Y || align="center" | N | ||
|- | |- | ||
| Smart Accounting || || | | Smart Accounting || || | ||
| Line 83: | Line 83: | ||
| align="center" | DBF || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | | align="center" | DBF || Y (Except GL Maintain Account) || align="center" | N || align="center" | N | ||
|- | |- | ||
| MYOB || align="center" | MYO || | |style='background: #f0fff0' | MYOB || align="center" | MYO || | ||
addr.csv<br> | addr.csv<br> | ||
cards.csv<br> | cards.csv<br> | ||
Revision as of 08:38, 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.