Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Cedar Falls, Iowa, USA
    Thanked 0 Times in 0 Posts

    strategy advice part 2 (A2002)

    This is the second part of my three part question. Again, the big picture of what I need to accomplish is this: take utility bills, break out the various tax amounts reported on them, total them and then report those amounts by quarters.

    My question is this: I need to report the tax amounts totaled by quarter, however the utility bills usually don't bill by quarter. Indeed the billing period may be from mid-month to mid-month while the quarter is from the first day of month 1 to the last day of month 3.

    I'm not coming up with any practical ways of setting this up and could use some suggestions. Thanks for your time in considering this.


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 33 Times in 33 Posts

    Re: strategy advice part 2 (A2002)

    I think you merely have to base your reports on the date of the billing. If it is monthly, you will only get 3 bills per quarter whether it is billed mid-month or end-of-month.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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