Hi,
I am not an accountant or a programmer.
I have been using Kmymoney for a small business for a while. The the accountant is now asking for the following reports at the date of the end of financial year.
-Trial Balance
-Profit & Loss
-Balance Sheet
-General Ledger Detail Report
I can’t seem to work out if this is possible in Kmymoney, and if so how do I produce them.
If anyone can help guide me it would be much appreciated.
-Trial Balance
I don’t know what this is. Can you give a description?
-Profit & Loss
Again, I don’t know what this would look like. Perhaps and Income and Expenses for the fiscal year report would do?
-Balance Sheet
Is this not just a list of balances in each account at the specified time? See if hte Net Worth Report - Today gives what you need.
-General Ledger Detail Report
Again, I don’t know what is actually needed for this. I would guess some sort of Transaction Report might do, but that would be one Account at a time.
Any better suggestions would need more details on what is needed.
As @ostroffjh already mentioned, we may have some of it but certainly not all. And probably not in the fashion an accountant would want to see it 
While searching, I found this video playlist which seems helpful.
-
Trial balance
We do have the necessary data but just don’t have a report that creates a trial balance. See this video that explains how to create it. -
Profit & Loss
That should actually covered by the income/expense report, but I am also not an accountant. -
Balance sheet
Another video that explains what it is and how to create it. I think, all the data that goes into it can be obtained from the net-worth and income/expense report. -
General ledger detail report
We certainly do have all the data, but we don’t have a function to create that report. Maybe a nice addition for one of the next versions. I found a page expressing how it can look like.
Hope that helps to get started.
1 Like
Thanks for the reply.
IPWIZARD seems to know what they are.
Thanks for the reply.
So no easy way to create these reports.
I now have a better understanding of what the reports are and should look like, but not how to get the information from Kmymoney in a way to easily create the report.
It would be great to see these all reports with a click of the button as future features.
Sorry, this might be a bit off-topic of the request, but…what is your accountant asking for those specific reports in order to do? (Prepare a tax return, something else?)
Just thinking on the chance that there is an equivalent, easier to get to way to get to the necessary info…
1 Like
He is wanting the info for the tax returns
also for the financials for the business for loans and whatever other reasons they need to be done.
IPWIZARD seems to know what they are.
Only after reading about them 
and with the little knowledge about accounting I have.
1 Like
At least we now have some concrete examples of ways in which KMyMoney does not support businesses. I can add these to the Handbook. However, I have some thoughts about a new data export tool (or maybe modifying one of the existing ones) to better support creation of such reports (which I still have to read about myself.)
1 Like
I hope that something can be added, at least in the future.
Unless I can figure out how to get the data out to make the reports I’m going to have to swap software. Which is really annoying due the fact I like the feel of KMyMoney (and it is a bunch of work I have to re-do 
)
It is unlikely that any business specific reports will be added, but very likely a more generalized data export tool. However, if the data is in KMyMoney, then there is most likely a report that will get it out, not necessarily in the format you need, and maybe needing more than one KMM report for all the data for a single financial report. If you find some type of data with no way to get it out, let us know, as that is something more likely to get looked at and acted on.
As @ostroffjh pointed out, most of the data is available in KMyMoney. I explain how one can create the trial balance report based on the mentioned example. The data is contained in this KMyMoney example file.
I added all accounts, categories and transactions as outlined and modified one report for simplicity. Exported the two reports as CSV
imported them using LibreOffice and copied them together into a single sheet.
Then I simply removed the unwanted/unnecessary data, added two formulas to sum the debit and credit column and was done.
1 Like
Thanks. That gives me a bit more idea on how to do it.
The info of the trial balance is basically also the information you need for the balance sheet. The one thing you need for it is the difference between income and expense (retained earnings or losses if negative) which is presented as the Grand Total of the income and expenses this year report (or maybe you have to customize it to show the respective fiscal year).
Hope that brings you forward.
2 Likes