Printing the Subsidiary Trial Balance

Screen ID: 

Screen Title: 

Panel Number:

Report Name:

images\kb_closed_shg.gif

LTBFASC-01

Subsidiary Trial Balance

5671

LSTBFA2


Click here to magnify

Access this screen by selecting Tool #687: Print Subsidiary Trial Balance Detail.

Helpful Resources

Visit Show Me the Steps for easy instructions on how to use CU*BASE to print financial reports and complete other tasks related to statements/reports.

Screen Overview

This screen is used to print a detail report showing the current state of all subsidiary records by item type.  This detail report will be in order first by corporate ID, then by branch number, then by department number and then item number. This is used to set up and print a report showing subsidiary item detail. This detail report reflects the current state of either fixed asset, prepaid expense, or accrued expense data in the subsidiary database. It is not necessary to generate a work file to run this report.

In addition, this report can be customized to provide only the records desired, based on parameters you specify in the area below.

Select your Month/year to process and report type at the top of the screen.  Here you can also select to export this report to a file.

After making your selections to the top section of the screen, use Enter to refresh the screen to show only the appropriate fields for this type of subsidiary record.  You can then elect to filter your results by using this bottom section of the screen.  (See field descriptions below.)

Press Enter again to generate the report. 

How Do I Save/Retrieve My Report Settings?

For more details on setting up this feature, refer to the Automating Reports and Queries booklet, available on the CU*BASE Reference page. 

This report can be used with the “Report Scheduler,” a time-saving automation feature that allows you to select and save the filters you use to run several commonly used reports and then set these reports to be run automatically by our operations staff on the first of the month.  Or you can save the settings and run them manually by yourself at any time.

o save your report settings, first select your filters, including printer (can be a physical printer or the HOLDxx or MONTHxx OUTQs).  Then select Save Settings (F24).  On the next screen name your settings (we recommend adding your name!), and designate whether you wish to run this manually or if you wish for operations to run the report.  At a later time, use Retrieve Settings (F23) to populate the screen with the settings you have saved.  You can also edit your settings using Retrieve Settings (F23).  All saved settings can be viewed on the Report Automation: Standard Reports screen.

Field Descriptions (Top of Screen)

Field Name

Description

Month/Year to process

Enter the month and year for which data should be shown.  Normally three previous months are available.  To run a report using month-end data prior to the months held online, contact a Client Services Representative.  (There is a charge if this service is requested.)

Specify range of Corporate IDs to print

This field can be used to print records for one or a range of corporate ID numbers. Enter both a starting and ending number. To print records for only one corporation, enter the same number in both fields. If both fields are blank, all corporations will be included in the report.

Export to file

Check this box to reveal a screen allowing you to export this report for use with Report Builder.

Field Descriptions (Bottom of Screen)

Field Name

Description

Select

Place a checkmark in this column on any field for which you would like to specify selection parameters. Otherwise, leave the field blank.

  • This field is required if you use the Low or High fields to enter a selection range.

Low

For any of the fields where the Select box is checked, use this column to specify the low end of the range to be included in the report.

  • For example, if you wish to include only branch numbers 1 and 2 on the report, enter “1” in this column on the Branch line.

High

For any of the fields where the Select box is checked, use this column to specify the high end of the range to be included in the report.

  • For example, if you wish to include only branch numbers 1 and 2 on the report, enter “2” in this column on the Branch line.

Sort

For any of the fields where the Select bpx is checked, use this column to enter a sequence for sorting the records on this report.

  • For example, to sort records by branch number then category, enter “1” in this column on the Branch line and “2” on the Category line.

Sub Total

For any of the fields where the Select box is checked, place a check mark in this column on any field for which you wish to see a subtotaled group on the report.

  • For example, to see subtotals after each branch, check this field on the Branch line.

  • Note that the final result of the report will vary depending on the sort order and how many groups you have selected for subtotals. It may be necessary to experiment in order to achieve the desired results.

Report Sample

Following is a sample portion of the Fixed Asset Trial Balance. This report was printed for subsidiary type “FA,” and did not include any special selection/sort parameters.

 

 

Link to ID: https://help.cubase.org/cubase/cubase.htm#LTBFASC-01.htm