Tracking Creator Income: Manual Records or a Dedicated Wallet Section?
Published 5 min read
The 11.11 season is usually when a creator's collaboration calendar is at its fullest. In a single week, you might have several reviews, a few livestreams and a few referral codes running at the same time. When the sale ends, the hardest question is usually not about content. It is this: which payments have you received, and which are still pending?
This article compares two ways to track creator income. The first is keeping manual records in a spreadsheet or notebook. The second is using a dedicated wallet section inside your work tool. Neither is right for everyone. The goal is to help you choose the one that fits your workload.
Why does tracking creator income get messy after a sale season?
A creator's money information is usually scattered. The terms sit in messages, the confirmations sit in emails, and the actual money sits in bank statements. Each place holds one piece, and no place holds the whole picture.
Every brand also pays differently. Some pay part upfront, some pay after the post is approved, and some pay based on the orders generated. Some collaborations are paid in products only. When you have many collaborations at once, it is easy to mix up these milestones.
The consequence is not just missing money. You might forget to follow up on a payment that is due, or follow up on one you have already received. Both make the conversation with the brand awkward.
Here is an illustrative example: a KOC takes on five collaborations during 11.11 week. Two weeks later, she remembers receiving payment from three brands. When she opens her bank statement, she only finds two payments that match by name. The third was sent from a brand employee's personal account, so she spent an extra afternoon reconciling it.
Manual records: what are the pros and cons?
This is how most creators start. You create a spreadsheet where each row is a collaboration and each column is a piece of information you need to remember.
Pros:
- You decide which columns you need and which to drop.
- There is no new tool to learn.
- It is easy to share with an assistant or a family member who helps with the books.
Cons:
- You have to remember to update it. Your busiest season is also when you are most likely to miss something.
- The sheet is separate from where you talk with brands, so you end up copying information back and forth.
- The more collaborations you have, the longer the sheet gets and the harder it is to see which payments are pending.
How is using a dedicated wallet section to manage KOC income different?
The second approach is to gather collaboration-related payments into a wallet section inside the tool you use to work with brands. Instead of opening a separate file, you see your money information right next to your collaboration management.
With HOJA for Creators, this is a wallet section for tracking payments related to your collaborations. The main idea is to keep money matters from being separated from your work.
The upside of this approach is that you have one fixed place to look back at. The trade-off is that you need to get used to a new interface. A wallet section in a tool also usually follows a ready-made structure, so it is not as freely customizable as a spreadsheet you build yourself.
Quick comparison of the two ways to track creator income
| Criteria | Manual records | Dedicated wallet section in a tool |
|---|---|---|
| Where information is stored | Separate file or notebook | Close to where you manage collaborations |
| Initial effort | Low, ready to use | Needs time to get used to |
| Level of customization | Very high | Follows the built-in structure |
| When you have many collaborations at once | Easy to miss items if you forget to update | One fixed place to review |
| Common risks | Multiple file versions, mismatched data | Depends on you using the tool consistently |
| Best suited for | Few collaborations, prefer to design your own | Regular collaborations, want everything in one place |
Which approach should you choose for your current stage?
When manual records are still enough
If you only have a few collaborations a month and your brands pay in a similar way, a spreadsheet is enough. Keep it simple and update it as soon as you confirm a collaboration.
When to consider a dedicated wallet section
If you often have several overlapping collaborations, especially during periods like 11.11 or the end of the year, gathering information in one place saves you reconciliation effort. This is also when copying back and forth between several places is most likely to cause mistakes.
When to combine both
Many people use both side by side during a transition. You keep the old sheet as an archive and start recording new collaborations in the new place. After a while, you will know which approach suits you better.
Whichever you choose, what should you record for each collaboration?
A tool only helps when the information you enter is clear enough. The following five steps apply to both approaches:
- Record it as soon as you confirm the collaboration, not when the money arrives.
- Note the payment type clearly: upfront, after posting, per order, or in products.
- Note the expected date you will be paid, according to your agreement with the brand.
- Note the contact person so you know who to follow up with when payment is due.
- Mark the status as received or pending as soon as you check it against your bank statement.
Just by doing these five steps consistently, you avoid most cases of forgetting or following up by mistake.
Next steps after the 11.11 season
The week after the sale is a good time to review all the collaborations you just completed. You will see right away whether your current way of keeping records is enough. If you find you spend a lot of time reconciling, that is a sign to try a different approach.
If you want to gather your collaboration payments in one place close to where you work, see how HOJA for Creators helps you track collaboration payments in the wallet section.