• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

accounting automation

Modernizing Financial Close: Automation, Accuracy, and Agility

May 2, 2025 by Revelwood

The financial close process is a mission-critical function for finance and accounting teams. Yet, for many organizations, it remains a bottleneck filled with manual tasks, reconciliation errors and time-consuming workflows. To stay competitive in today’s fast-paced business environment, finance leaders must embrace automation, connected thinking, and strategic transformation in their record-to-report (R2R) processes.

The Power of Accuracy in Financial Close

Financial data accuracy is the foundation of confident decision-making. Without it, businesses risk making strategic errors based on flawed insights. Two key areas that finance teams must address to enhance accuracy include:

  1. 1. Journal Entry Management
    • Errors in journal entries are a leading cause of inaccuracies in financial reporting.
    • Manual processes create bottlenecks, making audits more challenging.
    • Solution: Centralizing and automating journal entry creation, validation, and posting ensures compliance and efficiency.
  2. 2. Automated Reconciliations
    • According to PwC, 30% of accounting teams’ time is spent on manual reconciliations.
    • Traditional reconciliation methods—spreadsheet-heavy and labor-intensive—are prone to errors.
    • Solution: Automating reconciliation workflows helps unify data, match transactions, and flag exceptions in real time, significantly reducing errors and improving efficiency.

Beyond Quick Wins: Long-Term Transformation

While automation offers immediate benefits, organizations must think beyond short-term improvements. A successful finance transformation requires:

  • A holistic approach to financial processes: Instead of treating journal entries and reconciliations as isolated tasks, organizations should integrate them within an end-to-end accounting framework.
  • Incremental improvements to upstream data quality: Poor data entering the system creates problems down the line. Cleaning data at the source prevents recurring issues.

Scaling Financial Close Success Across the Enterprise

Many organizations begin their finance transformation journey with the financial close process. However, the most forward-thinking finance leaders recognize the need to extend automation and efficiency to other areas, including:

  • Invoice-to-Cash: Streamlining billing and collections to accelerate cash flow.
  • Intercompany Transactions: Reducing complexity in global financial operations.
  • Monthly Accruals: Connecting journal entries, reconciliations, variance analysis, and controls certification.

By expanding automation across these areas, organizations can create a finance function that is more agile, accurate, and strategically aligned with business goals.

Avoiding Common Pitfalls in Finance Automation

When selecting a financial close solution, organizations must avoid these common mistakes:

  1. 1. Moving inefficient processes to the cloud without rethinking workflows. Simply transferring spreadsheets into a cloud-based system doesn’t solve inefficiencies—it just shifts them.
  2. 2. Thinking too small. Choosing a solution based on short-term needs rather than long-term goals leads to fragmented processes.
  3. 3. Underestimating integration needs. A financial close solution must integrate seamlessly with an organization’s ERP and data sources to deliver full value.
  4. 4. Relying on partners who overpromise. Finance teams should work with solution providers that offer true automation and scalability.

The Future of Financial Close: A Unified Approach

The financial close process is evolving, and organizations that adopt a connected, automated and strategic approach will gain a competitive edge. By leveraging intelligent solutions that integrate seamlessly into broader financial operations, finance leaders can drive efficiency, reduce risk and transform the role of finance from a back-office function to a strategic powerhouse.

Learn more about unifying your financial close. Download the eBook Five Steps to Building a Growth-Ready Financial Data Foundation.

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accounting automation, accounting transformation, BlackLine, financial close

Are You 7 Metrics Away from Future-Ready Financial Operations?

April 25, 2025 by Revelwood

CFOs are investing in automating accounting

Finance leaders know that a stable, scalable and efficient financial close process is critical to long-term success. Yet, many organizations continue to struggle with slow, manual workflows that delay financial reporting, create unnecessary risk, and hinder strategic decision-making.

But what if you could measure and benchmark your financial operations to assess your “future-readiness?”

The latest industry benchmark guide from BlackLine explores seven key metrics that define a modern, resilient financial close process. Here are the critical areas that could be standing in the way of your finance transformation.

1. Hours Spent Cleaning and Downloading Data

Industry Benchmark: 2-8 Hours Setup

Data preparation is often one of the biggest hidden inefficiencies in financial operations. Manually downloading, importing and structuring data for reconciliation and reporting eats up valuable time and introduces unnecessary risk.

Future-Ready Solution: Organizations leveraging automation solutions can integrate data directly, reducing setup time to as little as two hours. This ensures real-time visibility and reduces the burden on accounting teams.

2. Percentage of Transactions Automatically Reconciled

Industry Benchmark: 99% Auto-Reconciled

Manually matching transactions is not just time-consuming—it’s also a morale killer for finance teams. A low percentage of automation in reconciliation means that skilled professionals are stuck on repetitive tasks instead of focusing on exceptions and anomalies.

Future-Ready Solution: With automated transaction matching, companies can achieve reconciliation accuracy rates of 99%, freeing up teams to focus on strategic financial analysis.

3. Percentage of Manual Journal Entries Per Month

Industry Benchmark: 10% or Fewer

Scalability will be a challenge if your organization is still processing a high volume of manual journal entries. Manual processing increases errors, compliance risks, and inefficiencies.

Future-Ready Solution: Automating journal entry creation and validation allows leading organizations to reduce manual journal entries to 10% or less. 

4. Percentage of Low-Value Journal Entries

Industry Benchmark: Less than 5%

Low-value journal entries (such as transactions below a certain threshold) can consume significant resources without providing much benefit. Understanding their impact allows organizations to optimize processing efforts.

Future-Ready Solution: Using AI-powered analysis, finance leaders can set materiality thresholds and identify unnecessary journal entries, allowing teams to focus on higher-value activities.

5. Percentage of Automated Recurring Journal Entries

Industry Benchmark: 35% Automation

Recurring journal entries—such as accruals and amortization—are predictable and should not require extensive manual intervention. Yet, many organizations still rely on outdated processes that require accountants to manually re-enter the same data every month.

Future-Ready Solution: Automating recurring journal entries eliminates redundant work and increases accuracy, leading to greater efficiency in month-end close.

6. Hours Spent Responding to Audit Requests

Industry Benchmark: Less than 2 Hours

Audit season shouldn’t bring financial close operations to a halt. But for many teams, responding to audit requests is an inefficient, time-consuming process that involves tracking down documents across multiple systems.

Future-Ready Solution: Centralizing audit documentation in an automated financial operations platform allows for self-service auditing, cutting response times to under two hours.

7. Number of Solutions Needed to Execute Financial Close

The more fragmented your financial close process, the harder it is to maintain consistency and accuracy. Relying on multiple disconnected tools increases operational risk and reduces efficiency.

Industry benchmark: Leading organizations aim for a unified financial close platform rather than relying on multiple disconnected systems.

Future-Ready Solution: A unified platform consolidates financial close processes, reducing complexity and improving transparency.

Is Your Finance Team Future-Ready?

By benchmarking your financial operations against these seven key metrics, you can identify opportunities for improvement and take steps toward a more agile and resilient finance function.

Want to see how your organization stacks up? Download the full eBook to learn how BlackLine customers have achieved best-in-class financial close automation and efficiency.

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accounting automation, accounts receivable, BlackLine, financial close

The Role of Record to Report in CFO Strategy

April 18, 2025 by Revelwood

Accounting and Accounts Receivable articles

CFOs are under increasing pressure to enhance efficiency, accuracy and compliance in financial reporting. One critical area of focus is the Record to Report (R2R) process, a fundamental aspect of financial management that ensures the integrity of financial statements.

The IDC MarketScape: Worldwide Office of the CFO Record to Report 2024 Vendor Assessment (issued December 2024) highlights the importance of R2R and evaluates key vendors offering solutions to streamline financial operations. IDC names BlackLine a leader, based on offering innovative, cloud-based automation solutions designed to optimize the financial close process.

Why Record to Report Matters

The R2R process encompasses multiple financial activities, from data collection and reconciliation to final reporting and compliance. It is critical for:

  • Ensuring financial accuracy and reducing reporting errors
  • Improving compliance with global regulations, such as Sarbanes-Oxley (SOX) and Anti-Money Laundering (AML) laws
  • Enhancing decision-making with real-time financial insights
  • Reducing cycle time in financial close, allowing for faster and more efficient reporting

According to IDC’s 2023 Office of the CFO Survey, CFOs have identified revenue recognition, transfer pricing, and financial reporting analytics as top areas for improvement in the R2R cycle. This underscores the need for technology-driven solutions that automate and optimize financial processes.

BlackLine: A Leader in R2R Solutions

IDC has positioned BlackLine in the “Leaders” category of its 2024 MarketScape, recognizing the company for its strong capabilities in financial close automation. Key strengths include:

  • Comprehensive Intercompany Capabilities – BlackLine provides robust tools to manage the full lifecycle of intercompany transactions, a critical need for multinational corporations.
  • Advanced AI-Powered Financial Insights – The platform leverages AI-driven tools such as the Journal Risk Analyzer, which detects anomalies in journal entries across multiple ERP systems. BlackLine is also testing generative AI for variance analysis, helping accountants streamline explanations for financial discrepancies.
  • Customizable Dashboards & Analytics – BlackLine’s real-time financial reporting and analytics allow finance teams to drill down into transactions, add notes, and gain deeper insights into financial performance.

The Future of R2R: Automation & Compliance at the Core

As organizations continue to digitally transform financial operations, automation and compliance will be key drivers in the R2R process. CFOs are seeking solutions that:
✔ Reduce manual effort and accelerate financial close
✔ Provide real-time financial insights for strategic decision-making
✔ Ensure compliance with evolving global regulations (ESG, AML, tax compliance)

BlackLine’s cloud-based automation software offers a powerful option for businesses looking to enhance accuracy, efficiency and compliance in financial reporting.

Want to learn more? Read the full IDC MarketScape 2024 Report today.

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accounting, accounting automation, accounting transformation, BlackLine, CFO

Invoice-to-Cash: Navigating the Crossroads of Efficiency and Growth

April 11, 2025 by Revelwood

In today’s fast-paced business landscape, finance leaders are under increasing pressure to optimize working capital, reduce risk, and streamline operations. The invoice-to-cash (I2C) process, a critical component of financial health, often stands at the intersection of efficiency and strategic growth. A new report, Invoice-to-Cash: Navigating the Crossroads, highlights the evolving challenges and opportunities within this crucial function.

The I2C Bottleneck: A Barrier to Growth

Many organizations still struggle with inefficient, manual, and fragmented I2C processes. These inefficiencies lead to:

  • Delayed Cash Flow: Slow collections impact liquidity and the ability to invest in growth.
  • Higher Costs: Manual processes and high days sales outstanding (DSO) drive up operational costs.
  • Customer Friction: Poorly managed invoicing and collections can strain client relationships.
  • Increased Risk: Disjointed processes elevate the risk of errors, fraud, and compliance issues.

The Shift Towards Automation and Intelligence

The report emphasizes how forward-thinking finance teams are leveraging automation, AI, and analytics to modernize their I2C functions. Key trends include:

  • AI-Powered Predictive Analytics: Machine learning models help forecast customer payment behaviors, reducing late payments and bad debt.
  • Automated Invoice Processing: End-to-end digital invoicing accelerates billing cycles and improves accuracy.
  • Intelligent Collections: Automated workflows ensure proactive follow-ups, optimizing collection efforts while preserving customer relationships.
  • Data-Driven Credit Management: AI-driven credit risk analysis allows for smarter, more agile decision-making.

Strategic I2C: From Cost Center to Value Driver

With the right technology and strategy, I2C can evolve from a cost-heavy back-office function into a competitive advantage. The report outlines best practices for transformation, including:

  • Integrating AI and Automation: Reducing reliance on manual intervention ensures efficiency and scalability.
  • Enhancing Customer Experience: A seamless, digital-first approach to invoicing and payments improves satisfaction and loyalty.
  • Aligning I2C with Business Goals: Shifting I2C from a reactive to a proactive function enhances 

Organizations that embrace intelligent I2C transformation can unlock faster cash conversion cycles, reduce operational burdens, and position themselves for sustained growth. The crossroads is clear—businesses must either modernize or risk being left behind.

Download the full Invoice-to-Cash: Navigating the Crossroads report to explore the latest trends, insights, and strategies for optimizing your I2C processes.

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accountant transformation, accounting automation, accounts receivable, BlackLine

BlackLine Makes it Easy to Reassign Reconciliations from One User to Another

February 28, 2025 by Revelwood

Managing reconciliations in an organization can be challenging, especially when staff changes occur. Whether someone has left the company or is taking an extended leave, BlackLine provides efficient methods to reassign reconciliations from one user to another.

Watch our BlackLine Practice Lead, Adam Riskin, demonstrate how easy it is to reassign reconciliations in BlackLine.

Method 1: Using the Bulk Assignment Account Screen

The Bulk Assignment Account screen is perfect for reassigning a large number of reconciliations efficiently. In our example, Kim Wilson is leaving the company, and her reconciliations need to be reassigned to Pat Black. Here’s how to do it:

  1. 1. Set the Role:
    • Ensure the role is set correctly for the reassignment. For instance, if Kim was a preparer, keep the role set to “Preparer.” If Kim was an approver or reviewer, adjust the role accordingly.
  2. 2. Select Users:
    • In the “From” field, select Kim Wilson (the current user).
    • In the “To” field, select Pat Black (the new user).
  3. 3. Adjust the Groups Field:
    • Set the “Groups” field to “GL and Grouped Accounts.” This ensures that both individually reconciled and grouped reconciliations are reassigned.
  4. 4. View and Select Reconciliations:
    • Click “Refresh” to display all reconciliations assigned to Kim. Ensure you adjust the results per page to display all items (e.g., 500 items per page) so nothing is missed.
  5. 5. Select and Assign:
    • Use the “Select All” option to mark all reconciliations for reassignment.
    • Click “Assign Accounts” to finalize the reassignment.

That’s it! All reconciliations previously assigned to Kim Wilson as a preparer are now reassigned to Pat Black.

Method 2: Managing Assignments via the Account Screen

For smaller-scale changes or more control over selected reconciliations, the Account screen is an excellent alternative.

  1. 1. Filter Accounts:
    • Use the filter options to ensure that both “GL” and “Grouped Accounts” are selected, showing all applicable reconciliations.
  2. 2. Select Reconciliations:
    • Manually checkmark the reconciliations you wish to update. For example, select a specific set of eight reconciliations to reassign.
  3. 3. Use the Actions Menu:
    • Click the “Actions” button and select “Manage Assignments.”
    • Choose the new preparer, approver, or reviewer from the dropdown menu (e.g., Pat Black).
  4. 4. Save Changes:
    • After selecting the new user, click “Save.” The system will update the selected reconciliations with the new assignments.

Key Considerations

  • Role-Specific Adjustments: Always ensure that roles (Preparer, Approver, Reviewer) are set correctly when reassigning reconciliations.
  • Groups Field: By default, this field may be set to “GL Accounts Only,” which limits changes to individually reconciled accounts. Adjusting it to “GL and Grouped Accounts” ensures comprehensive reassignment.
  • Page View: Expand the results per page to ensure you can review and select all reconciliations at once.

By following these methods, BlackLine makes it easy to manage and reassign reconciliations efficiently, ensuring smooth transitions during staffing changes. Whether handling a bulk reassignment or a smaller, targeted update, these steps help maintain the accuracy and integrity of your financial processes.

Read more about Accounting & Accounts Receivable:

7 Reasons Why Accounts Receivable (AR) Optimization is Crucial for CFOs

Top BlackLine Videos of 2024

Importing Multiple Accrual Schedules into a Reconciliation With BlackLine

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accounting automation, accounting transformation, BlackLine, financial close

How to Add and Remove Accounts from Group Reconciliations in BlackLine

February 21, 2025 by Revelwood

When managing group reconciliations, the ability to add and remove accounts seamlessly is critical for maintaining accuracy and organization. BlackLine makes it easy to manage your group reconciliations.

In our latest video, our BlackLine Practice Leader Adam Riskin, demonstrates step-by-step how to add and remove accounts from group reconciliations. Whether you’re onboarding new accounts or deactivating outdated ones, here’s a detailed guide to streamline your process.

The Account Group Screen

The process begins at the account group screen, which displays a list of all existing group reconciliations. Follow these steps:

  1. 1. Locate the Target Reconciliation:
    • Identify the specific group reconciliation you wish to modify.
    • Click on the relevant reconciliation to access the configuration screen.
  2. 2. Scroll to the Account Section:
    • Navigate to the bottom of the configuration screen to view the list of accounts currently assigned to the group reconciliation.

Adding Accounts to a Group Reconciliation

To include new accounts in your group reconciliation, do the following:

  1. 1. Click the “Add Accounts” Button:
    • A list of available accounts will appear. Select the ones you wish to add by marking the checkboxes.
  2. 2. Set the Add Date:
    • Pay close attention to the Add Date. This date determines the fiscal period when the selected accounts will join the reconciliation.
    • For instance, if you set the Add Date to August 2, 2024, the new accounts will be included in the group reconciliation starting from August 2024. They will not appear in any reconciliations prior to this date.
  3. 3. Finalize the Addition:
    • Once you’ve selected the accounts and set the appropriate Add Date, click the “Add Accounts” button.
    • Verify that the accounts are listed under the group reconciliation with the correct start date.

Removing Accounts from a Group Reconciliation

To remove accounts, follow these steps:

  1. 1. Click the “Remove Accounts” Button:
    • Select the accounts you wish to remove by checking the relevant boxes.
  2. 2. Set the Remove Date:
    • The Remove Date is just as crucial as the Add Date. It determines the fiscal period from which the accounts will no longer be part of the reconciliation.
    • For example, if you set the Remove Date to August 2024, the accounts will remain part of the reconciliation up until July 2024. They will be excluded starting from the August 2024 reconciliation.
  3. 3. Finalize the Removal:
    • After selecting the accounts and setting the appropriate Remove Date, click the “Remove Accounts” button.
    • Ensure the accounts are marked as removed with the specified date reflected.

After making your changes—whether adding or removing accounts—always click the Done button. This step saves your updates and ensures the system reflects the changes accurately.

Best Practices for Managing Group Reconciliations

  1. 1. Double-Check Dates: Always verify the Add and Remove dates to avoid discrepancies in fiscal reporting.
  2. 2. Audit Changes: Regularly review the account list to ensure all modifications align with your reconciliation goals.
  3. 3. Save Your Work: Never forget to click “Done” after making changes to avoid losing progress.

By following these steps and keeping these tips in mind, you’ll ensure that your group reconciliations remain up-to-date and accurate.

Read more about Accounting & Accounts Receivable:

7 Reasons Why Accounts Receivable (AR) Optimization is Crucial for CFOs

Top BlackLine Videos of 2024

Importing Multiple Accrual Schedules into a Reconciliation With BlackLine

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accounting automation, accounts receivable, BlackLine, financial close

Importing Multiple Accrual Schedules into a Reconciliation With BlackLine

November 21, 2024 by Revelwood

CFOs are investing in automating accounting

We recently launched a new video series on different ways to import reconciliation supporting items with BlackLine. In today’s video, our BlackLine Practice Leader, Adam Riskin, demonstrates how to import multiple accrual schedules into a reconciliation.

Step 1. Importing Multiple Amortization Schedules from an Excel File

  • In this demonstration, the Excel file contains two prepaid items: health insurance premium and dental insurance premium, set to amortize over 12 months.
  • Columns C and D represent the start and end dates of the amortization, while columns E and F hold the invoice amounts and open dates.
  • Make sure that the field names in the Excel file match exactly with those in the BlackLine.

Step 2. Ensuring Field Name Consistency

  • BlackLine automatically maps Excel fields to its own fields if the names are consistent.
  • This step simplifies the import process by ensuring the system recognizes the starting amortization date and invoice amounts correctly.
  • The process becomes easier and more efficient with consistent field naming conventions.

Step 3. Importing the Amortization Schedules

  • Click on the “Multiple” hyperlink to import the two schedules.
  • You need to set up the calculation method, typically straight line, before importing the file.
  • Browse and select the Excel file containing the scheduled items.
  • Select all records in the Excel file for import and click Import to add the schedules to the reconciliation.

Step 4. Viewing Imported Schedules

  • The imported schedules appear in the amortizable Schedule section of the reconciliation.
  • You’ll see the amortization amount for each month.
  • The “Roll Forward” button provides a traditional view of the amortizable balance at the end of each fiscal period.

Step 5. Handling Non-Standard Schedules

  • BlackLine can calculate standard schedules automatically, but non-standard schedules may require manual input.
  • Non-standard schedules, such as those with varying amounts each month, may not use auto calculation methods like catch-up.
  • The system administrator can use a specific technique to import these non-standard schedules using the Import v7 Data Import tab.

In our next video, Adam will demonstrate how a system administrator can import non-standard schedules.Have you missed some videos in this series? You can find them all on our YouTube channel.

Read more about Accounting & Accounts Receivable:

Importing a Single Accrual Schedule into a Reconciliation With BlackLine

How a System Administrator can Import Multiple Amortization Schedules in BlackLine

Import Multiple Amortization Schedules into a Reconciliation with BlackLine

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accounting, accounting automation, accounting transformation, BlackLine, reconciliation

Importing a Single Accrual Schedule into a Reconciliation With BlackLine

November 14, 2024 by Revelwood

Accounting and Accounts Receivable articles

A preparer can easily import a single accrual schedule from an Excel file into BlackLine for an accrued bonus reconciliation. Watch this video to see Adam Riskin, our BlackLine Practice Leader demonstrate how to do this.

Step 1. Setting Up the Excel File for Import

  • The Excel file including columns for fiscal month, description, and the accrued amount.
  • The fields in the Excel file do not need to be in a specific order, but it is best practice to align them with the BlackLine field headers.
  • The Excel file should have fields that match the date, description, and transactional amount fields in the reconciliation system.
  • It is important to name the field headers consistently in the Excel file for accurate import.

Step 2. Starting the Import Process

  • Click the link to start the import process.
  • You’ll see the description field in the import form is filled out as “2024 bonus accrual” and click Browse and select the Excel file.
  • The import form allows users to see the records from the Excel file, including fiscal month, description, and dollar amount.
  • It is important to select the correct tab in the Excel file that contains the uploading data.

Step 3. Mapping Excel Fields to Reconciliation Fields

  • Mapping ensures that the Date field in the Excel file will populate the Date field in the BlackLine supporting item schedule.
  • BlackLine needs to know which Excel records to import.
  • The final step is to click the Import button to upload the schedule into the system.

Step 4. Viewing the Imported Schedule

  • The imported schedule is visible by clicking on the scheduled icon in the system.
  • This feature allows users to see the accrual schedule in detail, ensuring accuracy and transparency.
  • The process concludes with a successful import and detailed viewing of the accrual schedule.

BlackLine makes it easy for a preparer to import a single accrual schedule. This video is one in a series on different ways to import reconciliation supporting items with BlackLine.

Read more about Accounting & Accounts Receivable:

How a System Administrator can Import Multiple Amortization Schedules in BlackLine

Import Multiple Amortization Schedules into a Reconciliation with BlackLine

Importing a Single Amortization Schedule into a Reconciliation With BlackLine

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: accounting, accounting automation, BlackLine, blackline reconciliation, financial close

How a System Administrator can Import Multiple Amortization Schedules in BlackLine

November 7, 2024 by Revelwood

In an earlier blog post, we showcased a video demonstration on how a preparer can import multiple amortization schedules. In this video, our BlackLine Practice Leader Adam Riskin shows you how a system administrator can import non-straight line amortization schedules.

Here is the process:

Overview of the Import File

  • You’ll see Adam work with two amortization schedules: one for health insurance premiums and one for dental insurance premiums, both amortizing over 12 months.
  • The first 20 or so fields are considered the header record for the amortization schedule, containing details like the supporting item header record and entity information.
  • Each record is copied down 12 times to reflect the 12-month amortization period, with values varying based on the months.
  • The header record includes fields like the supporting item header record, open date, entity, General Ledger (GL) account, and a unique ID.

Setting Up the Monthly Schedule

  • The monthly schedule lists the amortization amounts for each month.
  • You’ll see varying amortization amounts for the first six months compared to the last six months.
  • The same concept is applied to the dental insurance amortization schedule, with 12 records mirroring the structure.

Calculation Method and Upload Process

  • The calculation method is set to “end” for non-straight line amortization schedules, which allows the schedule to be created based on the provided amounts.
  • Next, you’ll copy and paste the data into a WordPad file and save it to the file share.
  • As an administrator, you’ll navigate to the Import Data screen, select the items v7 import type, and import the file into the system.
  • Once this is complete, you’ll see the the amortization schedule in the reconciliation within BlackLine.

This video is one in a new series on different ways to import reconciliation supporting items with BlackLine. Stay tuned for more videos on importing supporting items.

Read more about Accounting & Accounts Receivable:

Import Multiple Amortization Schedules into a Reconciliation with BlackLine

Importing a Single Amortization Schedule into a Reconciliation With BlackLine

Best Practices for Account Reconciliations

Home » accounting automation

Filed Under: Accounting and Accounts Receivable Tagged With: account reconciliation, accounting, accounting automation, accounting transformation, BlackLine

  • Page 1
  • Page 2
  • Page 3
  • Interim pages omitted …
  • Page 5
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.