OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Simple profit and loss account

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
chembai
Newbie
Newbie


Joined: 09 Apr 2010
Posts: 2

PostPosted: Fri Apr 09, 2010 7:19 am    Post subject: Simple profit and loss account Reply with quote

(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
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Fri Apr 09, 2010 10:18 am    Post subject: Reply with quote

http://gnucash.org/
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Fri Apr 09, 2010 12:47 pm    Post subject: Re: Simple profit and loss account Reply with quote

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
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
stevesaunders
OOo Advocate
OOo Advocate


Joined: 26 Dec 2009
Posts: 408

PostPosted: Fri Apr 09, 2010 3:10 pm    Post subject: Add Reply with quote

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
Back to top
View user's profile Send private message
chembai
Newbie
Newbie


Joined: 09 Apr 2010
Posts: 2

PostPosted: Sat Apr 10, 2010 5:37 am    Post subject: Reply with quote

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 .
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


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

PostPosted: Sat Apr 10, 2010 7:59 am    Post subject: Reply with quote

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
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group