I have realized that using Bills and Expenses module, it makes life very difficult for Zoho Books users.
Let’s assume the below scenario. I have Bills with Due date of 31 August 2018. However the bill are paid between 21 September to 30 September 2018. During the same period, I have also paid for expenses.
I need to be able to generate a report which shows me the payments made between 21 September to 30 September. It should include payments for both Bills and Expenses.
I tried using “Expense by Category” which is a good report. It does show Bills and Expenses and it's a categorized report (shows expenses and Bills by Account category). But the problem is: It takes into account the Bill Due date and it DOESN'T take into account the actual Bill payment Date. For example if the Bill due is 30th August but the Bill is actually paid on 21 September and I try to generate Expense by Category report from 20 Sep to 30 Sep - It won't show this bill payment, even though the actual payment was made on 21 Sep and the report is being generated for this period.
What I need is honestly a very basic thing. I should know where the money went out for a specific period and for which account categories. The report should include all payments made: Whether Bill payments or Expense payments.