What's new
By:
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

Gear Grinding 9: I Need a Wine!

Status
Not open for further replies.
Re: Gear Grinding 9: I Need a Wine!

bigblue_dl said:
I track everything manually, both for personal and the farm. Spreadsheets for all of it, no separate software to do anything.
Click to expand...
I knew I liked you for a reason.
I have a spreadsheet as well for our expenses and travel stuff. It's been great. The summer that I worked for the business school at BU opened my eyes to how much you can customize stuff in Excel and how to do functions and write formulas.
leswp1 said:
I don't think I even know all the things spread sheets can do. I can make simple ones but I have no idea how to make them anything other than check lists
Click to expand...
I can send you mine if you'd like. You might need to tweak it, but as someone who likes data, it's awesome.
MinnesotaNorthStar said:
I prefer to control when the money exits my account. Still pay everything online though. Only have , rent, cable/internet, electricity, and car payment (Also, I never make only the minimum payment on my car).
Click to expand...
Same, except substitute mortgage for rent. I prefer to control it as I don't get paid at the same time every month and if we're traveling I like to prepay bills so they don't come due while we're away.
 
Re: Gear Grinding 9: I Need a Wine!

LynahFan said:
I've been using Quicken my entire adult life, so I can tell you where every penny has gone since 1995. The only exception is cash - for the first few years, I even kept track of that (treating withdrawals as transfers into a cash account, which I then spent on food, hookers, blow, etc). I have so many accounts that I can't imagine doing it manually via a spreadsheet.
Click to expand...

Ditto. I’ve been on mint for about 9 years now. It keeps track of my checking, credit card purchases, car loans, mortgages, retirement, and investments. Same thing with cash. I just treat it as a slush fund. Hookers and blow seems about right.

I tried doing it all by spreadsheet and it’s just impossible. It grew to over 15 MB in under four years. Too processor heavy and it takes too much time to update the graphs. I’ve been thinking about playing around with power views but it’s not quite what I’m looking for.

I just like that it’s virtually zero effort and I can get a full financial picture on a moment’s notice.
 
Re: Gear Grinding 9: I Need a Wine!

bostonewe said:
I knew I liked you for a reason.
I have a spreadsheet as well for our expenses and travel stuff. It's been great. The summer that I worked for the business school at BU opened my eyes
Click to expand...

I've got my farm spreadsheet up to probably about 12 sheets. Input transactions, code each one with a 3 digit number to classify each one, then have pivot tables to spit out expenses and income for all areas. I have sheets that are automatically coded to create a tax summary cor each year, for my tax guy, ones that tell me my seed expenses, fertilizer expenses, chemical expenses, labor, land rent, land principal, land mortgage interest, etc. Then I also have a sheet that automatically creates a projection for the next season, based on past performance and inputs, to use to securing financing. Lastly have several calculator sheets so I can calculate my break even points for yield, price, land rent, etc. Its turned out pretty well so far.
 
Re: Gear Grinding 9: I Need a Wine!

bigblue_dl said:
I track everything manually, both for personal and the farm. Spreadsheets for all of it, no separate software to do anything.
Click to expand...

leswp1 said:
I don't think I even know all the things spread sheets can do. I can make simple ones but I have no idea how to make them anything other than check lists
Click to expand...

bigblue_dl said:
I've got my farm spreadsheet up to probably about 12 sheets. Input transactions, code each one with a 3 digit number to classify each one, then have pivot tables to spit out expenses and income for all areas. I have sheets that are automatically coded to create a tax summary cor each year, for my tax guy, ones that tell me my seed expenses, fertilizer expenses, chemical expenses, labor, land rent, land principal, land mortgage interest, etc. Then I also have a sheet that automatically creates a projection for the next season, based on past performance and inputs, to use to securing financing. Lastly have several calculator sheets so I can calculate my break even points for yield, price, land rent, etc. Its turned out pretty well so far.
Click to expand...

I wish this was something that was taught in HS or college. I learned more about financial management in the 3 months at this job than I had in any other time in my life. I have a Workbook for each year with a sheet for each month. The expenses are classified into a header at the top that populates as I enter data. The 13th page has charts and aggregate spending for the year. I love it.
 
Re: Gear Grinding 9: I Need a Wine!

bostonewe said:
I wish this was something that was taught in HS or college. I learned more about financial management in the 3 months at this job than I had in any other time in my life. I have a Workbook for each year with a sheet for each month. The expenses are classified into a header at the top that populates as I enter data. The 13th page has charts and aggregate spending for the year. I love it.
Click to expand...

I do most of the same type of thing using Quicken. I can't say I wish they taught this in HS- it wasn't invented then :eek: I do find it fascinating but I am a learn as I do person and watching videos, etc go right over my head.

dd_bl YIKES!!
 
Re: Gear Grinding 9: I Need a Wine!

MinnesotaNorthStar said:
I prefer to control when the money exits my account. Still pay everything online though. Only have rent, cable/internet, electricity, and car payment (Also, I never make only the minimum payment on my car).
Click to expand...

This. I pay most stuff online, but at my discretion. This is different than autopay. I pay my rent by check because the only other option is autopay.
 
Re: Gear Grinding 9: I Need a Wine!

Brenthoven said:
This. I pay most stuff online, but at my discretion. This is different than autopay. I pay my rent by check because the only other option is autopay.
Click to expand...

Billpay is always an option. If the person/company that you are paying doesn't accept electronic payments, the bank sends a secure cashier check instead.
 
Re: Gear Grinding 9: I Need a Wine!

Yeah I use pivot tables quite a bit and found great ways to combine with graphs depending upon who's going to be looking at my results.
 
Re: Gear Grinding 9: I Need a Wine!

Two people today nearly ran me off the road. Just because you’re signaling doesn’t mean I see it and it doesn’t mean I have to let you in. Especially when I’m side by side with you. I laid on the horn for the second one and the guy gave me the finger. :rolleyes:

Then, I got asked to play a second game of soccer tonight in net. I had everything laid out for dinner and ready to go. :-/

The other team was in need so of course I said yes. I’m currently paying for that with a reminder I’m no longer in my 20s. Oof.
 
Re: Gear Grinding 9: I Need a Wine!

Where did all of my spoons go?

I don’t have any of my eight small spoons anymore. I have no idea where they went.
 
Status
Not open for further replies.
Back
Top