Learn how to set up your company to use Expense Distribution Tables

In this article, we’ll take a closer look at the Expense Distribution Tables feature in Sage 100. You’ll learn how to set up your company to use Expense Distribution Tables and how to correspond percentage amounts with general ledger accounts. Let’s take a closer look …

What is a Distribution Table?

The Expense Distribution Table feature in Sage 100 ERP allows you to pre-define your General Ledger account distribution and their corresponding percentages. Expense Distribution Tables streamline the entry of standard invoices by removing the extra step of manually keying in amounts each time an invoice needs to be paid. For example, monthly rent payments can be set up to automatically allocate percentages to various departments and GL codes.
You can access Expense Distribution Tables for new invoices in Invoice Data Entry, Repetitive Invoice Entry, and Manual Check and Payment Entry.

Getting Started with Distribution Tables

You can enable Expense Distribution Tables by selecting the Enable Distribution Tables Checkbox on the Entry Tab in Accounts Payable Options.

Enable Expense Distribution Tables Button

Defining Distribution Tables If you select this option and the distribution percentage total is less than 100 percent in the data entry task, you must manually distribute the remaining balance.Please note that when you enable Expense Distribution Tables in Accounts Payable Options no transactions can be in process in Invoice Data Entry, Repetitive Invoice Entry, or Manual Check and Payment Entry.

After enabling this feature, select the Allow Total Distribution to be Less Than 100 Percent checkbox to allow the total distribution amount for all accounts in each table to be less than 100 percent.

All Total Distribution to be <100% Button

Now that you have enabled Expense Distribution Tables in your Sage 100 ERP system, let’s define the Expense Distribution Table. You can set up the Expense Distribution Tables using Expense Distribution Table Maintenance.

Once you are in Expense Distribution Table Maintenance, enter an easily identifiable code in the Table Code field. For example: rent, insurance or utilities.

Expense Distribution Table Maintenance Table Code Field

Next, select the General Ledger account numbers and percent amounts you wish to distribute to each account. You can select as many accounts as you need depending on whether or not you checked the Allow Total Distribution to be Less Than 100% checkbox in Accounts Payable Options.

A message dialog box will then appear to let you know whether the percentage distribution amount has exceeded – or is less than – 100%.

Clicking the Applied Balance button will allow you to apply any balance to the current line and existing accounts to total 100%. Click Accept.

Breakdown of the screen will show regarding GL Accounts, Percentages, and Applied Balance button

To view a listing of all defined distribution tables at one time, click the Print button.

And that’s all there is to it! Now you know how to set up and use Expense Distribution Tables for simplified invoicing.

For more information or assistance with your Sage 100 software, please contact our Sage 100 support team at 800.232.8913.

Copyright 2022 DWD Technology Group | All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.