LinkBack URL
About LinkBacks
Ideal Excel Spreadsheet for Accounting/Decision Making
If you could have your ideal Excel spreadsheet for accounting purposes, what would it include? Here are the ideas I've had so far:
Page for all expenses, which would list each expense with the following info:
- Expense Description
- Expense Category (Advertising/Content/Travel/Whatever)
- Date of Purchase
- Date of Expiration (if it expires)
- Price
- Payment Method
- Contact Method for Seller
- Also, a spot where you could list what website the expense was for (if it was for a specific site)
Page for all revenues, which would list each revenue with the following info:
- Revenue Description
- Revenue Category (affiliate income/domain sale/link sale/whatever)
- Date of Revenue
- Month the Revenue was actually earned (important for later)
- Amount of Revenue
- Paid to Which Account?
- A spot where you would list what website the revenue was from (if it was from a specific site)
- A spot where you could list what program paid you the money
A third page with broad analysis including:
- All expenses by month/All expenses for the year
- All revenues by month (for this, you would use the "Month the Revenue was actually earned", since most money comes in a month after you earn it)/All revenue for the year
- Profit by month/Profit for the year
- List expenses/revenue by Category by the month, as well as for the year (useful for seeing how much money you spend on links/domains/whatever by month and for the year)
- List expenses/revenue/profit by Website by the month, as well as for the year (should give you a great idea of where you should be focusing your time, and where any leaks in your business are located)
- Show you upcoming renewals by the month (for example, if you had 10 $500 links expiring in January, it would tell you you have a $5,000 upcoming liability for January)
That's all I was able to come up with so far, can you guys think of anything else?
Reply With Quote
Originally Posted by MJ
Bookmarks