Not enough expense headings 48 or 23?

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #1892
    Ian
    Participant

      Why on the Info sheet do we get 48 expenses headings (not enough really for us) but then on the data sheet we only get 23 and they do not tie in to the aforementioned 48 (which you can select but they obviously dont fit)?
      Ian

      #1894
      Ian
      Participant

        In short how do i get my 48 headings and costs onto the data sheet……………

        #1895
        Russell Bowyer
        Keymaster

          Hello Ian, the 48 headings on the ‘Info’ tab are so you can add new ones, to then select them from the drop down list on the ‘Data’ tab, rather than over type the existing ones.

          What you select on the ‘Data’ tab for each expense heading is what shows up on the ‘Overheads’ report, which has been restricted to the 23 headings, as this is what would fit on the page, otherwise the text would be too small to read.

          Out of interest how many expense headings were you looking for for your business. The trouble is that too many will make the text too small to read.

          Are you able to combine some of your expense headings in any way?

          I hope this answers your questions.

          #1897
          Ian
          Participant

            We have about 100 across all departments, I’ve done a first sweep and got that down to 32 whilst still maintaining meaningful headings/groupings – i’ll have a second go at further grouping but its not ideal as each heading has cost and budget against it so we’ll need to unravel everything for variance analysis.

            Thanks

            Ian

            #1898
            Russell Bowyer
            Keymaster

              Hello Ian, okay let me know how you get on with reducing them down.

              You’ve given me an idea, if I produced an optional overhead report without the sub headings, I could get more on the report without the text looking too small. However, it is set up with the sub-headings to correspond with the profit and loss report, and this would need some re-thinking too, as it’s important they correspond.

              Let me know and we can go from there, but I’d be concerned at having 32 expense headings as this is another 9. The text would be very small and hard to read.

              Regards.

            Viewing 5 posts - 1 through 5 (of 5 total)
            • You must be logged in to reply to this topic.