Share this content
0
34
8622

Trial Balance in Excel

I tend to use A3 Trial Balance Paper, on manual jobs, with the 14 columns-Balance b/fwd,Bank Account, Cash Account etc.

This can be quite time consuming, particularly when adding up a column or when making a mistake and having to re-add.

Has anyone devised their own Trial Balance in Excel or could someone point me in the direction of where I could download my own version.

Many Thanks
Jonathan

Replies

Please login or register to join the discussion.

avatar
By Anonymous
12th Mar 2006 10:42

3rd time lucky
I requested a copy on 26 Dec and again on 12Jan.
No joy as yet.
Have others received a copy?

Thanks (0)
avatar
08th Mar 2006 12:17

James Pearce TB
Hi James, Could you mail your TB, yes late in the que but hey its drum beats here in Z.
Many thks
K

Thanks (0)
avatar
By Anonymous
08th Mar 2006 15:58

Didn't get my copy...
...James sorry to be a pain but I did not seem to get my copy...

nick at yorkshireaccountancy.co.uk.

Thanks.

Thanks (0)
avatar
16th Jan 2006 08:29

E-mail addresses
There is some concern in the posts regarding the possible use of email addresses supplied for spamming. Look at spamgourmet site (www.spamgourmet.com) for how to create free disposable email addresses.

Thanks (0)
avatar
23rd Dec 2005 16:15

lots of takers
perhaps you should ask for a nominal fee to cover the admin?

Thanks (0)
avatar
27th Dec 2005 16:19

copy also

would also appreciate copy

tia

Thanks (0)

Have you thought about setting up a database TB?
I know it's tax season and everyone is probably most interested in a quick fix.

But the message from ExcelZone is that spreadsheets are not the ideal media for retaining important data for the long term (it's too easy to change/overwrite).

For those who have a bit of time on their hands and are curious about how databases can be used for such tasks, check out Simon Hurst's tutorial series on how to build an extended trial balance application in Microsoft Access. There's also a short introduction on how to set up a basic TB.

You can subscribe to the ExcelZone newswire to receive free fortnightly updates on spreadsheet news and tutorials. (NB - when it has signed you up, the link will take you to the AccountingWEB home page).

Good luck - whichever solution you choose!

John Stokdyk
Technology editor,
AccountingWEB.co.uk

Thanks (0)
avatar
By Anonymous
23rd Dec 2005 13:45

May i jump on the bandwagon.......
and have a copy also? I am hoping to get in before you are inundated!

Many thanks


Julie

Thanks (0)
avatar
05th Jan 2006 12:29

ok
All,

I shall send out another batch later today. Please ensure you email address is listed if you want it!!

ONCE YOU HAVE RECEIVED IT PLEASE EDIT YOUR POSTS TO REMOVE YOUR EMAIL ADDRESS SINCE YOU WILL LIKELY GET A LOAD OF SPAM FROM AUTOMATED WEB-CRAWLERS.

Thanks.

Thanks (0)
avatar
By Briar
05th Jan 2006 13:19

Are so many computer illiterate accountants!?
I have been using Excel (or its forerunners) to produce ETBs ("Extended Trial Balance" for those who might not know the term) for about 20 years now! The data for the ETB comes direct from Cash Book/Bank Statement Analyses via links. The the results of the ETB are transferred to a final set of accounts (sole trader/partnership/company/whatever)again via links. Each case is tailor made for each client. To use the ancient A3 analysis paper would be like going back to read H Foulks Lynch's Spicer & Pegler Book-keeping & Accounts

Am I astounded that any modern day accountant could ask such a question. At first, I thought it must be from a student starting out on a GNVQ course in book-keeping but then all the requests for a copy started appearing.

Unbelievable!!!

I suggest that the ICAEW takes all the names of those asking for copies and arranges a Practice Assurance visit on them.

Thanks (0)
avatar
05th Jan 2006 13:59

Ian
What has paper got to do with Practice Assurance?

It's comments like yours that often stop people from asking for help or simply expressing an interest.

Perhaps you might like to explain what constructive purpose your post serves?

As you're obviously such a God, why don't you offer your spreadsheets - and perhaps we can all learn something from your exemplary coding skills?

Thanks (0)
avatar
By Anonymous
26th Dec 2005 13:55

No problem Sheelagh...
...website is http://www.yorkshireaccountancy.co.uk/

Simple cashbook spreadsheet priced at £9.99. It is intended for one client use only but we can negotiate on that.

Merry Xmas!!

Thanks (0)
avatar
By Anonymous
23rd Dec 2005 20:27

Me too please
Please may I have a copy too. Thank you.

By the way, if you go to Nick R's Yorkshire Accountancy website, you can buy an excellent bookkeeping Excel spreadsheet to a very reasonable fee. (hoe you don't mind me mentioning it Nick)

Merry Christmas
Sheelagh

Thanks (0)
avatar
23rd Dec 2005 09:45

yes
Post your email address (maybe setup a hotmail account) and I'll send you one with linking journals (woo-hoo!).

Cheers

Thanks (0)
avatar
23rd Dec 2005 17:06

on its way
All

I shall send out the s/sht shortly.

Alister - what they don't realise is that it has a secret macro which sends me their client lists!

Only joking - Merry Christmas all.

Thanks (0)
avatar
By neileg
23rd Dec 2005 09:15

?
Surely it would take about ten minutes to set this up from scratch?

Thanks (0)
avatar
05th Jan 2006 14:26

I'm mostly with Ian on this
the question relates to something relatively trivial, and something which any qualified accountant should be able to create with ease. and within 10 minutes max.
I can see no harm in using analysis paper to get the same result, but spreadsheet solution is much more efficient.

Thanks (0)
avatar
By Anonymous
05th Jan 2006 16:56

Well Done James for providing everyone with the TB Spreadsheet.I didn't realise that this many people would ask for a copy. Sorry to have asked in the first place!

Find Ian's comments a bit much. As James says-why doesn't he make his spreadsheets available to everyone

Thanks (0)
avatar
27th Dec 2005 07:32

try "more" software
how about getting your clients to use "more" software - the cashbook package. I'v ebeen giving it to my clients for 2 years and it gives you a complete TB at the ye.
www.moresoftware.biz

Thanks (0)
avatar
31st Dec 2005 21:58

Me too please
Grateful if you would send me a copy too.

Many thanks and happy new year to you.

Regards

Joy

Thanks (0)
avatar
05th Jan 2006 23:01

Debi, please post your email addr

Thanks (0)
avatar
By Anonymous
23rd Dec 2005 10:14

Thanks James

Thanks (0)