Jul.

2

2007

How to Indent in FRx Without Spending Your Life at the Spacebar

by Jan Harrigan CPA

It’s easy to spend way too much time indenting FRx descriptions. Here’s a better way.

You want to indent your detail account names, and you sit at the keyboard and enter an exact number of spaces before each name. Or, one of my old consulting tricks is to concatenate the account name with a number of spaces in Excel, then paste in (the Excel indent feature won’t paste in). I still use this a lot. But in simple cases there’s an easier way, and here it is.  

Essentially, you put a ‘LFT’ in the format code in the row, and 2 extra spaces in the description in the column and you’re done. How much easier could it get?

Here’s the row, and note the LFT in the format code:
Indenting in the FRx row using a format code

Here’s the column, and note the 2 in the ‘Extra Spaces Before Column’ section:
Indenting in the FRx column using extra spaces before column

And the results:
Final results of indenting in FRx

Gotta love it.

Limitation: The LFT code must go on a description row. You can’t have a link to a GL account number or a total. So in the example above, COGS and Gross Margin are not very good uses of the LFT code since you’ll want to wind up with numbers there!

Share with Friends, or Print:
  • Print
  • email
  • Facebook
  • LinkedIn
  • Twitter

Leave a Comment

Previous post:

Next post: