How To Make A Profit Loss Statement In Excel On Windows?

Asked By Bianca B 0 points N/A Posted on - 09/07/2016

Hi everyone! I am from the accounting department of a marketing venture. I am doing the part of managing sales and revenue, and so, I want to know how to make a profit loss statement in Excel?

• Status: Open
• Question Views: 311
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By A Bagul 0 points N/A #113004

How To Make A Profit Loss Statement In Excel On Windows?

If you wish to create an electronic balance sheet to build and review the P and L for each period, you can follow the steps below:

• Launch Microsoft Excel.

• Type the ‘Name of Expense’ in cell A1, ‘Amount’ into B1, and ‘Running Balance’ into C1. Enter the initial balance into cell C2. • For each expense name, type the profit and loss amounts into cell C3 with the positive and negative signs respectively.

• Now click inside the cell D3 and drag the outlined box to several rows below to get the corresponding values.

By using this easy method, you can identify the areas of weaknesses and strengths in your business.

About A Bagul

Questions
16

Answers
19

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/07/2016
• Question Category: MS Excel