I'm fairly new in actually actively using Zoho Reports and thus do not know all the tips and tricks. :-)

Is there any way that I can create a report (or dash board, or any other way) that will give me account balances like this (just an example; need to do this for all my accounts), in a lay-out similar to this?:

_______________________________________

Petty Cash Summary for March 2016

Opening Balance:                     1234

Top-up                                       567

                                               -------

Available funds                         1801

Expense Account01                     89

Total Expenses                        1025

Closing Balance                         776

_______________________________________

The Expense Accounts listed above is the summary for each from the underlying daily transactions.

The table I use currently (please advise any changes required to achieve the above) looks like this:

      Date | Paid to | Description | Expense Account | Amount | Paid From

"Paid From" is the 'account' for example "Petty Cash", for which the summary report needs to be created every month.

There's currently no 'month end entries':  ALL transactions just gets recorded in the table as payments are made.

If any more information is required, please let me know.

Thank you very much!

Regards

Pieter