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