Labor Union and LM-2 Reporting

sage 100cloud 500x96

sage 100c manufacturing 500x96


sage Fixed Assets 500x96

Labor Union and LM-2 Reporting

The United States Department of Labor (DOL) / Office of Labor-Management Standards (OLMS) requires most unions to file a financial report in accordance to:

  • The Labor-Management Reporting and Disclosure Act (LMRDA),
  • The Civil Service Reform Act (CSRA)standards of conduct regulations
  • The Foreign Service Act (FSA)

LM-2 is the most common form unions file with the Department of Labor. LM-2 reporting provides a breakdown of a labor organization’s finances. The reports show financial details of how much money was spent and where it was allocated. In summary, LM-2 reporting represents a series of reports based on schedules 1 to 20/activities or specific allocations, Statement A – Assets and Liabilities, and Schedule B – Receipts and Disbursements. For example schedule 11 of the LM-2 report presents information on officer salaries, schedule 12 reflects employee salaries, schedule 20 addresses benefits, etc.

For nearly a decade Nims & Associates has been providing vital expertise to Labor unions utilizing Sage 100. Nims & Associates has developed a tool within Sage 100 for LM-2 reporting in partnership with a collaborative of unions. Developed and maintained over the years by Nims Master Developers, our LM-2 reporting tool is designed to collect data, export and upload according to Department of Labor requirements.

Latest Update

Our latest update to LM-2 reporting for Sage 100 is on version 2017. A majority of the most recent changes are to the A/P module to address changes to schedules 15 though 19, A/R module enhancement to capture miscellaneous cash receipts for schedule 15, and modifications to payroll to address schedules 11 and 12.

Here is how we have addressed LM2 reporting for Sage 100 at a glance:

Sage 100 Accounts Payable Modifications

The Accounts Payable programming consists of modifications to Sage 100 Accounts Payable Setup and Main menu items.

  • Invoice Data Entry has been modified to include invoice line data entry fields for Agent, LM-2 Category code and line Vendor.
  • Fields have standard Sage 100 lookup functionality
  • Sage 100 users are able to maintain Agent and Category code lists through separate menu items located on the Accounts Payable Setup menu
  • An additional Main menu item titled Invoice History Maintenance is available to change the Agent and Category assigned to an invoice line after the invoice item has been posted
  • Use of this utility can be restricted to authorized users through Menu Security Maintenance

LM-2 Reporting for Accounts Payable Transactions

The second component of the LM-2 Reporting System is Accounts Payable Disbursement Reporting for LM-2 Schedules 15 to 19 and Columns F and G of Schedules 11 & 12.

*Explanation of schedules

Schedule 11 – Reports all salaries and other direct and indirect   disbursements to officers.
Schedule 12 – Reports all salaries and other direct and indirect   disbursements to employees.
Schedule 15 – Reports direct and indirect costs associated with   representational activities
Schedule 16 – Reports direct and indirect costs associated with   political activities and lobbying
Schedule 17 – Reports direct and indirect costs associated with   Contributions, gifts and grants
Schedule 18 – General Overhead
Schedule 19 – Union Administration
  • Microsoft Access programming is used to extract Sage 100 Accounts Payable check and invoice history data
  • Allocation and Category aggregation calculations are applied to the data
  • The program creates files which are imported to the Form LM-2 Schedules 15 to 19 through the data import or file attachment feature provided with the DOL’s electronic LM-2

LM-2 Reporting for Payroll Transactions

The final component of the LM-2 Reporting System is Payroll Reporting for LM-2 Schedules 11 & 12 for officers and employees.

  • Sage 100 Payroll Employee Maintenance are modified with Custom Office to accommodate additional fields required by the LM-2
  • Microsoft Access programming is used to extract Sage 100 Payroll check history data.  The Payroll data is combined with Accounts Payable data for Columns F and G
  • User defined estimated percentages of time spent on activities that fall within Schedules 15 to 19 are imported for each officer/employee
  • The program creates files which are imported to the Form LM-2 through the data import or file attachment feature provided with the DOL’s electronic LM-2

Audit Trail Reports

A suite of audit trail reports are provided to allow for tracing data from Sage 100 to the Form LM-2 data and from the Form LM-2 to Sage 100.


Download Sage product spec sheets here

Make Nims Your Sage Partner

Fotolia contact us-b-350x232

Because you deserve the best ...

It only takes a few minutes to make Nims your Sage Reseller of record. Learn How...

If you are looking for a group of Sage 100 or Sage 500 experts who have a passion for ERP systems and inspire learning, you've come to the right place.  

Learn More

30 Years of Rave Reviews

Bill has far exceeded my expectations. I am happy to have another Super Technician to rely on for MAS200.
We are delighted with the service and we've received a number of comments by clients that they are very impressed with the way Tessa handles the problems and works with them. She REALLY picks up things quickly. We are continuously amazed and pleased that we only have to tell her something once and…

I’ve sent more than one shining Michael endorsement. The whole company kicks ass.

As someone who works remotely from a home office, connectivity and a reliable, functioning computer are absolutely critical to my ability to be able to perform. Recently my computer "crashed" and as you can imagine created great inconvenience. Your team of Joel, Tessa and Tim responded immediately.…

We are very happy to have your company in place. Joel and Tony have been excellent. The Senior Management Team feels as though a great weight has been lifted from their shoulders and we are appreciative that our systems and software are in the hands of experts.

We’re getting rave reviews on the new e-newsletter. I just want to let you know how grateful we all are for your help on this project—your great direction, patience and support are invaluable.

We would NEVER have gone this far without you!

Thank you for explaning what you did in an understandable way. You're very patient working with such a small company and treating us as though we were a huge corporation.

Can I tell you how we feel about Chris? He is the greatest. He goes way beyond the norm. We can't ask for better service and support. Chris has taken the time to teach me additional things to not only help him but us here which cuts the time we need him here to fix something I can do. Not many…

We are very impressed with josh…he seems very knowledgeable and he communicates well…and he just seems like a nice person also…basically our dream consultant….

Again, we’re really impressed with josh and would not hesitate to recommend Nims to anyone.

I have been extremely happy with your service. Michael is truly devoted to his clients and has been great about working with our current vendor to get our issues resolved. The MXLogic transition was seamless. Our users barely noticed the change, which is always a plus. 

We are so pleased with the installation of our Shoretel system. The phones work great and James was able to customize the system to suit our somewhat unusual need of combine live person answering and automation. Both the phones and the software are user friendly and required little training. James…

Thank you for assigning Don to handle our myriad of computer tasks throughout the year. His expertise and friendly can do personality are a cherished resource within our firm. Whenever the screen goes blank or freezes up we always think "Have no fear Don soon will be here" which he is and things…

At a time when it may seem like good customer service is at all time low and we hear so many negatives about many companies and their employees, it’s a pleasure to be able to send along our positive comments regarding Nims & Associates … and more specifically about Chris. Chris has worked our…

We are impressed with response times and the general aptitude of your support group. This stands in stark contrast to some of the experiences with other IT resources we’ve patronized in the past.

Nims and Associates are the best support company I have ever worked with. They get back to my every problem or question in record time. They have been able to help or fix every problem I have come up with. Bill and or Bob are very knowledgeable with all my MASS 200 problems. I would and have…

Nims At A Glance

Corporate Office:
Petaluma, CA | 707-781-6300 | 877-454-3200
This email address is being protected from spambots. You need JavaScript enabled to view it. | This email address is being protected from spambots. You need JavaScript enabled to view it. 
Service Areas:
San Francisco & Greater Bay Area | Sacramento & Northern California | Los Angeles  | Reno / Tahoe | Seattle / Tacoma | Denver | Houston | Honolulu | Phoenix and more
Industries Served:
Accounting, Architecture, Associations, Construction, Distribution, Wholesale, Energy Services, Engineering, Insurance, Legal, Manufacturing, Non-Profit, Professional Services, Property Management, Real Estate, Retail, Transportation and more.
Founded: 1985 
Consultants on Staff: 40

S5 Box


You need to enable user registration from User Manager/Options in the backend of Joomla before this module will activate.
Contact Me