Gl Account Analysis

[Camila Fonua]

Transactionlevel examination is a critical step in effectively reconciling and substantiating account balances. Yet, for accounts with high volumes of transactions, the process can be overwhelmingly complex, time-consuming, and unnecessarily risky.

BlackLine Account Analysis automatically groups and categorizes individual transactions to help Accounting identify potential exceptions and adjustments, monitor the health of accounts, and proactively mitigate risk.

Configurable rules automatically categorize transactions and other account balance characteristics for cleaner management and identification of aged and at-risk transactions, providing ongoing insight into account health.

Continually examine transactions throughout the month by taking timely action on aged or unusual transactions and avoid the period-end rush to track down missing or unexplained transactions. Account Analysis is directly integrated with BlackLine Account Reconciliations, allowing for improved substantiation processes.

Through this account analysis, XYZ Corp. identified and corrected a misclassification error, resulting in more accurate financial statements. The process also helped the company improve its internal controls and reduce the risk of similar errors in the future.

Pre-built reports by division are run after each month close by Financial Affairs. To access these pre-built reports instead of running the report yourself, you can access the Account Analysis folder within the UW Shotgun directory by clicking this link: \\warehouse\shotgun$\Financial_Management_Reports\ (If clicking the link does not work, copy the link into your computer's search.)

Additionally, users can run this report themselves as well for any period or date range for any segment of a chart string. The steps outlined below are instructions on how to pull the data from the General Ledger via the Account Analysis Report and pull the Budget by Account report. Using these two files, the macro excel workbook attached to the knowledge base is used to combine the files into pivot tables and format the report.

Although you can filter by additional fields it is recommended to just filter your Organization or range of Organizations at this step. This will pull in all transactions affecting your organization. Please note that the other chart of accounts segments will also pull in when you run this report using this filter.

There are two pivot tables included within the Account Analysis Report, one located on the AASummary tab, and one on the BudgetSummary tab (if budget information is included when running the report). From either tab, simply double click on any numerical value to open a new tab with the full details.

By default all available data for transactions is displayed when expanding transactional details by double clicking on a numerical value within a pivot table. However, you may not find all columns helpful for your needs. For example, you may only want to show the combined charge string of the transaction, not each segment displayed in its own column. You may adjust the columns displayed by using the Data Select tab.

The Account Analysis report includes the most complete and up to date transactional data available within WyoCloud. However there maybe circumstances where you are aware of transactions, such as IDT journal entries, that have not yet been posted in the system. You may use the Add Data feature to review your accounts with these transactions taken into account.

Similar to the AASummary tab, you can click on any number in columns: Accounted DR, Accounted CR Budget or Variance and the full details of what makes up that number will open into a new tab. The % Remaining column shows as a percentage how much of the budget has been used. See the appendix for column definitions.

The National Accounts Main Aggregates Database presents a series of analytical national accounts tables from 1970 onwards for more than 200 countries and areas of the world. It is the product of a global cooperation effort between the Economic Statistics Branch of the United Nations Statistics Division, international statistical agencies and the national statistical services of these countries and is developed in accordance with the recommendation of the Statistical Commission at its first session in 1947 that the Statistics Division should publish regularly the most recent available data on national accounts for as many countries and areas as possible. The database is updated in December of each year with newly available national accounts data for all countries and areas.

Annual collections of the official national accounts data reported to the United Nations Statistics Division by the countries in form of the United Nations National Accounts Questionnaires serve as the basis for the database. A basic description of the methodology related to the compilation of official national accounts data is provided in National Accounts Statistics: Main Aggregates and Detailed Tables. For full details on the 1968, 1993 or 2008 SNA, please visit the SNA website.

If a full set of official data is not reported for a specific country, estimation procedures are employed to obtain estimates for the entire time series. For estimation purposes, other data sources are analysed to gather supplementary data on the national accounts of a country. The data gathered are then either used directly or estimation procedures are applied to obtain a complete and consistent set of time series of main national accounts aggregates and their related growth rates and indices. As official data are not always available for use in the database, the sources and methods used for estimations should be taken into consideration. Metadata for each country describing the methods and sources used for all data included in the database are available via the Meta-Data link.

Once the national accounts data in national currency are complete, the current and constant price series are converted into US Dollars by applying the corresponding market exchange rates as reported by the IMF. When these conversion rates are not available other IMF rates are used (official rates or principal rates).

For countries whose exchange rates are not reported by the IMF, the annual average of United Nations operational rates of exchange (UNOPs) is applied. The UNOPs are conversion rates that are applied in official transactions of the United Nations with these countries. These exchange rates are based on official, commercial and/or tourist rates of exchange.

In cases where a country experiences considerable distortion in the conversion rates, the United Nations Statistics Division uses price-adjusted rates of exchange (PARE) as an alternative to the exchange rates reported by the IMF or UN operational rates of exchange. The conversion based on PARE corrects the distorting effects of uneven price changes that are not well reflected in the other conversion rates. Consequently, unrealistic levels in GDP and other national accounts aggregates expressed in US Dollars may have been adjusted for certain time periods to improve the economic analysis at national, regional and local levels.

It should be noted that the international comparability of data expressed in US Dollars between countries may not be entirely justified because the exchange rates applied may, in practice, only be used for the conversion of a limited number of external transactions and may not be relevant for the much larger portion of GDP covering domestic transactions.

Contributes to the international coordinated development and updating of the System of National Accounts (SNA).

Undertakes methodological research on issues on the research agenda of the SNA in collaboration with the Intersecretariat Working Group on National Accounts (ISWGNA)

Supports the implementation programme of the SNA by developing and updating supporting normative standards, training material and compilation guidance for the implementation of national accounts and supporting economic statistics and maintaining a knowledge base on economic statistics.

Delivers a statistical capacity building programme for the implementation of the 2008 SNA and supporting statistics through a series of regional and interregional workshops and seminars in collaboration with the regional commissions and regional agencies and through a limited number of individual country technical assistance missions.

Collects and disseminates annual national accounts statistics from countries and provides substantive service to the Committee on Contributions of the Fifth Committee of the United Nations on technical aspects of the elements of scale methodology for assessing the contributions to the United Nations by Member States.

Publishes the outputs of the Section in various publications of UNSD.

An advanced commercial billing tool can help your financial institution increase profits and support its growth strategy. This solution enables you to capture every billing point without limit, present customers with meaningful, graphical statements that enhance your brand and automate input from any third-party system.

Built on decades of input from the world's leading financial institutions, Weiland Account Analysis facilitates the detailed evaluation and billing of commercial demand deposit accounts. Its billing engine carefully tracks and presents balances on deposit and earnings allowances, as well as all volume, price and service details to manage cash income. It also allows fine-tuning of every aspect of your relationship analysis to ensure optimal fee income growth.

Weiland Account Analysis supports complex billing strategies and an unlimited number of accounts, classes, codes and services. The system allows you to compensate accounts with earnings credits, hard interest or a mixture of both.

With the ease of web-based account modeling, exception management, custom reporting and statement archiving, you gain anywhere, anytime analysis functionality. You'll also improve efficiency and reduce manual data entry using advanced automation features, including a data import tool that translates files into your account and service codes.

3a8082e126