DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Cash and Bank transactions Under Reports


#1

A cash and bank transactions report must be created under Report. Where cash and bank account are displayed. You must be able to see view transactions button or ‘view’ button to see transactions reported displaying figures under Debit, Credit, and Balance columns. It must ask of dates with ‘From’ and ‘To’. To enable periodic querying


#2

Until such a report is available, you can export the bank or cash account ledger. Then you can play whatever games you want with it. Not quite as convenient, but workable.


#3

Yes Tut, I already do that. I don’t know how hard it will take to do it. But if it could be done by Lubos soon it will really help manager users. Most ERPs have it


#4

I notice more and more users are requesting capabilities of ERP systems. I don’t know if that’s where @lubos planned to take the product or not. Fortunately, we can leave modules disabled when we don’t need the complexity.


#5

There is a report called Cash Summary which summarizes cash transactions across all bank/cash accounts.

I could make “Net movement” figure on this report clickable which would take you to the list of all transactions across all bank/cash accounts. Is that what you mean?


#6

What I mean is the ability to view cash and Bank Transaction reported with regards to a period. During the report, a single bank account or cash account is selected for viewing. The balance before the specified period will be brought forward and the transaction amounts will be displayed with Debit for Receipt and Credit for Payment. I exported an example from one ERP to explain this. I have attached the image please have a look.

You can use the same to enable viewing of transactions in any ledger or account in Manager.


#8

The layout is similar to General Ledger Transactions report Manager already have. If I add ability to filter the report by account, you would get what you are proposing.


#9

Let try that and see @Lubos.
I will give feedback immediately


#10

One thing that seems to be overlooked is the desire, expressed by several people, to see the details of transactions in some of the reports. In other words, they’d like to be able to scan down a report and tell that XX was spent on rent, YY on legal service, and ZZ on something else. The General Ledger Transactions report only lists the accounts involved, without saying what the transactions were for.