The manager currently has a receipt and payment report, but it is an accumulated report of cash and bank transactions. I need a single report with separate columns for each account, for example:
Cash: Receipt | Payment
Bank AC1: Receipt | Payment
Bank AC2: Receipt | Payment
As if more accounts or cash
Essentially, I want all cash and bank accounts displayed in separate columns showing receipts and payments. This report is required daily by management and is very important for me.
If there is an existing solution or a custom report can be developed for this, please inform me.
This solution is currently manual, but the client requires a ready-to-use report. In the Bank Summary report, there is a date-wise comparison option; however, it only displays one bank or cash account at a time.
Most of our clients require a consolidated report that shows all accounts’ receipts and payments (i.e., total inflow and outflow) in a single statement based on a selected date range. Additionally, the report should include overall totals.
This is a very important report for daily management use. We are facing difficulties due to the absence of this feature, and it would be highly beneficial if Manager could develop this report.
I can relate to your situation, however, introduction of pivot style reports would be a big endeavor.
Although I am all in for this feature but I assume that there needs to be some kind of foundations layed out before it can be introduces and I’m not the one ultimately responsible for the development so if I’m afraid that if I promote this to ideas, I would be given users false hope.
However, I think there could be a way to get this data automatically using API. I will have to try it out for myself and I will update you in case of success