Dear @lubos, premised that it can be obtained somehow with a custom report, being a requirement by law, at least in Italy, and I suspect not only here, may I suggest the implementation of an “Account Daybook” report under the General Ledger group?
because somehow it represents the basic of accounting
because it is required by law to have it
because this custom report does not have, obviously, the final closing entry, ie net profit and loss of the period vs balance sheet
because our law also requires to generate a pdf of it with a fixed number of lines per page and so every time I had to export in excel and adjust it
because the law also requires to have each page numbered and this doesn’t happen under custom reports (may I kindly ask to add a flag to enable it under every custom report?)
Country-specific reports are meant to be created with report transformations, not with custom reports.
Two reasons:
Report transformations have absolute flexibility
Users can easily import them and use them
Custom reports have their place but they are meant for management purposes where you create ad-hoc report based on your business-specific needs. For generic country-specific needs, the report transformations are the solution.
But I don’t think that an account Daybook can be defined as a country specific report. It is the first thing you learn when you start studying double accounting.
I completely agree with @Ealfardan. Maybe I didn’t explained myself in the right way.
In the end it is the same report called General Ledger Transaction in which you have only to swap the accounts with the transactions, ie the transactions becomes the groups and the accounts become part of the description of each writing (obviously there will be no opening/closing balance anywhere since a transaction open and close in the same day).
And, as I said, it is not a localization but it is the basis of double entry accounting, the first thing that they teach you.
I am always amazed by humanities aversion to change, preference to doing thing this way “because that’s they way they were always done”
I understand that in some countries the authorities have ingrained this into law and obviously we must then provide the reports deemed “necessary” and “unavoidable” but that does not diminish my sense of helplessness in the face of luddite behaviour.
I fail to see how having pages and pages of accounting transactions listed in a particular order advances the accuracy and validity of accounting records when billions of euros and $s only exist on a computer disk drive in a banks data centre or bitcoin ledger
Yes, but it’s not telling people what they need that get you far in life, it’s giving people what they want.
I know there’s hundreds of ways to work around not having a transaction journal report, but why do I have to explain how you could do without that report to every auditor that comes, every year multiplied by the number of businesses that I have. I would rather just give them what they want, even if they were “wrong.”
I have already made a report transformation for that since day 1 of report transformations, but it’s slow and crashes sometimes. Maybe I should revisit that.
Ok can someone post a sample of the report we are talking about here? I can easily generate a day book with custom reports. Are we talking about some special day book here ? @Ealfardan@Davide kindly post a sample of the report.
Yes, of course you need to produce reports in the format that the users (internal or external) require
I was just expressing my view that it is a bit depressing that we still need to produce reports that were designed in the age when transactions were entered in accounting ledgers using a pen and ruler
I’m 100% with you. I would rather like to give my counterpart a read only account to my Manager rather than saving every semester tons of excel and pdf report but I cannot.
Also, there is another aspect that you need to take into consideration.
If you sign a service contract usually there is a list of reports that you have to send to your client periodically that you need to send them.
Obviously you have to be so smart not to write down reports that are not in manager but you have to obey to your clients’ needs.
This is due to demonstrate that you have done your job, to get paid but most of all, for consultancy agreements for listed companies, to avoid to be accused of phantom contracts.
@Davide are these the type of reports you are looking for ? I’m a little lost, are you requesting that your Daybook format be added to the main reports?
Ok, I understand you now. Per my understanding of Daybooks, daybooks cannot show a profit. It lists transactions some of which are balance sheet account to balance sheet accounts transactions. I’m happy you can at least get something close to what you are looking for with custom reports.
