Solved

profit and Loss account

Posted on 2011-02-17
4
784 Views
Last Modified: 2012-05-11
My OS is windows 7 and I am looking for a simple app or template either for Access 2007 or Excel 2007 to create a simple profit and loss account.  Can someone please give me some suggestions. thank u.
0
Comment
Question by:jegajothy
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 34920131
Microsoft offers a number of templates. Check this link:

http://office.microsoft.com/en-us/templates/results.aspx?qu=profit+loss&origin=CT010144195

Flyster
0
 

Author Closing Comment

by:jegajothy
ID: 34921426
thank u
0
 
LVL 18

Expert Comment

by:Richard Daneke
ID: 34921710
IF you are looking for a quick Income less Expense summary, you may see something in the templates.  

Profit and loss account transactions are summarized over time so an alternative would be a table for entries and a Pivot Table for the report.
I have added a hasty example that uses Excel 2007 tables, data validation, and a Pivto Table report.
PandLExample.xlsx
0
 
LVL 22

Expert Comment

by:Flyster
ID: 34922233
You're welcome. I hope you found what you were looking for.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question