# Financial Statement -net profit calculation

Hi,

At the time of creating the , Profit & Loss account , In row structure how to get the net profit and where the + and - calculation are going means (exactly in row structure where the total income and expenses are deducted ) is there any calculation setup in row structure for getting net profit and finally how to add these net profit to balance sheet

Thanks

Hi Kola,

You have two options within financial statements either: -

1. Use calculations or;

2. Use a range

So, to calculate the net profit you can either use (1) above and use a calculation to take the total sales, less direct costs, less over heads, or use (2) a range that includes all of the profit and loss accounts.

For the balance sheet, I would suggest you use a range of all the profit and loss accounts.

It is always a good idea to check any calculations against a range to ensure that the calculations are valid and you haven’t missed out any accounts.

Cheers.

Hi John, on a related note, how could we show net sales in P&L supposing that I have

Net Sales = Sales - Discounts

Sales include a range of accounts say 3000 to 3100

Discounts include say 3200…3280

I am able to show the totals for sales and disounts, However, how to show the net? Appreciate your thoughts. Could we use a calculations if so, how? thanks

I am going with Range and that helped. Thanks a lot.

The rande is not helping me because it alredy appears in the financial statement, I cant use the same range more then one time.

I think the calculation might help me, but i dont know how to use it. can any body help me with that? how can i use the argument

table in the calculation? how can i add argumants to the table?

Thanks,

Ifat

The rande is not helping me because it alredy appears in the financial statement, I cant use the same range more then one time.

I think the calculation might help me, but i dont know how to use it. can any body help me with that? how can i use the argument

table in the calculation? how can i add argumants to the table?

Thanks,

Ifat