Custom Set Report is a set of different values that are calculated from various data sets. Additional calculations based on data extracted from the system are possible. Setup details see more Excel-based report template.
For example, a Company Balance sheet. A balance sheet gives a statement of a business’s assets, liabilities, and shareholder’s equity at a specific point in time.
A balance sheet is made up of the following elements:
- ASSETS
- Current Assets. Current assets can easily be converted to cash within a year or less. Current assets are further broken down on the balance sheet into these accounts:
- Cash and cash equivalents: These are your most liquid assets, including currency, checks, and money stored in business’s checking and savings accounts
- Marketable securities: Investments that business can sell within a year
- Accounts receivable: Money that clients for services that will be paid in the short term
- Inventory: For businesses that sell goods, inventory includes finished products and raw materials
- Prepaid expenses: Things of value that already paid for, like office rent or business insurance
- Long-Term Assets: Long-term assets won’t be converted to cash within a year. They can be further broken down into:
- Fixed assets: Includes property, buildings, machinery, and equipment like computers
- Long-term securities: Investments that can’t be sold within one year
- Intangible assets: Assets that aren’t physical objects, such as copyrights, franchise agreements, and patents
- Current Assets. Current assets can easily be converted to cash within a year or less. Current assets are further broken down on the balance sheet into these accounts:
- LIABILITIES
- Current liabilities include rent, utilities, taxes, current payments toward long-term debts, interest payments, and payroll.
- Long-term liabilities include long-term loans, deferred income taxes, and pension fund liabilities.
- SHAREHOLDERS EQUITY
- Shareholders’ equity refers to the amount of money generated by a business, the amount of money put into the business by its owners (or shareholders), and any donated capital. Shareholders’ equity is the business net assets. On company balance sheet it’s calculated using this formula: Stakeholders Equity = Total Assets – Total Liabilities
Assets and liabilities in the balance sheet change after each operation. But on the reporting date, the balance, as if being photographed, that is, fixed at one point in time.
Data sources
Each element of the balance is calculated based on the summation of the entries of an individual Register for a certain period. Each such summation is performed by a separate data source ( see Fig.1 ).
Examples:
- Get total Cash balance by the quarter: Money | Period ( ThisQuarter ) |Sum ( Amount)
- Get total Inventory balance: Inventory |Sum ( Amount)
See more about Get Data
Set up Excel File Template
The report layout is created in the Excel file. The marker of each value must be placed in the corresponding cell of the sheet. See more Setup Excel File Template and Fig. 2.
Also on the sheet, you can specify the necessary formulas for calculations. For example, “=SUM (C2:C4) ” and ” =SUM (C8:C11) “