List of Accounting can be import to SQL Accounting

From eStream Software
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
CreditorArea
CreditorCategory
Currency
Debtor
DebtorArea
DebtorCategory
Stock
StockCategory
StockGroup
StockLocation
Term

GDB
QZB
QIB

Y (Except GL Maintain Account) N N
QnE (MSSQL) MSSQL

MSSQL Backup
Debtors
Creditors
stocks

BAK Y (Except GL Maintain Account) N N
Mr Accounting(MSSQL) MSSQL

MSSQL Backup
Currency_Setting
Customer
Salesman
StockMasterDetails
SupplierDetail

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
Emas(MYSQL) MYSQL

MySQL Backup in .sql & zip
YYYYMMDD_ACCxxxxx.sql
apvend
arcust
currency
glarea
glagent

sql Y (Except GL Maintain Account & Stock) N N
Smart Accounting

AcStk.DB
AcCard.DB
(Use Office XP to Open)

DB Y (Except GL Maintain Account) N N
Smart Accounting(MSSQL) MSSQL

MSSQL Backup
AcAcc
AcStk
AcCard

BAK Y (Except GL Maintain Account) N N
AccSys Business Information System MSSQL

MSSQL Backup
Company
Product

BAK Y (Except GL Maintain Account) N N
Million Business Software MSSQL

MSSQL Backup
Currency
Customer
Product
Prodgrp
Project
Supplier

BAK Y (Except GL Maintain Account) N N
ICS Accounting MS Access

Cred6000
Debt6000

MDB Y (Except GL Maintain Account) N N
APlus DBase

agent.dbf
area.dbf
currency.dbf
customer.dbf
vendor.dbf
stock.dbf

DBF Y (Except GL Maintain Account) N N
MYOB MYO

addr.csv
cards.csv
chacc.csv
items.csv
terms.csv
(CSV files generated using myData CLI tool)

MYO Y N N
Master Accounting MSSQL

MSSQL Backup
Debtor
Creditor
Stock
StockGroup

BAK Y (Except GL Maintain Account) N N
ESoft Accounting MYSQL

MySQL Backup in .sql & zip
xxxxx.apvend.sql
xxxxx.arcust.sql

sql Y (Except GL Maintain Account & Stock) N N
iFAS Accounting MSSQL

MSSQL Backup
AP_VENDOR_MASTER
AR_CUSTOMER_MASTER
AREA_MASTER
CURR
INV_CATEGORY_MASTER
INV_GROUP
INV_ITEM_MASTER
INV_LOCATION_MASTER

BAK Y (Except GL Maintain Account) N N
Remicle PostgreSQL

Remicle PostgreSQL database dump backup in .sql & zip
product_product<vr> res_partner

sql Y (Except GL Maintain Account) N N
GreenPlus Accounting MSSQL

MSSQL Backup
AREA_TBL
BATCH
BRAND
CATEGORY
CHARTACCOUNT_TBL
CUSTOMER$
FOREX
GLMAST$
LOCATION
MASTERSALESMAN_TBL
SALESMAN_TBL
STOCK_BOM
STOCK
SUPPLIER$
SUPPLIER

BAK 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

See also