Month End Balances Report
Month End Balances Report
Month End Balances Report
Report #: 1171
Module: Accounting
Overview
The Month End Balances Report displays account balances through a specified closed month. SBN bases the output of this report on the account level because payments are posted against accounts and an account may relate to multiple contracts and installations.
Note: You may run this report in Export mode by selecting the Run in Export Mode check box in the lower pane. In Export mode, SBN generates the report as a text file in the report directory.
To access this report, select Month End Balances (report #1171) from the main menu of SBN.
The Month End Balances Report
This window contains two panes: use the upper pane to define the contents of the report; use the lower pane to define the job output - how, when, and where you want to print the report.
Note: See Report Parameters Pane for information on the fields in the lower pane, which are the same in every report.
Field Descriptions
The following table describes the fields used in the upper pane of this report.
Field |
Description |
Closed Month |
Select the closed month you want to report. This field defaults to the most recent full month. |
Group by |
You must select a grouping parameter for this report:
|
Dealer |
You may select a dealer ID to restrict the report to accounts associated with that dealer. (This menu originates from program #1537.)
|
Branch Ranges |
|
Branch |
You may select up to three ranges of branches to limit the report to branches within the ranges. Select the beginning branch number of a range. (These menus originate from program #1530.)
|
Branch |
You may select up to three ranges of branches to limit the report to branches within the ranges. Select the ending branch number of a range. (These menus originate from program #1530.)
|
Exclude |
You may exclude ranges of branches from the report by selecting the ranges and then entering a check mark in the corresponding Exclude box. |
Running and Viewing a Report
For information on running and viewing a report, see Common Functions in SBN.
Report Example
The following graphic shows an example of the output of the Month End Balances report.
Column Descriptions
The following table describes the columns used in the output of the report.
Column |
Description |
Dealer |
If you selected a Dealer from the parameters, this field displays the ID of the dealer associated with the displayed accounts. |
Branch |
Displays branch number and name. |
Account |
Account number. |
Name |
Account name. |
Balance |
Total open balance for the selected account. |
Branch Total |
Displays the total of open balances of all accounts in the selected branch. |
Grand Total |
Displays the total of open balances of all accounts. |
Button Functions
The following table displays the buttons, describes the shortcut keys, actions, and functionality.
Button |
Name |
Shortcut Key |
Action |
Description |
|
Open fields for recurring/template reports |
alt+f1 |
Open fields for recurring/template reports. |
|
|
Exit without saving |
esc |
Exit without saving changes to selected record. |
|
|
Save Existing Record |
enter |
Save changes to selected record. |
Modifications and Updates to Month End Balances Report
The following table lists modifications and updates to the Month End Balances Report document.
Mod Number |
Date |
Description |
n/a |
8/05/14 |
Images updated. |