This report must be formatted in the Report Format Maintenance module prior to printing. It will produce a Balance Sheet in the format most people are used to seeing. In one column, it will list all asset accounts with the current balance and place each total line to the right of the column. The assets will be followed by a list of all liability and equity accounts with totals. You can format both a detailed Balance Sheet and a consolidated one to print through this report module. When you enter this report module, the screen will appear as follows:
The cursor will be positioned at the Period (1) field and will default to the current open period in the system G/L. You can type an earlier period for the year if applicable. At the Select (2) box, if the default period is selected, these fields will not be available. However, if you type an earlier period in that field, you can then access these fields, though you cannot select Next Year if that period is still open in the current year. If you wish to access archived data, click the Previous Year option and the system will display an FYE drop-down menu so you can select a prior year. The Period Ending Date (3) will default to the current date. You can use the drop-down arrow to select another date. The Report Type (4) field will default to Balance Sheet. Switch to All to see a list of all available Report Formats in the next field. At the Report Format (5) field, use the drop-down arrow to select the applicable report to use. Click the Excel icon to export the data, or click the Print button to print to paper or screen. To exit without printing, click the Cancel button.