Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
BlackLine Reconciliation Templates provide a best practice approach to ensuring the accuracy, quality, and completeness of your account reconciliations.
Typology: Study notes
1 / 17
This page cannot be seen from the preview
Don't miss anything!
BlackLine Reconciliation Templates provide a best practice approach to ensuring the accuracy, quality, and completeness of your account reconciliations. Our standard Reconciliation Templates, as detailed in this guide, are available out of the box to support the most common reconciliation types and can be further adapted to meet your organization’s evolving goals and requirements.
The Accruable Items template is used to manage reconciliation items expensed and accrued in the current accounting period and paid in a future accounting period. Examples include accrued property tax, general expenses, or services. You can establish categories of accrued items in one account, and related activity for each category will display on the account reconciliation.
The accruable item activity history is stored together with each accruable item. The expected balance is automatically calculated for each item based on the sum of activity from prior and current periods. If desired, future periods can be loaded in advance and will be automatically included in the calculated balance in the appropriate future periods.
Populated with the Accounts template format and is the level at which your organization wishes to sign off on reconciliations. This is the most essential import to populate BlackLine, and the one customers most often automate.
The Show By Sub-Type Summary link provides a roll forward view of accrual data. In this example, the accrual data is organized by bonus type, by period, and by accrual activity type, in this case Expense and Payment. The activity type field can be configured for any type of accrual classification needed, and the user enters the desired number of periods to include in their view.
Users can toggle between the summary view and a detailed view of individual line items within each accrual that roll up to the totals. These items can be loaded into BlackLine by the end user either individually or in bulk, or can be imported through the Open Items import template by the System Administrator. If desired, this process can also be fully automated.
The Amortizable template is used to monitor expenditures or revenues in one accounting period that are recognized over several future periods. This reconciliation template allows you to record payments or revenues for amortizable or deferred items and establish a monthly schedule of the expenses or revenues to record over the life of the prepaid or deferred item. BlackLine automatically creates a straight line schedule for the amortization or deferral amounts over future periods. Non-straight line schedules are also easily created in this template.
The Amortizable template can be used for:
The Associated Accounts template enables the comparison of sets of imported account balances and supports non- exclusive grouping as well as existing reconciliation functions.
This template can be used for the:
Bank Account reconciliation templates are used for cash accounts, checking accounts, or any cash type account that involves reconciling items such as deposits, payments, bank fees, and other items that may be financial in nature and have timing differences from month to month. The template’s Bank Items control enables preparers to enter and categorize these items.
The Bank Account template can be used for:
Line items within a Bank Account reconciliation are summarized by Bank Items, categories created by the System Administrator and/or end users.
Users can drill down to view details for each line item within the Bank Items summary (e.g., individual Deposits in Transit).
The Bank Balance is populated via automated or semi- automated import, and can also be keyed in by users. If imported automatically or semi-automatically, organizations can take advantage of the bank auto-certification rule.
The basis for the calculation appears on the face page and can be rolled forward to new reconciliations.
Additional reconciling items can be manually input by Preparers or automatically imported and are accessible on the face of the reconciliation.
Calculations can be attached as Supporting Documents to enable quick and easy access to additional detail.
This commonly used BlackLine reconciliation template is designed to be flexible to support any type of account. With the General List template, users can enter items that make up the ending balance in a Balance Sheet account. It can also be used to accumulate information for an Income or Expense account.
Examples of accounts that can use the General List template include:
This reconciliation template is used when you have a separate subledger process that should be matched to your general ledger balance. The subledger may be part of an integrated accounting software system, or it may be a standalone system that is manually recorded each month. The template prompts you for the balance in your subledger and the balance in your general ledger, then it allows you to list any reconciling items.
The Subledger Match reconciliation template is commonly used for:
Line items can be populated automatically via the Items template format, semi-automatically through the Excel-based import template by the System Administrator, semi-automatically through Excel (in bulk) by the Preparer, or manually by the Preparer. Items may also be imported from queries or Matching, if desired. If imported automatically or with the Excel-based templates through the System Administrator role, auto-certification rules can be applied.
The Subledger Balance can also be imported automatically, semi- automatically, or manually. Auto- certification rules can be applied when this field is automatically or semi-automatically imported.
The Suspense Items provides a summary of open items by Item Total and Age Type. The total of Suspense items is compared to the GL balance.
The lower section of the reconciliation provides a means to document the detail of those items labeled with an Age Type designated high risk. They appear on the reconciliation and are summarized by the Business Justification Type. The subtotal of those items is compared to the high risk total.
The ERP Drill Down feature enables users to access account transaction details directly on the face of the reconciliation, so there is no need to navigate between BlackLine and the organization’s ERP and/or other third party systems. BlackLine does not circumvent the security of your ERP system, so users without access to the ERP, or a particular account, will not be able to see anything even when this feature is activated.
This control enables users to add a hyperlink to a document stored in another system as supporting documentation for a reconciliation in BlackLine. The document itself is not stored in the BlackLine document repository, but a link to the document is stored so that the document can be easily accessed within the BlackLine system.
The Integrated Spreadsheet control can be added to any BlackLine Reconciliation Template. This feature enables the creation of highly customized reconciliations to accommodate the most challenging scenarios and eliminates the need for supporting spreadsheet documents. Approvers and reviewers are presented with a fully functional spreadsheet on the face of the reconciliation and have quick and easy access to view all calculations.
The Related Account Balances functionality allows users to view the GL balance and link to other accounts which have been linked to their reconciliation. Users can view a grid of all open items which belong to the related accounts, and these related accounts, once added, will carry forward to future periods automatically.
