Macola® 10 & ES Software Year-end Checklist

Table of Contents

This checklist outlines your Macola® 10 & ES software year-end processing workflow steps. The checklist procedures are identical for calendar year and fiscal year companies. To assure consistency, we suggest that one person or a small team complete the checklist. Please call us with any questions and comments.


Leahy Consulting Assistance Desk (513) 723-8094

Preparation Steps

1. Read all of the following steps in each section before starting.

2. Periodically run utilities to help maintain data integrity:

  • Run File Validations
  • Run Reset Allocations and run Reset Quantities On-Order
  • Run Reset Low Level codes
  • Run Rebuild OE Inquiry Order Tables
  • Run Rebuild Batch ID’s

3. Frequently backup your Macola® database.

4. Frequently archive your Macola® database data.

  • Update your archiving plan frequently to support your retention policies.

Informational Steps

1. The year-end checklist follows two submenus within the Macola® System & General Ledger menus. These are shown below.
  • Go to System > Period End/Year-End submenu
  • Go to General Ledger > Taxes submenu

2. The Year-end checklist steps should be performed immediately AFTER completing the Period-end checklist steps for the LAST period of your accounting year.

3. The Year-end checklist sequence should be followed as described due to the data interactions and/or dependencies between multiple Macola® modules.

4. All users must exit Macola® prior to executing the Year-end checklist.

5. BACKUP your Macola® database prior to executing the Year-end checklist.

Period-Date Calendar

Confirm that your period-date calendar includes the new year.

1. Navigation: Go to General Ledger menu > Maintain > Period-Date calendar.

2. Highlight the coming year and click Open.

3. If the coming year is not listed, create one for the coming year.

Confirm that your journals are open for the new year.

The following instructions will be used for confirming that the needed journal(s) for each module are open in the coming year and the period is set to “1”. This will apply to Sales Order Entry, Accounts Receivable, Production, Manufacturing Cost Accounting, etc.:

1. Go to General Ledger menu > Maintain > Period-Date Calendar.

2. Highlight the coming year > click Open.

3. Highlight period “1” and click the closed quantity field to open that period.

4. Specify “All” for the filter and highlight the needed source journal(s).

5. Double click to change the “X” to a “check mark” and click SAVE

Sales Order Entry Year-end Checklist

Sales Order Entry/CM/RMA/Cash Steps:

1. Complete Period-end Checklist.

2. Confirm the Order Entry Sales History period date file is set to the new year and reflects “1” as the current period.

  • Go to System Menu > Distribution > Order Entry > Sales History Periods > change to reflect the coming year > current period “1” > click save.

3. Confirm that your Order Entry Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Accounts Receivable Year-end Checklist

Accounts Receivable Sales Order/CM/DM steps:

1. Complete Period-end Checklist.

2. Confirm that your Accounts Receivable Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Production (POP / SF / SC / MRP / SR / MS) Year-end Checklist

Production Steps

1. Complete Period-end Checklist.

2. Confirm that your Production Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Labor Performance Year-end Checklist

Labor Performance Steps

1. Complete Period-end Checklist.

2. Clear accumulators.

3. Go to System > Period End/Year End > Labor Performance > Clear Accumulators

Manufacturing Cost Accounting (MCA) Year-end Checklist

Manufacturing Cost Accounting Steps:

1. Complete Period-end Checklist.

2. Confirm that your MCA Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Purchase Order Year-end Checklist

Purchase Order Steps:

1. Complete Period-end Checklist.

2. Confirm that your Purchase Order Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Assets and Depreciation Year-end Checklist

Assets and Depreciation Steps:

1. Complete Period-end Checklist including posting depreciation.

2. Print Assets Year-end Totals report

  • Go to Assets > Reports > Assets Year-end Totals

3. Confirm that your Assets and Depreciation Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Inventory Management (BOM / IM) Year-end Checklist

Inventory Management Steps: 1. Complete Period-end Checklist including posting any physical inventory count tags. 2. Assure that the Current Period field is correct in I/M Package Settings.
  • Go to System Menu > Package Settings > Distribution > Inventory Management.
  • Confirm that the “Current Period” field in I/M Package Settings is accurate. If not, the Item Period History Report will be inaccurate.  If this number is not “12 and/or your year-end period”, then update it to the year-end period.  If it is off, your item Period History report is compromised for this and prior periods.

3. Clear accumulators

  • Go to System > Period End/Year End > Inventory Management > Clear Accumulators.
  • Specify the “Clear Year-To-Date Accumulators” option. Choosing this option also selects to “Clear Period-To-Date Accumulators”.
  • This process should only be run ONCE. If you ran this process during your period-end checklist steps, DO NOT run again at this time.

4. Confirm that your Inventory Management Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Accounts Payable Year-end Checklist

Accounts Payable Year-end Steps:

1. Complete Period-end Checklist

2. 1099s – this does NOT need to be completed as part of your year-end processing.

  • The Print 1099 Forms screen allows you to print 1099 forms.
  • The Create 1099 Forms screen allows you to create electronic files.
  • The Print 1099 Forms screen and the Create 1099 Forms screen have a Recalculate Vendor YTD Payment check box.
  • If you select the Recalculate Vendor YTD Payment check box, the system automatically clears the value in Number Field 1 for vendors in the selected range and recalculates the 1099 value based on 1099 designated transactions for the designated year. You should select this check box when creating 1099 forms for a new year. This functionality allows you to generate 1099 forms without manually clearing Number Field 1 for each vendor.
  • If you do not select the Recalculate Vendor YTD Payment check box, the system will generate 1099 forms based on the values in Number Field 1. This is useful when reprinting 1099s or when you have manually changed the 1099 value in Number Field 1 for a vendor.

3. Confirm that your Accounts Payable Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Cash Flow Year-end Checklist

Cash Flow Steps:

1. Complete Period-end Checklist.

2. Complete Bank Reconciliations

3. Process all bank journals

  • Go to G/L > Entries > Process > highlight bank journals > click Process
4. Confirm that your Bank Journal(s) are OPEN for the new year period “1”. Refer to the instructions above.

Tax Codes Year-end Checklist

Tax Code Steps:

1. Run Clear Tax Accumulators.

  • G/L > Taxes > Clear PTD/YTD tax accumulators
  • Specify only “year-to-date” accumulators.

General Ledger Year-end Checklist

General Ledger Steps:

1. Process all remaining journals

  • Go to G/L > Entries > Process > highlight journals > click Process

System Closing Checklist

Closed Periods Steps:

1. Close all journals for the closing year

  • Go to System > Period End/Year End > Closed Periods

Profit / Loss Steps:

1. Complete Period-end checklist.

2. You will need to REOPEN the closing year journal that will be used to process profit/loss.

3. Process Profit/Loss.

  • Go to System > Period End/Year End > Process Profit/Loss

General Ledger: Final Steps Year-end Checklist

General Ledger Steps:

1. Run Interactive Balance Reports

  • Go to G/L > Reports > Interactive Balance
  • To verify that all has been done correctly, print an interactive balance report with a starting and ending date of the last day of your closed year.  Assure that the ending balances are what you expected.
  • Additionally, print an interactive balance report for the first day of your new year.  Assure that ALL of your income and expense accounts beginning balances are zero.  Also, assure that your balance sheet beginning balances are the same as the ending balances from the step above
  • For both of the above reports, be sure to not check the “Zero Balances” checkbox so only account with activity will be printed.

Congratulations!

You have now successfully completed all of your year-end processing steps.  As always, we encourage your questions and comments regarding the above checklist and ways in which we can further simplify this processing for you.  Please call us at (513) 723-8094 or Assistance@LeahyConsulting.com.

Download the PDF