Balance Sheet: Default Summarizing

By default, the Balance sheet report calculates and summarizes
 
  • Assets up to specific dates indicated in the header area
  • Liabilities and shareholders’ equity up to specific dates indicated in the header area
 
In Cedejig ERP, the balance sheet report adheres to the accounting equation:
 
Assets = Liabilities + Equity
 
Both summarized values of Assets and Liabilities + Equity as of a particular date are displayed in one column. Summarized Assets being displayed first followed by liabilities and equity.
 
However, since there are two dates as of which the report summarizes your company’s financial position, the report displays data in 2 columns, each column containing data as of one of the dates.  
 
Begin Amount
 
Displays a balance of the previous reporting periods as of a date set in the field Date from.
 
End Amount
 
Displays your company’s financial position as of a date set in the field Date to. Usually, it is a balance of the current reporting period.
 
The amounts are worked out by summing the original values (using the SUM function). The summarized amounts are presented in your system currency.
Note: Summary values are displayed at each level of the report hierarchy and at the grand total level. If no summary value is available for a certain level, nothing is displayed for it.
The default summarizing settings are defined in the values section of the Balance sheet report. To define the summarizing methods, the summable fields have been added and summarizing options have been specified for them.  Except for specific reports that do not provide for full customization (see Customize Reports), you can change the summable fields and the summarizing methods for your reports. In case of Inventory report, you are allowed to do that.
 
To customize the default summarizing parameters
 
1. On the page for configuring report parameters, click the Customize button.
 
2. Use the values section to view and customize the default summable fields and summarizing methods defined for them.
 
You can delete, rearrange, add new summable fields and specify summarizing methods for them.
 
For information how to customize summarizing settings, see Summarize Report Data.
 
For summarizing options, see Summarizing Methods.
 
To add a summable field:
 
  • In the values section, click the Select an option box, and then select a summable field from the list of options.
 
The list displays summable fields from the selected report type which you can use to summarize report data in columns. For Balance sheet report, there are two fields you can use - Begin amount and End Amount. They are used in the report by default.