USAS Calendar Year-end Closing Checklist
This procedure outlines the steps to be taken to close USAS for the calendar year.
NWOCA 1099 Printing Deadline
Friday, January 24th, 2025
1099 reprints are $5.00 each.
Pre-Closing Procedures
The following pre-closing procedures can be completed any time prior to closing the calendar year.
Click on edit beside IRS Form 1099 Submission Configuration
Make sure 'District will Submit 1099 File to IRS' is checked
Enter your IRS issued Transmitter Control Code for the district
Enter DISTRICT Contact Name, Phone (no dashes) and Email
Enter the Job Parameters as desired
The ‘Approved for the combined Federal/State Filing Program’ check box should only be checked IF you have submitted a test file and have received an approval letter from the IRS.
Under 'Type 1099' filter by <> non 1099 to query all 1099 vendors. You can then use the YTD Taxable Total to filter on amounts (i.e. >=600).
YTD Taxable Total amount greater than or equal to 600
YTD Taxable Total amount less than or equal to 600
If Vendors do not have a Tax ID Type or Id#, use the edit on the vendor grid beside the vendor to update the record to include this information.
If needed enter Vendor Adjustments to Correct YTD Taxable Total amounts.
If the YTD Taxable Total needs to be updated for a vendor (Void Prior FY Check, Royalties, combining Vendor records) the Vendor Adjustments option can be used to modify the YTD Taxable Total and YTD Total fields.
The Vendor Adjustments option can be found by clicking the View icon on the Vendor. The amount can be entered as positive or negative to increase or decrease the totals.
Make sure the 'Taxable' check box is marked in order to update the YTD Taxable Total.
For more information see the Vendor Adjustments section on the Vendors page
If there are numerous Vendor Adjustments to make you may also use a spreadsheet to Import them. For more information and a template spreadsheet see the Add Vendor Adjustment Criteria section on the Vendors page.
Under Type 1099 enter Non 1099 and on the YTD Taxable Total enter <=600
If Vendors are marked as "Non 1099" but should be receiving a 1099, update the Vendor's Type 1099 field, Tax ID Type, and Tax ID # and verify the Name and Address marked as the 1099 Location.
By default, the report includes all 1099 types. You have the ability to include all 1099 types regardless of YTD amounts or those meeting the IRS requirement. You may also run the report for specified 1099 Types (i.e. royalty payments)
Month-End Closing
Perform Bank Reconciliation Procedure.
Under the Periodic menu, select 'Cash Reconciliation' to enter your cash reconciliation information for the month
The SSDT Financial Detail Report may be run for the month only to compare MTD totals to the Cash Summary Report.
Compare the totals from reports... they should match with the exception of encumbrances.
Encumbrances on these two reports may not match.
Cash Summary picks up total encumbrances (including carry-over encumbrances).
Financial Detail Report picks up encumbrances for the current fiscal year.
If all above steps are performed and totals all agree, you are in balance and may proceed with the next step.
Monthly CD Report Bundle
The Monthly CD Report Bundle is now available and will automatically run when the Posting Period is closed. The bundle includes 24 SSDT Template reports. A list of reports can be found here. Reports can be found in File Archive under the Utilities menu.
Calendar Year-End Closing
If you are in January processing and want to generate reports containing prior year calendar year-end amounts, the account-based reports have an "As of Period"
“As of Period” INFO
This parameter is relevant to account-based reports. The as of period parameter will return amounts as of a specific period (ex. FYTD or MTD totals), but will not limit transactions on accounts. If using with a report that is transaction-based, this parameter will need to be used in combination with Start and Stop dates to filter the transactions that are included.
You also have the ability to temporarily change the current period to December. Once you are finished running your reports, you may switch the current period back to January.
If a Posting Period is re-opened, the Monthly CD Bundle will automatically run again when the period is closed. If a monthly report bundle already exists in the archive a second copy of the reports will be added to the existing Monthly CD reports. To avoid this, delete the first Monthly CD Reports bundle before re-closing the reopened posting period to prevent duplicate copies of reports from being stored for that month OR disable the Monthly CD Reports bundle prior to re-closing the posting period to retain the original reports. Currently, you cannot delete individual reports from within a monthly archive.
Turning off Report Bundle
If you do not want the bundle to run for the period you are closing, navigate to the Report/Report Bundle and disable the bundle by clicking the checkbox to unselect the checkbox. This will prevent the bundle from automatically running when a posting period is closed. Remember to re-enable when you are finished closing.