Trying to make my quarterly City mill tax report preparation easier.

SOLVED

I'm trying to make my quarterly City mill tax report preparation easier.  This requires providing subcontractor payment amounts for the particular calendar quartier.  Presently I'm using the AP  Payment Register by Job, selecting the jobs which are in the geographical area of the City, and selecting the date range for the quarter.  Then I have to go in and sort through the subs and total their payments for that time period. 

Do you know if there's a report which would give payment totals by subcontractor for a particular date range over a selected group of jobs?

  • +1
    verified answer

    Do you include a local tax group on the setup of the Jobs that fall into the reporting geographic area? (Job Cost, Setup, Jobs, AP and GL tab, tax group) Does the report need to sort first by vendor and then Job and provide a total for each vendor? Does this reporting apply to only those Vendors set with a vendor type = Subcontractor?

  • +1 in reply to Denise Paulus
    verified answer

    Denise:

    1.  Thank you for your reply. 

    2.  I hadn't included the tax group you mentioned in the job setup.  It sounds as though that would be fairly easy.   

    3.  The sorting you described would work.  

    4.  Yes, only applies to subcontractors.  

    5.  I don't know if I mentioned it, but this would also have to be for a specific date range, typically, one calendar quarter.  

    Thank you again for your reply. 

  • +1 in reply to Charlie Menghetti
    verified answer

    The Payment register by job allows a date range to be entered related to the date the invoice was paid.  A condition can be added to the report to show only the paid distributions associated with a specific tax group.  To add that condition you would select conditions in the Print selection window, then Add, then Index to select the AP Distribution record, the Tax Group EQ ..in the value enter the ID of the tax group for that is associated with City Mill. Click OK twice and then enter the range of dates in the print selection window

  • 0 in reply to Denise Paulus

    Denise:

    1.  Thank you so much!  As soon as I come up for air, I'll give it a try!  

    Regards,

    CM