Creating a Simple FRX Trial Balance report:

 

 

This tip works on any version of FRx.   The goal is to create a simple trial balance report which has a single line for each account which summaries all sub accounts for this single account number.   Here is an example of what your report will look like:  

 

 

To create this report, open up FRX.  Then click on the icon for row definitions, and then click on the new tab and you will get to this screen,

 

 

Next click on the menu choice, Edit, then select from the list:  add rows from chart of accounts.  This will get you to

 

 

The next step is to list the complete beginning to end of the natural account column.  I typically just enter 0000 to 9999, where the number of digits is determined by the setup at your company for the length of the natural account.  These values are entered on the two areas:  Account Range Start, and Account range end.  After pressing the OK button, you will populate the row format with a separate line for each account number.  

 

 

 

 

Optionally you can modify the row format to include a few new rows for descriptors and / or totals for Assets and Liability/ Equity.

If you need help with this task, give us a call.

 

Save this row by clicking on the menu choice:  File, then save as:

 

 

 

Complete the row as shown above.

 

 

Next we are going to create a new Column layout. Close out of the row area by clicking File, Close all. Click on the icon for Column layout, then the button for new   column layout.

 

This takes you to this screen:

 

Complete this screen as shown below:

 

 

 

Save this new report by clicking File, then Save as and complete as shown below:

 

 

Close out of this area by clicking File, close all, which takes you back to this screen:

 

 

 

The last step is to link your row and columns together as a catalog id.  This is done by clicking the catalog of reports id, which takes you to this screen:

 

 

The next step is to create a new blank catalog, which is accomplished by clicking the new button in the upper right hand quadrant.  This screen is now created:

 

 

Next fill in these 4 areas:  catalog id, catalog description, row format, and column format.

 

 

Next click on black arrow head in the section called Report Date (upper right quadrant), and you get this screen. 

 

There are three changes I recommend :  1) set the base period/ base year to the desired values for your report, 2) in the center section, click the rebuild FRX GL indexes, and change the default base period report to Cur (for current period)

 

 

Leave this screen by clicking on the Ok button, then click on the save button in the top right corner area.

 

 

To create the report, click on the generate report button in the top right corner.   You should get an FRX report going to your screen, which looks like this:

 

 

The report can be “cleaned - up” as you desire, with special fonts, font sizes etc.  As I said earlier, this report is a great tool to understand what the next affect for any account across multiple sub accounts.   I think most CPA’s and accountants like this summary form because it creates the detail at the company level, not the sub account level.

 

 

Hope you can use this simple technique to create this report at your company….   Give us a call if you need help….