For small companies or associations, the state provides an option to report income on a cash flow basis, but conducting accounting using cash flow has disadvantages, the main one being that it’s difficult to track payables and receivables.
I would like to generate a cash flow statement from accrual accounting and combine the best of both worlds.
I believe this can be achieved by filtering moves that originate from cash account (bank, cash-draws ecc…), and including reconciled moves in the report. This can likely be implemented using pure SQL (or hope so).
So I have some implementation design question:
- What is the best way to identify accounts of “cash flow” type? Should users manually select accounts from a list, or should a “cash flow” flag be added to the account type?
- Is the “follow the reconciliation” a valid strategy for calculating a cashflow statement?
- Is best to book moves in a special journal, and filter it in this way? By doing so, will this interfere with other modules, like payment and statement?
- Should we simply overlook the issue and abuse the analytic account module?
Thanks in advance for your feedback