Labor Union and LM-2 Reporting

sage100erp-100x48

sage500erp-100x49

SageFixedAssets Green

sagehmrs-100x30

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 ERP. Nims & Associates has developed a tool within Sage 100 ERP 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 ERP is on version 4.5. 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.

Pending Update

Upcoming updates to LM-2 reporting for Sage 100 reflect updates to version 2013. The next update is due for release in June 2013.

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

Sage 100 ERP Accounts Payable Modifications

The Accounts Payable programming consists of modifications to Sage 100 ERP 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 ERP lookup functionality
  • Sage 100 ERP 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 MAS 90 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 ERP 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 ERP 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 MAS90 to the Form LM-2 data and from the Form LM-2 to Sage 100 ERP.

 

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, Sage 500 or Sage ERP X3 experts who have a passion for ERP systems and inspire learning, you've come to the right place.  

Learn More

Here To Help

Fotolia here to help meeting-300x200Looking for IT and ERP help from a company that cares about your business? That's Nims & Associates.  
Fotolia here to help-cables-300x205Most of our staff has been with us for more than eight years. Not many companies can match experience or references. 

Coming Sage Events

30 Years of Rave Reviews

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.…

Since our bank told us we need to become PCI compliant, we found lots of holes and “open doors” on our servers, hosting, website etc. Chris closed up them and Tim has helped with the all the other annoying daily problems we have had, and they both do it with a smile and a reassuring, calming tone…

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

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…
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.

We have been a client of Nims & Associates for over ten years. Chris has implemented and maintained our network for all of those years. As our network and our needs have changed and grown, Chris has provided excellent support to move us forward. Over the years I have come to know several of the…

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…

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.

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…

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.

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. 

....and, thank you for all YOU do. We are able to actually breathe easier knowing you're taking care of people. We have trusted you from the get-go because of your high intelligence, your ease at taking in and integrating huge amounts of new knowledge, and your grace and calmness in taking care of…

I cannot thank you enough for your help this evening. You have proven that your services are much more valuable than we ever expected - when you guys told me your hourly rate, I thought "no way can we afford that"! lol .... We are small and we do all we can to keep costs down, as I'm sure you…

Bill has far exceeded my expectations. I am happy to have another Super Technician to rely on for MAS200.

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

Register

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