Categories Income vs Expense report

Hello,
It’s possible in ERPNext to have/create a simple report Income vs Expense for each category (company account). Something similar to this:

Thank you,

Hi,

You can take the Profit and Loss statement monthly as follows:

Thanks,

Divyesh Mangroliya

Thank you for quick answer.
I have started my company with default accounts plus added some custom.
I have some payment entries for Income and some for expense but they are not reflected in this report.

Also related to your screenshot. Did you create manually your accounts for this Company?
Thank you,

payments do not reflect into P&L statement. Look into cashflow statements

I checked already “Cash flow” but there we don’t have Categories only general Income and Expenses

Hi,

One way of getting what you want is use the Journal Entry for the Payment and receipt instead of Payment Entry.

For Expense:

In Journal Entry you can Debit The Expense Account and Credit the Cash Account.

For Receipt:

In Journal Entry Credit the Income Account and Debit Cash account.

If you want to utilize full potential of ERPNext, I don’t recommend above method, though it will give your expected results.

I suggest you book all your expenses using Purchase Invoice and all Income using Sales Invoice.

With this also you will get same results as per your requirements. Only little bit of increase in a data entry part

Thanks,

Divyesh Mangroliya