Skip to main content

List of Accounting can be import to SQL Accounting

ProductFile TypeFile/Table NameFile ExtensionMaster File (90%)Opening Balance (70–80%)Current Transactions (70–80%)Remarks
Autocount Enterprise 2005MSSQLAutoCount BackupA06YesYesYes (Except Sales & Purchase Outstanding)
UBS AccountingFoxproUBS BackupACCYesYesNo
UBS StockFoxproUBS BackupSTKYesYesNo
QnEFirebirdTablesGDB / QZB / QIBYes (Except GL Maintain Account)NoNo
QnE (MSSQL)MSSQLTablesBAKYes (Except GL Maintain Account)NoNo
Mr Accounting (MSSQL)MSSQLTablesBAKYes (Except GL Maintain Account)NoNo
3A Accounting (Windows)MS AccessCrdat.mdb / DbDat.mdb / Stdat.mdbMDBYes (Except GL Maintain Account)NoNo
EmasFoxproEmas BackupEMSYes*YesNo
Emas (MySQL)MySQLTablessqlYes (Except GL Maintain Account & Stock)NoNo
Smart AccountingAcStk.DB / AcCard.DB (Use Office XP to Open)DBYes (Except GL Maintain Account)NoNo
Smart Accounting (MSSQL)MSSQLTablesBAKYes (Except GL Maintain Account)NoNo
AccSys Business Information SystemMSSQLTablesBAKYes (Except GL Maintain Account)NoNo
Million Business SoftwareMSSQLTablesBAKYes (Except GL Maintain Account)YesNo
ICS AccountingMS AccessCred6000 / Debt6000 / Mast4000 / ENVI1000.MDBMDBYes (Except GL Maintain Account)NoNo
APlusDBaseagent.dbf / area.dbf / currency.dbf / customer.dbf / vendor.dbf / stock.dbfDBFYes (Except GL Maintain Account)NoNo
APlus (MSSQL)MSSQLTablesBAKYes (Except GL Maintain Account)NoNo
MYOBMYOaddr.csv / cards.csv / chacc.csv / items.csv / terms.csv (CSV via myData CLI)MYOYesNoNo
Master AccountingMySQLTablesBAKYes (Except GL Maintain Account)NoNo
ESoft AccountingMySQLTablessqlYes (Except GL Maintain Account & Stock)NoNo
iFAS AccountingMSSQLTablesBAKYes (Except GL Maintain Account)NoNo
RemiclePostgreSQLPostgreSQL dump (.sql / .zip) — product_product, res_partnersqlYes (Except GL Maintain Account)NoNo
GreenPlus AccountingMSSQLTablesBAKYes (Except GL Maintain Account)NoNo
KusimiMySQLTablessqlYes (Except GL Maintain Account & Stock)NoNo
MHW Financial AccountingMSSQLTablesBAKYes (Except GL Maintain Account)NoNo
BBS AccountingMSSQLTablesBAKYes (Except GL Maintain Account)NoNo

Yes = Supported
No = Not supported
Yes* = Conditional support depending on data completeness

info
  • 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