• Exporting all Formulas (spreadsheet based) to Excel (specifically level totals).

    Hi, I am trying to export my sage spreadsheet to excel with the stipulation that all relevant cells populate with the spreadsheet formula as it is set up in the sage spreadsheet (i.e. an item's total amount contains a formula that is the sum of all…
  • Open Invoices

    Hi, I am new to Sage, How do I run a report that will give all the open invoices for a specific project ?
  • Sage 100 Contractor Modify Report - Define Selection Criteria - Enable 'Or' logic

    When modifying a report, there is an option to enable 'or' logic in the selection criteria. I'm having a hard time setting this up and wanted to see if anyone has had success with this.
  • Is there an option or work-around to show multiple jobs on one Gantt chart?

    I'd like to be able to pull a Gantt chart that shows everything going on in a month/quarter, ideally for the whole business and by supervisor. I've dug through all the report options and can't seem to find anything, but the Gantt charts are kind of useless…
  • Voided A/P Checks

    I just voided several checks for a vendor. How do I run a voided check report?
  • Open Purchase Orders and Contracts for Non Jobs

    Hi there, I am looking for a report that can confirm purchase orders and contracts that are open but do not apply to any specific jobs and are strictly overhead expense booked to the GL accounts.
  • Payroll system - terminated employee

    We have quite a number of terminated employee's that still appear on reports, the term date and reason are both completed fields. Some of these people we don't want to delete because they are seasonal. Why would terminated employees still appear on…
  • JC summary showing a difference in GL vs JC- how do I find out where the mistake is?

    Hello, I recently ran my JC summary reconciliation report and have a difference of $900 in my GL that is not showing up in my JC on the subcontractor line of the report. What reports do i run to narrow down where the mistake is at? Looks like it was…
  • Service Days from Request to Invoice Report

    I was looking for a solid report for our service department efficiency and could not find anything I liked. I created a report which captures the number of days from call to schedule, schedule to invoice, and the total days from call to invoice. Enjoy…
  • committed cost-developer

    Report 6-1-12-51 Committed Cost-Developer. How does this report for Developer differ from regular reports? There are asterisks after some items, but no description of what the * means.
  • Report for closed jobs

    Is there a report in sage that can show jobs closed during any given year or specified time period? I know that when you pull an old over/under extended report it will show the job for what ever the current status is so it is sometimes hard to track…
  • Anyone work with State of Ohio ODOT and have to submit Certified Payroll Report in xml format?

    Anyone work with State of Ohio ODOT and have to submit Certified Payroll Report in xml format? Have you figured out a way to submit payrolls in the xml format?
  • Payroll Report Needed

    I am looking for a Weekly Labor Report that includes ALL PR costs (Burden, Reimbursements, etc) that can be run by Period End Date NOT Accounting Date. (I know I can condition it with the PED after the accounting date is selected but that's not what I…
  • Job Cost Detail Report

    Is there a report that shows all of the posting detail for a specific job? I am looking for a job cost detail report that shows the detailed cost for each cost code.
  • AP Pending Invoice Register with Detail

    We have started using the enter pending invoices function. How do you print a pending AP register with detail that shows the distributions so I can proof the invoices? Thanks.
  • Labor Hours by Cost Codes

    I need to be able to show number of hours for the year by various cost codes but can't seem to find a report that will do that. So for example, 1/1/2021-06/30/21 I need to see how many hours were entered with drywall cost codes, electrical, etc. Any help…
  • Workers Comp Wages

    In 5-1-5-21 Worker's Comp Report, the Workers Comp Wages column is deducting the employee paid health insurance and 401K amounts. I'm sure its due to how those two payroll calculations are set up. I need to change something in the calculations, but, I…
  • Is there a report in the payroll module that condenses the information in the Check Activity report to TOTALS only?

    I am printing reports for an audit and need to show annual totals. The "Check Activity" report is perfect except its almost 50 pages long. Is there another report in the Payroll module that condenses the check activity information to totals only?
  • Contractors Annual EEO Report - Form PR 1391

    Ohio DOT has sent out the letters for the Annual EEO Report Form PR 1391. Do any of my Ohio Sage users have any suggestions or gathering the required data? Or has anyone come up with a report that they would be willing to share?
  • Report showing jobs associated to companies?

    Hi, Within a datafolder we have numerous companies - all with jobs associated to them. Is there a report or easy way to show what company each job is associated to or show a list of jobs associated to a certain company within a datafolder? Further…
  • Field Section of 'Add Condition'

    If I add a condtion to a report, it lists a bunch of items in the Field Section. How do I add an additional field to that? Right now 'Owner' is an item in the Field for Job Lists. But when I view the same report in our Archived database, 'Owner' is not…
  • W2 Reports

    Is there a report or a small set of reports that I can give to our accountant to produce our W2's? A summary of the W2 information?
  • Direct deposit pay stubs

    What are people using for direct deposit pay stubs? Just a stub? A stub with a $0 check? Pre-printed?
  • Payroll by State

    Is there a report where I can get gross payroll by state. I need to get this to our CPA firm for our yearend tax return preparation.
  • Sage Intelligent Reporting vs Liberty Reports

    I am a long time user of Sage 100 Contractor (formerly Master Builder). I need more flexibility in data reporting from the system. I have read that Sage Intelligence Reporting and Liberty Reports are two add-in options. If you have experience with either…