Tip #1: Setup a separate bank account for your eBay business
As an organizational tool--just to keep your business's financial affairs well-organized--you'll want to setup a separate bank account for your eBay business. Use this bank account for collecting the money you receive and for paying any of the businesses expenses.
Tip #2: Treat PayPal as just another bank account
From Quicken's perspective, PayPal is just another bank account. So that's the way you want to treat it.
Note: If you're using only PayPal as your "business bank account," that's okay. But then you need to pay all your bills from and make your all your deposits to the PayPal account.
Tip #3: Download PayPal transactions automatically
If your PayPal transaction volumes get large--say you've got hundreds of transactions a month--be sure to automatically download the transactions from your PayPal account into QuickBooks.
To automatically download transactions from PayPal into your QuickBooks data file, log on to PayPal, choose the Download History command from the History menu, specify the date range you want for which you want to download transactions, and indicate you want to use the QuickBooks download format.
After you download the PayPal transactions into the a QuickBooks download file, start QuickBooks and choose the File Utilties Import command and, when prompted, indicate you want to import the downloaded PayPal transactions.
Note: The precise procedures you use to export transactions from PayPal and then import the transactions into QuickBooks vary over time and from one version of QuickBooks to the other. You may notice some differences between the instructions provided here and the actual mechanics you need to use.
Tip #4: Be sure to regularly reconcile your bank accounts
You want to regularly reconcile your business bank accounts including the PayPal account. By reconciling your bank accounts, you'll catch and correct data entry errors and omissions. In short, bank account reconciliations clean up your QuickBooks records.
Tip #5: Simplify your inventory accounting
The one complicating factor in a eBay business--at least in terms of the accounting--concerns the inventory. The accounting rules say that you can't simply write off as a deduction the amounts you pay for the inventory until you sell the items in, for example, an eBay auction.
QuickBooks can handle inventory accounting with quite a bit of sophistication. But the usual QuickBooks approach may be overkill with an eBay business where you're selling one or two of a bunch of different items. Fortunately, you can simplify your QuickBooks inventory accounting for an eBay business if you take a couple of simple steps: First, categorize your inventory purchases as, well, "purchases."
Second, at the end of each year, do a physical count and valuation of the items you're holding as inventory. You're interested in knowing what the inventory you hold at year-end originally cost you.
With the year-end inventory balances and the annual purchases, either you or your accountant will easily be able to calculate the cost of the goods you sell over the course of the year using this formula:
Last-years ending inventory + Purchases - This-year's ending inventory
The preceding formula, by the way, is exactly what the Schedule C Sole Proprietorship tax form does to calculate a business's cost of goods sold.
About the author: Stephen L. Nelson, CPA is the author of QuickBooks for Dummies and runs the limited liability company kit store.