Skip to main content

GL Flow Columns

GL Flow Columns let you assign a GL code based on the journal description.

Samson Wai avatar
Written by Samson Wai
Updated over 3 weeks ago

Overview:

  • GL Flow Columns allow you to have a separate column in addition to the existing GL Code Column based on the journal entry description

*Please note that this feature in part of the comprehensive functionality. If you would like to request to subscribe to this feature, please contact [email protected]

Refer to the following video to learn how to use the GL Flow Columns and to apply the Flow GL Code to your journal report.

Video length: 4 minutes
​

Or alternatively, you can refer to the steps below.
​

Step 1: Create Your Custom GL Columns

  1. In the sidebar, click Chart of Accounts (see arrow 1).

  2. Select + Add New Column (arrow 2) and enter the details for each custom GL column you need.

For an overview of how to build your Chart of Accounts and define GL codes, see How Chart of Accounts and General Ledger Codes Work.

Step 2: Adjust GL Flow Columns in Your Journal Layout

  1. Switch to the Journal Column Order tab.

  2. You’ll notice each custom column appears twice—once under “Custom GL column” and once as “[FLOW] Custom GL Column.”

  3. Drag and drop these “[FLOW]” columns into your desired order to determine where the auto-assigned GL codes will appear.

Step 3: Add GL Flow Columns

You can map Flow columns either in a GL Template or directly at the Company/Agreement level GL Codes:

  1. Via GL Template

    a. Open or start a new GL Template.

    b. Click + Add Code (arrow 1) next to each account you want to include.

    c. Click + Add Flow Column (arrow 2) for each extra Flow mapping you need.
    ​


    ​

  2. Directly in Company or Agreement GL Codes Tab

    1. Click on GL Codes under a Company or Agreement GL Code Tab

    2. Click + Add Code next to each account you want to include.

    3. Click + Add Flow Column for each extra Flow mapping you need.

Agreement Level

Company Level

Step 4: Configure Your GL Flow Columns

  1. For each GL Flow Column you’ve added,

    1. Open the Journal Description dropdown and select one or more journal descriptions (Arrow 1)

    2. Enter the GL code that should be applied when the journal descriptions match (Arrow 2)

  2. You can add additional Flow columns at any time by clicking + Add Flow Column (Arrow 3)

  3. Scroll to the bottom of the GL Column and click “Save”

Step 5: Run the Journal Report

  1. Navigate to Reports > Journal Report.

  2. Run the report—your Flow columns will now automatically populate the GL codes based on matched journal descriptions. (Arrow 1)

FAQs:

What if I use a journal description that doesn’t apply to the lease’s accounting standard while setting up a GL Flow Column (for example, an IFRS 16 description on an ASC 842 lease)? In that case, the Flow GL Code simply won’t populate in the export journal report.

Further Reading:

Did this answer your question?