Setting up Financial Report Sequence Ranges (ATL, BTL, etc)

The sequence range is used to put in ATL, BTL/Post and Other Totals into groupings on your Financial Reports. It is also very useful for consolidating many different non-sequential accounts into the one report, which you can read on how to do that here: Financial Reports - Merging Sequence Ranges

Remember that Eclipse runs in alphanumeric order, so it first starts at (blank), 0, 1, 2, 3, etc until all numbers are exhausted, then it starts from A, B, C, D, etc until it reaches Z. This is why you will see a grouping of ZZZ's in your ending fields.

Because of this, if your nominal/TB accounts start with a letter the TB can be printed “upside down”. To fix your report and print your assets first, add another sequence and use the first sequence to print your assets, Liabilities, Investor funds and then the 2nd sequence to print your Expenses.

The below guide will show you how to setup a basic sequence range for your financial reports with the following groupings:

Above the Line
Below the Line - Production
Below the Line - Post
Below the Line - Other Costs

1. Go to General Ledger > Financial Reports. Select your Report in Report Defaults, then select report type in Report Layout.

2. Click on the Sequence Range tab

3. Right-click in blank space and select Insert.

Enter in a 3 digit number to identify the sequence and position in the report. The numbers in Seq should be ascending.
Click tab. Next Eclipse will automatically generate an ID.
Click tab. Enter in ABOVE THE LINE in the the header.
Click tab. Enter in TOTAL ABOVE THE LINE in the footer.
Click tab multiple times to move to the Prod, Detl and Set (above lines). Enter in the From range for the sequence (account start). Make sure the Detl and Set lines are blank for the starting range, unless you want to start the report at a specific Detl and Set codes.
Click tab multiple times to move to the Prod, Detl and Set (below lines). Enter in the To range for the sequence (account end). Make sure the Detl and Set lines are ZZZZ’s for the ending range unless you want the report to stop at a specific Detl or Set account.
Press Enter. Completed example below.

4. Continue entering all the sequence lines, like below.

5. Return to the Report Details tab. Click Save. Run the report (you may also choose to save this report under a new name so that you may save the sequence details for another occasion)

6. To save the report under a new name, Enter in a description in the Report Defaults field. Click save.

7. To Delete the report, Select the report in Report Defaults field. Click the scissors.