Question about Microsoft Computers & Internet

# How to do profit and loss a/c in ms excel

And how to do balance sheet in ms excel with what formulae

Posted by on

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Master

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)

Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)

I hope this helps

Mark

Posted on Jan 05, 2009

• Level 2:

An expert who has achieved level 2 by getting 100 points

Habit-Forming:

Visited the website for 3 consecutive days.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

• Expert

Keep track of operating income and expenses with this template for a 12-month profit and loss statement. The line diagram shows how expenses relate to the gross profit.
visit us -

Posted on Feb 20, 2018

• Level 1:

An expert who has achieved level 1.

• Contributor

First define the name of your complete debit cell and credit cell.means 1st select all expences define with any name,and same with credit. than,go to the net profit cell and type formula =if(cell adress,"","","netprofit") same formula for net loss. than go to the net profit amount cell and type =if(sum(cell address)>sum(cell address),sum(cell address)-sum(cell address) than enter your formula run smoothly and apply same as net loss..... at last coputing total =sum(cell address) than enter..............

hope my effort help.......

Posted on Mar 07, 2011

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### BALANCE SHEET FOR OFFICE PRACTICE HOW DO YOU CALCULATE IT

The balance sheet is part of the double entry bookkeeping method that dates back to the 14th century. Producing and understanding a balance sheet is a complex matter to be undertaken only by those who have a grounding in accountancy.

The balance sheet is where the calculated totals of the bookkeeper's work are brought together with a number of fairly notional figures for depreciation/appreciation of stock, equipment, buildings, land, certain taxes and liabilities and so forth. To the experienced a balance sheet can show the worth of a company.
A person needs to be formally taught the process of producing a balance sheet.

For most people most of the time when a business is not either a limited company or a limited partnership and there are minimal assets the balance sheet is an unnecessary expense and a Trading and Profit and Loss Account will suffice.

Jun 26, 2017 | Balance Computers & Internet

### Difference in opening and closing balances

refer the opening balance cell to the closing balance cell.. so everytime your closing balance change it would change the opening balance as well.. just use the simple formula Closing Balance Cell (A1)=Opening Balance (B2)

Mar 15, 2014 | Computers & Internet

### Want to copy formula into multiple excel sheets

why not? however, you can also insert an apostrophe (') at the start of the equation before copying the entire formula so that the formula will be treated as a text thus preserving all cell references. dont forget to remove the apostrophes after you have pasted them though for the formulas to work again.

Jul 29, 2009 | Computers & Internet

### Excel work sheets delete,pls how is it restore

Easiest way would be to use the Undo function to work your way back to the point prior to deleting the worksheets. If you can't back up through the list that far, you could close the file WITHOUT SAVING IT, then reopen the original file again. If you have already saved the document after deleting the worksheets, you will have to restore it from a backup (you do perform backups, right?) and continue working fro there.

Apr 15, 2009 | Microsoft Computers & Internet

### Excel formulas

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

### Excel 2003 formula

detail about growth formula in ms excel

Jan 23, 2008 | Computers & Internet

### Formmulas are not appling in the excel of office xp

Dear chidambar, thats usually because you've mistakenly tampered with a file or because you're putting an inapplicable value. Can you tell me what error is it exactly ?

you might like to re-install your MS excel after backing up your files. You might also like to repaire your ms office from your cd.

if that has helped you plz press fixya.

Dec 13, 2007 | Computers & Internet

### Excel 2003

Dear Thccsl, if you meant formulas by writing codings then you can find a complete list of formulas by clicking fx button beside the formula bar in MS excel. You can get complete range of forumlas and example and explanation of how to use this formula.

You also might like to see this for detailed information:

http://en.wikipedia.org/wiki/MS_excel

Nov 24, 2007 | Computers & Internet

## Open Questions:

#### Related Topics:

622 people viewed this question

Level 3 Expert

Level 3 Expert