How to create an income statement for individual accounts in BC?

(0) Share

Report

Posted on by Olivere91

Scenario:

I want to create an income statement for our largest retail account in BC. I want it to include That accounts sales, minus COGS and COOPS and marketing spend on that account. How can I set it up? I've gotten close by using the chain below but the report is incomplete.

Trial Balance>Trial Balance Detail Summary>Income Statment>Date Filter>Department filter (Account goes here)>Document Type"Invoice"

Categories:

Reports and Business Intelligence

All responses (3)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 13,695 Moderator on at

Like (1)

Report

RE: How to create an income statement for individual accounts in BC?

Are you using the Account Schedule ? If yes, you can just create a total line with formula.
Olivere91 27 on at

Like (0)

Report

RE: How to create an income statement for individual accounts in BC?

Thanks Teddy Herryanto, I was able to pull in all the fields I needed. Is there a way to have a end balance at the bottom of the report?
Suggested answer

Teddy Herryanto (Th... 13,695 Moderator on at

Like (1)

Report

RE: How to create an income statement for individual accounts in BC?

Have you tried using Account Schedules ? You can build your own report using that.