Categories Income vs Expense report

ERPNext
#1

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

image
image1266×474 39.5 KB

Thank you,

#2

Hi,

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

image
image1944×1707 210 KB

Thanks,

Divyesh Mangroliya

#3

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.

image
image1047×607 107 KB

#4

image
image1260×781 41.7 KB

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

#5

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

#6

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

image
image1269×672 53.8 KB

#7

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