[Blogging Intensifies]

Technology, Projects, Linux, Coding, Internet of Things, Music, Books, Life...

  • About
  • Photo Gallery
  • Privacy Policy

money

New Year, New Budget

December 17, 2019

As part of my need to keep my personal spending reasonable, I like to keep a spread sheet budget. Each paycheck I get a set aside amount of money dumped into a separate bank account that I use for personal spending on hobbies and things like eating out and gas for my car. Part of the reason for this is that my wife gets annoyed trying to keep track of a bunch of small purchases, like ebooks and fast food stops. Part of it is to keep my spending somewhat reasonable.

I have a spread sheet I’ve used for a few years now to track what I spend and what categories I spend it in. I’ve used the same sheet for a few years now. It also serves as a way to forecast out my budget, which is really handy as more and more I’ve started just preordering things rather than trying to catch them in stores.

For example, I’ve already got pre orders going out through June of 2020. I keep a page of just these pre orders with approximate dates, where it’s been ordered, and a generic value, usually estimated up. Like all those Black Series figures. I reordered a bunch of them using a coupon over the holidays, so they are all 20% less, but for now it’s easiest just to keep them in the list as is.

These also go in the main sheet with approximate dates, mostly based on expected paycheck. Above is a generic form of the first week, though chances are the Endgame Wave will get pushed back, and at least one of those Hasbro Pulse orders is coming out of a different bank account for other reasons. The point is more to help illustrate how the spreadsheet works.

I’ve pre filled out the deposits, each with a bunch of blank lines in between to add in purchases. I also add in a generic $20 for gas out of each paycheck, though that doesn’t always get spent and occasionally it’s more. It’s a good starter ball park. I also fill in any pre orders on the appropriate dates. Some of the dates are approximate. I know however that, Amiami order usually come at the very end of the month. For the most part, if something happens and I need to cover something, I can pull from the seperate main household budget, but I generally prefer not to. The sheet also does not include a buffer amount that is always in the account. The above sheet suggests a $2.73 balance, but it’s actually higher than that, since the buffer is intended to remain as a buffer.

I also add in reoccuring costs. Website domains and hosting costs, subscriptions for some websites and games, that sort of thing. The idea is that I can be covered for any larger months. For example, in 2019, around the end of August, I had a huge ball of pre orders coming all at once. So I cut back on spending leading up to that time, so I could cover everything.

Lastly, the sheet is also useful for getting an idea on what I spend my money on. For example, in 2019, I spent roughly 54% of my budget on toys. Eating out, Gas, Video Games, and Books were all around 10%. Everything else was smaller. This tracks as a sort of running total, so I can watch it rise and fall over the year if I want.

I do this all in Excel. It’s easy to edit and adjust, and I can easily sync it between my desktop, laptop, and phone with One Drive.

Anyway, If you’d like to take a closer look at the spreadsheet, I’ve worked up a clean version of it which can be found here.

Share this:

  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Reddit (Opens in new window)
Posted in: Software Tagged: Budget, Excel, money, Spreadsheet
Mastodon LinkedIn email
Instagram Instagram GitHub
JoshMiller.net
Lameazoid.com

Categories

  • collapsCat options: Array ( [title] => Categories [showPostCount] => 1 [inExclude] => exclude [inExcludeCats] => [showPosts] => 0 [showPages] => 0 [linkToCat] => 1 [olderThan] => 0 [excludeAll] => 0 [catSortOrder] => ASC [catSort] => catName [postSortOrder] => ASC [postSort] => postTitle [expand] => 0 [defaultExpand] => [debug] => 1 [postTitleLength] => 0 [catfeed] => none [taxonomy] => category [post_type] => post [postDateAppend] => after [postDateFormat] => m/d [showPostDate] => 1 [useCookies] => 1 [postsBeforeCats] => 1 [expandCatPost] => 1 [showEmptyCat] => 1 [showTopLevel] => 1 [useAjax] => 0 [customExpand] => [customCollapse] => [style] => kubrick [accordion] => 1 [title_link] => [addMisc] => 1 [addMiscTitle] => [number] => 3 [includeCatArray] => Array ( ) [expandSym] => ► [collapseSym] => ▼ ) postsToExclude: Array ( ) CATEGORY QUERY RESULTS Array ( [0] => WP_Term Object ( [term_id] => 486 [name] => Advent of Code 2020 [slug] => advent-of-code-2020 [term_group] => 0 [term_taxonomy_id] => 486 [taxonomy] => category [description] => [parent] => 172 [count] => 12 [filter] => raw ) [1] => WP_Term Object ( [term_id] => 156 [name] => Android [slug] => android [term_group] => 0 [term_taxonomy_id] => 156 [taxonomy] => category [description] => [parent] => 155 [count] => 3 [filter] => raw ) [2] => WP_Term Object ( [term_id] => 135 [name] => Arduino [slug] => arduino [term_group] => 0 [term_taxonomy_id] => 135 [taxonomy] => category [description] => [parent] => 153 [count] => 8 [filter] => raw ) [3] => WP_Term Object ( [term_id] => 438 [name] => Books [slug] => books [term_group] => 0 [term_taxonomy_id] => 438 [taxonomy] => category [description] => [parent] => 436 [count] => 4 [filter] => raw ) [4] => WP_Term Object ( [term_id] => 368 [name] => CHIP [slug] => chip [term_group] => 0 [term_taxonomy_id] => 368 [taxonomy] => category [description] => [parent] => 153 [count] => 5 [filter] => raw ) [5] => WP_Term Object ( [term_id] => 172 [name] => Coding [slug] => programming [term_group] => 0 [term_taxonomy_id] => 172 [taxonomy] => category [description] => [parent] => 153 [count] => 13 [filter] => raw ) [6] => WP_Term Object ( [term_id] => 541 [name] => Concerts [slug] => concertphotos [term_group] => 0 [term_taxonomy_id] => 541 [taxonomy] => category [description] => [parent] => 527 [count] => 7 [filter] => raw ) [7] => WP_Term Object ( [term_id] => 247 [name] => Copyright and You [slug] => copyright-and-you [term_group] => 0 [term_taxonomy_id] => 247 [taxonomy] => category [description] => [parent] => 154 [count] => 3 [filter] => raw ) [8] => WP_Term Object ( [term_id] => 155 [name] => Devices [slug] => devices [term_group] => 0 [term_taxonomy_id] => 155 [taxonomy] => category [description] => [parent] => 166 [count] => 4 [filter] => raw ) [9] => WP_Term Object ( [term_id] => 622 [name] => Elite Dangerous [slug] => elite-dangerous [term_group] => 0 [term_taxonomy_id] => 622 [taxonomy] => category [description] => [parent] => 523 [count] => 2 [filter] => raw ) [10] => WP_Term Object ( [term_id] => 606 [name] => Fairs [slug] => fairs [term_group] => 0 [term_taxonomy_id] => 606 [taxonomy] => category [description] => [parent] => 527 [count] => 8 [filter] => raw ) [11] => WP_Term Object ( [term_id] => 523 [name] => Feeds [slug] => feeds [term_group] => 0 [term_taxonomy_id] => 523 [taxonomy] => category [description] => [parent] => 0 [count] => 0 [filter] => raw ) [12] => WP_Term Object ( [term_id] => 549 [name] => Goodreads [slug] => goodreads [term_group] => 0 [term_taxonomy_id] => 549 [taxonomy] => category [description] => [parent] => 523 [count] => 0 [filter] => raw ) [13] => WP_Term Object ( [term_id] => 366 [name] => Hardware [slug] => hardware [term_group] => 0 [term_taxonomy_id] => 366 [taxonomy] => category [description] => [parent] => 153 [count] => 1 [filter] => raw ) [14] => WP_Term Object ( [term_id] => 373 [name] => Hardware [slug] => hardware-what-i-use [term_group] => 0 [term_taxonomy_id] => 373 [taxonomy] => category [description] => [parent] => 159 [count] => 0 [filter] => raw ) [15] => WP_Term Object ( [term_id] => 243 [name] => Home Security [slug] => home-security [term_group] => 0 [term_taxonomy_id] => 243 [taxonomy] => category [description] => [parent] => 153 [count] => 2 [filter] => raw ) [16] => WP_Term Object ( [term_id] => 446 [name] => Language [slug] => language [term_group] => 0 [term_taxonomy_id] => 446 [taxonomy] => category [description] => [parent] => 436 [count] => 1 [filter] => raw ) [17] => WP_Term Object ( [term_id] => 524 [name] => Letterboxed [slug] => letterboxed [term_group] => 0 [term_taxonomy_id] => 524 [taxonomy] => category [description] => [parent] => 523 [count] => 135 [filter] => raw ) [18] => WP_Term Object ( [term_id] => 436 [name] => Lifestyle [slug] => lifestyle [term_group] => 0 [term_taxonomy_id] => 436 [taxonomy] => category [description] => [parent] => 0 [count] => 2 [filter] => raw ) [19] => WP_Term Object ( [term_id] => 224 [name] => Linux & Open Source [slug] => linux [term_group] => 0 [term_taxonomy_id] => 224 [taxonomy] => category [description] => [parent] => 279 [count] => 2 [filter] => raw ) [20] => WP_Term Object ( [term_id] => 153 [name] => Maker [slug] => maker [term_group] => 0 [term_taxonomy_id] => 153 [taxonomy] => category [description] => [parent] => 0 [count] => 1 [filter] => raw ) [21] => WP_Term Object ( [term_id] => 530 [name] => Micro Blog [slug] => microblog [term_group] => 0 [term_taxonomy_id] => 530 [taxonomy] => category [description] => [parent] => 0 [count] => 30 [filter] => raw ) [22] => WP_Term Object ( [term_id] => 437 [name] => Music [slug] => music [term_group] => 0 [term_taxonomy_id] => 437 [taxonomy] => category [description] => [parent] => 436 [count] => 14 [filter] => raw ) [23] => WP_Term Object ( [term_id] => 395 [name] => My DIY Projects [slug] => my-diy-projects [term_group] => 0 [term_taxonomy_id] => 395 [taxonomy] => category [description] => [parent] => 153 [count] => 6 [filter] => raw ) [24] => WP_Term Object ( [term_id] => 154 [name] => Opinion/Editorial [slug] => articles [term_group] => 0 [term_taxonomy_id] => 154 [taxonomy] => category [description] => [parent] => 0 [count] => 3 [filter] => raw ) [25] => WP_Term Object ( [term_id] => 491 [name] => Organizing [slug] => organizing [term_group] => 0 [term_taxonomy_id] => 491 [taxonomy] => category [description] => [parent] => 436 [count] => 5 [filter] => raw ) [26] => WP_Term Object ( [term_id] => 279 [name] => OS [slug] => os [term_group] => 0 [term_taxonomy_id] => 279 [taxonomy] => category [description] => [parent] => 166 [count] => 0 [filter] => raw ) [27] => WP_Term Object ( [term_id] => 534 [name] => Other Photos [slug] => otherphotos [term_group] => 0 [term_taxonomy_id] => 534 [taxonomy] => category [description] => [parent] => 527 [count] => 11 [filter] => raw ) [28] => WP_Term Object ( [term_id] => 617 [name] => Outdoor and Nature [slug] => outdoor [term_group] => 0 [term_taxonomy_id] => 617 [taxonomy] => category [description] => [parent] => 527 [count] => 4 [filter] => raw ) [29] => WP_Term Object ( [term_id] => 242 [name] => PCs [slug] => pcs [term_group] => 0 [term_taxonomy_id] => 242 [taxonomy] => category [description] => [parent] => 155 [count] => 6 [filter] => raw ) [30] => WP_Term Object ( [term_id] => 384 [name] => Photography [slug] => photography [term_group] => 0 [term_taxonomy_id] => 384 [taxonomy] => category [description] => [parent] => 159 [count] => 2 [filter] => raw ) [31] => WP_Term Object ( [term_id] => 527 [name] => Photos [slug] => photos [term_group] => 0 [term_taxonomy_id] => 527 [taxonomy] => category [description] => [parent] => 0 [count] => 42 [filter] => raw ) [32] => WP_Term Object ( [term_id] => 146 [name] => Privacy [slug] => privacy [term_group] => 0 [term_taxonomy_id] => 146 [taxonomy] => category [description] => [parent] => 154 [count] => 3 [filter] => raw ) [33] => WP_Term Object ( [term_id] => 142 [name] => Raspberry Pi [slug] => raspberry-pi [term_group] => 0 [term_taxonomy_id] => 142 [taxonomy] => category [description] => [parent] => 153 [count] => 9 [filter] => raw ) [34] => WP_Term Object ( [term_id] => 136 [name] => Social Media [slug] => social-media [term_group] => 0 [term_taxonomy_id] => 136 [taxonomy] => category [description] => [parent] => 154 [count] => 2 [filter] => raw ) [35] => WP_Term Object ( [term_id] => 160 [name] => Software [slug] => software [term_group] => 0 [term_taxonomy_id] => 160 [taxonomy] => category [description] => [parent] => 159 [count] => 6 [filter] => raw ) [36] => WP_Term Object ( [term_id] => 241 [name] => Synology NAS [slug] => synology-nas [term_group] => 0 [term_taxonomy_id] => 241 [taxonomy] => category [description] => [parent] => 155 [count] => 4 [filter] => raw ) [37] => WP_Term Object ( [term_id] => 166 [name] => Technology [slug] => technology [term_group] => 0 [term_taxonomy_id] => 166 [taxonomy] => category [description] => [parent] => 0 [count] => 11 [filter] => raw ) [38] => WP_Term Object ( [term_id] => 424 [name] => The Basement [slug] => the-basement [term_group] => 0 [term_taxonomy_id] => 424 [taxonomy] => category [description] => [parent] => 153 [count] => 6 [filter] => raw ) [39] => WP_Term Object ( [term_id] => 413 [name] => The Cloud [slug] => the-cloud [term_group] => 0 [term_taxonomy_id] => 413 [taxonomy] => category [description] => [parent] => 153 [count] => 3 [filter] => raw ) [40] => WP_Term Object ( [term_id] => 557 [name] => Toy Photos [slug] => toyphotos [term_group] => 0 [term_taxonomy_id] => 557 [taxonomy] => category [description] => [parent] => 527 [count] => 0 [filter] => raw ) [41] => WP_Term Object ( [term_id] => 1 [name] => Uncategorized [slug] => uncategorized [term_group] => 0 [term_taxonomy_id] => 1 [taxonomy] => category [description] => [parent] => 0 [count] => 2 [filter] => raw ) [42] => WP_Term Object ( [term_id] => 159 [name] => What I Use [slug] => what-i-use [term_group] => 0 [term_taxonomy_id] => 159 [taxonomy] => category [description] => [parent] => 436 [count] => 2 [filter] => raw ) [43] => WP_Term Object ( [term_id] => 280 [name] => Windows [slug] => windows [term_group] => 0 [term_taxonomy_id] => 280 [taxonomy] => category [description] => [parent] => 279 [count] => 2 [filter] => raw ) [44] => WP_Term Object ( [term_id] => 207 [name] => Windows Phone [slug] => windows-phone [term_group] => 0 [term_taxonomy_id] => 207 [taxonomy] => category [description] => [parent] => 155 [count] => 3 [filter] => raw ) [45] => WP_Term Object ( [term_id] => 538 [name] => Zoos [slug] => zoophotos [term_group] => 0 [term_taxonomy_id] => 538 [taxonomy] => category [description] => [parent] => 527 [count] => 12 [filter] => raw ) ) POST QUERY: POST QUERY RESULTS
  • ►Feeds (137)
    • Elite Dangerous (2)
    • Goodreads (0)
    • Letterboxed (135)
  • ►Lifestyle (36)
    • Books (4)
    • Language (1)
    • Music (14)
    • Organizing (5)
    • ►What I Use (10)
      • Hardware (0)
      • Photography (2)
      • Software (6)
  • ►Maker (66)
    • Arduino (8)
    • CHIP (5)
    • ►Coding (25)
      • Advent of Code 2020 (12)
    • Hardware (1)
    • Home Security (2)
    • My DIY Projects (6)
    • Raspberry Pi (9)
    • The Basement (6)
    • The Cloud (3)
  • ►Micro Blog (30)
  • ►Opinion/Editorial (11)
    • Copyright and You (3)
    • Privacy (3)
    • Social Media (2)
  • ►Photos (84)
    • Concerts (7)
    • Fairs (8)
    • Other Photos (11)
    • Outdoor and Nature (4)
    • Toy Photos (0)
    • Zoos (12)
  • ►Technology (35)
    • ►Devices (20)
      • Android (3)
      • PCs (6)
      • Synology NAS (4)
      • Windows Phone (3)
    • ►OS (4)
      • Linux & Open Source (2)
      • Windows (2)
  • ►Uncategorized (2)

Hosted on…


Help support hosting with our referral link!

3rd Party Feed Syndication:

  • Doctor Strange in the Multiverse of Madness, 2022 – ★★½
  • Supernova, 2000 – ★★½
  • EDSM Fortnightly Report 2022.06.01 – 2022.06.14
  • Predestination, 2014 – ★★
  • The Weeknd x The Dawn FM Experience, 2022 – ★★★

Micro Blog Posts:

  • 2022.06.25 – Daily Games
  • 2022.06.24 – Daily Games
  • 2022.06.23 – Daily Games
  • 2022.06.22 – Daily Games
  • 2022.06.21 – Daily Games

Copyright © 2022 [Blogging Intensifies].

Me WordPress Theme by themehall.com