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