An expert who has achieved level 3 by getting 1000 points
An expert that got 10 achievements.
An expert that got 5 achievements.
An expert whose answer got voted for 100 times.
Re: how to do profit and loss a/c in ms excel
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:
Sales Product A
Sales Product B
Cost of Sales Product A
Cost of Sales Product B
Total Cost of Sales
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..............
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. click here to Talk to a Technician (only for users in the US for now) and get all the help you need. Goodluck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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.
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)
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.
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.
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.
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: