Income and work

Referral fee income: a log for small, scattered payouts

A simple log for scattered referral payouts from different sources, with the columns and formulas to total them month by month and by source.

Editorial illustration for Referral fee income: a log for small, scattered payouts

Small referral payouts are easy to forget because they arrive as a ₹200 credit here and a ₹500 transfer there. A simple log with one row per payout, a source name and a month label lets you see the monthly total and which sources actually pay. It takes seconds per entry if you record it the day the money arrives.

Why do small payouts need a log?

A UPI credit may show only a person's name, and a wallet credit may carry a vague label. After a month you will not remember which was a referral, which was a refund and which was a friend returning money. Without a log, your referral income looks smaller than it is, or you count it twice.

What columns does the log need?

ColumnHeadingWhat to enter
ADateThe day the money arrived
BSourceThe company, app or person that paid
CWhat forA short note on whom you referred or what the payout was
DAmount in ₹The amount received
EModeUPI, bank transfer, wallet or cash
FReferenceThe transaction ID or a note to find it
GMonthA formula that labels the month

In G2, enter =TEXT(A2,"mmm yyyy") to produce a label such as Nov 2026. It works in Excel and Google Sheets, though month names follow the language setting of the file.

Which formulas give me the totals?

  • Total for a month, with the label typed in J1 as Nov 2026: =SUMIFS($D$2:$D$500, $G$2:$G$500, $J$1)
  • Number of payouts that month: =COUNTIFS($G$2:$G$500, $J$1)
  • Total from one source: =SUMIFS($D$2:$D$500, $B$2:$B$500, "App X")

What does a month look like?

Hypothetical November entries:

DateSourceAmount in ₹
4 NovApp X250
9 NovApp Y500
15 NovApp X250
22 NovA friend, for a broker referral1,000
28 NovApp Z300

The month's total is 250 + 500 + 250 + 1,000 + 300 = ₹2,300 from five payouts. App X gave 500, which is the sum of two entries. Seeing the split helps you decide which referral programmes are worth your time.

How do I stop missing entries?

  1. Enter each payout when you get the credit message, not at month end.
  2. Once a month, scan your bank statement for credits you have not logged.
  3. Write the source name the same way every time.
  4. If a credit's source is unclear, add it with the source marked Unknown and fix it when you find out.

How does an expense tracker help?

The log is for income, and your bank statement is where all the credits sit. SpendixAI lets you upload that statement in PDF, CSV or Excel after you pick the account, and you review the rows before saving. Use it to find credits you forgot to log. It does not know which credits are referrals, so your sheet stays the record for that.

What about payouts that come as vouchers or credits?

Some referral rewards are not cash. They may be wallet credit, a voucher or a discount. Log them in the same sheet with the Mode set to Voucher, and add a note about expiry. When you use the voucher, note that too. That way the sheet shows both what you earned and what you actually received in your account, and you do not count a voucher you never used.

Month-end check

  • Total payouts and their count
  • Best and worst sources
  • Any credit on the statement not in the log
  • A reminder if a promised referral payout is still pending
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports