Consolidated Payments

Written by
Manuelito Macalinao
Published on
July 28, 2023 at 2:14:56 AM PDT July 28, 2023 at 2:14:56 AM PDTth, July 28, 2023 at 2:14:56 AM PDT

If you sell to customers who have subcustomers, the Consolidated Payments feature gives you the flexibility to accept payment for subcustomer invoices from either the top-level customer or from the individual subcustomer.

With this feature enabled, when you select a top-level customer in the Customer field atCustomers > Accounts Receivable > Accept Customer Payments > List, the Invoices subtab shows both the invoices entered for the top-level customer as well as the open invoices for each of its subcustomers.

Additionally, when a top-level customer is selected on the Payment page, the Deposits and Credits subtabs list all of the deposits and credits entered for the top-level customer and its subcustomers. These credits and deposits can be applied to any of the open invoices entered for the top-level customer or its subcustomers.

If you allow customers to make payments through the Customer Center, top-level customers can make payments on their invoices or the invoices of their subcustomers. They can also apply any credits or deposits to these invoices. For more information, seeAllowing Customers to Pay Online.

To enable the Consolidated Payments feature, go toSetup > Company > Setup Tasks > Enable Features > Accounting (Administrator), click the Accounting subtab, and check the Consolidated Payments box. After enabling the feature, you can go toSetup > Accounting > Preferences > Accounting Preferences (Administrator), and enable theAccept Payments Through Top-Level Customer Onlypreference if you want to only apply payments, credits, and deposits through the top-level customer.

For more information on accepting payments, seeApplying a Payment on the Customer Payment Page.

For information on consolidated payments and the Multiple Currencies feature, seeCustomers and Multiple Currencies.

Consolidated Balance Fields

To help you track the consolidated balance for a customer-subcustomer hierarchy, when you enable this feature, the following consolidated balance fields are shown on the Financial subtab of customer records:

  • Consolidated Balance- the total of all open invoices for the entire customer-subcustomer hierarchy.

  • Overdue- shows the total overdue balance for all customers and subcustomers in the hierarchy

  • Days- the number of days the consolidated overdue balance is past due

  • Consolidated Deposit Balance- the total amount of unapplied deposits for all subcustomers and customers in this hierarchy

  • Consolidated Unbilled Orders- the total amount on orders for the customers and subcustomers in this hierarchy that have been entered but not billed

  • Consolidated aging fields - show the current consolidated balance broken down into amounts in each aging category (1 - 30 days, 31 - 60 days, etc.).

These fields can be added to custom reports by selecting the consolidated fields from the Customer folder. The consolidated fields are also available when performing a customer search. If you use the Multiple Currencies feature, balance fields on the customer record are shown in the customer's currency. To add these fields to searches or reports, you can choose between either the fields in the base currency or the foreign currency.

Customer Statements

With the Consolidated Payments feature, you can print either individual customer statements or consolidated statements with balance information for the entire customer-subcustomer hierarchy.

To print a single consolidated statement, go toCustomers > Accounts Receivable > Individual Statement, and check the Consolidated Statement box. To print consolidated statements for multiple customers, go toBilling > Sales > Generate Statements, and check the Consolidated Statements box. For more information, seeCustomer Statements.

If you use a custom invoice form to include balance information on printed invoices and use the Consolidated Payments feature, these fields show the consolidated balance. For more information, seePrinting Mini Statements.

You can add Deposit Balance and Net Amount Due information to customer statements. For more information, seeDisplaying Deposit Balance on Customer Statements and Remittance Slips.

Credit Limits and Holds

With the Consolidated Payments feature enabled, the credit limit defined for a top-level customer is the applied to the entire hierarchy. With this feature enabled, credit limits set on individual subcustomer records are not enforced.

Likewise, manual credit holds placed on the top-level customer are applied to the entire hierarchy.

Reports and KPIs

With Consolidated Payments, the A/R Aging report shows the un-consolidated balance for each subcustomer. Amounts are totaled for each customer-subcustomer hierarchy allowing you to see the consolidated balances.

The following consolidated KPIs are available on customer dashboards with the Consolidate Payments feature:

  • Consolidated Balance

  • Consolidated Overdue Balance

  • Consolidated Unbilled Orders

  • Consolidated Days Overdue

  • Consolidated Average Days Overdue