In the new version of Excel 2007, we see the power of Pivot Table being enhanced again with the capability to work directly with database servers.

consolidating excel entries-24consolidating excel entries-72

Functional currency issues SFAS 52 introduced the concept of functional currency, defined as "the currency of the primary economic environment in which the entity operates; normally, that is, the currency of the environment in which an entity primarily generates and expends cash." For example Z company's subsidiary Y company deals with 5 countries. All these Transactions are often translated at the spot rate, i.e., the rate of exchange between the transaction currency and the functional currency on the date of the transaction.

Let’s be more practical today and learn some advanced accounting techniques.

How do you merge multiple Excel worksheets into one master worksheet, The file I’m working with, which you can download here or at the end of this post, is for a fake used car dealership that sells the Honda Accord, Honda Civic, Toyota Corolla, Toyota Matrix and Toyota Camry.

There are 30 employees and three separate worksheets (one for January, February and March), each containing the total cars sold that month per employee, per car. The best way to learn is to practice yourself, so click the link below to download the Excel 2010 workbook used to show the methods described in this post.

For solving this issue, International financial reporting standards have given some guidelines. Pre-acquisition equity will be translated at historical rate Subsidiary company's pre-acquisition equity will be translated at historical rate. The foreign financial statements must be recast into US GAAP and the foreign currency financial statements must be translated into US dollars. No additional work is needed if the functional currency is the U.

Suppose, shares capital of Y company before acquisition was Pre-acquisition rate was 1$ = RS. Like USA, there are many country's GAAP follow such rules. Re-measurement of foreign currency financial statements into a subsidiary’s functional currency The remeasurement of the foreign entity’s statements into the functional currency of the entity After re-measurement, the statements must then be translated if the functional currency is not the U.

Here’s the question: Mommy Corp has owned 80% shares of Baby Ltd since Baby’s incorporation.

Below there are statements of financial positions of both Mommy and Baby at 31 December 20X4.

And the calculation becomes even more complex if the components include fixed cost and step up cost.