Sunday, June 9, 2013

56 days, 5 countries, 4 bikes...

In my previous post I commented on being "below budget" in my goal for cycling mileage in 2013.  A large part of this has been due to significant travel so far in 2013.  Since March, I've been out of the country for 56 days, 10 of which were vacationing with Pati and the rest were for business trips to Brazil and Argentina.

Although this kept me from quality cycling on a quantitative basis, it has not lacked in qualitative experiences as I've been able to experience biking in several other cities.  My first trip out of the country this year was to South America, and after a week in Sao Paulo without biking, I left for a week in Buenos Aires where I was able to do some riding.

The city has a bike share program for locals, but I was not eligible to try Mejor en Bici due to eligibility limitations having to do with the type of visa I had (or rather, didn't have).  So instead I rented a bike and explored the city.  Trusty #128 (see below) turned out to be the worst bike I have ever paid to ride, but even a horrible bike is better than no bike.



I was quite impressed by the cycling facilities.  There are many on-road bike lanes, and many of the parks also have dedicated bike paths separated even from running and walking lanes.  For locals it is especially convenient because the bikeshare stations are ubiquitous in the heart of the city.  Biking the city as a means of transportation seems to be gaining momentum in Buenos Aires.  

I picked up my rented mule in Palermo and initially biked back to my hotel to load up my laundry (I noticed a laundromat a few blocks away from the bike station so thought I'd put the bike to work).  The chain fell off no fewer than three times, and after I dropped off my laundry and washed up, I exchanged the first bike for good ol' #128, which was only superior in that the chain stayed on the entire time.

I did most of my exploring in and around the Palermo area, but did get as far as the Estadio River Plate (to the northwest) and also to my hotel near the Estacion Retiro and Torre Monumental.  I really wished I had a more comfortable bike to traverse the 20-some miles, but it was still worth the 75 pesos I paid for four hours of biking.

After my time in Buenos Aires was up, I returned to Sao Paulo for another week and a half or so and was back in Minneapolis by the end of March.

The next post will cover the Barclay's Cycle Hire scheme in London..

Sunday, June 2, 2013

Get busy bikin', or get busy drivin'

Somehow five months of 2013 are already in the books, and I glanced back at my mileage goals for the year compared to my actuals YTD.  It's extremely disappointing: I haven't even logged 100 miles on the Cross Check and I planned to get to 4,000 for the calendar year.

There have been circumstances contributing to this poor performance (more to come in future posts), but in order to achieve these goals I am going to have to do a lot less commuting by car, and a lot more biking.  The round-trip commute will add 24 miles a day, which will definitely help reach 4,000, but it would take 167 days of bike commuting alone to get there.  With an average of 20 working days per month, this would mean more than eight months of commuting every day to do it so the miles will have to come from other riding, too.

So if anyone out there is looking for a biking buddy, just let me know, remind me about this post, and I'll pretty much be obligated to join you.

And the other goals?  Here's what else I want to achieve by 12/31/2013, (and what I've achieved so far):

25 blog posts (this will be #6)
30 hand written letters to friends / family (written 5 so far)
3 hours per week of Spanish / Portuguese study or practice (on track - more details to come)

Other than the language practice, I have some more work to do.

Saturday, April 20, 2013

Achieving Proper Cut-Off


Every time a new biking season comes around, I tell myself that "this will be the year" that I finally get an accurate count of my annual bike mileage.  In each of the past two years, I purchased a new bike but failed to buy a bike computer at the same time.  As a result, I've ridden hundreds of miles that never get recorded, or they get recorded but I forget to identify how many relate to one year versus the next.  A classic cut-off problem:

(Disclaimer: if you have no interest in accounting nerdspeak, just skip to the bolded part below)

AU Section 326:


The Use of Assertions in Obtaining Audit Evidence

.14 Management is responsible for the fair presentation of financial statements that reflect the nature and operations of the entity.  In representing that the financial statements are fairly presented in conformity with generally accepted accounting principles, management implicitly or explicitly makes assertions regarding the recognition, measurement, presentation, and disclosure of information in the financial statements and related disclosures.

.15 Assertions used by the auditor (see paragraph .16) fall into the following categories:

a. Assertions about classes of transactions and events for the period under audit:
....
iv. Cutoff.Transactions and events have been recorded in the correct accounting period.


But this year IS the year!  I swapped out the Cateye from the Long Haul Trucker and installed it on the Cross Check, my go-to ride these days.  Unfortunately I've already logged a few miles this year, but forgot to first take a peak at the odometer to find out what my opening balance was for 2013.

As such I've had to prepare a "roll-back" schedule to arrive at the ending balance for 2012.  This is similar to what a lot of my clients in public accounting would do if they didn't perform their inventory count right at December 31. Depending on the amount of activity before or after the count and year-end date, this could get messy.

My situation will be fairly straight forward and since I haven't ridden at all this year on the Giant, no roll-back is necessary for those miles.  Here are the key odometer stats, complete with workpapers supporting the balances:

2013 Opening Balances

916 miles = 2013 opening balance, Cross Check

1,111 miles - 2013 opening balance, Giant TCR





The 916 miles comes from backing out the 35 miles already included in the odometer, which actually relate to the 2013 riding year.

As long as I remember to compare these totals to the miles on the odometers as of December 31, I should have no problem calculating and reporting my miles this year.


Sunday, April 14, 2013

Last Busy Season Soundtrack

Yet again, I've managed to put off posting my previous year's busy season play list until now.  Of course, were I still in public accounting, I would be creating the 2013 busy season playlist, but I no longer experience the bittersweet phenomenon that is a busy season in public accounting.

The bitter requires no description.  But for those who have never experienced the 70-80 hour work week protecting the vitality of the capital markets, perhaps it's beneficial to explore how this could be "sweet" in any way.

Despite these unfortunate circumstances, my fellow auditors and I always forged ahead with a common goal and found ways to make the most of it.  My defense mechanism was to find the humor in the situation, relieving the pressures from the unreasonable demands and deadlines encountered in a public accounting busy season.  There was no shortage of laughter in the audit rooms, as clients or co-workers usually provided sufficient fodder for new material.  And if they were short on supply, YouTube could always save the day.  These are memories and relationships that I will always cherish.

For me the other bright side of spending so much time in front of a computer is that it gave me an opportunity to get back into music.  As my workday stretched into the evening hours, I looked forward to streaming the Current after the client had left.  It provided a great backdrop for reviewing workpapers, wrapping up memos or taking care of anything else that the day hadn't afforded time to complete.

For the past few years I've enjoyed accumulating the a list of "greatest hits" so to speak of the songs that I heard most frequently and can quickly bring me back to those times.  It's with a slight touch of melancholy that I present last year's, and my last year's, busy season soundtrack.

This year I tried to group the songs into categories that represented what I usually felt over the course of a busy season.  Here goes:

Simple Song / 1996 - These songs are both high energy for me, and I always tried to launch out of the gate with a strong push.

Parade / Neon Indian / Shiny Things - After the initial burst of energy, it's time to focus and get into a strong rhythm.  Energy is still high but you know you can't keep this initial pace the entire time.

Go Outside - The initial round of deadlines (interoffice reporting, preparation of client schedule requests, etc) passes, so you slow down just long enough to catch your breath.

Up, Up, Up / Temporary - That doesn't last long and you realize the breather you took was longer than it should have been.  Time to catch up.

Don't Move / Strange Attractor / Myth - It's back to getting into a rhythm, but as work piles up, the work days drive you deeper into the night.  This leads to dream like reflection, dragged into this state by a lack of sleep and also by the soothing lights of the skyline overhead as I drive home on the vacant highways.  You're not sure busy season will ever end.

Emmylou / 1904 - You don't know if it will ever end, but you no longer care.  The adrenaline has long worn off and you have no energy.  Your mind and body will not allow you to feel anything but a peaceful mellow that pulses through your veins.

The House that Heaven Built - It's over and now you need to blow off some steam.  You hate your job right now, but you know that this will pass.  Or maybe you're just done with it all and it's time to leave.


Busy Season 2012 by James McConeghey on Grooveshark



Monday, February 18, 2013

2013 YTD Mileage - Reconciling the Subledger

I will admit that it is a little strange to report numbers in the middle of a month, but I am afraid if I don't get them out there I will lose the data forever.  Granted, if I compare these miles against my total anticipated mileage for 2013, they will be mere rounding errors and are hardly material.  But it always bugs me that I have so much off-ledger miles that don't get recorded that I wanted to make sure I kept track of them all in 2013. 

Through February 18, I have ridden 56 miles.  Of those, 27 were in San Diego on a rental bike, and 28 were from two separate rides in Minneapolis.  Once enough of the snow had melted (or been plowed) to clear a safe path, I ventured out for some invigorating winter biking.  

Normally I wouldn't have to resort to updating a sub-ledger as I usually install a bike computer on any new bikes.  However, when I bought the Cross Check to commute with, I never got around to outfitting it with a computer.  Since most of my miles in the fall were on the Cross Check, I have a hard time seeing how anyone could do anything but issue a disclaimer of opinion on the operation of internal controls over bicycle mileage reporting.  I guess remediation will have to happen in 2013...

Thursday, January 31, 2013

Q4 Reporting: Trend Analysis

As you might remember from October, I started reporting quarterly results of my bike commuting.  January has come and gone, so I am long overdue for a year-end update.  Here is how Q4 ended up compared to Q3.


At first glance, it appears that Q4 merely follows the pattern established in Q3 but if you dig further into the detail, however, a pattern emerges and a story begs to be told:



So what happened?  July had no activity as I was still working in public accounting and had not yet started a regular biking routine.  August through November included four months of consistent commuting activity, but December had none.

Did the cold weather suppress my bike commuting activity?  Not quite.  In fact the reason for the drop off was due to a job change.  Instead of biking 4.5 miles to downtown Minneapolis and taking advantage of what I suspect to be the best bike commuting facilities that I will ever experience, I now work in Eagan and have a 12 mile commute.  I have biked to work on two occasions since I started in late November, but I have opted to not bike as the temperatures aren't quite as bearable for a longer commute. 

All together, there were only seven days in my four month tenure at Target where I didn't bike to work. Four of those days were during my first week, and two were days that I interviewed for my new job.  

It all adds up to a commuting by bike percentage of 92%.  


Sunday, January 27, 2013

78 Reasons Why I'm Glad I'm in No Longer in Public Accounting

Since I left the world of public accounting in July of 2012, I have done a lot of reflecting on what I gave up, and what I gained by making the switch.  It was a no-brainer to give up the work-life imbalance, yet not so easy to lose the day to day interactions with a lot of great people, both co-workers and clients.  Not being in client service has meant a predictable work location which makes regular biking to work much easier for me.

Although these are all great reasons, there is one benefit that I recently experienced that trumps them all: the flexibility for Pati and me to celebrate our anniversary in a warm locale.  For seven of our first 10 anniversaries, I was barely able to peel away from work for a few hours for a nice dinner since I was already knee deep in busy season workpapers.  This year we booked a four day mid-January trip to southern California.

So what are the 78 reasons?  Check out the following, do the math, and you'll see: