Trial Balance in Excel

Trial Balance in Excel

Didn't find your answer?

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 (34)

Please login or register to join the discussion.

avatar
By User deleted
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
By AnonymousUser
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 User deleted
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
By User deleted
10th Feb 2006 09:43

Can I have a copy please
Sorry James, only saw this tread today. Could you send me a copy please;

[email protected]

Many thanks
John

Thanks (0)
avatar
By PeterCalderley
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
By User deleted
10th Jan 2006 18:50

Copy too please
Hello James,
Please send me a copy at [email protected]
Thanks.

Thanks (0)
avatar
By User deleted
12th Jan 2006 17:10

Polite Reminder
Sent original request on 26 December and as yet have not received the spreadsheet.
[email protected]

Thanks

Thanks (0)
avatar
By User deleted
23rd Dec 2005 13:40

One more if you don't mind...
...Sorry. You may live to reget this!!

[email protected]

Regards and all the best.

Thanks (0)
avatar
By AnonymousUser
23rd Dec 2005 15:14

Please may I have a copy
[email protected]
Thank you and Happy Xmas!

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

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

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

copy also

would also appreciate copy

tia

Thanks (0)
avatar
By gus.donnelly
23rd Dec 2005 12:20

Me too please
Hi

I would appreciate a copy of your spreadsheet - [email protected]

Thanks

and Merry Christmas

Thanks (0)
avatar
By AnonymousUser
31st Dec 2005 10:58

Could I jump on the bandwagon please
e mail to send spreadsheet to is [email protected]

Thanks (0)
avatar
By User deleted
28th Dec 2005 12:20

Me to please......
Sorry to add to the growing list, but could you please let me have a copy :

email : [email protected]

Thanks in anticipation

Thanks (0)
John Stokdyk, AccountingWEB head of insight
By John Stokdyk
28th Dec 2005 17:46

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 User deleted
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
By porterj
05th Jan 2006 12:15

ME TOO !!
I would also be grateful for a copy of the spreadsheet.

My email address is [email protected]. Many thanks

Thanks (0)
avatar
By AnonymousUser
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
By AnonymousUser
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 User deleted
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 User deleted
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
By AnonymousUser
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
By AnonymousUser
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
By listerramjet
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 User deleted
26th Dec 2005 11:01

Please may I have a copy
[email protected]

Thankyou

Thanks (0)
avatar
By User deleted
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
By shaunmcguinness
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
By Joy Eziefula
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
By derek_allwood
06th Jan 2006 12:27

....and still they come...
Pls can you sned me a copy before you turn off the tap.........to:

[email protected]

Many thenks

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

Debi, please post your email addr

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

Thanks James

Thanks (0)
avatar
By AnonymousUser
20th Mar 2007 05:44

Well done
James,

Please send a full copy of ETB for analysis.
email:[email protected]


Thanks

Larry

Thanks (0)