Suggestions For Revenue Reporting
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Suggestions For Revenue Reporting

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have just been given the task of doing the revenue reporting for the company. Does anyone know of any sites I can visit to get ideas on how to present the data and store it efficiently in Excel.

    The current method uses 10 workbooks with 5 to 40 spreadsheets each. From these 10 workbooks, 10 diffrent sheets are copied to the 1 main report which is sent to Mgmt. There are a lot of links and formulas that slow down my computer. I was thinking of moving the data to Access but, what about the calculations?

    Any ideas, suggestions or if you have encountered the same issues, please respond.

    Thank you

    Parra

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Revenue Reporting

    why what reason, accounting, accountant , IRS??


    many agencry have own Excel stuff now or IRS will do for you if small buisness.. OK UK they will world wide best check

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    just thought not really excels thibg could be done with namy ledgers and report i guess. but accounting softwar that will inport export with esxcel best Uk we use sAGE sUN, AND PEGASUS.


    or some bespoke like XKO, as400 unix sco XKo whatever...


    you should have accountant check wahts legal in you location... best call...

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Its for Financial Analysis, more for managerial reporting, analysis of trends, mostly comparing 2002 week to 2001 week and Year to Date.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    no excel stuff to start will been dumped the job ???


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We'll the excel reports they currently have, they have been using for at least 4 years. I am looking to make these things more efficient.

    We'll see how it goes...

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    more efficant ?? how do you want to improvbe them....


    Scripts >>> sorry that s VBA

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    We'll I have some ideas, merging some of the workbooks, copying pasting values of data to eliminate formulas...I guess I really don't know and that is why I was hoping for some suggestions.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com