List of Accounting can be import to SQL Accounting: Difference between revisions
From eStream Software
No edit summary |
No edit summary |
||
Line 93: | Line 93: | ||
terms.csv<br> | terms.csv<br> | ||
(CSV files generated using myData CLI tool) | (CSV files generated using myData CLI tool) | ||
| align="center" | | | align="center" | MYO || Y || align="center" | N || align="center" | N | ||
|- | |- | ||
| Master Accounting || align="center" | MSSQL || | | Master Accounting || align="center" | MSSQL || |
Revision as of 03:04, 5 January 2023
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 |
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 |
* 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