Archive for Downsizer For an ethical approach to consumption
 


       Downsizer Forum Index -> Small Business Questions, Ideas and Advice
sally_in_wales

Improving my accounts

So far, we've always done our accounts through a fairly basic excel spreadsheet to record stuff going in and out, part of which can be cross referenced if needs be against the sales reports generated by the online shop, and a file of paperwork/post office receipts etc.

It sort of works, but I live in dread of the chaos that would ensue if we were audited as it only really makes sense to me, its all there, but a bit illogical and I fret that I've accidentally missed off small things every year when doing the tax returns or worry that I've set up a calculation incorrectly, leading to a lot of wasted time as I cross reference everything endlessly.

I've recently started using a free online bit of software for generating and tracking invoices, which is proving very useful as I can see at a glance who owes us money, and I think it might be time to think about graduating all the accounting to a slightly more professional system that will track things sensibly and make it all simple at tax return time.

I don't need anything terribly complicated though, we have income from the online shop, from shows, from clients like museums and from online pattern sales on sites like Ravelry to track. Outgoings are either plain old 'money on supplies' or are expenses for shows/petrol and post. I'm pretty sure thats about it.

I've tried having a look online, but I'm utterly flummoxed as to what exactly I should be looking for. I don't mind paying a little bit, especially if its integrated with the tax return system, but not too much at this stage.

Any suggestions or recommendations?
Chez

I used to use a basic version of SAGE. It was very straightforward once I'd got the hang of it.
joanne

How about trying http://www.intuit.co.uk/index.jsp - the guys who have just given 1k to Rob - you can do it all online and trial it for free, so no worrying about backing up in the event you loose your pc etc
sally_in_wales

How about trying http://www.intuit.co.uk/index.jsp - the guys who have just given 1k to Rob - you can do it all online and trial it for free, so no worrying about backing up in the event you loose your pc etc


they look good, but 9 a month forever is quite a lot of money at this stage even with a one month free trial. I think I was hoping for something that there was maybe a small one off payment. Perhaps thats unrealistic of me though?
Chez

I think so, sadly. I did quite a lot of looking for a cheaper alternative at one point and didn't have much success with anything that made any sense to me.

The SAGE online thing is a fiver plus vat., though - bit cheaper than Intuit. No idea what it's like, though.
Penny Outskirts

Are you VAT registered Sally?
stumbling goat

FWIW I think that you may be over fretting. I use an excel spreadsheet, and if you make a genuine error you will not likely be put into the Tower.

And if only you can understand the books, you can the explain anything away. Very Happy

No point spending anything unless you absolutely have to IMHO.

sg
Rob R

How about trying http://www.intuit.co.uk/index.jsp - the guys who have just given 1k to Rob - you can do it all online and trial it for free, so no worrying about backing up in the event you loose your pc etc


I (and BA) am happy to recommend Quickbooks, although others will pour scorn on it, but it works for me. I find it easier to manage the many small transactions you get with online sales, but if I had fewer outgoings/incomes, I would stick with the spreadsheet. QB takes a bit of getting used to, but the help button is easy to use with step-by-step instructions. I think it was a one-off 100.
powerjen

Try Quickfile.co.uk, it's cloud based so you can access it securely over the internet from anywhere and it's completely free and very good. You can import bank statements and paypal accounts and print and create invoices etc.

Jen
Mistress Rose

We started with QuickBooks, but we have gone over to Sage now. Not sure I have really got the hang of it even now, but you can use it at so many different levels, so it is good for long term use.

We don't have too many large or difficult transactions, but being a small company, we have to get our books inspected but not audited by an accountant, and a lot of them use Sage.
sally_in_wales

Are you VAT registered Sally?

no, got about a million miles to go before we're anywhere near the threshold, but I'd like to get the accounts in some sort of logical shape before its something we have to start worrying about
sally_in_wales

Try Quickfile.co.uk, it's cloud based so you can access it securely over the internet from anywhere and it's completely free and very good. You can import bank statements and paypal accounts and print and create invoices etc.

Jen

I use them to generate and keep track of the invoices at the moment, and agree its been very good for that.

I haven't been able to work out how to use it to record sales that aren't invoice based though. I think, given that the online shop keeps detailed records of transactions through there, that in principle I could transfer over a 'shop total for month' as one single sum into a recurring monthly invoice set up with 'the shop' as the supplier? Would that make sense?
Penny Outskirts

Are you VAT registered Sally?

no, got about a million miles to go before we're anywhere near the threshold, but I'd like to get the accounts in some sort of logical shape before its something we have to start worrying about

All you need to keep is a record of how much you've taken, and how much you've spent, anything you've spent as a business expense needs a receipt to back it up. Your sales records can be as simple as a hand written book, don't spend any money on systems or software, you just don't need it.
Somewhere-by-the-river

A friend was recommended 'Cashbook' (by an accountant) - apparently you can get a free version... (The friend has a Mac so uses 'Abacus'.) sally_in_wales

I'll be a bit braver about seeing what else I can do with the Quickfile thing, I've certainly found it helpful with the invoices, if I can work out how to make it do the other things I need, and run it parelell to my current excel spreadsheet method this financial year, I might have it working properly for next year.

I know I 'could' just use paper, or the spreadsheet, but I'd like to feel I had a logical system so that as we get bigger and hopefully a bit more solvent, we have a method in place that can grow in a way that some future accountant won't have heart faliure over Embarassed
       Downsizer Forum Index -> Small Business Questions, Ideas and Advice
Page 1 of 1
Home Home Home Home Home