Hands-on Salesforce Billing implementation project.

Salesforce-Billing-Implementation-with-Hands-On-Project

Get Started with Salesforce Billing Implementation with Hands-On Project

This Comprehensive document helps you to Get Started with Salesforce Billing with images for each step to give you 100% clarity.

Document Structure

  1. How Salesforce CPQ and Billing Fit Together.
  2. How to Setup Salesforce Billing Developer Org
  3. Setting Up Accounting in Salesforce Billing
  4. Building Blocks of Salesforce Billing
  5. Project Implementing Salesforce Billing for T-Mobile in Different Regions (UK, US, India)
  6. Step by Step Implementation
  7. Interview Questions

img80

This diagram shows each stage in the Salesforce CPQ and Billing process showing the complete Lead to Payment Process (QTC).
1. First step starts from Lead getting generated. It is potential customer who is interested in the product or service.
For Example, you go to T-Mobile’s website and fill out a form showing interest in a new mobile plan.

img82

2. When the lead is qualified. It means that looks like customer is serious about buying the product or service then lead is converted into Account, Contact, Opportunity.

img83

3. Based on the opportunity, a quote is created to offer the potential customer a formal proposal.

img85

4. Quote line is a line item in the quote that details individual products or services and their pricing.

img86

5. Once the customer accepts the quote, an order is created.

img87

6. Each product or service from the order is linked to an order product.

img89

The order product refers to the specific products or services being purchased as part of the order.

img90

7. The order is linked to a contract that outlines the terms and conditions.

img92

img93

8. An invoice is a bill that the customer receives, requesting payment for the products or services. After the order is processed, an invoice is generated.
For example, T-Mobile can send an invoice to the customer for the first month’s charges on the data plan.

img94

9. Invoice lines are individual items on the invoice that break down the charges.

img96

Each order product is reflected as an individual line item on the invoice.

img97

10. Once the customer pays, the payment is recorded in the system.

img99

img100

11. Payment allocation is the process of applying the payment to the specific invoice lines. The payment is allocated to settle each of the charges on the invoice.

img102

How to Setup Salesforce Billing
Developer Org

Go to the Link and fill out the sign-up form.

img103

It will take you to the installation page. Once Installation is complete, new org will get created with Salesforce CPQ and Salesforce Billing Packages.
Go to Setup->Installed Packages to view it.

img106

You will be able to see Salesforce CPQ, Salesforce Billing in the App Launcher
Where

img107

Where Salesforce Billing Begins

Before we can even start using Salesforce Billing, these foundational steps need to be set up.
• Legal Entity
• Finance Book and Finance Period
• GL Account, GL Rule, GL Treatment
• Tax Rates, Tax Rule and Tax Treatment
• Billing Rule and Billing Treatment
• Revenue Recognition Rule and Revenue Recognition Treatment

Object Data Model

img109

Understanding the Building Blocks of Salesforce Billing

In this section, let’s break down the key building blocks before moving to implementation stage.
1. Legal Entities
A Legal Entity represents a company or a part of the company that has legal standing in a specific region. This separation is crucial because each country has its own legal and financial requirements. It is the starting point where Salesforce Billing Starts.

For Example, T-Mobile USA is a separate legal entity in the United States. T-Mobile India operates under Indian laws as its own legal entity.

img111

2. Finance Books and Periods Finance Books are like financial diaries that organize and record all financial transactions. Finance Periods are specific timeframes (like a month or a quarter) during which these transactions are tracked.
Financial Books are of two kinds: Revenue and Accounting.
For Example, T-Mobile USA Finance Book will record all financial transactions for the US operations. T-Mobile India Finance Book will track transactions in India.

img112 img113

3. General Ledger (GL)
GL Accounts categorizes financial transactions like sales, shipping charges etc. It is generally handled outside Salesforce as part of
accounting software or ERP system. GL Credit and Debit are necessary in order to create GL Treatment.
Example Use Case of GL Account

img115

img116

GL Rules link these accounts to specific financial processes.

img117

GL Treatments are the detailed instructions on how these rules should be applied. One Rule can have multiple treatments.
For example, when a customer in the USA buys a mobile phone, the revenue is recorded under the Sales Income GL Account. If there are any shipping costs, they are recorded under the Shipping Charges GL Account.

img119

4. Tax Configuration
Tax Rates define the tax percentage applied to products or services in each region.

img120

Tax Rules determine how taxes are calculated.

img122

Tax Treatments apply these rules to specific transactions.
Example:
T-Mobile USA might apply a 7% sales tax on data plans.
T-Mobile UK might apply 20% VAT.
T-Mobile India could apply 18% GST on the same service.

img123

3rd Party Tools like Alvara, Vertex is used to calculate accurate taxation. 

5. Billing Rules Billing Rules determine how and when invoices are generated.

img125

Billing Treatments apply these rules to specific transactions.

img126

T-Mobile USA might have a billing rule that invoices customers at the end of each month for their data usage.

6. Revenue Recognition Rule and Treatment Revenue Recognition Rules dictate how revenue should be recognized (recorded) over time.
For example, you purchased T-Mobile data plan worth ₹200. Only when you have that data plan started, does T-Mobile mark that ₹200 as truly earned.

So basically, Revenue Recognition is the practice of waiting until a sale’s obligations / responsibilities are met before considering the money from that sale as earned revenue.

img128

img129

Revenue Recognition Treatments apply these rules to specific transactions. One rule can have multiple treatments.

img130

Revenue Recognition method is required to create Revenue Recognition Treatment.
In Summary:
• Legal Entities are the first thing we set up.
• Finance Books and Periods follow to organize financial records.
• General Ledger comes next to categorize and manage financial transactions.
• Tax Configuration ensures compliance with local tax laws.
• Billing Rules determine how invoices are generated.
• Revenue Recognition ensures revenue is reported accurately.

Project: Implementing Salesforce Billing for T-Mobile in Different Regions (UK, US, India)

Let’s take a small project for setup to enhance the learning.
Project Overview
T-Mobile operates in three different regions:
• United States (US)
• United Kingdom (UK)
• India

Each region has its own legal requirements, financial practices, and tax regulations. Let’s set it up in Salesforce Billing.

Brief Overview of Steps

I am giving a concise summary of the step-by-step implementation, so it is easy to understand before we deep dive into implementation.
Step 1: Set Up Legal Entities for each region
Step 2: Create Finance Books for each region
Step 3: Set Up Finance Periods for each region related to Finance Books
Step 4: Establish General Ledger

  1. Create GL Accounts for key financial activities (Sales Income, Shipping Charges).
  2. Create GL Rules that reference these GL Accounts.
  3. Set up GL Treatments within GL Rules

Step 5: Configure Tax Rates for Each Region
Step 6: Set Up Tax Rules and Treatments for Each Region
Step 7: Set Up Billing Rules and Treatments
Step 8: Set Up Revenue Recognition Rules and Treatments for each region.

Step-by-Step Implementation

This Section Covers Detailed Implementation for T-Mobile Operating in three Different regions (US, UK, India). Image is added for every single step.
Step 1: Set Up Legal Entities
Create Legal Entities for each region T-Mobile operates in.
US: T-Mobile USA

img133

UK: T-Mobile UK

img135

India: T-Mobile India

img136

Step 2: Create Finance Books
Create a Finance Book for each region:
Set the Period Type to “Accounting” for tracking invoices and payments.
Set the Finance Period Duration to “Monthly.”
T-Mobile USA Finance Book

img138

T-Mobile UK Finance Book

img139

T-Mobile India Finance Book

img141

Step 3: Set Up Finance Periods
Track financial transactions within specific timeframes.
Financial Period USA

img142

Financial Period UK

img144

Financial Period India

img145

Step 4: Establish General Ledger

  • Step 1: Create the GL Accounts (Sales Income, Shipping Charges).
  • Step 2: Create the GL Rules that reference these GL Accounts.
  • Step 3: Set up GL Treatments within the GL Rules to define specific financial processes.

Step 1: Create the GL Accounts (Sales Income, Shipping Charges).
Sales Incomeimg147

Shipping Chargesimg147

Similarly Create for UK and India.

img150

Step 2: Create the GL Rules that reference these GL Accounts.
GL Rule for USA

img152

GL Treatment US Related to GL Rule USA

img153

GL Rule for UK

img155

GL Treatment UK Related to GL Rule UK

img156

GL Rule for India

img158

GL Treatment India Related to GL Rule India

img159

Step 5: Configure Tax Rates
Apply the correct tax rates for products and services in each region.
T-Mobile USA Tax Rate (7% Sales Tax)

img161

T-Mobile UK Tax Rate (20% VAT)

img163

T-Mobile India Tax Rate (18% GST)

img164

Step 6: Tax Rule and Tax Treatment for Each Region

img166

Tax Treatment US Related to Tax Rule US

img168

Tax Rule UK

img169

Tax Treatment UK Related to Tax Rule UK

img171

Tax Rule India
img171

Tax Treatment India Related to Tax Rule India

img172

Step 7: Billing Rule and Billing Treatment for Each Region
Step 1: Create Billing Rules
Step 2: Create Billing Treatment
Set up Billing Rules that dictate how and when invoices are generated.
Billing Rule for T-Mobile USA

img176

Billing Treatment for USA Related to Billing Rule USA

img177

Billing Rule for T-Mobile UK

img179

Billing Treatment for UK Related to Billing Rule UK

img180

Billing Rule for T-Mobile India

img182

Billing Treatment for India Related to Billing Rule India

img183

Step 8: Set Up Revenue Recognition Rules
Ensure revenue is recognized accurately according to regional regulations.
Step 1: Create Revenue Recognition Rules
Step 2: Create Revenue Recognition Treatment

T-Mobile USA Revenue Recognition Rule

img186

T-Mobile USA Revenue Treatment Related to USA Revenue Recognition Rule

img187

T-Mobile UK Revenue Recognition Rule

img189

T-Mobile UK Revenue Treatment Related to UK Revenue Recognition Rule

img190

T-Mobile India Revenue Recognition Rule

img192

T-Mobile India Revenue Treatment Related to USA Revenue Recognition Rule

img193 

Set of Interview Questions

This section covers list of interview questions related to Salesforce Billing 

What is a Legal Entity in Salesforce Billing? A Legal Entity represents a company or part of a company that has legal standing in a specific region. It is necessary for managing different tax rules, billing rules, and financial operations depending on the region where the company operates.
Example, T-Mobile operates in multiple regions, such as the USA, UK, and India. They need to create separate legal entities for each region in to comply with local tax laws and regulations. For instance, T-Mobile USA would have a different legal entity compared to T-Mobile India.

img195

img197

What is the purpose of Finance Books and Finance Periods?
Finance Books organize and store financial periods, which represent specific timeframes (like a month or a quarter) during which financial transactions are recorded. This helps in keeping track of invoices, payments, and revenue recognition over time.
T-Mobile USA Financial Book.

img199

Financial Period Related to US Financial Book

img200

What is the use of Period Type in Financial books?

img202

Accounting: This is used to manage and track financial transactions such as invoices, payments, and allocations.
Revenue: This is used to track revenue recognition over the period. It focuses on the revenue generated and recognized during the specified timeframe.
For example, in case of T-Mobile If you are tracking the revenue generated from selling mobile data plans over a certain period, you would select “Revenue.”

What is the use of Finance Period Duration in Financial books?

img204

This field sets the length of the financial period, such as monthly, quarterly, or custom durations. Monthly: The financial period is set to one month. All transactions within this month will be grouped and reported within this financial period. Custom: Allows the user to define a specific time range that doesn’t necessarily fit into a standard month or quarter.
Example: For T-Mobile, if you are tracking the revenue or financial transactions for each month, like all revenue and expenses related to mobile plans sold in January 2024, you would select “Monthly.”

What are GL Accounts and why are they important?

GL (General Ledger) Accounts are used to categorize financial transactions for reporting purposes. They help in summarizing different types of financial activities, such as sales income, accounts receivable, and taxes payable. T-Mobile would need to set up GL Accounts for various financial transactions, such as “Sales Income” for revenue from data plans and “Shipping Charges” for any costs incurred during mobile delivery.

Sales Income – USA GL Account

img206

Shipping Charges – USA GL Account

img207

How are Tax Rates managed in Salesforce Billing?

Tax Rates defines the amount of tax applied to a product or service in a specific region. They are linked to Legal Entities and can be managed manually or through an integration with tax engines like Avalara.
For example, in the USA, T-Mobile may apply a 7% tax rate on data plans, whereas in India, the rate might be 18%. These tax rates makes sure that T-Mobile complies with local tax laws when billing customers.
Example: Tax Rate for US Region is 7%

img209

Example: Tax Rate for India Region is 18%

img211

What happens when an Order Product is created in Salesforce Billing?

When an Order Product is created, it inherits the Billing Rule, Tax Rule, and Revenue Recognition Rule from the parent product. Salesforce Billing then matches these rules with the Legal Entity specified on the Order Product to determine the correct billing and tax treatment.
For Example, When T-Mobile creates an Order Product for a customer in the USA, the Order Product will inherit the USA-specific Billing Rule, Tax Rule, and Revenue Recognition Rule.

img213

What is the importance of the Billing Rule in Salesforce Billing?

A Billing Rule determines how and when an invoice should be generated for a product. It includes the billing treatment, which is linked to a specific legal entity, finance book, and GL rule.
For example, for T-Mobile’s data plans, the Billing Rule might specify that customers are billed at the end of each month for their data usage.

img215

What is the purpose of a Revenue Recognition Rule in Salesforce Billing?
A Revenue Recognition Rule determines how and when revenue from a sale is recognized in the company’s financial records. T-Mobile might use a Revenue Recognition Rule to recognize revenue from data plan subscriptions monthly, as customers use the service. This helps in accurately reflecting revenue earned in each financial period.

img217

How does Salesforce Billing handle multiple finance periods for different legal entities?

Salesforce Billing allows the creation of multiple finance periods within a Finance Book, each linked to a specific legal entity. This setup ensures that financial transactions are recorded accurately for each legal entity across different time periods.

img218

What happens if you try to update Legal Entities or Rules on activated Order Products?
Once an Order Product is activated, Legal Entities and Rules cannot be updated. This restriction ensures the integrity of the billing and financial processes, preventing changes that could lead to discrepancies in financial reporting.

img220

What does the period status “Open” and “Closed” in a finance period indicate?

img222

The period status field in a finance period indicates whether the period is currently active and whether it can accept new financial transactions.
When a finance period is marked as “Open” it is actively receiving new records. When a finance period is marked as “Closed” it no longer receives new records. This status is used after all transactions for the period have been finalized. The concept is similar to accountants “closing their books” at the end of a month or year.

 

Leave a Reply

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