AR and GB Consolidation

How to Consolidate Payments?

Can't see GBI detail.

Account Inquiry missing CRP Information. 

• Payment Processing
• General Billing
• General Ledger
• Setup and Admin

Users will want to know how to control account consolidation for both CRP and GBI postings.

CRP Consolidation is set on a category basis.

1. Navigate to General Revenues > Accounts Receivable > Setup > Accounts Receivable Settings
2. Select Cat Specific from the Munis Ribbon
3. Use the arrows at the bottom of the screen to tab to the relevant payment category.
4. Select PAYMENTS tab Under the Payment Posting Options section
5. Click Update
6. The field GL Consolidation determines whether to consolidate multiple journal lines that affect the same account into one value entry on the general ledger:

• • No Account Consolidation—Do not consolidate multiple journal lines that affect the same account, but display lines in detail on the general ledger. If consolidation is not used, the REF 2 field for each journal entry displays the receipt record responsible for creating the entry.
  • Consolidate Cash Accounts—Only consolidate cash account journal lines into one value entry.
  • Consolidate Non-cash Accounts—Only consolidate non-cash account journal lines into one value entry.
  • Consolidate All Account—Consolidate journal lines for each account type into a value entry (one for cash and another for non-cash)

GBI Consolidation is set in the General Billing Settings.

1. Navigate to General Revenues > General Billing > Setup > General Billing Settings.
2. Click Update
3. Under Miscellaneous see Accounts Receivable Account Posting Method

• • Detail—Creates a journal entry per individual receipt.
  • Summary—Creates one entry for the entire journal.

Please reach out to Support for additional information. 

If using Treasury Management (Bank Reconciliation) module, the option No Account Consolidation should be selected in Accounts Receivable for easier reporting and reconciliation.