Financial Reporter

Help! I am trying to update our financial reports to reflect the addition of some new GL's. The original reports seem to have been made long hand (not using a smart sheet) and has no ranges. However when I add GL account it creates errors all over the place. So I thought I would start from scratch, using the smart sheet, and build what I want. I get stuck at the very first step. When I drag the accounts from the Account Group Tree I can only drag over All or One at a time. If I do one at a time and try to bring the next one in it over laps the first one and ofcourse, creates errors. What am I doing wrong. I have read the book but can't find anything to explain.

I figured out where I went wrong. Sorry for the bother.

Hi Sammy,

If you are creating a Financial Statement by dragging information from the View Account Groups window, the way to do this is select the highest-level group. This selects all sub-groups and ranges within. For example, a sample account group called 'Income Statement' has sub-groups for Revenue and Expenses, and multiple account ranges within each of these sub-groups. If you drag the 'Income Statement' part to an empty spreadsheet, this will bring over Revenue, Expenses and all the ranges contained within each at the same time.

Indeed if you drag-and-drop an account group on top of an existing spreadsheet, the previous information will be overwritten, which may cause errors. Thus this process should be done 'all at once' rather than a part at a time. Of course, if you had already done this for one account group, you could copy/paste rows in the spreadsheet and make new ranges, but this would take a little longer to do.

Thanks for the response. I figured out that I had to create Account Groups that had the groupings I needed. Now I have a new problem. We have a report that compares current year to previous year. I have no problem with the Balance Sheet but the Income and expense reports will not show the previous year. I am sure there is a simple answer, but I have been working at this for 2 days without results. Any ideas?

Hi Sammy,

Do you have a column using the specification code "LY" (Last Year) or "LYY" (Last Year YTD)? If so, then the numbers should be there.