I am new to Gnucash, I like it, but the report is far from being usefull for me.
Is there anyone who can write a template for me and how much it could cost?
First report will be in two separate sections:
o 1) income – a list of all entries in the database from the dates I pick (description field) and fields: deposit or withdrawal (amount),
without income “Key Deposit”. There should be a summary for all the income quotes.
o 2) expenses – a list of all entries in the database from the dates I pick (description field) and fields: deposit or withdrawal (amount),
without expense “Key Refund”. There should be a summary for all the expenses quotes.Second report will be for the “Key Deposit” . In “assets” I have a sub account “Key deposits”
o Start balance for this accout
o 1) income – “Key Deposit” – all income for new keys for the period I chose, the same period as for the first report
o 2) expenses – “Key Refund” – all expenses for keys refund for the period I chose, the same period as for the first report
o Float money for the key deposit, which is 100 pounds, this amount will stay always 100 pounds. It is in the account “Cash flow Keys” in “assets”
o End balance for this account: start balance + income – expenses + float money for keys.Then I want to have a “Summary report” for the “Business Account” in “assets”. In that summary I want:
o Money in the account on the first day of the period I chose
o Income – only final quote from the first report above
o Expenses– only final quote from the first report above
o Float money for the shop, which always is 20 pounds. It is in the account “Cash in Shop” in “assets”
o Account Balance as of the last the of the period I chose
o Spendable money as of the last the of the period I chose (Account balance minus key deposits)Third report for our SumUp accout:
o 1) income – a list of all entries in the database from the dates I pick (description field) and fields: deposit or withdrawal (amount). There should be a summary for all the income quotes.
o 2) expenses – a list of all entries in the database from the dates I pick (description field) and fields: deposit or withdrawal (amount). There should be a summary for all the expenses quotes.Then I want to have a “Summary report” for the “SumUp Account” in “assets”. In that summary I want:
o Money in the account on the first day of the period I chose
o Income – only final quote from the first report above
o Expenses– only final quote from the first report above
o Account Balance as of the last the of the period I chose
