The Blackline Export will export GL Account data that can then be uploaded and used for accounting purposes in Blackline.
Article Topics
Navigation
To navigate to the Blackline Export, click 'My Reports' under 'Reports' in the left pane and select 'Financial' in the top header of the reporting window. Once opened, a listing of reports will be shown.
Find 'Blackline Export' and select 'Customize' next to the report to select the Report Parameters that will define your report.
Report Parameters
1) Filter By - A listing of all Location categories
2) Filter - A listing of all Locations within the selected Location category
3) Account - A listing of all GL Accounts
4) Start - The beginning date for the report data
5) End - The end date for the report data
6) Download - This will download the data
Report Columns
1) Entity Unique Identifier - The Tax ID from the Legal Entity
2) Account Number - The GL Account number
3) Key3 - This is left empty
4) Key4 - This is left empty
5) Key5 - This is left empty
6) Key6 - This is left empty
7) Key7 - This is left empty
8) Key8 - This is left empty
9) Key9 - This is left empty
10) Key10 - This is left empty
11) Account Description - The GL Account name
12) Account Reference - This is listed as the unique R365 identifier. R365 does not use a unique identifier, so this column will be left empty
13) Financial Statement - This is set to 'A' for Account Groups
14) Account Type - The GL Type associated with the GL Account. This will display Blackline's equivalent value, which is compared to R365's Values below (format: R365 Value = Blackline Equivalent)
- Asset = Asset
- Liability = Liability
- Equity = Equity
- Sales = Revenue
- COGS or Prime Cost = Expense
- Operating Expense = Expense
- Non Controllable Expense = Expense
- Corporate Overhead & Other = Expense
- Income Tax = Expense
15) Active Account - This will display the following value based on the GL Account:
- True - This is an active account
- False - This is an inactive account
16) Activity in Period - This will display the following value based on the GL Account:
- True - There is account activity for the given GL Account in the set time frame
- False - There was no account activity for the given GL Account in the set time frame
17) Alternate Currency - This is set to USD
18) Account Currency - This is set to USD
19) Period End Date - Date as set by the End Date Report Parameter
20) GL Reporting Balance - This is set to 0
21) GL Alternate Balance - This is set to 0
22) GL Account Balance - The balance of the GL Account for the set time frame