Solved

profit and Loss account

Posted on 2011-02-17
4
746 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Aceess 2016 - Variable Data Fields? 12 46
Multiple queries for a form 14 22
Query 14 19
Syntax using Declare 3 11
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now