COST OF ROADS SPREAD

DESCRIPTION: This program will calculate your Cost of Roads and spread the results to your general ledger with a source of entry of COR.

========================================================

 

To start, click the GENERAL LEDGER button on the Main Screen , then click the COST OF ROADS SPREAD button.

 

 

1. ACCOUNT LEVEL TO SPREAD TO: 

Enter the account level (from 5 to 7) to have your cost of roads spread to.

 

2. PERCENT TO SPREAD: 

Enter the percentage you want to spread.

(You will get this percentage from your completed ACT-51 report.) The percentage should be entered as a whole number with a decimal point for tenths of a percent. In our sample, we’re spreading 1.7644%.

 

3.  LOW ACCT 3/HIGH ACCT 3: 

Enter the low and high Account Level 3 numbers you want to spread the percentage to.

 

You may use a range of account numbers, or you may enter the same account number in the low and high fields to spread to only one account.  Continue entering low and high account number levels to fine-tune the spread. (Acct 4-7)

 

4.  YEAR START DATE/EFFECTIVE DATE:

Enter your fiscal year start date and the effective date for this spread (typically last day of fiscal year, unless you run this monthly.)

 

 

5. When you’re ready to proceed, click OK. 

6. To return to the Main Screen without spreading Cost of Roads, click CANCEL.

 

After clicking OK, the following confirmation message will be displayed:

 

Click OK and make a note of the journal number being created.  If any of the information displayed is erroneous, click CANCEL to stop the Cost of Roads Spread

 

 

After the debits have been spread, you will see a message similar to the following:

 

 

 

BALANCING THE COST OF ROADS SPREAD ENTRIES

The Source of Entry "COR" (Cost Of Roads) will contain only debit entries. In order to balance, you will need to run GL Post to post the credit entries.

 

1. Run GL Post and enter the same effective date as you used in the Cost of Roads Spread program (Ex:12/31/2015)

 

2. Use the source of entry COR, and enter the journal number the Cost of Roads Spread program created (Ex: 56).

 

3. Click OK, and the Cost of Roads Spread detail will be displayed on the main posting screen.

 

 

4. At this point, if you need to make any adjustments to the amounts debited to any of the entries listed, highlight the entry needing adjustment and click the EDIT button to change the amount. Click the SAVE button  to save your change.

 

5. Finally, post the credit, then click the COMMIT button   to save the journal.