We recently launched a new video series on different ways to import reconciliation supporting items with BlackLine. 

In our latest video, BlackLine Practice Leader, Adam Riskin, demonstrates how to import multiple amortization schedules into a reconciliation with BlackLine.

Step 1. Importing Multiple Amortization Schedules from an Excel File

• 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 BlackLine for proper importing.

Step 2. Importing the Amortization Schedules

• The calculation method, typically straight line, needs to be set before importing the file.
• Browse and select the Excel file containing the scheduled items.
• Click the “Import” button is to add the schedules to the reconciliation.

Step 3. Viewing Imported Schedules

• The imported schedules will 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.

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.
• Your system administrator can use a specific technique to import these non-standard schedules.

Stay tuned for more videos from Adam on how to import supporting items into BlackLine.

Read more about Accounting & Accounts Receivable:

Best Practices for Account Reconciliations

Mitigating Financial Risk through Automation

How Automating Accounting Meets the Growing Demands of Finance