NetSuite | Red Nucleus - Discovery / Personalization Workshop: Overflow Session: Project Management & Cost Management | Session 3

  • Completed Project Cash Part One last week, which involved the detailed review of financial performance and resource allocation.

  • An overflow session is scheduled to finalize discussions on Project Cash today, aiming to address any outstanding questions and ensure alignment among team members.

  • There is an upcoming session on the 25th, focused on discussing ordering cache mechanisms, which will improve the efficiency of inventory management.

  • The session will cover crucial aspects such as billing methods utilized across different projects and detailed revenue recognition strategies, which are essential for accurate financial reporting and planning.

Project Cash Overview

  • The earlier discussions regarding time and expenses laid the groundwork for understanding project profitability and cost management.

  • Today's session topics include:

    • Billing methods: A comprehensive overview of how various billing methods impact project cash flow.

    • Revenue recognition: A look into the principles that guide when revenue is acknowledged in financial statements for accurate reporting.

  • In SGP (System for General Projects), each project is uniquely configured with:

    • Billing rules tailored at the project level to ensure proper invoicing.

    • Revenue recognition rules that dictate how and when revenue is recorded for financial reporting.

Billing Rules

  • The designated billing rules play a critical role in determining the charges for invoices issued in the SPP.

  • Invoice Process:

    • Once billing rules are established, all charges generated will automatically appear on corresponding invoices.

    • Invoices must go through an approval process in SPP to maintain accuracy and compliance before they can be exported to the NetSuite ERP system.

    • Payments received on these invoices are documented in NetSuite, which seamlessly syncs back to SPP ensuring that payment statuses are accurately logged and tracked.

Revenue Recognition Rules

  • These rules dictate the creation of revenue recognition transactions, which are subsequently exported as journal entries to NetSuite for accounting purposes.

  • Key Questions:

    • No inquiries arose regarding the mechanisms of these processes during the overview, indicating a potential area for further clarification in future sessions.

Credit Card Transactions Discussion

  • There was a focused discussion regarding the integration of credit card transactions into the NetSuite platform:

    • Credit card transactions are directly imported into NetSuite from the banking institutions your organization uses.

    • Personnel involved in these processes expect that transactions will auto-generate corresponding expense reports in the SPP to streamline workflow.

    • These transactions are associated with specific users based on their credit card details to maintain accountability and accuracy.

    • A comprehensive list of banks that can integrate with the system was requested, with known options being American Express (Amex) and Bank of Montreal Mastercard.

    • There is consideration of transitioning to US Bank, contingent on the provision of superior integration features.

Integration Between Systems

  • Currently, Amex is the only bank with a native feed integrated into the SPP system; the methods of integration with other vendors vary and require further confirmation.

  • Clarification is still pending on what type of record is created during credit card feeds:

    • Specifically, it is crucial to determine whether these processes generate a credit card transaction record, an expense report, or both to ensure proper accounting practices.

    • It is vital to identify the records that flow natively between the ERP and SPP systems to maintain data integrity across platforms.

Expense Reports and Purchase Orders

  • Expenses incurred will be logged in NetSuite, incorporating specific PO details to enhance traceability.

  • Different types of billing, including purchase orders or vendor bills, will be managed within NetSuite and subsequently exported to SuiteProjectsPro (SPP) for comprehensive reporting.

  • Rebilled Items:

    • It is a common practice to bill clients for various contractor-associated expenses to ensure businesses remain cost-neutral.

    • Additionally, there is a need to discuss how honoraria payments will be processed through accounts payable (AP) to streamline these transactions.

Markup on Expenses and Subcontractor Time

  • Markup on Certain Items:

    • Typically, markups do not apply to pass-through expenses, thereby ensuring transparency in client billing.

    • Markup is primarily applicable for costs related to subcontractor services to cover overhead and profit margins.

    • It is noted that subcontractor time may not incur additional markup depending on the specific contractual agreements in place.

  • Every logged expense must be linked to its respective project, regardless of whether it is marked as billable; this tagging will determine the visibility of costs in future billing.

Customer Billing Methods Discussion

  • A detailed clarification of the various billing methods was undertaken:

    • Common Methods:

      • Fixed fee

      • Upfront fixed fee

      • Milestone-based billing

      • Time and materials (T&M)

      • Retainers

      • Subscriptions and licenses

  • There arose a need for clarity concerning pass-through billing, which was not encompassed in the initial enumerations; this billing method is handled separately due to its unique nature.

Fixed Fee Billing Scenarios

  • Regularly recurring fixed fees:

    • It is imperative to ensure that billing occurs in a timely manner, reliant on date-driven invoicing at scheduled intervals, whether monthly or quarterly.

  • Milestone Billing:

    • Milestones are not solely based on time but should be validated through confirmation from project managers to ensure accountability and accuracy.

Retainer Projects

  • Definition:

    • It is essential to delineate specific work and funding associated with retained amounts (e.g., $1 million budgeted over a year) to maintain financial control.

    • Each engagement will be thoroughly scoped out and require client approval as projects unfold, ensuring stakeholder involvement throughout the process.

Project Ownership and Team Dynamics

  • Projects may involve multiple owners depending on their complexity. Currently, the system allows only one owner per project in SPP, but ongoing discussions aim to evaluate the necessity of expanding this to enhance collaboration.

  • Visibility:

    • Best practices suggest that all project managers should maintain visibility over all projects to foster collaboration and resource sharing across teams.

Revenue and Profitability Measurement

  • Project-based profitability accounting:

    • This method involves calculating income against costs associated with specific projects. Furthermore, different task types can generate varied General Ledger (GL) impacts requiring careful management.

    • Direct costs attributable to projects need to be linked back effectively, along with employing an allocation strategy for indirect costs including overhead expenses for comprehensive financial management.

    • Questions regarding real-time revenue tracking and the ability to predict future project profitability were also raised, highlighting a significant area for enhancement in reporting tools.

Final Notes on Service Items and Billing Practices

  • Service items are consistently managed within NetSuite and exported to SPP for systematic tracking and analysis.

  • An understanding of how services, items, and lines interrelate was clarified, thereby ensuring that project tasks correspond to the appropriate services defined within sales orders for accurate billing and reporting.

Conclusion

  • The discussions surrounding project management cover a vast array of topics, from expense control, various billing methods, to the integration of financial management systems like NetSuite and SPP.

  • Action items have been noted to further clarify vendor integrations, milestone billing practices, definitions of retainer projects, and enhancing visibility dynamics, paving the way for improved discussions and successful implementations in the future.