Thanks so much for the reply! I had a feeling this was the only way to do this..
I am currently in the trial period for quickbooks, and I am comparing and contrasting features of Quickbooks and Xero to make a decision as to what platform will be best for my organization. There is a lot about QBO that I prefer, however the inability to customize a report to that level is a major drawback for my needs, and the spreadsheet route adds additional processes in my flow. This is a function that I found very easy to accomplish in Xero within a few seconds.
Is there a way for me to formally submit a feature suggestion to QBO developers for future consideration?