Todd, I dealt with a similar situation in GnuCash where I ran a small side business after i retired and it was not worth setting up separate business accounts for it - low turnover and only just a bit more than a hobby.
I setup separate Income and Expense accounts for the business (my business did not really have assets as such and was cash sales only) and another set of Income and Expense accounts for my personal income and expenses within the same set of books in GnuCash with a shared set of bank accounts. The tax return for my business which was classified as a sole trader was filed as part of my personal tax return. This was allowable under the Tax rules in my jurisdiction at that time. The information from my business income and expense accounts was sufficient in my case to meet those needs and the record keeping for tax purposes. To do this you simply post business expenses to the business income and expense accounts and personal expenses to the personal income and expense account in GnuCash. You can customise the standard reports to limit them to subsets of the accounts so it is reasonably easy to extract the required business information. This does however require that you use GnuCash as it was designed and intended to be used. The real question would be how to integrate the account keeping for your business in your database system with account keeping in GnuCash? GnuCash does have a Python API which may be useful for doing this but this would require becoming familiar enough with the API and Python to write a custom interface between your database and GnuCash. Someone else who has done that can probably comment on how easy and what the limitations of using the Python API are. You need to think through fairly carefully what information you are trying to extract from the data for your credit and check accounts that are used jointly together with the level of detail required to meet any reporting obligations for your business and personal reporting. If all you need is a total for personal expenses and a total for the business expenses and business income then a spreadsheet approach or another type of program may be a better solution. It is possible to simplify GnuCash and its account structure but it is not possible to avoid its basic double entry operation David Cousens ----- David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
