Re: Setting up to do my accounts (very newbie!)

Keeping your records month by month will affect your ability to draw out
information for analysis. For instance, consider that you would have to
make a new work *** each month - including any analysis that you do.
Multiply that by the months and years that you expect to be in business and
you have a large administrative overhead.. It would be much more effective
to keep one 'day book' from which you can draw out information (possibly
using a pivot table) to your hearts content.

I would also suggest you have a word with your (or an) accountant. He has
the responsibility to advise you and, to do that, would expect some input
from you so it's as well to ensure that you can work together. He may be
able to suggest - from experience - a way to set up a spread*** or may
recommend specialist (inexpensive) software.
--

Regards.

Bill Ridgeway
Computer Solutions

"Ron O'Brien" <ron@xxxxxxxxxxxxxx> wrote in message
news:fjc8j19ig640o8cnfu90ctbatnstphsce5@xxxxxxxxxx
>
> Having done my small business accounts for years in 'book' format I am
> now moving towards the idea of doing them on the computer.
>
> I am fairly new to the technicalities of spreadsheets.
>
> It seems to me the neatest way to do my annual accounts is to have
> each work*** represent a different month - is that feasible? is it
> possible? can I change the name from '*** 1' to 'January *** 2 to
> february etc?
>
> My stubbling-block seems to be working out how to carry-forward
> balances from one *** to another. Is this possible or am I going
> about the whole thing the wrong way?
>
> Any help appreciated
>
>
> Ron


.