×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Accounts Software

Accounts Software

Accounts Software

(OP)
Not *exactly* VFP, but maybe one of us has come across something...

A customer just started a tiny offshoot company and asked me if I would develop a system to do his bookkeeping and prep his CT600 (UK tax for companies).
I said it would be an expensive solution to do it that way, and suggested a spreadsheet system I've used in the past (costs about 50/year) called DIY accounts.

Do any of you have anything similar you could recommend - for my own Ltd I use an in-house database for the day to day, then hand over to accountant at year end,
that system is all VFP (hence why I thought maybe one of us use something similar), but it's developed for my business and doesn't do the CT600 (it does do the VAT via MTDSimple).

Any ideas?

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Accounts Software

Griff, you haven't given us the most important piece of information: the likely data volumes. The fact that this is a " tiny offshoot company" suggests the volumes will be low, at least to begin with, but they still need to be taken into account.

If that's the case, I would agree with you that he should consider some sort of spreadsheet solution. I've seen this done in several small businesses, and it works well if properly thought out.

You would typically have a page within the workbook for each of the following: purchases (with a separate column for VAT); sales (again with a VAT column); bank account; cash (if applicable); perhaps directors' loan account (if applicable); VAT summary (showing the figures to be copied to VAT100 or the equivalent for MTDSimple); and finally a summary sheet that shows totals of sales and purchases to date. The purchase and sales sheets could have columns to analyse the transactions into cost centres or departments.

The CT600 is another matter. Does not HMRC have a free on-line tool for that? That might involve manually cutting and pasting from the spreadsheet, which is perhaps not ideal, but would still be do-able.

And will this business use a professional account? If so, he or she would almost certainly have their own software for doing the CT600. Your client should be able to simply send them the workbook and they could do the rest (not to mention PAYE and other stuff like that).

I hope you manage to find a good solution. Let us know what you finally decide to recommend.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Accounts Software

(OP)
Thanks Mike,

He's talking about a business that has maybe FOUR invoices a month, perhaps TWO expenses, no VAT.
He doesn't want it involved with his other interests at all though, an entirely new company, not part of
his existing organisation.

The DIY accounts spreadsheets might actually be too complex for this! As for developing something new, that
would make no sense at all - so I was just looking for suggestions.

Were it me, I'd probably use the thing I know, but perhaps someone here has heard of something opensource or whatever.

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Accounts Software

Griff, with such very low volumes, is it worth using a computer at all? I can't imagine it would take more than a few minutes to enter the transactions on a sheet of ruled paper, and to tot them up manually at the end of the accounting period. Of course, you know his preferences better than I do, but I would think that even a simple spreadsheet might be over the top in this case.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: Accounts Software

(OP)
Exactly

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Accounts Software

(OP)
In fact, you have given me an idea.
I used to be RFO for a local council, they had a really clever (but really simple) spreadsheet.
I'll cook that up for him, boil off all the stuff he doesn't need, change a few headings and he can maintain it himself.

Can't use paper any more Mike, gotta Make Tax Digital happy shades

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Accounts Software

(OP)
Thank you

It's the problem being a developer, customers think you can do everything and not all give you value added

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Accounts Software

There is a popular accounting software here in India, called Tally. It doesn't cost much here.

I think they have solutions for UK too. No idea about their pricing though. Check here: https://www.tallyaccounts.co.uk/

-------------
Looking for knowledge from anyone, anywhere.

RE: Accounts Software

(OP)
Thank you I will take a look.

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Accounts Software

Is there no British equivalent of Quicken/Quickbooks?

Tamar

RE: Accounts Software

(OP)
I think they are called Quicken and QuickBooks... happy shades

Thank you, Mike pushed me in the right direction, the spreadsheet took a couple of hours to customise for him
and it's done and dusted... didn't need an app for something so simple.

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

RE: Accounts Software

@GriffMG, that makes sense, but because you were asking and this seemed to me to be exactly the sort of thing where Quicken or Quickbooks would make sense, I thought perhaps there were no UK versions.

Tamar

RE: Accounts Software

(OP)
It is the kind of thing you would use them for, but probably only if it was about 10 times the size!

On the off-chance anyone is interested:

https://files.engineering.com/getfile.aspx?folder=...

happy shades

Regards

Griff
Keep Smileing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close