Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropping Trial Balance into Financial Statements
I need your expert advice :)
I have my trial balance in a spreadsheet as follows: GL Acct# Jan Amt Feb Amt Mar Amt.......Dec Amt YE Total I want to drop the appropriate line item amounts into the year end P&L, Balance Sheet, and Cashflow Stmt. Does anyone have any suggestions on the easiest way to do this without linking each and every cell to the appropriate cell on the financial statements? Thank you for your help! -Angela |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dropping Trial Balance into Financial Statements
Hi Angela
You need to have a look up code to group your accounts to the financial statements. You make a new sheet with your chart of accounts called coa column A has the account column B has the description column C has the financial statement group column D has the cashflow group ie you may have 1001, Accounts Receivable Asia, BS_AR, CF_AR and then you On the trial balance you insert another column, say in column B, with vlookup(a2, coa!A:C,3,false) this will get the grouping then in the financial statements you use sumif(trial!!B:B,"BS_AR", trial!N:N) It may be easier to have a check on your coa sheet to ensure that the linking tb balances. I hope that explains it. If you like send me an example to his and I will show you. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Ang" wrote: I need your expert advice :) I have my trial balance in a spreadsheet as follows: GL Acct# Jan Amt Feb Amt Mar Amt.......Dec Amt YE Total I want to drop the appropriate line item amounts into the year end P&L, Balance Sheet, and Cashflow Stmt. Does anyone have any suggestions on the easiest way to do this without linking each and every cell to the appropriate cell on the financial statements? Thank you for your help! -Angela |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning a mortgage balance based on a particular date | Excel Discussion (Misc queries) | |||
Can I use Exel to create Financial Statements? | Excel Worksheet Functions | |||
running balance in Excel | Excel Worksheet Functions | |||
How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
How to make aging possible in Excel for an age trial balance shee. | Excel Discussion (Misc queries) |