CenterPoint® Accounting - Customize the General Ledger Account Activity Report

Related Help

Printing and Previewing Reports Video - Duration: 12 min 52 sec

Customizing Reports Video - Duration: 16 min 18 sec

Report Favorites and Batch Reports Video - Duration: 9 min 50 sec

View or Print as PDF

Step-by-step instructions on how to customize a General Ledger Account Activity report that includes these modifications:

  • The cash, accounts payable, accounts receivable, and line of credit accounts will be excluded from the report to condense the length of the report.
  • Account Number headings will print on multiple pages if transactions for an account span more than one page.
  • The notation information will be added to the report.

Customize the General Ledger Account Activity Report:

  1. Select Reports > Reports > Transaction Reports > General Ledger > General Ledger Account Activity.
  2. Specify the preferred Report Selections on the right side of the screen, and then click Preview.

  1. Click on the Filters tab on the left side of the previewed report so that we can exclude the
  2.  appropriate accounts from the report.
    1. Click on the More Items button.
    2. Place a check mark in the Account Category box and click OK.

     

     

    1. In Report Selections, click on Account Category to display the Account Category filtering.

     

     

     

     

    1. In the By field in the upper right corner, select Account Category.
    2. Move the Accounts Payable, Accounts Receivable, Cash and Line of Credit account categories from the left to the right using the green arrow buttons.
    Note: To make it easier to find these categories, click on the Account Category column heading on the left in the Available box to sort the Account Categories in alphabetical order.

     

    1. Select the Exclude selected items check box and click OK.
  3. Select the General tab to modify the name of the report and add group names to multiple pages.

    1. Click in the Title field and specify the name you'd like to use for this report. In our example we added "(exclude cash)" to the end of the existing report name.
    2. Place a checkmark in the Group headings on each page box.
    Note: By selecting this option, if an account's transactions span more than one page, it will show the account number heading on each page of transactions.
  1. Select the Columns tab to add the Notation field to the report.

  1. Select the Available tab, scroll down to Notation, and then place a check mark in the box to add it to the report.
  2. Use the green arrow up and down buttons to decide what order to display the columns in.
  1. Select the Refresh button after making changes to update the report with the new changes.
  2. While in the preview of the customized report, save the report as a Favorite by clicking on the favorites icon..
  3. Specify a name for the new customized report and click OK. It will then be available for future use in the Reports > Reports > Favorites tab.

Document: 3074

Concept Link IconSee Also