September 01, 2014, 03:38:02 PM

Author Topic: I lost $300 in an accounting error.  (Read 1880 times)

jdramirez

  • Canon EF 300mm f/2.8L IS II
  • *******
  • Posts: 2287
    • View Profile
I lost $300 in an accounting error.
« on: May 08, 2013, 10:10:23 PM »
I keep a spreadsheet with all of my gear.  What I've paid, what I've sold, residual values, etc.  I was going through past years and I noticed I had a projection which combined several fields which resulted in me having to make a correction and consequently losing $300. 

It isn't that much considering I have spent over $29500 in gear in the past few years, but that phantom $300 will haunt me.  Every time I am saving up for a lens/body and I am a stone's throw away...

Ugh.
Upgrade  path.->means the former was sold for the latter.

XS->60D->5d Mkiii:18-55->24-105L:75-300->55-250->70-300->70-200 f4L USM->70-200 f/2.8L USM->70-200 f/2.8L IS Mkii:50 f/1.8->50 f/1.4->100 f/2.8L->85mm f/1.8 USM->135L -> 8mm ->100L

canon rumors FORUM

I lost $300 in an accounting error.
« on: May 08, 2013, 10:10:23 PM »

RGF

  • 1D X
  • *******
  • Posts: 1264
  • How you relate to the issue, is the issue.
    • View Profile
Re: I lost $300 in an accounting error.
« Reply #1 on: May 10, 2013, 12:16:13 PM »
$300 out of $29,500 is 1%.  I know it hurts but at least it is a small percent.

Perhaps next year, you will find $300 in your favor  :D

RLPhoto

  • Canon EF 300mm f/2.8L IS II
  • *******
  • Posts: 3368
  • Gear doesn't matter, Just a Matter of Convenience.
    • View Profile
    • My Portfolio
Re: I lost $300 in an accounting error.
« Reply #2 on: May 10, 2013, 12:19:02 PM »
The Canon 50mm 1.4 that got away.

jdramirez

  • Canon EF 300mm f/2.8L IS II
  • *******
  • Posts: 2287
    • View Profile
Re: I lost $300 in an accounting error.
« Reply #3 on: May 10, 2013, 10:34:32 PM »
$300 out of $29,500 is 1%.  I know it hurts but at least it is a small percent.

Perhaps next year, you will find $300 in your favor  :D

I'm just happy if I land on Free Parking. 
Upgrade  path.->means the former was sold for the latter.

XS->60D->5d Mkiii:18-55->24-105L:75-300->55-250->70-300->70-200 f4L USM->70-200 f/2.8L USM->70-200 f/2.8L IS Mkii:50 f/1.8->50 f/1.4->100 f/2.8L->85mm f/1.8 USM->135L -> 8mm ->100L

jdramirez

  • Canon EF 300mm f/2.8L IS II
  • *******
  • Posts: 2287
    • View Profile
Re: I lost $300 in an accounting error.
« Reply #4 on: May 10, 2013, 10:36:13 PM »
The Canon 50mm 1.4 that got away.

The funny thing is that I just sold my Canon 50mm f/1.4 so I can upgrade to the 35mm f/1.4 (either Canon or Sigma)... and I do this all the time... I prematurely sell my gear before I have its replacement.  So now I'm without a low light prime. 
Upgrade  path.->means the former was sold for the latter.

XS->60D->5d Mkiii:18-55->24-105L:75-300->55-250->70-300->70-200 f4L USM->70-200 f/2.8L USM->70-200 f/2.8L IS Mkii:50 f/1.8->50 f/1.4->100 f/2.8L->85mm f/1.8 USM->135L -> 8mm ->100L

Chewngum

  • PowerShot G1 X II
  • ***
  • Posts: 61
  • F1.6 is the best.
    • View Profile
    • Peter Kingsley Photography
Re: I lost $300 in an accounting error.
« Reply #5 on: May 10, 2013, 11:15:56 PM »
I do the same thing. I have bought(and sometimes then sold) 136 items of camera gear in the last year. I had $250 of difference at the end. I realised after a long time that I had written that I was owed money but not that I had lent it out. Maths is funny sometimes, unfortunately it is very subject to user error!
Cameras: 5d2, 5d3
Lenses: 17-40L 24-105L 50L 100L s35A s85 70-200L IS II + lots of flashes. About 100 previous bodies/lenses

jdramirez

  • Canon EF 300mm f/2.8L IS II
  • *******
  • Posts: 2287
    • View Profile
Re: I lost $300 in an accounting error.
« Reply #6 on: May 10, 2013, 11:45:21 PM »
I do the same thing. I have bought(and sometimes then sold) 136 items of camera gear in the last year. I had $250 of difference at the end. I realised after a long time that I had written that I was owed money but not that I had lent it out. Maths is funny sometimes, unfortunately it is very subject to user error!

I took a course in financial accounting in college.  I got A's in Calculus, but I scraped by with a C in Financial Accounting.  Damn double entry accounting.  Fifo v. Lifo... it still makes me angry.  That's not math, that's making addition and subtraction harder than it needs to be.
Upgrade  path.->means the former was sold for the latter.

XS->60D->5d Mkiii:18-55->24-105L:75-300->55-250->70-300->70-200 f4L USM->70-200 f/2.8L USM->70-200 f/2.8L IS Mkii:50 f/1.8->50 f/1.4->100 f/2.8L->85mm f/1.8 USM->135L -> 8mm ->100L

canon rumors FORUM

Re: I lost $300 in an accounting error.
« Reply #6 on: May 10, 2013, 11:45:21 PM »

sandymandy

  • 6D
  • *****
  • Posts: 599
    • View Profile
Re: I lost $300 in an accounting error.
« Reply #7 on: May 11, 2013, 02:16:01 AM »
Dont take it so hard. Its just some colored paper, its just some digits. If you were a lion for example then it wouldnt matter to you at all even the 300$ are the same. Its just the thought in your head that u can change and then u will feel better. You just made an error. Doesnt mean you are a bad person. Think about city planners who miscalculate by millions.  Its all natural, stay relaxed buddy :)

jdramirez

  • Canon EF 300mm f/2.8L IS II
  • *******
  • Posts: 2287
    • View Profile
Re: I lost $300 in an accounting error.
« Reply #8 on: May 11, 2013, 06:44:43 AM »
Dont take it so hard. Its just some colored paper, its just some digits. If you were a lion for example then it wouldnt matter to you at all even the 300$ are the same. Its just the thought in your head that u can change and then u will feel better. You just made an error. Doesnt mean you are a bad person. Think about city planners who miscalculate by millions.  Its all natural, stay relaxed buddy :)

Thanks.  In all honesty... it isn't that big of a deal.  I still have enough saved for a 5d mkiii when I find the right price point.  And after that... I almost out of stuff I need.

the 35mm sigma or canon and maybe a 1.4 teleconvertor and then done.  I don't NEED a tilt shift. I don't need an 85mm 1.4 or a 135mm f/2.  So this $300 gives me more time to finish buying stuff I need.  But seeing that finish line just that much further away is a little disheartening.
Upgrade  path.->means the former was sold for the latter.

XS->60D->5d Mkiii:18-55->24-105L:75-300->55-250->70-300->70-200 f4L USM->70-200 f/2.8L USM->70-200 f/2.8L IS Mkii:50 f/1.8->50 f/1.4->100 f/2.8L->85mm f/1.8 USM->135L -> 8mm ->100L

canon rumors FORUM

Re: I lost $300 in an accounting error.
« Reply #8 on: May 11, 2013, 06:44:43 AM »