SEP outsource accr

Overview of the Outsource Accrual and Billing Process

  • The meeting focuses on reviewing the outsource accrual process and the related billing concerns.
  • Key personnel involved in the discussion include the speaker (not named), Karen, and Joey.
  • The objective is to clarify the current status of the accrual and to ensure accurate billing.

Key Steps in the Accrual Process

  • Review of the outsource accrual spreadsheet from November.
    • The spreadsheet contains items highlighted in yellow for items not yet identified, alongside amber-colored entries.
    • A new spreadsheet was created to isolate and examine these entries.
  • Organization of data based on customer and project number.
  • Instructions provided to refresh data and download raw data for selected items.

Data Organization and Corrections

  • Emphasized the importance of categorizing entries appropriately.
    • Yellow entries signify items which will remain in the current account, while amber ones may need to be resolved or cleared out.
  • Specific operations discussed to correct previous accounting errors.
    • Identification of items previously cleared but mistakenly reinserted into the system.
  • Importance of ensuring data integrity from previous months, particularly September and October.

Detailed Item Review

  • Active discussion around specific line items causing discrepancies.
    • Analysis of billing performed in different months than the accrual period, particularly focusing on items billed in December but stated as released in November.
  • Importance of tracking invoiced items accurately.
    • Noted a systematic error where certain entries did not match what should have been recorded, leading to confusion in reporting.
  • The discussion involved navigating records in the NetSuite system for checking invoices, sales orders, and purchase orders.

Financial Accountability and Reporting

  • Emphasis on the necessity of understanding how to classify negative balances accurately.
    • Previous miscalculations were acknowledged, with corrective actions identified for the future.
  • Concerns were raised regarding the rolling balance strategy of the outsource accrual. Suggested that this could cause miscommunication regarding billing periods.

Challenges with Billing and Costs

  • Discussion on the complexities of reconciling costs against billed amounts and ensuring they are accurately reflected in the financial reporting.
  • Enquiries posed about the accuracy of sales orders and linkage to General Ledger (GL) accounts.
    • Notably, issues surrounding missing repair service entries in billed invoices were examined.

Process Improvements and Communication

  • Suggested strategies for enhancing current workflows and processes to prevent future issues.
    • Importance of transparency in communication with team members about errors found in earlier periods.
  • Recommendations made to involve Jay for further clarifications and to streamline the understanding of the recording process.
    • Consideration of reaching out for support to address unresolved items in accounts before the closing of December.

Visual and Organizational Management of Data

  • Utilization of color coding to manage project statuses effectively.
    • Yellow for items to be accrued, light red for costs moving to the cost of goods, and green for items already cleared/processed.
  • Reminder of how to maintain a systematic approach to visually manage entries in a shared spreadsheet.

Conclusion and Action Items

  • A consensus on the need for a comprehensive plan to address these discrepancies before the next billing period.
  • A plan was made to draft a formal inquiry to Jay for assistance in resolving outstanding issues.
  • Responsibility assigned for further review of commission calculations to ensure no overpayments are made due to misclassified costs.
  • Clarification on the urgency to proceed carefully, avoiding multiple touches on the dataset until certain clarifications are received.

Additional Notes

  • Importance of keeping detailed notes and tracking changes in the system and entries made.

    • Consistent communication amongst team members is essential for managing the outsource accrual and related billing complexities.
  • Strategic planning for future reporting and possible adjustments based on findings from the current review process.