Forum Discussion

kenthub's avatar
kenthub
Icon for Helper I rankHelper I
8 years ago

Profit and Loss statement - help with hierarchy

I know its been asked and I have checked all the suggested articles, but I need some help!   I'm trying to get this: This image is from thebiaccountant.    The guy talks way over my head a...
Need Help
Tips and Tricks
Tutorial Requests
kenthub's avatar
kenthub
Icon for Helper I rankHelper I
8 years ago

Gotcha. How or what would you use to connect the two tables? Like the YouTube video above shows there are headings, subheads, sub-subheadings, etc.   Would it be best to associate a number linking the specific Chart of Account (Revenue, Cost of Sales, etc.) to the desired GL number? Or would you used some other method of connecting the tables?

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
8 years ago

 

The connections between the tables can be seen in the sample files from my blogpost.

If you're struggling to apply it to your data, I would need to see your tables.

  • kenthub's avatar
    kenthub
    Icon for Helper I rankHelper I
    8 years ago

    ImkeF link to your blog post? 

    • ImkeF's avatar
      ImkeF
      Icon for Community Champion rankCommunity Champion
      8 years ago

      It's in your first post - I'm "The guy" ;-)

      (Unfortunately Microsoft decided to delete the signatures here in the forum and I gave up adding them manually)

       

      • kenthub's avatar
        kenthub
        Icon for Helper I rankHelper I
        8 years ago

        Great! I didn't see the downloadable files. I'll sift through them to see what you have done and get back to you. 

         

        Thanks!