RGCI - Accounting Year End Tips Tricks in Unanet

As the year comes to an end, there are some additional considerations and setup items that need to be completed. Unanet is a comprehensive accounting system that offers clear procedures for closing on the Support Site. Every company is different, therefore, we at Redstone GCI wanted to provide a checklist and a few links to the Unanet Support Site to help guide you through the Year-End Process smoothly and efficiently:

Year End Considerations:

  1. Month End Checklist
  2. Administrative (Unanet) Updates
  3. Financial Updates and Year End Closing
  4. On Premises Considerations
  5. Project Dashboards for 2023
  6. GL Budget for 2023

Month-End Close (Support Site Month-End Close)

  1. Update procedure for any changes in process throughout the year
  2. Ensure that each month is properly documented for 2022
  3. Address any reconciling items (if any)
  4. Check source records for completeness of attachments (bank statements, vendor invoices, etc.)

Year-End Checklist (Support Site Year-End Close)

  1. Add next fiscal year
  2. Create new holidays and assignments
  3. Roll over accrual plans (if necessary)
  4. Set up Custom Time Periods (if necessary)
  5. Person profile audit of location, PTO, rates, other UDFs, etc.

System Admin Checklist

  1. Clean & update saved shared reports
  2. Review scheduled items and make necessary updates (reminders, accrual postings, project alerts, etc)
  3. Review and update project set up templates
  4. Update person cost rates for pay increases
  5. Review “Active” users for any that should be “Inactive”
  6. Review Assignments on internal projects (Training, B&P, etc.)
  7. Review Accruals and remind employees of “Use It or Lose It” policy
  8. Import new Per Diem rates and update mileage rates if you haven’t done so already
  9. Add next year financial budgets (GL or Labor & Expense)
  10. Add next year indirect rates into cost structures
  11. Update Cost pools for next fiscal year
  12. True-up indirect rates
  13. Incurred Cost Electronically/Incurred Cost Submission (ICE/ICS)
  14. Update any recurring annual journal entries (Rent payments)
  15. Gross Salary reconciliation to Payroll journals
  16. Check Purchase Order Status Report for any processing necessary
  17. 1099 activities/Print off 1099 info
  18. Fiscal period close
    1. Once a Fiscal Year has been closed it CANNOT be reopened
    2. Fiscal Periods for a Fiscal Year CANNOT be reopened
    3. Only the Unanet Administrator can post into a closed Fiscal Year.
      1. If entries made to a closed fiscal year affect revenue or expense account balances for the closed fiscal year, the year-end closing entry will be made for the document as part of the posting process for that document.
      2. To close a Fiscal Year, all posting features for all the individual periods in the year must have been previously closed.

Looking Forward

  1. Setup your My Reports & Shared Reports Dashboard for 2023
  2. What process improvements do you want to make for 2023?
  3. Are you using Unanet to its capability to make your life easier?
  4. Start thinking of creating your GL Budget for 2023
    1. This step is key where the P&L Report can show budget versus actuals. If the GL Budget is setup, companies can perform indirect rate calculations based on GL Budgets to forecast indirect rates for the year. (Stay tuned for more information on GL Budgets coming early 2023)

We hope this checklist helps you prepare your accounting system for the end of 2022, guiding you through the essential steps to closing 2022 with Unanet. Our Unanet experts are always here to offer additional help as you utilize Unanet and can offer consulting and training options to make sure you are getting the most out of your investment. Reach out to us to make your year-end process or any Unanet functions run smoother for your department and company.

Written by Katie Donnell

Katie Donnell Katie is the Unanet Practice Lead at Redstone Government Consulting, Inc. based in our Huntsville, Alabama office. Her areas of expertise include supporting government contract businesses with a special focus in DCAA-compliant Unanet Time and Expense Tracking, Project Portfolio and Financials. QuickBooks, and Deltek GCS. Katie is a QuickBooks ProAdvisor, Certified Unanet Systems Implementer and has completed the Unanet Advanced Project Management training. Katie was one of the first Unanet Certified Implementers and was part of the initial pilot offering to non-Unanet consultants. As part of her certification process, Katie invested over 300-hours of instruction, out of class database development time and testing to obtain her certification. Since certification, Katie has assisted numerous Redstone GCI clients with implementation and post-implementation support services. Katie is frequently called upon by Unanet to join their implementation teams as an external resource and is considered a subject matter expert in the implementation of all Unanet software offerings. In her role with Redstone Government Consulting, Inc., Katie not only provides software systems expertise, but also frequently assists clients with preparation and support of DCAA audit activities including SF1408 pre-award accounting system audits, provisional billing rate submission, development of forward pricing rates for proposals, incurred cost submission preparation and development and design of policies and procedures necessary to support an adequate (DCAA-approved) accounting system. Katie serves as the primary point of contact for many small business clients in government cost accounting/compliance and assists monthly with the close of those contractor’s accounting systems and reporting to program management and executives. Her industry experience, software systems expertise and compliance knowledge provides a rare combination of knowledge to clients looking for a consultant to become an integral part of their team. Professional Experience Prior to joining Redstone Government Consulting, Inc., Katie worked in public accounting as well as small to mid-sized government contractors. She has prior operational experience with the many types of software such as Unanet, Deltek GCS, QuickBooks, SpringAhead, Deltek T&E, ADP, Paychex, and QB Payroll. Education Katie earned a Bachelor of Science degree in Accounting from The University of Alabama in Huntsville in 2010, where she was President of Beta Alpha Psi (an honor organization for finance and accounting students and professionals). She received her Master of Business Administration (MBA) from The University of North Alabama in 2014, graduating Cum Laude. Decades of Consulting, Training and Helping Government Contractors Succeed Redstone GCI offers a variety of services for large and small government contractors including evaluation, education and training, monitoring and DCAA audit preparation. Through our consulting and training programs, government contractors develop and learn to maintain compliance processes that help them succeed by mitigating risk and maximizing profitability. Our consulting team is comprised of senior leaders from government agencies and industry executives creating balance and an informed approach to our client services. Our services span the entire government contract lifecycle from proposal assistance, accounting, audit readiness, purchasing, project controls, contract administration, system implementation through to contract closeout. We specialize in preparing contractors for growth through our deep knowledge of common pitfalls companies face as they progress from small business in CAS, DFARS Business Systems and other common gates to contractor growth. In addition to almost 30 full-time consultants we also maintain a trusted network of independent contractors and other service providers who work with our team on specialized areas like ITAR, facility security, EVMS and other areas.

About Redstone GCI

Redstone GCI is a consulting firm focused on fulfilling the needs of government contractors in all areas of compliance. With a singular mission to help contractors through the multiple layers of “red tape,” we allow contractors to focus on what they do best – support their mission with the U.S. Government. We are home to a group of consultants made up of GovCon industry professionals, CPAs, attorneys, and retired government audit and acquisition professionals.

Our focus and knowledge of audit and compliance functions administered by DCAA and DCMA will always be at the heart of what we do. However, for the past decade, we’ve strategically grown to support other areas of the government contractor back-office with that same level of focus and expertise. We’ve added expertise in contracts management, subcontract administration, proposal pricing, various software systems, HR and employment law, property administration, manufacturing, data analytics/reporting, Grant specialists, M&A, and many other areas. When we see a trend in the needs of contractors, we act to ensure we can provide the best expertise in the market to fulfill those needs.

One thing our clients can be certain of is that with the Redstone GCI Team in your corner, there is no problem too big and no issue too technical for our team to tackle.

Topics: Unanet