Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

Journal Entry Spreadsheet Print - Screen Overview

The Journal Entry Spreadsheet Print report is a transactional report that prints line-level details of a Journal Entry (JE) in a spreadsheet format. Both posted as well as unposted Journal Entries can be selected for Spreadsheet print report.

Navigation Tip: Journal Entries >> Journal Entry >> Work with Journal Entries >> Select a JE # >> Click tab Spreadsheet Print.

1.png

2.png

Click Submit to run the job at a specific time. It displays the following message:

3.png

The system displays the following pop-up:

4.png

Click OK. Click the Spooler button from the Common Actions Bar to view the Work with Print Jobs page that includes the report in the list with a status of it for Spreadsheet Print as follows:

5.png

View Spreadsheet page appears with the following options:

  • View Journal entry name
  • Email Journal entry name

Click the View Journal entry name button. The system downloads the excel file to your machine.

6.png

Click the downloaded file to open the spreadsheet. The JE Spreadsheet report contains following columns. These are the same fields available on the Journal Entry Control and Details screens.

mceclip0.png

Version 1.1

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.