Reporting Balance Fields

Reporting balances are one of two types of balance record used in Accounting. See Types of Balance Record for more information.

Here is a description of the custom fields on the Reporting Balance object.

Field   Description
Account   Lookup to the related accountClosed In this context, accounts are organizations or people that you conduct business with, such as customers or vendors. Account is a standard Salesforce object. Certinia accounts can be any Account Record Type..
Accounting Book   Lookup to the accounting book associated with this reporting balance. This field is only available if you have enabled the Multi-Book Accounting feature using Feature Console.
Balance Update Timestamp   Last modified date on the related budget and balance record.
Bank Account   Lookup to the related bank account.
Budget and Balance   Lookup to the related budget and balance instance.
Cash Flow Exception Hash Code   For internal use only.
Company   Company that owns this record.
Dimension 1-4   Lookups to the related analysis dimensionsClosed Custom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you..
Dual Value   Value in dual currencyClosed The currency in which your corporate headquarters reports financial statements. This defaults to, and is normally the same as, the corporate currency..
General Ledger Account   Lookup to the related general ledger accountClosed The general ledger will normally include general ledger accounts (GLAs) for items such as income, expenses, assets, liabilities, and reserves..
Home Value   Value in home currencyClosed The main working currency of the current company..
Intersect Definition R Lookup to the intersect definition used to create this reporting balance.
Local GLA   Lookup to the local GLA you want to use to store balances, if your org is set up to allow financial reporting to different statutory bodies. Only active local GLAs are available. See What is a Chart of Accounts Structure? for more information.
Number of Related Transaction Line Items   For internal use only.
Period   Lookup to the related accounting period. You must enter a valid period.
Period Number   Formula with the numeric value for the accounting period.
Product   Lookup to the related product.
Reporting Balance Hash Code R For internal use only. Concatenation of Period, Year, Company, GLA, Dimensions, Entity, Intersect Definition and Type fields. Must be unique. If you do something that would result in two or more reporting balance records with the same hash code, the operation will fail.
Sub-Analysis   Concatenation of the four entityClosed Collective term for the following predefined dimensions within your chart of accounts: account, product, bank account, and tax code. dimensions.
Tax Code   Lookup to the related tax code.
Type   Type of balance record: Actual, Budget or Cash Flow Exception. Balance records of type Actual are read-only.
Year Number   Formula with the numeric value for the financial year.

Cash Flow Analysis

These are populated using the default values set on the GLAs. They are used to adjust and group data on a statement of cash flows report.

See Setting up a Statement of Cash Flows for examples of how to use these fields.

All fields in this section are Text fields.

Field  
Reclassify Profits True or false. True indicates that you want to adjust the section in which transactions using this GLA will appear.
Cash Flow Category Heading under which a transaction using this GLA will appear on the cash flow report. Example cash flow categories are Investing Activities and Financing Activities.
Cash Flow Line Summary Text used to group transactions using this GLA on the statement of cash flows report. This is useful when the value that you want to group by doesn't already exist in your chart of accounts.

Reporting Balances of type "Cash Flow Exception" have an additional related list that lists all related transaction line items.