excel help

Posted By Message

jillee03
LIF Adult

Member since 8/05

953 total posts

Name:
Jill

excel help

Trying to figure out excel

I just opened up a business and I want to create an excel spreadsheet to keep track of everything.

I made an expense report. My next goal is to try and figure out how to take the total cost. say 10,000 that it cost to get up and running and make a spreadsheet that allows me to add and subtract costs to keep a running tally.

For instance

Starting Balance 10,000
sold 2 products - 75 dollars
new balance 9,925
added materials 100 dollars
new balanace 10,025.

any help would be appreciated

Posted 12/19/09 11:02 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

CouponKT
Our family is complete

Member since 6/06

16494 total posts

Name:
K

Re: excel help

you should really buy a program like Quickbooks to help you run your business.

But as far as Excel, send me your email address and I will set up a quick sheet for you

Posted 12/19/09 11:04 AM
 

jillee03
LIF Adult

Member since 8/05

953 total posts

Name:
Jill

Re: excel help

[email protected]

Posted 12/19/09 11:06 AM
 

Christine
2nd verse same as the 1st

Member since 5/05

15287 total posts

Name:

Re: excel help

You can set up tabs for each type of transaction - units purchased, units sold, etc. These tabs would keep a running total of purchases/sales.

Then have a summary tab that has the

beginning balance
+ units purchased which would be = to the total on that tab

- units sold which would = to the total from that tab

ending balance.

I am not sure if I am explaining it correctly but if you like fm me your email and I can send a sample of what I mean.

Chat Icon

Posted 12/19/09 11:07 AM
 

jillee03
LIF Adult

Member since 8/05

953 total posts

Name:
Jill

Re: excel help

anyone who is willing to send me samples would be great. My email is in this thread

Posted 12/19/09 11:08 AM
 

CouponKT
Our family is complete

Member since 6/06

16494 total posts

Name:
K

Re: excel help

OK, sent. Let me know if those are the formulas you are looking for.

Posted 12/19/09 11:09 AM
 

jillee03
LIF Adult

Member since 8/05

953 total posts

Name:
Jill

Re: excel help

this is a good start, but my question is is there a way where it can be a whole spreadseet that I could have descriptions of what I sold and what I bought and it eithe add or subtract

Posted 12/19/09 11:18 AM
 

CouponKT
Our family is complete

Member since 6/06

16494 total posts

Name:
K

Re: excel help

Posted by jillee03

this is a good start, but my question is is there a way where it can be a whole spreadseet that I could have descriptions of what I sold and what I bought and it eithe add or subtract



Yes you can. But in my opinion, this is not the easiest way to do it. If you have a lot of products, it will be a huge headache in no time. I tried it in Excel when I was selling some eBay items and even with my knowledge of Excel, it was frustrating.
I recommend trying a version of QuickBooks or a small business software. Way easier and the reports you can generate are easy to read and very useful!

Posted 12/19/09 11:36 AM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Can a Word doc be merged into an Excel doc? NFT Smileyd17 7/9/09 1 Families Helping Families ™
Excel Wizards... nevermind! Lucky09 5/10/08 0 Families Helping Families ™
can you format a table in Word, the same way you can in Excel? randella 6/13/07 3 Families Helping Families ™
my excel freaking crashed- I lost 2 hours worth of work! Beth 1/24/07 8 Families Helping Families ™
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
PowerPoint and Excel.. LBG30 10/18/05 6 Families Helping Families ™