Help - Need to get organized

[matyko]

Very nice thread!

Since I am analyzing my stats/sales/etc my biz is growing very fast. I highly recommend to everyone to track sales, traffic and ROI as accurate as possible.

I have a spreadsheet for all my submitted galleries, with date/URL/long description, and have a separate sheet for important submissions like The Hun, WorldSex, etc. For these I also track if they are approved (with date) and results (sale amount/type/$$$).

For tracking the sales I have another spreadsheet and I log: date/sale type/$$$/source (AskJolene for example)/site (assholefever for example)/gallery URL/sponsor program/notes (rebilled or not for trials). At the beginning of each new month I summarize the latest months sales:
Rebill $$$/sales $$$/extra (bonuses, etc), number of sales/rebills, and 10 most important sale sources. This way its very easy to count at least an approx ROI for paid passes.

Payment tracking:

Another spreadsheet with 3 pages:
1) payment forecast: when can i expect a payment/from which sponsor/exact amount.
2) payment history: when receiving a payment, i move the cells from the forecast part to here, under the actual month. There's a huge autosum cell where i can see clearly how much money i got that month.
3) expense calendar: to avoid expired passes, etc.