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.