Hi Narayan,
About five percent of the lines are matched by the system (I excluded them from the sample). They are always matched on the same date.
I manually matched amounts were debit = credit (1:1). Most of them match the same day. I have a few outliers which I think are accidental.
I did...
Hi Narayan,
First of all thanks for your help. I really appreciate it.
I cannot be sure that there are any matches but from an accounting perspective it is highly unlikely that there are none. The only reason I can think of is that debit and credit are further apart in time and that the 300...
Sorry it took longer to upload the workbook, but here it is
https://dl.dropbox.com/u/83088130/Chandoo%20VBA%20accounting%20problem.xls
@Hui, I found those options when I googled, but I do not have enough VBA experience to adapt them to my specific situation. Thanks for the input.
The process is a one time process. I have to repeat it for several GL accounts. They told me around 10 in total. After that the new system takes over.
I also know for sure that not all entries will matches. Some are simply to recent.
The list I am working with is a system dump and contains...
I have an accounting problem. I need to clean up a list of about 17000 lines. Incoming and outgoing payments have to be matched, meaning the sum of a group of invoices is exactly zero. The system has matched about 200 of them and I found about 300 more where debit and credit are exactly the...
I have this query (in Excel) on a Hyperion Database. One of the lines reads like this:
<Link ((<LEV("Customers", "Lev0,Customers")) AND ( <IDESC("FRANCE")))
In this case FRANCE is a variable for a country. There are some 20 countries in all.
I get the name of the variable from...
Hui,
Once again thanks for answering my question. I did a few tests and it looks fine, so I am gonna break the links and send out the reports. Thank you for your help.
Gert-Jan
I work in asset management and was wondering what everybody's ideas are to track the change in assets that we manage (overall).
Broadly speaking there are two influences:
- Investors' money flowing in and out of funds (inflow)
- Value of investments that changes with the markets (market...
I have several reports where I copy sheets with lots of graphs and data points to a new workbook. I want to break the links to the graphs, but am a bit worried that I will get errors. I've tried it and for now it works fine. I've seen that Excel remembers the values. Is there a limit to the...
Exceluser is the site that really taught me the most when I started to develop my first dashboards
http://www.exceluser.com
The site itself looks flashy. Don't let this fool you. The example dashboards and graphs and stuff are clean, stripping out all the superfluous bits and pieces.
By far the most interesting site for me is the sparklines for Excel blogspot
http://sparklines-excel.blogspot.com/
100 per cent inspiration
Discovered it through PHD a month ago and have been testing it ever since. it is brilliant. Gives me the chance to spend more time on analysis and...
Usually I find sites of interest when I am trying to solve a particular problem.
http://www.codematic.net/
In this case i wanted to audit spreadsheets and I found the codematic website.
They sell all kinds of Excel products, but also have a few very nice free tools
It is the colourmapper...
Hui thanks for your suggestion.
The Excel macro recorder doesn't recognize Essbase.
I found another solution that I want to share
When saving a query two files are generated an query file (*.eqd) and a report file (*.rep)
You can drag the report file into Excel where it is displayed as...
For now i have solved it using a defined name for year In this formula it is the only thing that is different between Dutch and English. In Dutch jjjj, in English yyyy.
I've been searching the net for days now. I asked our IT department, they don't know either. Not sure if this is the right place, so apologies if I'm mistaken.
In the office we use Excel 2003 combined with Hyperion Essbase 6.5 to retrieve data from our databases.
Every month we prepare a...
Sometimes I keep my to do list in Outlook and sometimes on paper. Had a quick look at Excel, but didn't like it because I need to synchronise manually with Outlook.
I saw a couple of commercial products for sale as well as some free ware.
Anybody using Excel for maintaining their task lists...
Hi Old Chippy,
Had a quick look at the web site and at first glance it's just what I need.
Currently we're having Quarter 1 close at the office, so I'll have to delay this a couple of weeks. Thanks for your suggestion.
GJ
In another posting I mentioned that I'm preparing reports (Excel 2003) that are used by people with different regional and language settings in Windows (Because of their location or they global IT profile)
For instance on the first page of the report the reporting date is printed using TODAY...
Hui,
Thanks, I tried it and it works perfect. Didn't know that there was a function called choose. using the text function to control the formatting is really nice too.
Why I choose to divide the number by 1000 or so is that this way you get the result (by vlookup or different) and apply...
Hi,
Just discovered that you can use styles in Excel as well. I have a report (Excel 2003)where I control the number by simply dividing this by 1000, mln or bln (Investments). I think using the appropriate format would be better, but I generate some 20 country reports from the same file. Any...
Hi all,
Let me introduce myself, my name is Gert-Jan and I work as a controller at a large asset management firm. First I have to say that I think the website is great. It has given me lots of new ideas. Thanks for that.
I've developed this new report (Excel 2003). How can I make sure that...