Fiverr Accounting Tips & Free 12 Month Tracking Template

[zimamedia]

Hello Everyone!



I’ve been exporting my fiverr revenue and tracking my earnings. It’s been a wonder to export in a .CSV and really see what I make on paper. I know a lot of you haven’t maximized the true value of exporting data and I wanted to start a thread with the best tips.



Tip #1 Earnings periods starts the 15th of every month and ends the 14th of the proceeding month. This is because revenue has to clear for 14 days~ and what you “earn” in sales is not the same as cleared, useable income.



I built a model that measure 12 months and this is how it work.

1. Download the template and upload into Google Drive. It should save a new sheet and name to whatever you want.
   
2. Export monthly .CSV and update the template at the beginning of each month.
   
3. Fiverr Emails you that month and you double click/upload to Google Drive.
   
4. Copy & Paste into the accounting template.
   
5. Count up only how many orders you have and input that number inside the highlighted yellow field for that month.
   
6. Repeat for every month.
   
   
   
   Please provide me with feedback on my template and how I can improve it. The community deserves a savvy way to manage earnings.
   
   
   
   This template only needs to have the order amounts manually entered on the first sheet to crunch the numbers. You will have a high level breakdown of how many “orders” a month, what you earned, and average for that month.
   
   
   
   More tips coming soon!
   
   
   
   Fiverr won’t let me upload an excel or post a link. Please message me if you need assistance in managing your own clients.
   
   
   
   The file is .ods and is readable by Google Drive; I tested and uploaded it to another account.

[zimamedia]

==================Top Tips==================



Tip #1



Earnings periods starts the 15th of every month and ends the 14th of the proceeding month. This is because revenue has to clear for 14 days~ and what you “earn” in sales is not the same as cleared, useable income.



Tip #2:



Use the template as a remarketing effort to reach out to your top tier clients.

---

[isaacroot]

I use Quickbooks and i can import all of my paypal and bank transactions to see how much i make and spend each month

[zimamedia]

Reply to @isaacroot: That’s a good method. I hate paypal with a burning passion…

[isaacroot]

Reply to @zimamedia: Don’t we all lol. The only downside to quickbooks is that it costs 6.99 per month. But it syncs with all your accounts so it tracks all of your expenses not just fiverr income. i just got it last night and i can finally see how much i make/spend each month

[zimamedia]

Reply to @isaacroot: I would rather invest that in hosting. I believe, I was an accountant in a previous life. Thanks for sharing!

[isaacroot]

Reply to @zimamedia: Your welcome! http://www.fiverr.com/isaacroot

[zimamedia]

Reply to @isaacroot: We have the same amount of reviews! https://www.fiverr.com/zimamedia

[isaacroot]

Reply to @zimamedia: cool! How many orders have you had?

[zimamedia]

Reply to @isaacroot: How granular are you paypal transactions. I only draw a couple times a month and don’t have the itemized transactions, by ID.

[zimamedia]

Tip #2 Use the template as a remarketing effort to reach out to your top tier clients.

[isaacroot]

Reply to @zimamedia: I used to withdraw all the time until i realized a few days ago that i save more in paypal fees if i withdraw when i have $50+