tusken

--------------------------------------------------------------------------------

does anyone know a good piece of kit or have a excel template they wish to share with me for this?

I am looking at using it for my ebay store and paypal fees.

Anything to update the excel system i use now which i created myself but is not 100% accurate.

I know SAGE but anything else out there, can't afford an accountant yet i dont think.

merton.908

Quickbooks Pro

tusken

Cheers. Does this allow download for eBay?

merton.908

If you sign up for Seller Manager Pro then download your reports each month you can calculate your profits off that. Download each report, run through the totals, take into account any sales/costs off eBay and add them in to the equation and your there. They also take care of all your PayPal fees etc, the lot.

Pump all that data into a Excel spreadsheet and save yourself a few quid on buying a fancy accounting package.

David.Pagotto

If you are looking for overall accounting software I would go with MYOB.

__________________
Australian Buisness Forum \\ Australian Business Directory \\ Australian Business Blog

tusken

thankyou david.pagotto

Elven

Hi Tusken,

I do a lot of excel programming using built-in functions and VBA. I'm also a contract corporate trainer in the stuff.

Excel is great for data analysis, but as an accounting system it just doesn't cut it. That's what a database is for. Excel has too many limitations.
The conventional wisdom is to use a database to gather the data, then Excel to analyze it.

Professional maxims aside, Excel will suffice for a small operation on a month by month basis. By linking sums to another workbook, you could do the full financial reporting; and still have the analysis tools available.

One small company I work with uses Excel for its Invoices, then calculates their BAS statements after entering receipts. It's quick and easy.

I'd be happy to look over what you've got and fine-tune it. Drop me a line.

Elven

__________________
Anything to do with the Web: Internet research, SEO/SEM, blogging, ADSL and cable, networking businesses and database access/design, commercial websites, programming in .NET, Java, Javascript, Ajax, CMS systems like joomla, etc.
After 15 years as a contract programmer, the Web became the focus about 12 years ago. Feel free to contact me anytime by email.