Royalty Report with Gift Card Reconciliation

Royalty Report with Gift Card Reconciliation

Implementation in Back Office:

Page Navigation: My Enterprise >> Royalty/Franchise.

              The generated royalty report should include the columns "Gift Card Sold", "Gift Card Redeemed" and “Total Due”. 

              In the "G / C Sold" column, based on the stores, the total gift cards sold for the respective selected time period 

                  should be shown.

              The gift cards redeemed value should be shown in the column “G/C Redeemed”.

              The total value of the gift cards sold should be added to the royalty fee. 

             The redeemed value of the total gift cards should be subtracted from the royalty fee.

            The exported form of report should include the columns “G/C Sold”, “G/C Redeemed” and the “Total Due” by default.

 

      Screen Layout:


      


      Calculation of Total Due:

 

  To obtain the total due, the gift card sold value should be added along with the royalty fee and the Gift card redeemed value should be deducted from the royalty fee.

Formula for Total Due = Royalty Fee + G/C Sold – G/C Redeemed.

  In the above screen shot attached, Consider store 1

Royalty fee $17591.88

G/C sold value is $1000

G/C redeemed value is $500.

Total Due = 17591.88 + 1000 – 500 = 18091.88



    • Related Articles

    • Royalty Report with Gift Card Reconciliation

      Implementation in Back Office: Page Navigation: My Enterprise >> Royalty/Franchise.               The generated royalty report should include the columns "Gift Card Sold", "Gift Card Redeemed" and “Total Due”.      ...
    • Enhancement in Gift Card

      Implementation in Back Office:   Page Navigation: My Stores >> Products/Items >> Gift Card   Users can do issue (sold), recharge, Adjust for the gift card at the back office.   And the values are recorded in the gift card report as well as in the ...
    • Enterprise Level Gift Card Report

      Implementation in Back Office: Page Navigation: My Enterprise >> Enterprise Report >> Gift Card >> Redemption Report   The following fields should be included to filter the options and run the report, 1)      Stores – Users can select the stores they ...
    • Gift Card For Linga POS

      Gift cards For linga POS
    • Gift Cards on Online Ordering

      Introduction Linga Gift Card functionality lets restaurant customers to buy and present prepaid cards to be used for their payments in their favorite restaurants (stores). In this document, steps to follow to activate gift card functionality for a ...