Import into QuickBooks or PeachTree
Posted on 2008-10-06
Does anyone know if it is possible to establish a routine process that exports financial transaction data from a custom DB, like MSSQL, into a financial app like QuickBooks or Peachtree? We have a FoxPro front end, SQL backend invoicing system that can easily be modified to create a structured doc that could be imported into an app like QuickBooks. We use QuickBooks as our accounting software for tax, payroll, general ledger, etc. We manually reeenter the data from the FoxPro app into QuickBooks. I can see that QuickBooks does allow you to import some data, I just can't tell if it's designed to work in the more routine method we are looking for: using a routine export/import method rather then our current process of manally reentering everything.