# Financial Statement -net profit calculation

#### Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
page a complete list of our different newsletters.

#### This post has 1 verified solution | 5 Replies | 3 Followers

108 Posts
1,055 Points
Joined: 2011-8-29
Last Online:
2013-1-5 12:32
Location: india
kola posted on 2012-9-13 21:11

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

#### Verified Solution

36 Posts
955 Points
Joined: 2006-9-25
Last Online:
2012-10-4 5:41
Location: Hampshire, UK.
John Lincoln replied on 2012-9-25 19:04

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.

#### All Replies

36 Posts
955 Points
Joined: 2006-9-25
Last Online:
2012-10-4 5:41
Location: Hampshire, UK.
John Lincoln replied on 2012-9-25 19:04

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.

471 Posts
4,400 Points
Joined: 2012-11-4
Last Online:
2013-5-21 19:19
Location: Hoboken New Jersey
Patrick Am replied on 2013-1-28 17:32

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

471 Posts
4,400 Points
Joined: 2012-11-4
Last Online:
2013-5-21 19:19
Location: Hoboken New Jersey
Patrick Am replied on 2013-1-30 20:30

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

2 Posts
10 Points
Joined: 2013-2-2
Last Online:
2013-2-13 18:50
Ifat replied on 2013-2-2 12:40

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

2 Posts
10 Points
Joined: 2013-2-2
Last Online:
2013-2-13 18:50
Ifat replied on 2013-2-2 12:40

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

Page 1 of 1 (6 items) | Get this RSS feed |