This post is the result of observation, trial and error. If you are an accountant, and you have suffered for the statement of changes in fi...
The Pivot tables are an incredible Reporter. And if you know them you can parameterize anything. Ok. ¿How to parameterize or configure a database to obtain the statement of changes in financial position?
Follow these steps:
One: If you know the financial statement, you get to know the differences between the movements of the final balance less the opening balance.
Two: You must have a trial balance of the annual period: January 1 of year to work until December 31st of the year to work.
Three: Needless to say, that in the profit and loss accounts, the opening balance is zero and that the balance must be square.
Four: In a spreadsheet, get the difference unless Opening balance Ending balance, the variation.
Fifth: In a new column, to all accounts in the income statement will name "1. Profit or Loss for the year."
Sixth: The asset accounts related provisions, Depreciation, Amortization, the will name "2. Charges (credits) not affecting working capital:"
Seventh: The accounts of Capital and Reserves, the will name "3. Increased capital"
Eighth: The accounts of the profit or loss for the year and profit or loss of previous ejercios (heritage), the will name "Distribution Utilities"
Ninth: The rest of the assets and liabilities, name them according to their current and noncurrent portion. (Current assets, noncurrent assets, current liabilities, noncurrent liabilities.) If the account "Accounts Receivable", "Customer" or accounts receivable and have current portion of long-term portion, you must separate each one and classify current assets and active in non-current. The same for investment and other items of current assets. Same for current liabilities, most of all with regard to loans from financial institutions or other lenders.
Ok, this is the first part, which is like the "top level". Now comes the following grouping:
In a second column:
The 'profit or loss for the period ", the" Charges (credits) not affecting working capital "and" Capital increase "will call" 1. Provided Resources ".
The assets and noncurrent liabilities, and distribution of profits, will name "2. Financial resources applied to"
The assets and current liabilities will name it "3. Changes in Assets and Current Liabilities"
In a third column:
to "1. Provided Resources" and "2. financial resources applied to" the will name "1. Increase or decrease in working capital."
Finally, the "3. Changes in Assets and Current Liabilities," call it "2. Analysis of changes in working capital"
If you believe that any accounting item is incorrectly configured, you can correct the parameterization in the base and refresh the PivotTable.
Well, having configured the balance, we can now make a pivot table that we assemble in seconds the statement of changes in financial position
VERY IMPORTANT: Please note the signs. Credit accounts are negative in nature, if you had utility, you will see credit balance, negative, in red. So, to not confuse readers of the report, you must arrange the signs. But, we need the signs according to the nature of the accounts to see if the match report. Similarly you can build cash flow by the indirect method.
You will understand much better if you download the example here.
I appreciate share the entry on social networks: Twitter, Facebook and Google Plus. Help me to show my blog please.