Month End Close

MONTH END CLOSE PROCESS

When Using

Deltek Vision’s Revenue Generation

 

Daily Processing & Posting Steps

  1. Post Invoice Files – NOTE:  this is critical
    when scheduling Revenue Generation (Do not leave un-posted invoice files overnight)
  2. Post Accounts Payable Files (Vouchers, Cash Disbursements
    or A/P Disbursements)
  3. Post Cash Receipt Files
  4. Post Unit Files
  5. Post Expense Reports Files
  6. Post Journal Entry Files

Weekly Processing & Posting Steps

  1. Post any A/P, CR, Unit, Expense or JE Files not already
    posted
  2. Post Timesheets (this assumes you are on weekly 7 day
    timesheets)
  3. Run Revenue Generation (REV GEN) – From Saved Favorite
    (See my blog on Rev Gen)
  4.  Run Adjusted Salary Cost (if using)  (See my blog on ASJC )
  5. Run Labor Cross Charge (if using)
  6. Compare Project Sub-Ledger to General Ledger – Run Project
    Earnings Report with Activity set to “Current” on the Activity Tab.  Select Current Labor Amount Cost, Current Expense Amount Cost, Current Revenue, Current Profit on the Columns Tab.  In the selection criteria set Charge Type Code = R.  Note:  Active Only UNCHECKED.

Reporting

  1. Run a standard income statement and compare to Project
    Earnings:  Current Revenue = Revenue, Current Profit = Gross Margin, Current Labor Amount Cost = Direct Labor, Current Expense = Reimbursables + Other Directs.
  2. Review All Sub-ledgers to confirm they agree with General Ledger:  Total Aged AR = Balance Sheet Account, Unbilled Receivables from Project Earnings = Balance Sheet Account, Unpaid Payables = Balance Sheet Account & Unpaid Expense Reports = Balance Sheet Account.  Balance Sheet Accounts
    must be those assigned in Configuration.

 

Monthly Processing & Posting Steps

  1. Complete ALL Weekly Processing & Posting Steps
  2. Open New Period
  3. Immediately Close Old Period
  4. The Controller should have access to create and post journal entries in a prior and closed period.
  5. All other users should be by Security locked into the New & current period to avoid errors.
  6. Any other Key Reconciliations can be completed including bank rec’s if desired.
  7. ONLY indirect (overhead) expenses should be posted into the prior now closed period.
  8. Adjust AP Vouchers – When errors were made, you can adjust AP Vouchers so that the correction remains attached to the original.  See “MANUALAP VOUCHER ADJUSTMENT” file.
  9. Recurring Journals like Depreciation etc. can be posted anytime throughout the month, but if not done post now.
  10. Review Financials for any necessary adjustments.  Note:  Anything
    above Gross Margin line should be done in the new period, the old period should
    not be touched except for Indirect Expense entries.  (See my Blog Accounting 101)

Leave a Reply

Your email address will not be published. Required fields are marked *

1 × 1 =