Journal Reports

Reports Checklist

Use the Journals report to print transactions that have been recorded in a journal. Then, use the printed report to verify the transactions that have been posted are correct. Also, keep the printed journal on file as a hard copy of the journal transactions. You can use the hard copy to restore the journal if the backup is corrupt.

 

Watch a video

Learn more about using journal reports to complete the Reports Checklist. [MP4]

 

 

Printing journal reports

1. Open Connect General Ledger > Reports > Journals.

2. Use the Definition box to select a report title.

Definition box

3. Set up the report date range.

Report dates

 

4. Set up the report options.

Use these options to determine which transactions to include or exclude and when to print totals.

Options on the Report Options tab

Include pending journal amounts

Include transaction count by journal

Include split totals

Include journal out-of-balance warning

Include inactive journal codes

 

5. Use the Journal Code box to select the journals to include on the report.

The Journal Codes box shows all of the journal codes that are set up in Connect General Ledger. To update the journal codes on the list, How do I add a journal code?

Journal codes

6. Set up the options on the Additional Options tab.

Use these options to filter accounts by segment range, total segments, and total by account type. If you're using grant accounting, you can include grant accounting accounts.

Additional Options tab

Filter by segment selection

Total with leading segments or by each segment

Provide a running total by account type

Include accounts from these grants only

 

7. Set up the selection criteria, report order, report sections, and columns. (Optional)

 

8. Click Print (CTRL+P).

202002, 2020Jan08

 

Including pending journal amounts

Include transactions when the transaction type is pending. A pending journal amount is an amount that is waiting for approval.

Including transaction count by journal

When the report section for the group is set to total and page, the number of transactions will print at the end of each page.

Including split totals

When transactions share the same date and reference number, the report will total the transactions and then print the "split" total.

Split total by date and reference number

Including journal out-of-balance warning

For each journal, check if the debit value and credit value net to zero. If the journal does not net to zero, the report prints ***Journal is out of balance: $###,###,###.##***.

Journal is out of balance warning

Including inactive journal codes

Include journals when the journal code status is inactive. To learn more about inactive journals, see How do I activate/deactivate a journal code?

Filtering by segment selection

Use the Segment Selection grid to filter the report by account segment. Click Filter to enter the segment range to include on the report.

Segment selection grid

Totaling with leading segments or by each segment

Use total with leading segment, to use the leading segment to group accounts. When the leading segment changes, the report will total the transactions in the group and then print the leading segment total.

Total with x on the Additional Options tab

Use total by each segment, to use the segment to group accounts. When the segment changes, the report will total the transactions in the group and then print segment total.

Providing a running total by account type

Use the account type to group accounts by account type. When the account type changes, the report will total the transactions in the group and then print the account type total.

Provide a running total by account type

Include accounts from these grants only

This option is only available when a journal allows grants. To learn how to set up grant accounting in General Ledger, see How do I turn on grant accounting?

Include accounts from these grants only

 

Copyright © 2020 Caselle, Incorporated. All rights reserved.