Ideas for Cash Summary Report

1

For @lubos … Do you think that it would be possible:

  1. to divide the Cash Summary Report by the different tracking codes?
  2. to have to possibility to have a breakdown of all the accounts reveivable/payable divided by customer/supplier inside the cash summary report?
  3. to replace the accounts payable/receivable in the report with the corresponding voice of p&l?
1 Like
2

@lubos any consideration on the ideas?

3

Those are all workable ideas. My main issue with cash summary report is that it’s quite non-standard. I’m not sure what direction to take it because I don’t understand how businesses are using this report and why it’s useful at all.

Perhaps if you could explain why this report is useful to you (and maybe others), it could give me more clarity.

4

I’ll do some examples soon and post them.

5

I may be wrong but if I look at the cash summary report as at now, it almost like a cash flow statement. Cash flow statement shows what has come in and gone out and through what .

The cash summary does same, only difference is that, cash flow statement has a presentation structure and the cash summary is just inflow and outflow but in the end they all show net increase (decrease) in cash held, cash at beginning of period and cash at end of period.

We could use some mechanism, for example the Multi-step reporting style to regroup the line items/accounts and what do we have? a cash flow statement.

@lubos?

6

yes. but the main problem is that all the accounts receivable and payable are grouped in one line each. Like that, for a company that works only by invoices, it’s almost useless since you would have almost only two lines for a cashflow.

7

@Davide well Cash Flow statement is a requirement to Financial Reporting. The company’s transactions determines what will appear on the statement.

8

I would like to have flexible arrangement similar to Income Statement, the only difference is inflow and outflow are mixed in user-defined group category, which I want to achieve similar to cashflow statement.

I want to arrange it in away it tells me the source of cash and its application. Categorise by primary to secondary.

1 Like
9

Dear Lubos,

answering to your request as how I would do a cashflow statement I think that we can start with an “indirect cashflow” report a.k.a. “financial statement”.

I did a small example starting from your Northwind example.

  1. I’ve extracted the general ledger summary (GLS) of three months: Jan, Feb, Mar 2017

  2. I’ve done some reclassification starting from the GLS. I think that it would be great to have the possibility to set up an additional chart of accounts for the financial statement (with the possibility to create groups and totals) and to assign to each account voice of financial statement one or more voice of the GLS.

  3. Obviously I have to exclude the retained earnings from the reclassification.

I’ve sent you an email with the excel example. Next step is to come up with a “direct cash flow statement” but i have to think how to obtain it, if possible, from the actual outputs of Manager.

Alternatively, as I told before, this can also be obtained with third party software if you create an extra “long text” field (other than the actual code) in the actual existing chart of accounts (BS and P&L) where anyone can store the keys for reclassification. This would be useful for many other scopes until you will somehow give access to an external SQL dump of the database.