The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> Book-keeping Software -> VT Final Accounts
Post Info TOPIC: VT Final Accounts
Georgie


Guru

Status: Offline
Posts: 700
Date:
VT Final Accounts
Permalink Closed

As if life isn't complicated enough I decided to have a go at producing a set of final accounts from an old text book and seeing if I could arrive at the same answer as the book....(and I thought it would be easy)

Can someone tell me why in the balance sheet - Creditors amounts falling due within a year the box is empty yet when I click on notes my figures are there? It's driving me crazy no

There must be a VT boffin on here who will put me out of my misery biggrin

 

Georgie



__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Georgie,

start with the simple things (which are normally the things that I miss).

Are you producing you accounts for the same period that you are looking at in VT Transaction+.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Hi Shamus - Well now you mention it I didn't set any dates ...would that be it?

Georgie

__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Georgie,

it's definitely go potential!

set up the periods and the reporting dates and try again.

On of the good things about VT is that if you accidentally miss a step you can always go back and do it afterwards and it slips it in the right place.

Talk later,

Shaun.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Okey kokey I will give it a go, thanks!

__________________
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

noIt didn't work Shamus



__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

not going to have access to VT till the morning. But I really think that this has to be something to do with the dates.

Sure that you wil have an answer before I log in tomorrow afternoon.

in the meanwhile, just to clarify

You are using VT Accounts to produce the accounts and you have correctly set up the dates for the current period and comparitive prior period in the workbook properties (the icon with a P next to a white page which is the second icon across).

Your balance sheet will then have your two years. Current followed by prev.

Now from what you are saying when you look at the notes, note 11, creditors, amounts falling due within one year has data in it but when you go to the balance sheet the entry next to note 11 is blank?

Also worth confirming that in VT Transaction+ you have set up all required period end entries. (These will be identified as YET 000001, YET 000002, etc.).

When you mine down into the creditors figure in VT+ I'm assuming that you are getting the figures that you have in your notes in VT Accounts.

Basically I'm trying to eradicate all of the basics to ensure that all of your data is tieing together and the ossue is purely a differnece in VT Accounts beween the notes and the balance sheet.

If nothing clicks can you paste pictures in here as to the screens that you are having issue with? (cntl, alt & prtscn then paste into paint, save as a jpeg and use the advanced editor on here to load & post.... There's probably an easier way but that's the only way that I know of for getting screen shots on the site).

Sorry that I can't help more at the moment but we'll try to get this sorted tomorrow.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Hi Bill, I cant use  the Trail balance analyser as I am not importing the TB, I am doing it manually...and a right ole mess I made of it too!  no Still at the day job...trying to look busy, wishing I was at home!!

I will let you and shamus know how I get on later.

Georgie



-- Edited by Georgie on Friday 4th of May 2012 12:31:47 PM

__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Actually, as this is only test data lets go plan B.

if it's still not making sense this morning send me as attachments

1) the .vtr extension file on which your accounts are being built

2) the final accounts saved as either .xls or .xlsx file extensions.

I'll then bring the laptop home and have a look at your file after the school run today so around 16:00(ish) after I've just checked to ensure that we've got no spammers or any threeads getting out of hand.

Talk later,

Shaun.

P.S. Worry not, this will be something simple. In IT there's a term for it called code blind where you look at a problem for so long that you see what you think is there rather than what is actually there.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

.

 

Right off to find the hammer!...I can't do it!
-- Edited by Georgie on Friday 4th of May 2012 04:11:13 PM



-- Edited by Georgie on Friday 4th of May 2012 04:28:18 PM

__________________
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Good morning Shamus,

Hey thanks for this! I am at work at the mo (the day job) but will have a good look at it again when I get home later. Because I was only trying to do an exercise out of an old text book I didn't really set it up properly and maybe that's it. So I will look at your suggestions and go through it.

Best wishes
Georgie

__________________
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Hi Georgie

Have you tried actually previewing the printed version ( the button on the tool bar that looks like a landscaped sheet of paper)?

The reason I ask is that if something is missing, you usually get a message saying that the balance sheet doesn't balance, and shows you where the imbalance lays (well the cells that aren't equal, anyway).

This usually happens when you insert an account line in Final Accounts, or add a custom account in VT+ that does not match the preset Final Accounts categories (Although you usually get a warning when you import). You can check that using the Trail balance analyser button on the tool bar (blue box with dark blue thick line at top), which checks that your ledger accounts are assigned to the Final Accounts categories.

Likewise as Shaun, if you can send the files happy to check it over

HTH

Bill



__________________

 

 
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Hi Georgie

So you have entered a manual TB.

Sounds like you may have created a line in the TB that has not been linked in the balance sheet (that's only a guess at the moment though).

Speak later

Bill



__________________

 

 
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

confuseOK, had another look and I can't figure it.

I have got the P+L to match the text book (But did I actually put the figures in the right place)?

The balance sheet is way off - some of the entries in VT I don't understand and there is no explanation to tell you which figures go where- some are obvious but I don't understand the terminology of some of it.

As I am using a tb out of a text book there is no comparitive year.

As far as I can tell I have entered the dates OK.

I am so glad I didn't pick a difficult exercise to do !

 

Georgie





__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Just post the .xls on here Georgie and Bill and myself will fight over who can solve it fastest.... Actually, Bills going to have a whopping great advantage as I've got to go pick a pakage up from the post office (more accountancy text books biggrin... How sad am I that I get excited at getting new accountancy text books!!!)



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Bit drastic no

Can you send an email attachment through the private message function in my profile?

Bill



__________________

 

 
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Yes I will do that, thanks Bill!

__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

me too...

believe it or not only just discovered after Bills post that the site had a private messaging function... Doh... Again you prove yourself the master Bill.

When we've got the messages I'll still paste back on here as don't like to take things off site.... Well, unless it's one of you girlies out there wanting to have your wicked way with me then private message away wink lol



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Bill I sent you an email, think it went to your business address though.

Shamus@ you make me laugh.....you'l be inundated in a little while when the wine gets opened,biggrin



__________________
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

OK, stupid question...how do you know when you've got a private message?

__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Georgie wrote:

OK, stupid question...how do you know when you've got a private message?

The message just comes through to the email account that you used when you set up your forum account and when you reply it replies to the actual email account of the person who sent the message but depending on the settings that you used it doesn't show the email address that the message came from, only the userid of the forum account.

Anyway, I'm inpeeding on your wine supping and sending me naughty messages time! lol



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Oh OK..........Do you know, I even surprise myself sometimes with my stupid questions....Def not been myself this week laughing.gif



__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

worry not, there are no stupid questions, only stupid answers (and some of there aren't even mine!).



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Georgie wrote:

Bill I sent you an email, think it went to your business address though.

Shamus@ you make me laugh.....you'l be inundated in a little while when the wine gets opened,biggrin

 No problems, it arrived last night but I didn't get to read it 'till this morning. I replied with a modified version. Hope you get it OK, it is quite a large file.

Morning Shaun. How's things?

I did try to attach my workings in this reply but it is to large, so I am attaching just the TB part (hopefully).

Bill



Attachments
Unicorn TB.xlsx (22.0 kb)
__________________

 

 
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

biggrin Wahey!!

Thank you so much Bill, I owe you one!

 

Georgie



__________________
Shamus


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Bill,

been in and out of the site this morning so sorry didn't pick up this thread immediately,

unfortunately didn't get the email so couldn't play with this one

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
Georgie


Guru

Status: Offline
Posts: 700
Date:
Permalink Closed

Sorry Shamus, it was a really big file ... Didn't want to risk upsetting both of you!  no

Georgie



__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum (UK) -> Book-keeping Software -> VT Final Accounts
Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About