Requirement From Balaji Wireless

Based on the information provided, here are some requirements and suggestions for integrating NetSuite (NS) and Utility Provider -SCE:

Vendor Billing Integration

• Implement a seamless integration between NetSuite and utility provider SCE to automate the billing process for utility services.
• Ensure that utility charges, including electricity bills and user service fees, are accurately calculated and recorded in NetSuite.

Automated Billing Workflow

• Develop a workflow within NetSuite to generate vendor bills for utility charges from SCE.
• Configure the integration to automatically pull billing data from Utility provider-SCE and create corresponding vendor bills in NetSuite.

Payment Processing

• Implement functionality to process payments to utility provider-SCE from NetSuite.
• Ensure that payments are accurately recorded and reconciled in NetSuite upon confirmation from SCE.

Billing and Accounting Consolidation

• Ensure that the integration facilitates easy management of billing and accounting processes within a single platform.
• Provide a unified view of financial data, allowing for streamlined reporting and analysis.

 

Deliverables

We have reviewed the requirement thoroughly and please find below the deliverables we propose.

·        Integration between NetSuite and Utility Provider SCE for automated utility billing and payment processing.

·        Custom records and fields in NetSuite to capture utility billing details.

·        Automated workflows for generating vendor bills and processing payments.

·        Reports for tracking utility expenses and payments.

NetSuite Set up.

To create different tenants, utility invoicing, and other relevant entities in NetSuite, you would typically utilize NetSuite’s customization features and built-in record types. Here’s how you can create these entities:

 

Utility Providers

Utility Providers will be created as a vendor record in NetSuite. We need to fill in the details such as name, address, contact information, etc. We can also create custom fields to capture additional information about utility providers. Utility invoices can be represented as vendor bills in NetSuite if you’re receiving invoices from utility providers.

 

 

Bill Payments to Utility Provider

• Enter bills received from utility providers into NetSuite, specifying the amount due and the billing period.

·        Utilize NetSuite’s payment features to process payments to utility providers either manually or through automated payment methods such as ACH or checks.

Tenants

We will create tenants as customers in NetSuite corresponding to tenants. Fill in the required information such as name, address, contact details, etc. We can also create custom fields to capture additional tenant-specific information.

Meter Readings:

Meter readings can be tracked using custom records or custom fields within the lease or tenant records. We will create custom fields to capture meter readings and associated details. NetSuite User need to update the meter readings periodically.

 

 

Set Up Solar Usage Items:

Create new items in NetSuite to represent solar usage or related charges. These items could include “Solar Energy Usage,” “Solar Panel Rental,” or any other applicable charges. We need to create the necessary items with appropriate pricing and descriptions.

Create Billing Rules:

If your solar usage charges vary based on specific criteria such as usage levels or time periods, we can set up billing rules in NetSuite and define the rules for calculating solar usage charges. When generating invoices for customers, include the solar usage items along with any other applicable charges.

·        Add line items for solar energy usage or related charges to the invoices, specifying the quantity and rate based on the billing rules or agreements.

·        Calculate the amount to invoice customers by subtracting the previous meter reading from the current reading and multiplying by the agreed-upon rate.

Billing to Tenants:

We need to configure billing schedules and items in NetSuite to handle recurring billing for tenants.

·        Define billing schedules for recurring charges such as rent, utilities, etc.

·        Set up billing items to represent different types of charges that tenants may incur.

·        Send invoices to customers via email or mail, depending on your preferred communication method.

 

Buildings Sites in NetSuite

We will define custom segments in NetSuite to represent the physical sites where our solar installations are deployed.

·        Create custom segment records for each building or property where solar panels are installed.

·        Include address details, site-specific information, and any relevant identifiers.

Accounts:

·        Configure accounts in NetSuite to track financial transactions related to your solar installation business.

·        Create income accounts for revenue generated from solar installations and services.

·        Set up expense accounts for costs associated with purchasing materials, paying vendors, and other operational expenses.

 

Price Lists:

·        Create price lists in NetSuite to establish pricing structures for your products and services.

·        Define price levels based on customer segments, contract terms, or other criteria.

·        Associate price lists with customers to ensure accurate pricing during sales transactions.

Handling the ownership transfer of tenants in a building with solar panels installed involves updating the relevant records and agreements to reflect the change in tenant responsibility for solar energy usage and billing. Here’s how you can handle the ownership transfer of tenants in NetSuite:

Meter Ownership Transfer

When ownership of a tenant is transferred, we will create a new customer record in NetSuite for the new tenant. Include all relevant information for the new tenant, such as name, contact details, and billing preferences.

·        Review any existing billing agreements or contracts related to solar energy usage for the tenant.

·        Adjust the billing responsibility to reflect the new tenant’s responsibility for solar energy charges.

·        Revise billing terms or agreements as necessary to accommodate the change in tenant ownership.

Adjust Solar Energy Allocation:

·        Recalculate the allocation of solar energy usage charges for the tenant unit based on the transfer of ownership.

·        Ensure that solar energy charges are allocated to the new tenant rather than the previous tenant.

 

 Generate New Invoices:

Generate new invoices for the new tenant reflecting the updated solar energy charges and billing terms. Create and send invoices to the new tenant for their share of solar energy usage using NetSuite’s invoicing features.

Storing Transfer Details:

We will create child records for each Meter reading custom record in NetSuite.

·        Maintain records of the ownership transfer within NetSuite for audit and tracking purposes.

·        Document the date of the transfer, the parties involved, and any relevant details or agreements related to the transfer.

By creating separate customer records for each tenant and adjusting billing and usage allocation accordingly, we can effectively handle the ownership transfer of tenants in a building with solar panels installed while maintaining separate utility history records for each tenant. Ensure that all records and agreements are updated accurately to reflect the change in tenant ownership and billing responsibility for solar energy usage.

Utility Provider SCE- NetSuite Integration

Billing Sync from Utility Provider SCE to NetSuite

We can set up a scheduled integration process to fetch billing details from utility provider and create vendor bills in NetSuite.

Payment Sync from NetSuite to Utility Provider

We will be fetching all the payments from NetSuite and transfer it to Utility Provider.

Assumptions

The utility provider’s API is available, well-documented, and reliable.

The API endpoints required for billing, payment processing, and meter readings are stable and provide consistent responses.

All required data points accessible via the API.

Necessary API credentials (API keys, tokens, etc.) will be provided and securely managed.

Necessary custom fields and records can be created in NetSuite without significant limitations.

The volume of data to be exchanged is within acceptable limits for both NetSuite and the API.

The billing data provided by the utility provider is accurate and complete.

Custom fields required for capturing billing and payment details can be added to NetSuite without impacting existing processes.

The mapping of API response fields to NetSuite fields will be straightforward

Scope Limitations

The details mentioned above in the document are only considered in the scope of the integration and any new cases or API additions other than those mentioned in the document will be considered as a different scope of the integration and additional effort will be required for analysis and development.