P&L / Balance Sheet Breakdown by Vendors/Customers

[Former Member]

Hello ppl! Hope you're all well.

I'm currently needing to create a P&L and Balance Sheet Report itemized by Vendors and Customers in the following way:

P&L Example:

Sales Income:   1.000.000

     Customer A:  300.000

     Customer B:  700.000

Costs of Goods:   500.000

     Supplier A:       200.000

     Supplier B:       300.000

Balance Sheet Example:

Assets:         2.000.000

Cash:            1.000.000

Receivables:    800.000

    Customer A:  300.000

    Customer B:  700.000

And so on..

Please, if you know any standard report I can use to get the information broken down this way, Me, the management, and the accounting coordination would really appreciate it!

Thanks in advance and have a great day!

[former_member184878]

Hello,

Such report is not available.

Putting all that stuff to one paper would be a little bit confusing - in my opinion.

How to handle this:

make balance + P&L report.

For AR + AP make open item report.

For Assets make summary of fixed assets

For sales make sales report.

To put it in a nutshell: make detail reporting where sub ledger values are available, like AP, AR, Assets,

all the best erwin