May 2020 Archive

Character-Perfect Fixed Width Import Files

Posted on May 25, 2020
Read time: 4 minutes
Tagged with automation, php, tech

One of my springtime projects at work was to button up a recently-refreshed process to transmit some billing data between systems. By 'recently-refreshed,' I mean 'finally made a process whereby a human doesn't have to manually generate a file which had been the de-facto process for the better part of twelve years. Due to the cascading effects of some staff turnover in the unit in question, IT was brought into the loop to help find a better way to work this process.

Posted on May 18, 2020
Read time: 5 minutes
Tagged with finance, inspiration, personal

Over the years I've developed a habit where a short part (~30 minutes on average) of most weekends are dedicated to entering the week's receipts, reconciling (or balancing) accounts, updating investment fund values, and so forth. Once familiar with GnuCash, this process is pretty straightforward and easy to do.

Posted on May 11, 2020
Read time: 3 minutes
Tagged with inspiration, tech

As a reflection exercise for a project I wrapped up a bit ago, combined as an exercise to make Future Me's life a Better Place, I pulled together a simple Google Sheets workbook to make a quick 'calculator' and balancing mechanism to help keep track of a couple datasets. And in so doing, I again befriended a couple of super simple, and super powerful functions:

Parks and Rec "They call me the Swiss Army accountant" gif

Posted on May 04, 2020
Read time: 6 minutes
Tagged with finance, inspiration, personal

As I wrote about a couple months back, GnuCash is my accounting software of choice since ~2010. I wasn't exactly "sold" on it from the start, but it was a free and open-source solution that seemed robust enough to handle pretty much anything I could throw at it, from managing business finances and whatnot to a whole mess of personal accounts.