It will put our bank to the correct GBP figure. If the difference is substantial you should check how it came about and, if it is due to some error you will be able to post a journal to the exchange diffs. a/c.
When you d a month end it should prompt you to run the revaluation which you should do.
Your worth is in your skill I once, through health insurance, visited a consultant surgeon who had a consulting room attached to his house. Of course he charged MUCH less for his services (NOT!). I was paying for his skills, acquired through his years of hard work; not for his running costs.
When I worked for a company selling machinery world wide
We had a note which said 'The company does not disclose its turnover by geographic location as it considers that it would be detrimental to its business.'
How would I get relief on my first £1000 savings interest (I wish!). All my savings are in ISAs so it won't affect me but if they were not would this push me into SA?
Presumably the banks will still have to deduct tax on all interest as they won't necessarily be privy to all one's savings.
The used to have a nasty habit of putting out new versions before they were fit for purpose. However once they had sorted out the bugs it was (then) a very good system. It's main attraction was that reporting was very easy once one had learned a few (literally) tricks. All output was to Excel and all transactions in one table, so extracting data was a doddle.
If you decide to go further make sure that they put everything in writing and that the version is a least three years old!
Another thing, not yet mooted:- If we vote to stay in the Eurocrats will have us by the whatsits. Once we are committed they will be able do do absolutely anything in the knowledge that we can't go back, for many years at least!
I only very recently learned how to copy and paste a filtered list! For the benefit of anyone else who has not worked it out, if you go to 'Find and Select' icon and click the dropdown there is a choice called 'Go to special'.
Under that there is a choice 'Visible cells only' which enables one to copy the filtered list.
If anyone knows an easier way I would be glad to know.
Most appropriate method may depend on what you want to do with the result returned. If it is the source cell for other areas of the sheet (ie has "dependents") then use SUMIF or SUMPRODUCT or similar function. If you just want to view the affected items and totals, then you *might* be better off by auto-filtering the table. Then above the Debit column enter =SUBTOTAL(9,D4:D19), and above the Credit column enter =SUBTOTAL(9,E4:E19).
Then just autofilter the table by the desired expense code, and the relevant totals will be shown above the column headings, and the individual entries making up those totals will be shown in the table with others excluded.
Again, if it is just totals that interest you, then a PivotTable may provide all of the expense code totals at a glance, without faffing about with SUMIF
With kind regards
Clint Westwood
Shouldn't the '9' be '109' Clint? 9 will return the grand total even if the list is filtered.
But I suspect that he should have been given a formal share option at the outset. Ages since I have done this but from memory this would have fixed the value at the start date. Others will know more!
My answers
Why do you need to use a guide
Surely you have an invoice or HP/Lease agreement; or is that (i.e. actual price paid) not valid any more? (Genuine question).
You really DO need to run Bank Revaluation!
It will put our bank to the correct GBP figure. If the difference is substantial you should check how it came about and, if it is due to some error you will be able to post a journal to the exchange diffs. a/c.
When you d a month end it should prompt you to run the revaluation which you should do.
Your worth is in your skill
I once, through health insurance, visited a consultant surgeon who had a consulting room attached to his house. Of course he charged MUCH less for his services (NOT!). I was paying for his skills, acquired through his years of hard work; not for his running costs.
When I worked for a company selling machinery world wide
We had a note which said 'The company does not disclose its turnover by geographic location as it considers that it would be detrimental to its business.'
As a pure PAYE employee
How would I get relief on my first £1000 savings interest (I wish!). All my savings are in ISAs so it won't affect me but if they were not would this push me into SA?
Presumably the banks will still have to deduct tax on all interest as they won't necessarily be privy to all one's savings.
Eight years ago!
The used to have a nasty habit of putting out new versions before they were fit for purpose. However once they had sorted out the bugs it was (then) a very good system. It's main attraction was that reporting was very easy once one had learned a few (literally) tricks. All output was to Excel and all transactions in one table, so extracting data was a doddle.
If you decide to go further make sure that they put everything in writing and that the version is a least three years old!
Another thing, not yet mooted:-
If we vote to stay in the Eurocrats will have us by the whatsits. Once we are committed they will be able do do absolutely anything in the knowledge that we can't go back, for many years at least!
On a lateral theme
I only very recently learned how to copy and paste a filtered list! For the benefit of anyone else who has not worked it out, if you go to 'Find and Select' icon and click the dropdown there is a choice called 'Go to special'.
Under that there is a choice 'Visible cells only' which enables one to copy the filtered list.
If anyone knows an easier way I would be glad to know.
CLINT,
Shouldn't the '9' be '109' Clint? 9 will return the grand total even if the list is filtered.
I am no expert
But I suspect that he should have been given a formal share option at the outset. Ages since I have done this but from memory this would have fixed the value at the start date. Others will know more!