DSD Business Systems   

 MAS 90/ MAS 200 White Paper 

 DE6 / DE9 / DE9c / California Quarterly Unemployment Filing

Background 

 The following DSD White Paper explains the 2011 changes to filing of California EDD Quarterly Unemployment, and how it relates to DSD’s MRCA California Quarterly Unemployment Reporting. 

 The following are presented in this White Paper: 

  • What are DE6, DE9 and DE9C filings?
  • How does DSD’s MRCA California Quarterly Unemployment Reporting fulfill these filings in MAS90 | MAS 200?
  • What format is the MRCA California Quarterly Unemployment Reporting in?
  • How do I setup an online account with the EDD?
  • How do I generate the upload file using DSD’s MRCA California Quarterly Unemployment Reporting?
  • How do I upload the file to the EDD website?
  • How do I contact the EDD for assistance?

  

What are DE6, DE9 and DE9C filings?
DE6: The California DE6 Form, Quarterly Wage and Withholding Report, is a required report to be filed by California employers. Business owners report individual employee’s wages and personal income tax (PIT) withholdings. This form is used for filing for years 2010 and prior. To view a copy of this form, select this link: http://www.edd.ca.gov/pdf_pub_ctr/de6.pdf 

When filling out this form, you submit Company and Employee information on one form. 

If you have 250 employees or more, you may not use this form, but must instead file electronically. 

DE9 and DE9C: Starting in 2011, the DE9 and DE9C forms replace the DE6 form. Basically, they broke up the DE6 form into 2 forms: The DE9 is the Company information, and the DE9C is the Employee information. 

To view copies of these forms, select the following links: 

http://www.edd.ca.gov/pdf_pub_ctr/de9.pdf

http://www.edd.ca.gov/pdf_pub_ctr/de9c.pdf 

As with the DE6 form: If you have 250 employees or more, you may not use this form, but must instead file electronically. 

How does DSD’s MRCA California Quarterly Unemployment Reporting fulfill these filings when using MAS 90 |MAS 200? 

As mentioned, if you have more than 250 employees, you may not use the DE6 or DE9/DE9C forms for filing. Conversely, you may file electronically instead of using these forms, regardless of how many employees you have. 

DSD’s MRCA California Quarterly Unemployment Reporting is a MAS 90/200 enhancement that generates the file that can be sent to the EDD electronically. It can be purchased through your Sage Reseller. If you are a Sage Reseller, you may contact DSD directly to purchase at (858) 550-5900. 

What format is the MRCA California Quarterly Unemployment Reporting in? 

As of 2011, the California EDD allows for three (4) formats for Electronic filing: 

• Comma-Delimited file (CSV)
• MMREF format
• ICESA format
• XML format (added in year 2011) 

DSD’s  MRCA California Quarterly Unemployment Reporting is in the ICESA format. 

According to the California EDD, all 4 formats will be allowed for the next few years. At some point, the MMREF and ICESA formats will be retired, and you will be required to submit in XML format. DSD is currently researching this format, and the MRCA California Quarterly Unemployment Reporting will be changed to this format in the next 18 months, before it is required by the EDD. 

When uploading the electronic file, the EDD allows for the CSV and XML files to be uploaded as-is. For the ICESA and MMREF formats, the file must be zipped into a .zip file before uploading. 

How do I setup an online account with the EDD? 

Starting March 1, 2011, employers that submit Quarterly Unemployment Reporting electronically are required to enroll in e-Services for Business. To start this process, select the following link: 

https://eddservices.edd.ca.gov/index.html 

1. Select the e-Services for Business Login link
2. Select the Enroll for a username and password link
3. Enter the information on the e-Services for Business enrollment.
4. Continue through the enrollment process. Once you obtain a User Name and Password, you will then have the ability to upload your electronic file. 

IMPORTANT: DSD recommends that you setup your EDD account IMMEDIATELY, as it may take a week or more to obtain your User Name and Password, 

How do I generate the upload file using DSD’s MRCA California Quarterly Unemployment Reporting? 

The latest version of the User Manual for DSD’s MRCA California Quarterly Unemployment Reporting can be obtained by selecting the following link: 

http://www.dsdinc.com/enh/downloads/MRCA440.PDF 

Please review this User Manual, as it explains how the UIWAGE file is created. Once you create your UIWAGE file, you can then zip the UIWAGE into a .zip file, and use the .zip file to upload. 

To create a .zip file, typically, you can right-click on the UIWAGE file, and select “Send to” and then “Compressed (Zipped) Folder”. This will create a UIWAGE.ZIP in the same directory as UIWAGE. Again, the UIWAGE.ZIP is the file that you upload. 

How do I upload the file to the EDD website? 

1. Go to https://eddservices.edd.ca.gov/index.html
2. Select the eServices for Business Login link
3. After you login, a new screen will be displayed that has two sections. On the top section, it displays My Summary and on the bottom section, it displays My Accounts.
4. On the right side of the screen is the navigation “I Want to…” with some selections
5. IMPORTANT: Do NOT select an account from My Accounts, as it will display different ”I Want To” selections.
6. From the “I want to…” selection, select Attach a Return File
7. A new screen will be displayed that allows for you to enter information for the upload.
8. At the top of this screen, it will ask you for the Attachment Type.
9. Select DE9, ICESA, ZIP
10. Select the Browse Button to select the UIWAGE.ZIP that you generated from DSD’s MRCA enhancement.
11. Go to the Return File Upload section and complete the information on the screen. 

On the following page, Appendix A, there is a screenshot of this Upload screen. 

How do I contact the EDD for assistance? 

There are many phone numbers on the EDD website that you can call, but the one that I used that got me directly to the proper person is: (800) 796-3524

Prepared by
Jon Reiter
VP Engineering
 

DSD Business Systems 

 

Share

Version 4.40 and later:

The Average Inventory YTD is calculated based on the Year and Period/Month selected. The data used in the calculation is stored in the IM_PeriodPostingHistory.m4t file.

The first step is to calculate the Ending Balance for each period. For example: if period 3 was selected you would have the following calculation:

  • BeginningBalQty (Per1) + PeriodChangeQty (Per1) = EndingBalPer1
  • BeginningBalQty (Per1) + PeriodChangeQty (Per1) + PeriodChangeQty (Per2) = EndingBalPer2
  • BeginningBalQty (Per1) + PeriodChangeQty (Per1) + PeriodChangeQty (Per2) + PeriodChangeQty (Per3) = EndingBalPer3

Then, add these Ending Balances together then divide by the number of periods.

(EndingBalPer1 + EndingBalPer2 + EndingBalPer3)  / 3

Here is what those formulas look like with data:

  • Period 1:  0 + 0 = 0
  • Period 2:  0 + 0 + 0 = 0
  • Period 3:  0 + 0 + 0 + 0 = 0
  • Period 4:  0 + 0 + 0 + 0 + 33 = 33
  • Period 5:  0 + 0 + 0 + 0 + 33 + 2642 = 2675
  • Average Inventory Quantity: YTD (0+0+0+33+2675) / 5 = 541.60

Version 3.71 to 4.30

Note: Inventory is perpetual; therefore the quantity on hand may include future transactions.

The Average Inventory is calculated at period end by dividing the running total of the quantity on hand plus the current quantity on hand by the number of periods.

Formula: (A + B) / C = D

  • A = The running total of the quantity on hand
    The quantity on hand for the prior period is added to the accumulated quantities on hand for all the prior periods for the year. The current period is not included.
  • B = The quantity on hand for the period just closed
  • C = The period last closed (in other words, for period 5, C = 5)
  • D = Average inventory

Example:

  1. Inventory is in period 1, and a new item is created. A receipt for 50 of the items is processed.  Then I/M period end is performed. When period end was performed, the quantity on hand was 50. The calculation for Average Inventory is: (0+50)/1=50
    Note: A=0 (Prior total); B = 50 (0 + 50); C = 1; D = 50.
  2. In period 2, another receipt for 75 of the items is processed. Then I/M period 2 is closed. At the time of period end, the item’s quantity on hand is 125. The calculation forAverage Inventory is: (50 + 125) / 2 = 87.5
    Note: A = 50 (0+50); B = 125 (50+75); C = 2; D = 87.5
  3. During period 3, another receipt for 100 of the items is processed, and then period 3 is closed. The current quantity on hand is 225. The calculation for Average Inventory is:  (175 + 225) / 3 = 133.3
    Note: A = 175 (0+50+125); B = 225 (125+100); C = 3; D = 133.3
  4. In period 4, a sales transaction for 150 of the items is processed, and then period 4 is closed. The current quantity on hand is 75. The calculation for Average Inventory is: (400 + 75) / 4  = 118.7
    Note: A = 400 (0+50+125+225); B = 75 (225-150); C =  4; D = 118.7
  5. In period 5, a receipt for 50 of the items is processed, and then period 5 is closed. The current quantity on hand is 125. The calculation for Average Inventory is: (475 + 125) / 5  = 120
    Note: A = 475 (0+50+125+225+75); B = 125 (75+50); C = 5; D = 120

Notes: The Average Inventory is stored in the IM2 file in field 28 (Avg on hand Qty), which is calculated at period end. Each time period end is processed, this field is updated in the following way:
(Avg on Hand Qty in IM2 * Previous Period) + (Current Qty on Hand ) / Current Period.
For step 5 (before running Period End for this period), the Avg Qty on Hand in IM2 was 118.7 (as determined at the end of step 4). When running Period End for period 5, the calculation is as follows:
(118.7 (Avg On Hand Qty) * 4 (Previous Period)) + (125 (Current Qty on Hand)) / 5 (Current Period) =
(474.8 + 125) / 5 = 119.96 (which is rounded to 120)

From the Sage Knowledgebase.  If you have any questions please contact our support team as DSD Business Systems

Share
© 2010 DSDtips.com Suffusion WordPress theme by Sayontan Sinha