Export Accounting Data With the Report Builder

After the transaction journal records are ready, create a report with this data, and export it as a comma-separated values (CSV) file. Then, import that file into your accounting system.

REQUIRED EDITIONS AND USER PERMISSIONS
Available in: Lightning Experience
Available in: Enterprise, Performance, Unlimited, and Developer Editions with Accounting Subledger
User Permissions Needed  
To create, edit, and delete reports in private folders: Create and Customize Reports
To create, edit, and delete reports in public and private folders: Report Builder OR Report Builder (Lightning Experience)
To export reports: Export Reports

Create a Transaction Journal Report

  1. On the Reports tab, click New Report.
  2. Select the Transaction Journals report type, and then click Start Report.
  3. The report opens in edit mode, and shows a preview. Customize your report until it shows the data that you need.
  4. Click Save, and then enter a report name.
  5. Save your changes.
  6. To view the report results, click Run.

See Build a Report in Lightning Experience.

Export a Transaction Journal Report

  1. On the Reports tab, next to the report to export, click Show Actions icon, and then select Export.
  2. Click Details Only, and then select the Comma Delimited .csv format.
  3. Select an encoding, and then click Export.
  4. If prompted by a browser dialog, select a location and save the file.

See Export a Report.