Install the (firebird/postgres/mysql) odbc driver and go to the odbc administrator and add a new ODBC and select the driver.
In excel create a new database query.
The flowing screen will appear. Pres the sql button and past the sql below this screen shot to see all transaction input in the database.
SELECT V_TRANSACTASBATCHWITHTRANSID.SREFERENCE, V_TRANSACTASBATCHWITHTRANSID.DDATE, V_TRANSACTASBATCHWITHTRANSID.SACCOUNT, V_TRANSACTASBATCHWITHTRANSID.SDESCRIPTION, V_TRANSACTASBATCHWITHTRANSID.SCONTRAACCOUNT, V_TRANSACTASBATCHWITHTRANSID.STAX, V_TRANSACTASBATCHWITHTRANSID.FAMOUNT, V_TRANSACTASBATCHWITHTRANSID.FDEBIT, V_TRANSACTASBATCHWITHTRANSID.FCREDIT, V_TRANSACTASBATCHWITHTRANSID.FTAXAMOUNT
FROM V_TRANSACTASBATCHWITHTRANSID V_TRANSACTASBATCHWITHTRANSID
Now save the SQL and go to the menu to add a datasource again.
Select import data and select the query you just saved.
The data will be imported and you can see the list in excel.
if data changes you need to refresh the external source.
you can us the data in excel reporting like charts. This way you can create your own view on the osFinancials or Turbocash data using your Favourite tool.
