[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
chembai
Newbie

Joined: 09 Apr 2010
Posts: 2

 Posted: Fri Apr 09, 2010 7:19 am    Post subject: Simple profit and loss account (Solved) Can any one please tell me how I can create a simple profit and loss Account . I have entered Dates in A , Profit in B and Loss in C .I want the total in D . Can any one help please . My question has been solved by Mr Ken Johnson who has given me the correct Answer . Thanks to Mr Ken Johnson and the rest of you who gave a hellping hand . God bless you! .Last edited by chembai on Sat Apr 10, 2010 7:41 pm; edited 2 times in total
Villeroy
Super User

Joined: 04 Oct 2004
Posts: 10065
Location: Germany

 Posted: Fri Apr 09, 2010 10:18 am    Post subject: http://gnucash.org/_________________Rest in peace, oooforum.org Get help on http://forum.openoffice.org
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6733

Posted: Fri Apr 09, 2010 12:47 pm    Post subject: Re: Simple profit and loss account

 chembai wrote: Can any one please tell me how I can create a simple profit and loss Account . I have entered Dates in A , Profit in B and Loss in C .I want the total in D . Can any one help please .

You need to learn some basic spreadsheet operations. Try any library or used book store for a copy of "Spreadsheets for Dummies" or something similar. It does not have to be about OOo since the basics are the same for any spreadsheet.

Actually though, Villeroy's suggestion is a better one as the software is likely to be much more reliable and secure than trying to do much of this in a spreadsheet.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
stevesaunders

Joined: 26 Dec 2009
Posts: 408

 Posted: Fri Apr 09, 2010 3:10 pm    Post subject: Add in column D =A1+C1 or =A1-C1 What are you trying to Total?_________________Steve ~ Tennessee USA Mac OS X 10.6.2 Open Office 3.1
chembai
Newbie

Joined: 09 Apr 2010
Posts: 2

 Posted: Sat Apr 10, 2010 5:37 am    Post subject: Thanks every one for the help . I dont want a software ,Well, in answer to stevesaunders question I am a small time stock trader and I Day Trade . At present I am entering the Dates in A , Profit in B and Loss in C and manually adding the total in D . For example if todays Trade is a profitable one then I enter profit in coloumn B , leave the coloumn C Blank and enter the amount in coloumn B again in Coloumn D . Vice versa if I make a loss tomorrow then coloumn B is blank ,coloumn C is entered with the loss and in coloumn D I enter the figure in coloumn C (along with the addition /substraction of the previous day . So what I want is very simple . Just 3 coloumns . One for profit , the other for loss and the third one for the cumulative profit/Loss for the month . The formula must be something like this =B> or < C = D ! Ha ha ha ! Hope the point is understood /Hope no one suggests buying a Stock Trading software ! Its a simple requirement but it may be difficult to create ! Thanks to all for the help rendered .
ken johnson
Super User

Joined: 23 Apr 2009
Posts: 1850
Location: Sydney, Australia

Posted: Sat Apr 10, 2010 7:59 am    Post subject:

With Profits starting in B2, Losses in C2 then cumulative total is given by...
 Code: =SUM(B\$2:B2)-SUM(C\$2:C2)
in C2 then filled down to the last row of you data.
http://www.4shared.com/file/hx9xgP8n/Cumulative_Total_from_Profit_L.html
Ken Johnson
_________________