User | Post |
9:07 pm June 30, 2011
| Suba @ Wealth Informatics
| | |
| Moderator
| posts 1876 |
|
|
|
I am not sure if this was discussed before, I did a search and there was nothing. So I was closing the books for this month and as I have more than a handful of transactions, I was thinking of moving to a s/w. Excel might be good enough but I am spoiled by mint.com :) Is there anything like that for business accounting? That would automatically categorize/tag and help me with overall accounting? Or may be an intelligent excel sheet would be the way to go?
I found outright and quickbooks, but both of them is ~$10-$12. Don't know if it is worth the cost at this low income level. Any one using these? Are they worth the price? Do you know of any good alternative?
Thanks.
|
|
|
9:26 pm June 30, 2011
| The Family CEO
| | |
| Member | posts 391 |
|
|
|
I use Quicken for our personal stuff and I have line items for blogging/online income. That way I can pull all the income and expenses up easily at tax time or when I just want to see where I'm at.
I use Quickbooks for the bookkeeping for two small businesses. I don't think QB would be necessary for a blog business, since it's such a simple business model. Quicken should be more than okay and it's much, much cheaper.
Hope that helps!
|
|
|
9:35 pm June 30, 2011
| Budgeting in the Fun Stuff
| | |
| Member
| posts 3048 |
|
|
|
I've created my own Excel sheet with minimal cool extras (like pink highlighting when an ad is going to expire in a month and red highlighting when it is expiring in the month we are in). I like to keep it simple. :-)
|
|
|
10:25 pm June 30, 2011
| Invest It Wisely
| | |
| Member
| posts 2019 |
|
|
|
I tried quickbooks and didn't really like it, but I went with GnuCash and after getting over the initial learning curve i find it pretty good to use. The fact that it supports multiple currency transactions is also great for me as a Canadian, and hey, it's free.
|
|
|
10:26 pm June 30, 2011
| Invest It Wisely
| | |
| Member
| posts 2019 |
|
|
|
Oh, I also use Excel spreadsheets for supporting data such as which ad deals are currently active.. not totally ideal since it's duplication of data so there's the possibility to make mistakes but it does provide an easy snapshopt to see what's going on.
|
|
|
10:36 pm June 30, 2011
| Suba @ Wealth Informatics
| | |
| Moderator
| posts 1876 |
|
|
|
May be I am the only one "spending" a lot on blogs I find it annoying to remember all the transactions I made with my credit card, some transactions using paypal, checks I sent… Income part is the easiest for me, 3 lines… haha. I just want to make sure I won't miss any deduction due to me forgetting to keep track of an expense. Hence the desire to find a software that would automate it for me….
@Kevin, I tried out GNUCash for personal budgeting before I went with mint. I forgot about that. I will give it a try. Thanks.
If anyone have any other suggestions, keep them coming guys. Thanks!
|
|
|
10:36 pm June 30, 2011
| The College Investor
| | San Diego, CA | |
| Admin
| posts 1935 |
|
|
|
I use excel for keeping track of my advertisers, and when they expire.
I use Quickbooks for the accounting piece.
|
|
|
10:46 pm June 30, 2011
| Invest It Wisely
| | |
| Member
| posts 2019 |
|
|
|
Suba @ Wealth Informatics said:
May be I am the only one "spending" a lot on blogs I find it annoying to remember all the transactions I made with my credit card, some transactions using paypal, checks I sent… Income part is the easiest for me, 3 lines… haha. I just want to make sure I won't miss any deduction due to me forgetting to keep track of an expense. Hence the desire to find a software that would automate it for me….
@Kevin, I tried out GNUCash for personal budgeting before I went with mint. I forgot about that. I will give it a try. Thanks.
If anyone have any other suggestions, keep them coming guys. Thanks!
Gnucash probably won't be easy as Mint but I believe you can import your online banking into it… personally I do everything manually and spend a couple of hours at the end of each month, but if the lines grew too much I would definitely want to automate more if it. With GnuCash you can set up recurring transactions so if you have something to pay every month and it's consistent, you can easily set that up to repeat so you don't have to manually enter it each time.
|
|
|
5:55 am July 1, 2011
| My Personal Finance Journey
| | |
| Member
| posts 3159 |
|
|
|
I use excel to track income (or lack there of some months! haha) and expenses. Then, I just put auto reminders in my Outlook or Gmail calendar to remind me when to take the ad down/it expires.
|
|
|
6:14 am July 1, 2011
| JT_McGee
| | |
| Member | posts 723 |
|
|
|
Outright is exceptional.
I used to use Excell sheets (still do for things that are more complicated) but Outright is the bee's knees. Worth every dime of the $10/mo.
|
|
|
6:18 am July 1, 2011
| Jason@LiveRealNow
| | |
| Member | posts 727 |
|
|
|
Suba @ Wealth Informatics said:
I am not sure if this was discussed before, I did a search and there was nothing. So I was closing the books for this month and as I have more than a handful of transactions, I was thinking of moving to a s/w. Excel might be good enough but I am spoiled by mint.com :) Is there anything like that for business accounting? That would automatically categorize/tag and help me with overall accounting? Or may be an intelligent excel sheet would be the way to go?
I found outright and quickbooks, but both of them is ~$10-$12. Don't know if it is worth the cost at this low income level. Any one using these? Are they worth the price? Do you know of any good alternative?
Thanks.
You could go with a separate bank account for all blogging transaction, in and out. Then you'd just have to dump the data at tax time. I do that and have GCal reminders for ad expirations.
|
|
|
6:25 am July 1, 2011
| JT_McGee
| | |
| Member | posts 723 |
|
|
|
Jason@LiveRealNow said:
Suba @ Wealth Informatics said:
I am not sure if this was discussed before, I did a search and there was nothing. So I was closing the books for this month and as I have more than a handful of transactions, I was thinking of moving to a s/w. Excel might be good enough but I am spoiled by mint.com :) Is there anything like that for business accounting? That would automatically categorize/tag and help me with overall accounting? Or may be an intelligent excel sheet would be the way to go?
I found outright and quickbooks, but both of them is ~$10-$12. Don't know if it is worth the cost at this low income level. Any one using these? Are they worth the price? Do you know of any good alternative?
Thanks.
You could go with a separate bank account for all blogging transaction, in and out. Then you'd just have to dump the data at tax time. I do that and have GCal reminders for ad expirations.
That sounds good, too. I would imagine that any PF blogger would probably qualify for most business credit cards out there (with a personal guarantee). Makes it real easy.
|
|
|
7:18 am July 1, 2011
| Glen Craig
| | |
| Member
| posts 1087 | |
|
|
Spreadsheet for me. I track all income and expenses that way. I use Gcal for anything I need to keep of dates for (expirations and such).
|
|
|
8:14 am July 1, 2011
| Eric – PersonalProfitability.com
| | Portland, OR | |
| Member
| posts 2120 |
|
|
|
Indinero is a Mint.com for small businesses.
Quickbooks is good if you need something robust and are willing to learn how it works, which takes time.
I use Excel but I am looking at going LLC and will probably use Quickbooks or Indinero from then on.
|
|
|
8:24 am July 1, 2011
| Suba @ Wealth Informatics
| | |
| Moderator
| posts 1876 |
|
|
|
Thanks a lot, guys!
@Eric I will look into Indinero. Looks like it is free upto 50 transactions and I will probably have less than that every month.
@Jason, I do have a separate blogging (right now it is a checking account/debit card) account, but some things (like paypal fees) stays within paypal. I am sure I will get a 1099 with the full amount and I have to deduct the paypal fees, same goes with Amazon payments.
I don't have that many individual ads, so google calendar along with the email link works for me with expiration. I just have to be more diligent with excel I suppose. That would work…
|
|
|
9:31 am July 1, 2011
| MoneyBeagle
| | |
| Member
| posts 1466 |
|
|
|
I have an Excel spreadsheet that tracks all my advertisements as well as their income and expiration dates, contact info and the like. It's a little cumbersome at times but it's a tab within a spreadsheet that I use to track pretty much everything financial, so at this point I'm sticking with it.
|
|
|
9:39 am July 1, 2011
| financialstudent
| | |
| Member | posts 86 |
|
|
|
I use Quickbooks. I'm still getting the hang of it, but it's not too hard. I know a lot of people are intimidated by Quickbooks because it can do so much. But it doesn't have to. I've just been entering my transactions in the general journal so far. Quickbooks can also connect to online banking and automatically download everything, which I know will save me a ton of time as my monthly transactions increase.
|
|
|
9:56 am July 1, 2011
| Mike – Saving Money Today
| | |
| Member | posts 520 |
|
|
|
I've been using Excel but I really need to find a better solution. Excel was great in the beginning but as things grow and get more complicated I'm spending too much time on it. Some good suggestions in this thread, Outright in particular looks really cool.
|
|
|
3:00 pm July 1, 2011
| JT_McGee
| | |
| Member | posts 723 |
|
|
|
If you're just worried about PayPal fees, then you can use the "count" or "countif" to count the PayPal transactions then nest in an if/then statement to compare to this table:
$0.00 USD – $3,000.00 USD |
2.9% + $0.30 USD |
$3,000.01 USD – $10,000.00 USD |
2.5% + $0.30 USD |
$10,000.01 USD – $100,000.00 USD |
2.2% + $0.30 USD |
|
|
|
|
|
7:33 pm July 1, 2011
| Money Reasons
| | |
| Admin
| posts 697 |
|
|
|
I created an Excel compatible spreadsheet template in Open Office. It has 12 tables and a yearly sheet. I fill out the monthly sheets, and the annual one is done automatically.
My structure is simple so this works for me, at least from now…
|
|
|