Skip to content

Instantly share code, notes, and snippets.

@jottr
Last active August 31, 2015 09:37
Show Gist options
  • Save jottr/281c46ad628fa9272ccd to your computer and use it in GitHub Desktop.
Save jottr/281c46ad628fa9272ccd to your computer and use it in GitHub Desktop.
Ledger Test File and ipython notebook trace
---------------------------------------------------------------------------
DatabaseError Traceback (most recent call last)
<ipython-input-19-7bbf1816cba4> in <module>()
1 # open gnucash database as writeable
----> 2 book = pc.open_book("/tmp/foo.gnucash", readonly = False, open_if_lock = True)
/usr/local/lib/python2.7/site-packages/piecash/core/session.pyc in open_book(sqlite_file, uri_conn, readonly, open_if_lock, do_backup, db_type, db_user, db_password, db_name, db_host, db_port, **kwargs)
241 shutil.copyfile(url, url_backup)
242
--> 243 locks = list(engine.execute(gnclock.select()))
244
245 # ensure the file is not locked by GnuCash itself
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in execute(self, statement, *multiparams, **params)
1749
1750 connection = self.contextual_connect(close_with_result=True)
-> 1751 return connection.execute(statement, *multiparams, **params)
1752
1753 def scalar(self, statement, *multiparams, **params):
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in execute(self, object, *multiparams, **params)
727 type(object))
728 else:
--> 729 return meth(self, multiparams, params)
730
731 def _execute_function(self, func, multiparams, params):
/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.pyc in _execute_on_connection(self, connection, multiparams, params)
320
321 def _execute_on_connection(self, connection, multiparams, params):
--> 322 return connection._execute_clauseelement(self, multiparams, params)
323
324 def unique_params(self, *optionaldict, **kwargs):
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_clauseelement(self, elem, multiparams, params)
824 compiled_sql,
825 distilled_params,
--> 826 compiled_sql, distilled_params
827 )
828 if self._has_events or self.engine._has_events:
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)
956 parameters,
957 cursor,
--> 958 context)
959
960 if self._has_events or self.engine._has_events:
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _handle_dbapi_exception(self, e, statement, parameters, cursor, context)
1157 util.raise_from_cause(
1158 sqlalchemy_exception,
-> 1159 exc_info
1160 )
1161 else:
/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.pyc in raise_from_cause(exception, exc_info)
197 exc_info = sys.exc_info()
198 exc_type, exc_value, exc_tb = exc_info
--> 199 reraise(type(exception), exception, tb=exc_tb)
200
201 if py3k:
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.pyc in _execute_context(self, dialect, constructor, statement, parameters, *args)
949 statement,
950 parameters,
--> 951 context)
952 except Exception as e:
953 self._handle_dbapi_exception(
/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.pyc in do_execute(self, cursor, statement, parameters, context)
434
435 def do_execute(self, cursor, statement, parameters, context=None):
--> 436 cursor.execute(statement, parameters)
437
438 def do_execute_no_params(self, cursor, statement, context=None):
DatabaseError: (DatabaseError) file is encrypted or is not a database u'SELECT gnclock.hostname, gnclock.pid \nFROM gnclock' ()
<?xml version="1.0" encoding="utf-8" ?>
<gnc-v2
xmlns:gnc="http://www.gnucash.org/XML/gnc"
xmlns:act="http://www.gnucash.org/XML/act"
xmlns:book="http://www.gnucash.org/XML/book"
xmlns:cd="http://www.gnucash.org/XML/cd"
xmlns:cmdty="http://www.gnucash.org/XML/cmdty"
xmlns:price="http://www.gnucash.org/XML/price"
xmlns:slot="http://www.gnucash.org/XML/slot"
xmlns:split="http://www.gnucash.org/XML/split"
xmlns:sx="http://www.gnucash.org/XML/sx"
xmlns:trn="http://www.gnucash.org/XML/trn"
xmlns:ts="http://www.gnucash.org/XML/ts"
xmlns:fs="http://www.gnucash.org/XML/fs"
xmlns:bgt="http://www.gnucash.org/XML/bgt"
xmlns:recurrence="http://www.gnucash.org/XML/recurrence"
xmlns:lot="http://www.gnucash.org/XML/lot"
xmlns:addr="http://www.gnucash.org/XML/addr"
xmlns:owner="http://www.gnucash.org/XML/owner"
xmlns:billterm="http://www.gnucash.org/XML/billterm"
xmlns:bt-days="http://www.gnucash.org/XML/bt-days"
xmlns:bt-prox="http://www.gnucash.org/XML/bt-prox"
xmlns:cust="http://www.gnucash.org/XML/cust"
xmlns:employee="http://www.gnucash.org/XML/employee"
xmlns:entry="http://www.gnucash.org/XML/entry"
xmlns:invoice="http://www.gnucash.org/XML/invoice"
xmlns:job="http://www.gnucash.org/XML/job"
xmlns:order="http://www.gnucash.org/XML/order"
xmlns:taxtable="http://www.gnucash.org/XML/taxtable"
xmlns:tte="http://www.gnucash.org/XML/tte"
xmlns:vendor="http://www.gnucash.org/XML/vendor">
<gnc:count-data cd:type="book">1</gnc:count-data>
<gnc:book version="2.0.0">
<book:id type="guid">0272a99426d140fe64af3af19e8d3fbb</book:id>
<book:slots>
<slot>
<slot:key>options</slot:key>
<slot:value type="frame">
<slot>
<slot:key>Budgeting</slot:key>
<slot:value type="frame"/>
</slot>
</slot:value>
</slot>
</book:slots>
<gnc:count-data cd:type="commodity">1</gnc:count-data>
<gnc:count-data cd:type="account">64</gnc:count-data>
<gnc:count-data cd:type="transaction">2</gnc:count-data>
<gnc:commodity version="2.0.0">
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
<cmdty:get_quotes/>
<cmdty:quote_source>currency</cmdty:quote_source>
<cmdty:quote_tz/>
</gnc:commodity>
<gnc:commodity version="2.0.0">
<cmdty:space>template</cmdty:space>
<cmdty:id>template</cmdty:id>
<cmdty:name>template</cmdty:name>
<cmdty:xcode>template</cmdty:xcode>
<cmdty:fraction>1</cmdty:fraction>
</gnc:commodity>
<gnc:account version="2.0.0">
<act:name>Root Account</act:name>
<act:id type="guid">6c16301f5606aed0a75350504103a2fa</act:id>
<act:type>ROOT</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Aktiva</act:name>
<act:id type="guid">e103f2c2849954e7bb624a622d64bfc0</act:id>
<act:type>ASSET</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Aktiva</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">6c16301f5606aed0a75350504103a2fa</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Barvermögen</act:name>
<act:id type="guid">c768bb505a3bfc9cfd18a57abd398c0e</act:id>
<act:type>ASSET</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Barvermögen</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">e103f2c2849954e7bb624a622d64bfc0</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Girokonto</act:name>
<act:id type="guid">651dcf942b4938edddae864e87601547</act:id>
<act:type>BANK</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Girokonto</act:description>
<act:parent type="guid">c768bb505a3bfc9cfd18a57abd398c0e</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sparkonto</act:name>
<act:id type="guid">a6e4f33942740c54f813f966fcab8f66</act:id>
<act:type>BANK</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sparkonto</act:description>
<act:parent type="guid">c768bb505a3bfc9cfd18a57abd398c0e</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Bargeld</act:name>
<act:id type="guid">2c086d841cae2b7cd52f1895469446ed</act:id>
<act:type>CASH</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Bargeld</act:description>
<act:parent type="guid">c768bb505a3bfc9cfd18a57abd398c0e</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Fremdkapital</act:name>
<act:id type="guid">64e6da702da33ea5a45605077e77f0ac</act:id>
<act:type>LIABILITY</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>alle Verbindlichkeiten</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">6c16301f5606aed0a75350504103a2fa</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Barverbindlichkeiten</act:name>
<act:id type="guid">92cf0352c6915c4859f8869378f24edb</act:id>
<act:type>LIABILITY</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Barverbindlichkeiten (noch offenstehende Rechnungen)</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">64e6da702da33ea5a45605077e77f0ac</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Kreditkarte</act:name>
<act:id type="guid">2037a8b94f631ed174e384656f3e211d</act:id>
<act:type>CREDIT</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Kreditkarte</act:description>
<act:parent type="guid">92cf0352c6915c4859f8869378f24edb</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Erträge</act:name>
<act:id type="guid">e7d6e88c1fd2060b61bbb0292ed641a5</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Erträge</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">6c16301f5606aed0a75350504103a2fa</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Gehalt</act:name>
<act:id type="guid">929a7aed3a52915d7b702386c83281b2</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Gehalt und Zulagen</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">e7d6e88c1fd2060b61bbb0292ed641a5</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Gehalt</act:name>
<act:id type="guid">a397c41bad204d42b6dd5af5a289e42a</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Gehalt</act:description>
<act:parent type="guid">929a7aed3a52915d7b702386c83281b2</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Zulagen</act:name>
<act:id type="guid">55e02c7f91d1ae8a20d77846f4315b07</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Zulagen und Bonus zum Gehalt</act:description>
<act:parent type="guid">929a7aed3a52915d7b702386c83281b2</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Geschenke</act:name>
<act:id type="guid">7f51eab2200994fc2797af120fda5bb8</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Empfangene Geschenke</act:description>
<act:parent type="guid">e7d6e88c1fd2060b61bbb0292ed641a5</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sonstiges</act:name>
<act:id type="guid">e4c5dd2ef9d0c05d27d40c5eeea897ce</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sonstige Erträge</act:description>
<act:parent type="guid">e7d6e88c1fd2060b61bbb0292ed641a5</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Zinsen</act:name>
<act:id type="guid">9a146e5ac5fb9e04a81ac2d3ec6779a4</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Zinseinkommen</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">e7d6e88c1fd2060b61bbb0292ed641a5</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Girokonto</act:name>
<act:id type="guid">14ba801c8fd2ead45a40bc41782c4821</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Girokonto Zinsen</act:description>
<act:parent type="guid">9a146e5ac5fb9e04a81ac2d3ec6779a4</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sonstige</act:name>
<act:id type="guid">ece1bd98c1eb4c558da318571b5e2d83</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sonstige Zinsen</act:description>
<act:parent type="guid">9a146e5ac5fb9e04a81ac2d3ec6779a4</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sparkonto</act:name>
<act:id type="guid">3a9bc28013cf969a73bdf6cce1a7c827</act:id>
<act:type>INCOME</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sparkonto Zinsen</act:description>
<act:parent type="guid">9a146e5ac5fb9e04a81ac2d3ec6779a4</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Aufwendungen</act:name>
<act:id type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Aufwendungen</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">6c16301f5606aed0a75350504103a2fa</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Bildung</act:name>
<act:id type="guid">8b320bc9b40c462d130ad40323022a71</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Bildung</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Abonnements</act:name>
<act:id type="guid">14c6c96e4133eb7a307cd56a857a7e6b</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Abonnements</act:description>
<act:parent type="guid">8b320bc9b40c462d130ad40323022a71</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Bücher</act:name>
<act:id type="guid">c378910db31d7582858cce65e2035070</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Bücher</act:description>
<act:parent type="guid">8b320bc9b40c462d130ad40323022a71</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Büroartikel</act:name>
<act:id type="guid">c1053bee0c35dc041ffdfeb9f7f8133c</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Büroartikel</act:description>
<act:parent type="guid">8b320bc9b40c462d130ad40323022a71</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Zeitungen</act:name>
<act:id type="guid">849f60826d242e581ad21b155ef6e14e</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Zeitungen</act:description>
<act:parent type="guid">8b320bc9b40c462d130ad40323022a71</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Computer</act:name>
<act:id type="guid">a836501023672537db1e6ef646a831fa</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Computer</act:description>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Fahrtkosten</act:name>
<act:id type="guid">c07d39ea58a2e8046930fbd39ee6e5b9</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Fahrtkosten</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Fahrkarten</act:name>
<act:id type="guid">8bac78565b77d39f3af34fd8a2e0a3a2</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Fahrkarten Bus, Bahn, Flugzeug</act:description>
<act:parent type="guid">c07d39ea58a2e8046930fbd39ee6e5b9</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Geschenke</act:name>
<act:id type="guid">c14da6756f128bd001b8e0a0901b0ee4</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Geschenke</act:description>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Hobbies</act:name>
<act:id type="guid">d01465bff09fead4cf25ce0d0a0890c8</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Hobbies</act:description>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Kleidung</act:name>
<act:id type="guid">40ee8066c90324939d2e27c74de5559e</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Kleidung</act:description>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Lebensmittel</act:name>
<act:id type="guid">cf7fb6f4b45bfe1d53b562b16144a192</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Lebensmittel</act:description>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Medikamente</act:name>
<act:id type="guid">15ea91d2f0bb42ee5eaee676c980e8bb</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Medikamente</act:description>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sonstiges</act:name>
<act:id type="guid">253010cf021bf4e76f548e21b9256b06</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sonstiges</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Bankgebühren</act:name>
<act:id type="guid">236653a49a5894dc1d2433220a8d2629</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Konto- und Bankgebühren</act:description>
<act:parent type="guid">253010cf021bf4e76f548e21b9256b06</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sonstiges</act:name>
<act:id type="guid">ca624d2b1e5f1a4abc488f448b3d3130</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>nicht aufgegliederte Ausgaben</act:description>
<act:parent type="guid">253010cf021bf4e76f548e21b9256b06</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Spenden</act:name>
<act:id type="guid">94921ab93da5542a40dbdbaa27ecd3df</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Wohltätige Spenden</act:description>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Steuern</act:name>
<act:id type="guid">8380ee77bb481d1e946bcfa0ccb7b2e9</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Steuern und Sozialabgaben</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Einkommenssteuer</act:name>
<act:id type="guid">f75abafecc70c1b39e825468e4727e1b</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Einkommenssteuer</act:description>
<act:parent type="guid">8380ee77bb481d1e946bcfa0ccb7b2e9</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Pflegeversicherung</act:name>
<act:id type="guid">406614914067b6e605cfb5a94e54afa3</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Pflegeversicherung</act:description>
<act:parent type="guid">8380ee77bb481d1e946bcfa0ccb7b2e9</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Rentenversicherung</act:name>
<act:id type="guid">8b2b926921d035fdfb323cd72129f990</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Rentenversicherung</act:description>
<act:parent type="guid">8380ee77bb481d1e946bcfa0ccb7b2e9</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Solidarzuschlag</act:name>
<act:id type="guid">3cf48bb0660a230671454f87378ca507</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Solidarzuschlag</act:description>
<act:parent type="guid">8380ee77bb481d1e946bcfa0ccb7b2e9</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sonstige</act:name>
<act:id type="guid">7b7002411148978afeb2341996046b62</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sonstige Steuern</act:description>
<act:parent type="guid">8380ee77bb481d1e946bcfa0ccb7b2e9</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sozialabgaben</act:name>
<act:id type="guid">a7c4e5de019d25c731e331d8ecd70154</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sonstige Sozialabgaben</act:description>
<act:parent type="guid">8380ee77bb481d1e946bcfa0ccb7b2e9</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Telekommunikation</act:name>
<act:id type="guid">98fa5dd9a6e2aa1ce782463c370c0ac3</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Telekommunikation</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Fernsehen</act:name>
<act:id type="guid">2260d64693e3572007129b0de0dc1308</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>GEZ und Kabelfernsehen</act:description>
<act:parent type="guid">98fa5dd9a6e2aa1ce782463c370c0ac3</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Online-Dienste</act:name>
<act:id type="guid">2a85a4a4abde3190f08b161588e16897</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Online-Dienste</act:description>
<act:parent type="guid">98fa5dd9a6e2aa1ce782463c370c0ac3</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Telefon</act:name>
<act:id type="guid">7c64d14826128a6d9f02d2cd5e685885</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Telefon</act:description>
<act:parent type="guid">98fa5dd9a6e2aa1ce782463c370c0ac3</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Unterhaltung</act:name>
<act:id type="guid">ab7054448aea38ca405fa73e3a06b4ad</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Unterhaltung</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Ausgehen</act:name>
<act:id type="guid">51aa72ec79d922ccf973fc32056f9ef2</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Auswärts Essen</act:description>
<act:parent type="guid">ab7054448aea38ca405fa73e3a06b4ad</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Musik/Kino</act:name>
<act:id type="guid">f632b859a53e1337cccb0fafce080873</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Musik/Kino</act:description>
<act:parent type="guid">ab7054448aea38ca405fa73e3a06b4ad</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Reisen</act:name>
<act:id type="guid">6859f30337232ced4d421e79a36ac0dd</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Reisen</act:description>
<act:parent type="guid">ab7054448aea38ca405fa73e3a06b4ad</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Sport</act:name>
<act:id type="guid">d61eb62a508440a71f97c35b8af19e3f</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Sport</act:description>
<act:parent type="guid">ab7054448aea38ca405fa73e3a06b4ad</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Versicherungen</act:name>
<act:id type="guid">38a39e6e3682972008000f058c7f5adc</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Versicherungen</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Haftpflicht</act:name>
<act:id type="guid">d4f65ed1315c8eaaeb91beeafdab030c</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Haftpflichtversicherung</act:description>
<act:parent type="guid">38a39e6e3682972008000f058c7f5adc</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Krankenversicherung</act:name>
<act:id type="guid">8bf8ff8669f85725995d06df3bca3187</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Krankenversicherung</act:description>
<act:parent type="guid">38a39e6e3682972008000f058c7f5adc</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Wohnen</act:name>
<act:id type="guid">fd95291c8fefbf8da4bd3f2a870f38ce</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Ausgaben für Wohnung/Haus</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">da4a9fad453ce720209b28eecdb8f4b6</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Miete</act:name>
<act:id type="guid">1f36e6e3117a62e3b7c684bcd6c06f2b</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Miete</act:description>
<act:parent type="guid">fd95291c8fefbf8da4bd3f2a870f38ce</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Nebenkosten</act:name>
<act:id type="guid">e53e4b7471d2cd90477a16065a1e919e</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Wohnnebenkosten</act:description>
<act:slots>
<slot>
<slot:key>placeholder</slot:key>
<slot:value type="string">true</slot:value>
</slot>
</act:slots>
<act:parent type="guid">fd95291c8fefbf8da4bd3f2a870f38ce</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Abfall</act:name>
<act:id type="guid">67cf388aa3b0d1959160c9d92797eef6</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Abfallentsorgung</act:description>
<act:parent type="guid">e53e4b7471d2cd90477a16065a1e919e</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Gas</act:name>
<act:id type="guid">7586f1c04c5409e1078ad5c9d5ac9ac8</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Gas</act:description>
<act:parent type="guid">e53e4b7471d2cd90477a16065a1e919e</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Strom</act:name>
<act:id type="guid">58b4d615e3865ccddee8c832f14cf6c5</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Strom</act:description>
<act:parent type="guid">e53e4b7471d2cd90477a16065a1e919e</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Wasser</act:name>
<act:id type="guid">f74601683cc62fba4b5a415602b6edb1</act:id>
<act:type>EXPENSE</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Wasser</act:description>
<act:parent type="guid">e53e4b7471d2cd90477a16065a1e919e</act:parent>
</gnc:account>
<gnc:account version="2.0.0">
<act:name>Anfangsbestand</act:name>
<act:id type="guid">6fab3d2b6142efbe7b1231c5351e5529</act:id>
<act:type>EQUITY</act:type>
<act:commodity>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</act:commodity>
<act:commodity-scu>100</act:commodity-scu>
<act:description>Anfangsbestand</act:description>
<act:parent type="guid">6c16301f5606aed0a75350504103a2fa</act:parent>
</gnc:account>
<gnc:transaction version="2.0.0">
<trn:id type="guid">8992e239c7da2f44df6bd8a1b99f87cd</trn:id>
<trn:currency>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</trn:currency>
<trn:date-posted>
<ts:date>2015-08-31 00:00:00 +0200</ts:date>
</trn:date-posted>
<trn:date-entered>
<ts:date>2015-08-31 11:20:53 +0200</ts:date>
</trn:date-entered>
<trn:description>Anfangsbestand</trn:description>
<trn:slots>
<slot>
<slot:key>date-posted</slot:key>
<slot:value type="gdate">
<gdate>2015-08-31</gdate>
</slot:value>
</slot>
</trn:slots>
<trn:splits>
<trn:split>
<split:id type="guid">e6c7e79d38f03df89f2c73de31788002</split:id>
<split:reconciled-state>n</split:reconciled-state>
<split:value>100000/100</split:value>
<split:quantity>100000/100</split:quantity>
<split:account type="guid">651dcf942b4938edddae864e87601547</split:account>
</trn:split>
<trn:split>
<split:id type="guid">c0e844fab8ebba45873e73c16aacaa1f</split:id>
<split:reconciled-state>n</split:reconciled-state>
<split:value>-100000/100</split:value>
<split:quantity>-100000/100</split:quantity>
<split:account type="guid">6fab3d2b6142efbe7b1231c5351e5529</split:account>
</trn:split>
</trn:splits>
</gnc:transaction>
<gnc:transaction version="2.0.0">
<trn:id type="guid">061614db067cbbf889ba15790d95b13a</trn:id>
<trn:currency>
<cmdty:space>ISO4217</cmdty:space>
<cmdty:id>EUR</cmdty:id>
</trn:currency>
<trn:date-posted>
<ts:date>2015-08-31 00:00:00 +0200</ts:date>
</trn:date-posted>
<trn:date-entered>
<ts:date>2015-08-31 11:20:53 +0200</ts:date>
</trn:date-entered>
<trn:description>Anfangsbestand</trn:description>
<trn:slots>
<slot>
<slot:key>date-posted</slot:key>
<slot:value type="gdate">
<gdate>2015-08-31</gdate>
</slot:value>
</slot>
</trn:slots>
<trn:splits>
<trn:split>
<split:id type="guid">2ff911f0198a1628c5bbca735f768670</split:id>
<split:reconciled-state>n</split:reconciled-state>
<split:value>10000/100</split:value>
<split:quantity>10000/100</split:quantity>
<split:account type="guid">2c086d841cae2b7cd52f1895469446ed</split:account>
</trn:split>
<trn:split>
<split:id type="guid">a8ee18bb7aedcb41ec495578c78e987a</split:id>
<split:reconciled-state>n</split:reconciled-state>
<split:value>-10000/100</split:value>
<split:quantity>-10000/100</split:quantity>
<split:account type="guid">6fab3d2b6142efbe7b1231c5351e5529</split:account>
</trn:split>
</trn:splits>
</gnc:transaction>
</gnc:book>
</gnc-v2>
<!-- Local variables: -->
<!-- mode: xml -->
<!-- End: -->
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment