The last transaction of the report, which should be automatically generated like in the GLT, is the one that move the profit of P&L to the undistributed profit.
It is also the one that makes the total amounts of the period that you have in General Ledger Transaction equal to the Account Daybook.
Can you share one of the reports you have produced on excel with input from Manager? Looks like it a daily (periodic) profitability report with detailed transactions.
Tomorrow I will share one. It is nothing special. The one that I posted plus a manual stiched last transaction to close the profit vs the undistributed profit.
Can you please post the implementation under Report Trasformation of the General Ledgder Transactions report so that I have something to hack. I am not that confident with Liquid.
That’s basically it, but then transaction should also be grouped by day so it becomes a true daybook.
The other report (grouped by account) is redundant since it’s basically the same as General Ledger Transactions report, which is already available.
They should show all entries to the books, including profit and loss, both manual and automatic. So no, they should include profit and loss.
I believe that exclusion of profit and loss account is just a side effect of custom reports or maybe it’s a special requirement. @Davide can correct me.
I understand the group by date type of report. The part I find unfamiliar is the profit and loss part because a daybook reports financial entries, it is not intended to show you your profit or loss, that responsibility is handled by the profit or loss statement. Besides what are you going to use such a report for, determine the most profitable day? I have used Quickbooks, Tally ERP etc, I don’t remember seeing a daybook that showed profit or loss (maybe it was there and I didn’t notice).
I guess such a report may be useful for some users and may be a legal requirement for some but I don’t think I will ever need the type of report you are requesting.
Because the closing is manual and you usually take out the daybook for the auditors JV testing. And that’s usually before you close your books.
But once you manually post that entry, it will show in the daybook.
@lubos possible to allow grouping by date? It will at least get the report closer to @Ealfardan’s suggestion.
Having thought of it, if grouping by date is too much, just sorting by date would also do the job.
Profit at the end of the period is automatically calculated by Manager based on the opening and closing date and it is shown in GLT dynamically. It is not a written entry since Manager is a perpetual accounting software.
That’s why you cannot get it with a custom report. From what I can understand you can with a Report Transformation but I still haven’t found time to work on them so much.
That’s why I asked @lubos if he can provide a General Ledger Transaction report “translation” under Report Transformation to have something to start working at.