Versions Compared

Old Version 4

changes.mady.by.user Persia Xenopoulou

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt
hiddentrue

Find out how wallet balance and wallet allotment balance is calculated.

Status
colourGreen
titleAvailable from CRM.COM R4.0.0

What does this section cover? 

StatuscolourGreen

titleAvailable from CRM.COM R4.0.0

Table of Contents
minLevel2

What is Wallet Balance Calculation?

A Wallet is an account which holds an amount of money that is used to fund transactions. Even though a wallet is within an accounts receivable the transactions and balance of the accounts receivable does not necessarily match the wallet transactions and wallet balance. Wallets have their own Wallet and Wallet Allotment balancesbalance.
Both amounts are calculated dynamically based on the wallet transactions and wallet transaction allotments accordingly 

How is Wallet Balance calculated?

The wallet balance is calculated based on the formula described below:

Info
titleFormula for balance calculation

Balance = (credit WT amounts + voided debit WT amounts + voided reimburse WT amounts) - ( debit WT amounts + reimburse WT amounts + voided credit WT amounts) 

WT = Wallet Transaction

Example

  • Credit Invoice 1: 100
  • Credit Invoice 2: 200
  • Debit Invoice 1: 50
  • Debit Invoice 2: 150
  • Reimburse Invoice 1: 30
  • Reimburse Invoice 2: 40
  • Void Credit Invoice 1: (100) ( Cancelled Credit Invoice)
  • Void Debit Invoice 1: (50) (Cancelled Debit Invoice)
  • Void Reimburse Invoice 1: (30) (Cancelled Reimburse Invoice)

BALANCE = (100 + 200 + 50 +30) - (50 + 150 + 30 + 40 +100) = 380-370 = 10

 

How is Wallet Allotment Balance calculated?

The wallet allotment balance is calculated for each product included in a wallet transaction allotment, based on the formula described below:

Provide a short title using Company ZX as the business client
Info
titleFormula for allotment balance calculation
nameblue
title

Balance = (credit WTA amounts + voided debit WTA amounts debit WTA amounts + voided reimburse WTA amounts reimburse WTA amounts) - ( debit WTA amounts + reimburse WTAamounts debit WTA amounts + reimburse WTAamounts + voided credit WTA credit WTA amounts)

WTA = Wallet Transaction Allotment (related with a specific product)

Panel

)

Example

Allotted Products: Sports HD, Kids HD

  • Credit Invoice 1: 100
    • Sports HD: 60
    • Kids HD: 40
  • Credit Invoice 2: 200
    • Sports HD: 120
    • Kids HD: 80
  • Debit Invoice 1: 50
    • Sports HD: 30
    • Kids HD: 20
  • Debit Invoice 2: 150
    • Sports HD: 90
    • Kids HD: 60
  • Reimburse Invoice 1: 30
    • Sports HD: 18
    • Kids HD: 12
  • Reimburse Invoice 2: 40
    • Sports HD: 24
    • Kids HD: 16 
  • Void Credit Invoice 1: (100) ( Cancelled Credit Invoice)
    • Sports HD: 60
    • Kids HD: 40
  • Void Debit Invoice 1: (50) (Cancelled Debit Invoice)
    • Sports HD: 30
    • Kids HD: 20 
  • Void Reimburse Invoice 1: (30) (Cancelled Reimburse Invoice)
    • Sports HD:18
    • Kids HD: 12

(Sports HD) BALANCE = (60+ 120 + 30 + 18) - (30 + 90 + 18 + 24 + 60) = 228 - 222 = 6

(Kids HD) BALANCE = (40 + 80 + 20 + 12) - (20 + 60 + 12 + 16 + 40) = 152 - 148 = 4



 

 

Panel
namegrey

Related Areas

Filter by label (Content by label)
showLabelsfalse
spacesV4Manual
showSpacefalse
excerpttrue
labelswallets-basics, wallets-advanced, wallets-admin

 

 

Panel
namegrey

Popular Labels

Popular Labels
spaceKeyV4Manual
styleheatmap

Include Page
V4:Check our Getting Started Manuals Banner
V4:Check our Getting Started Manuals Banner