Well Rajesh
Regards, Vivei do not think there is a specific formula... its just that i would create a vba application which would transfer the entries from the trial balance to the respective target reports... Regards Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Jul 21, 2009 at 7:21 PM, Rajesh Janardanan <rajesh...@gmail.com>wrote: > > Thanks Vivek. > But what are the tools or formulas in excel we can use for doing this > package ? I would like to try my self. > > Best regards > Rajesh > > On Tue, Jul 21, 2009 at 2:18 PM, Vivek Agrawal<vivek.agrawa...@gmail.com> > wrote: > > > > Hello Rajesh > > > > For this you would require to send the following excel files so that > > the format and the structure can be used... > > > > 1. The report which you download from SAP.... > > 2. the format in which you want the P&L, Cash Flow and the Balance > > sheet.. > > > > Thanks > > > > On Jul 16, 7:42 pm, Rajesh Janardanan <rajesh...@gmail.com> wrote: > >> Dear All, > >> I need some ideas from you experts. > >> I need to design a financial reporting package. I can download the > >> trial balace from SAP in excel format after monthly closing and > >> accounts have unique GL numbers , I want a package to be created where > >> I need to get all reports populated immediately after I download the > >> TB every month. > >> Please advise me how shall I proceed ... Reporting package I am > >> looking are balance sheet, P&L and cash flow and many other reporting > >> packages. > >> > >> Best regards > >> Rajesh > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
