• Incorrect Income percentages

    I am new to Sage 300 and new to my role as Comptroller for my employer. I was surprised to find our Income Statement total income percentage for the month and YTD do not equal 100%. For example, for May, the total income % is 103.53%. For YTD, the income…
  • 401K Contribution

    Hi Sage, I have an employee who wants to contribute 100% of his bonus to his 401K. The FICA taxes calculate on the full amount, so I reduced the contribution by the FICA taxes and now it calculates a state tax, which there shouldn't be a state tax…
  • Setting up HSA as a Direct Deposit

    Is Article ID 26573 in the knowledge base still applicable to set up HSA for direct deposit? Also, can I copy and paste the formula as shown in the article when I create the formula?
  • 401K/Roth Fringe Match Combined

    I'm curious if anyone has a situation similar to what we have with our 401K/Roth Matching and how they went about creating the formula. I've looked at several KBs on the Sage website and none will seem to match what we are doing or don't appear that they…
  • Payroll FWH Calculation Verification

    I’m processing my first new employee under the 2020 W-4 form, and I cannot reconcile using the IRS tables to verify Sage’s calculation. Anyone see where I am going wrong? Single, $2000 for dependent, $860 taxable this week, state is NH (no income tax…
  • PTO Accrual: Limits and carryover

    Good Morning, I am new to the Sage Community about 4 months. I am evaluating the leave balances and accruals for all of our employees and I am having some concerns as to the set up. We have employees that earn 40 hours a year (new Hires) then after…
  • Payroll State Tax withholding needs to be rounded

    Colorado rounds the state withholding tax. Does anyone know how I get payroll to round for the State withholding?
  • Payroll Direct Deposits with Chase Bank

    Does anyone process Payroll direct deposits with Chase bank? It looks like they have some unique requirements. If you were able to get this to work, can you share your set up? Here is a link to their specifications: www.chase.com/.../cbo_nacha_filespecs…
  • Deferred Compensation

    I am new with the company, and not as familiar with SAGE 300. Has anyone set up a Non-Qualified deferred compensation plan? I am trying to work with Sage support, but so far two people i've talked with don't even know what a deferred compensation plan…
  • Pending Commitment Change Order Amount Incorrect

    Hello! When we enter commitment change orders, they are saved with a "Pending" status until management approves them to be issued. We have one commitment change order that was updated as approved, but the totals on the commitment are now incorrect. …
  • Subtotals in AP (Select Invoices to Pay)

    When I go in AP to set invoices up for payment ... AP - Tasks - Select Invoices to Pay - On Screen List. Is there a way to show subtotals for each of the vendors / suppliers I am paying? I do see that I can go in and view the total (by going into…
  • Partial Direct Deposit - Net check is less than amount to that account

    Is there a formula I could use for partial direct deposits where the net check after Process Payroll is less than the amount to go to that account? Example: Employee wants $750 to go to a specific account, with reminder going to another. This week,…
  • Formula MAX Pay Period End Date

    Looking for a formulaa to simply look into the PR-Check table and return to me an employees maximum date within the Pay Period End Date field . As the help file suggests, the MAX function is only used for numbers and Sage doesnt like it when I try to…
  • Is it possible to alter labor hours using a calculation without changing the takeoff unit to hours in Estimating Extended?

    I want to add a calculation in my assembly that will change the labor hours behind the scenes. My takeoff unit is EA and I don't want to change that. For example: If I have a qty of 10, I want my labor hours to be unaffected. If I have a qty of…
  • How do I make a new payroll formula based on a percentage of gross pay?

    I need to first compare 15% of Gross Pay to a flat amount of $114.75. If 15% of Gross Pay is greater than $114.75, then use $114.75. If 15% of Gross Pay is less than or equal to $114.75, then use 15% of Gross Pay. Here is the formula I have so far that…
  • How to set up salary PMs for estimate

    I am new to using Sage Estimating and am in the process of upgrading to 16.11 SQL. That being said, I am being asked if there is a way to set up a salary PM that will hit the Labor category but will NOT follow any markup rules that apply to that category…
  • Subcontracts and MyAssistant

    When I enter a subcontract in JC with multiple job numbers and then run the MyAssistant task "JC Subcontracts without a signed contract", the result does not include that subcontract. Even though the "Signed Contract Received" checkbox is not checked…
  • updating 2016 Tax Rates

    We are all fairly new to this company and we have closed 2015. We did the Sage update for payroll taxes. However there are no state taxes and I cannot find the amounts we are supposed to be using to update for 2016. This is holding up our 2016 forward…
  • 401K formulas/setup when plan allows different withhold amount on Bonuses?

    does anyone have 401k formulas setup to incorporate different amounts withheld on Bonuses. Our plan allows participates to withhold a different amount on Bonuses both 401k and Roth. We have formulas setup to calculate 401K and Roth and to compare to one…
  • Taxing per diem and auto allowances

    Our company has recently undergone an accounting review and it was determined that we were not following IRS guidelines in our paying out of per diem and auto allowances. It seems that we have 2 choices: to call it an accountable plan and collect receipts…