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