Solved

profit and Loss account

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
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…
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…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

920 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