Blackline Export

The Blackline Export will export GL Account data that can then be uploaded and used for accounting purposes in Blackline.

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