-
Document to track your monthly and yearly earnings!
Okay, so I don't know if anyone else is as obsessive as me, but I just got finished creating an excel document that tracks each month's hours and earnings for the year.
Each tab has the month done out in 4 weeks where you input your hours spent and amount earned which totals up weekly. That then all totals up for the month and tells you your average hourly pay for the month, how much to save for taxes (I used 30%) and how much you have left over!
Here is a screen shot that makes more sense!
http://i.imgur.com/oYINN.png
All of that data from each month is put together into a final tab that calculates your yearly total income and total to save for taxes.
I'm sure it could use some kinks, but I figured it'd be helpful to anyone else who might want something like it but wasn't familiar with excel.
The document is in an Open Office format (A free program that opens up word/excel/powerpoint files) so that anyone can use it.
Here's the download if you're in need of something like this =D
http://www.mediafire.com/file/45amyh...20Template.ods
-
Re: Document to track your monthly and yearly earnings!
thanks! i've been doing this on paper but keeping a spreadsheet would be great. i use a spreadsheet to track monthly income, fees, taxes, etc. but not raw earnings/hours/goals. i appreciate you sharing this!
-
Re: Document to track your monthly and yearly earnings!
You're awesome!! Thank you!!
I have a spreadsheet where I calculate total number of hours, monthly earnings, etc. already. It includes like my pic/video sales, my C4S site, and all that. I've been meaning to do another spreadsheet like this ... and here it is ... thanks a ton :)
xx
-
Re: Document to track your monthly and yearly earnings!
I've definitely been meaning to make something like this..
I LOVE YOUUUU
-
Re: Document to track your monthly and yearly earnings!
WOW. Thanks, I downloaded....I can be a real spender sometimes and this will help me be more realistic.
-
Re: Document to track your monthly and yearly earnings!
That's awesome! I was already using a spreadsheet but mine was nowhere near as good :)
-
Re: Document to track your monthly and yearly earnings!
I havent paid for my Microsoft programs yet and used up all my trial lol. Anyone know of anything online till I pay for the program?
-
Re: Document to track your monthly and yearly earnings!
Quote:
Originally Posted by
Breannasparks
I havent paid for my Microsoft programs yet and used up all my trial lol. Anyone know of anything online till I pay for the program?
Open office is free :)
Quote:
Originally Posted by
Cam_chick
The document is in an
Open Office format (A free program that opens up word/excel/powerpoint files) so that anyone can use it.
-
Re: Document to track your monthly and yearly earnings!
Wow, thanks so much! This will really help my extreme spending, haha.
-
Re: Document to track your monthly and yearly earnings!
WOW thank you!!!! I am an excel n00b. This is excellent!
-
Re: Document to track your monthly and yearly earnings!
BUMP!
Thought this would be especially helpful with the December challenge going on.
-
Re: Document to track your monthly and yearly earnings!
I wish I could thank this post again! this file has been open on my computer everyday since it was posted. I absolutely love it :thanx:
-
Re: Document to track your monthly and yearly earnings!
thanks so much. I'm going to use this for stripping and camming.
-
Re: Document to track your monthly and yearly earnings!
So......You're Awesome!
Thanks!!
-
Re: Document to track your monthly and yearly earnings!
Neato... I make a lot of cool shit in Excel too but never thought about something like this. I am going to start using it in January so I can start with a fresh year and do it the whole year.
-
Re: Document to track your monthly and yearly earnings!
-
Re: Document to track your monthly and yearly earnings!
-
Re: Document to track your monthly and yearly earnings!
Oooh, one for Mac & one for Windows, now I'm totally set. Thanks! I had made my own but I've never done more than plug numbers into a pre-made spreadsheet on Excel so mine was pretty basic and lame. These are great!
-
Re: Document to track your monthly and yearly earnings!
Thank you soooo much! I am pretty good with Excel, but I just have not had the time to sit down and do a spreadsheet. You are a doll for sharing with us!
-
Re: Document to track your monthly and yearly earnings!
AHHHHH!! Thank you SO much for this! :D
-
Re: Document to track your monthly and yearly earnings!
Yikes. Is 30% really what I should be anticipating the government to tax me???! That's so much!!!
-
Re: Document to track your monthly and yearly earnings!
^^^ there's a new discussion about tax liabilities for webcam girls in the Dollar Den
... and yes, 30% is pretty much the 'minimum' for a webcam girl who is single, who does not have children, who does not own a home or have other tax favored investments, and who is earning something on the order of $1000 a week in total income. Half of that amount is Social Security - Medicare taxes. The 30% figure counts federal SSI + federal income taxes only, and doesn't count an additional 2-3-5% in state income taxes if the state you live in has an income tax of its own. There are still a couple of unresolved tax issues in Washington, involving possible extension of the temporary SSI tax reduction by 2%, involving the possible extension of the temporary 3% lower GWB federal income tax rates, etc. which could change that percentage for 2012.
Quote:
{ 30% tax rate } That's so much!!!
Welcome to the 'real world' of operating a small business !!!
For better or worse, in past years many dancers and camgirls were able to 'have their cake and eat it too' by being able to earn relatively high amounts of income that was not officially documented, thus not subject to the 'high' tax rates other people earning similar amounts were forced to pay ... if those dancers and camgirls chose not to report their incomes. However, with the passage of the National Health Care act, new reporting requirements were put in place regarding issuance of 1099s to report 'independent contractor' income. Also the National Health Care act funded the hiring of 15,000 additional IRS agents, with the establishment of specific 'targets' of businesses that have historically poor income reporting / tax compliance ( with adult businesses being near the top of that 'target' list ). Thus dancers and camgirls still choosing not to report their incomes to the IRS has now become an extremely risky proposition.
~
-
Re: Document to track your monthly and yearly earnings!
Quote:
Originally Posted by
SarahTime
I made this one for myself but I can only get it to work with Numbers (for Mac). So if you have a Mac, this one will work great!
I am obsessed with tracking stuff like this! I made an example too so you can see how it works. If you are like me and count past midnight as still being the previous day, it works for that too. So like 10pm - 3am would count as one "day" not two. If that makes sense.
Download:
http://www.lifeofacamgirl.com/misc/TEMPLATE.zip
omg thank you!! thank you!! thank you!!!!!!!!!!!!!
i tried to make one on numbers but it was horrible and i gave up before i finished lol.
seriously thanks so much for this! so awesome ;D
-
Re: Document to track your monthly and yearly earnings!
sarah, i love the options yours has! :) i just track by day usually but this is making me want to add different fields to my spreadsheet.
-
Re: Document to track your monthly and yearly earnings!
Thanks cam_chick! What if you work more than one site? Just make two spreadsheets?