NetLoan - Use a Different Segment for Balance Sheet or P&L Accounts

Overview

Some companies need:

  • One segment on the Loan Balance (Balance Sheet) accounts
  • A different segment on the related Interest or Expense (P&L) account

This is common when loans are managed centrally, but interest expense needs to be tracked by a different department, location, class, or other segment. It also applies when reporting needs to show loan activity by a specific segment for management or financial reporting purposes.

By default, NetLoan carries the same segments to all posting lines generated from the loan.

If you want different segments for different accounts, you’ll need to:

  1. Create a second segment field on the NetLoan record
  2. Use Custom Sourcing to control which segment posts to the Balance Sheet accounts and which posts to the Interest or Expense account

This process works the same for department, location, class, and other custom segments.

Prerequisite

Before starting this setup, please review the Manage Custom Sourcing article. It contains the detailed instructions for creating sourcing rules.

This article provides a high-level overview of the process, but the detailed configuration steps for Custom Sourcing are covered there.

Step-by-Step Setup

1. Add Field to the NetLoan Loan Form. This is the field that the custom sourcing will look to for the segment retagging on transactions. 

2. Create a new Custom Sourcing rule using the Transaction Posting trigger. Make sure to specify the accounts the rule should apply to in the Sourcing Filters section; otherwise, it will update the segment on all journal lines. When setting up the rule, select the new field you created on the NetLoan Loan record as the source field. 

3. Now when journals are run, the new segment will be applied to the accounts specified in the sourcing. 


Was this article helpful?