Skip to content

Sage 50 Manual Payroll Formulas – Install, Setup, and Use

Sage 50 Manual Payroll Formulas

Sage 50 Manual Payroll Formulas

Sage 50 is one of the widely used Accounting Software for business development. It helps in finance management and decreases efforts needed for processing invoices, client management, payroll tasks, and more. After the successful completion of the Payroll Setup wizard, you have to operate payroll yourself rather than through Sage payroll solution service. After setup, the next phase you need to do is to set manual payroll formulas to let Sage 50 perform payroll taxes and other business liabilities calculations. Sage subscribers will automatically get up-to-date formulas for processing payroll transactions. AccountsPro provides you guidance on how to create Sage 50 manual payroll formulas also get in touch with Sage Payroll Support Number for more information.

Payroll formulas are not incorporated into the software. You need to manually set up payroll formulas and their basic equation to calculate the outcome. The installed Sage 50 does not permit automatic taxes calculations while entering payroll. To let the software perform automatic calculations the latest tax update is mandatory. The constant updates help to keep the Sage 50 executing uninterruptedly.

Advantages of Using Payroll Formula Sage 50

Payroll formulas play a prime role in Sage 50 to determine federal, local, or state-level tax deductions, calculations, or exceptions. This includes gross pay alignment tables and percentages. These payroll formulas are created according to organization specifications so that these user-maintained formulas can be further used for editing, modifications, and updating. These formulas act as Sage 50 enhancements, thus connecting to Sage Support, network administrator, or accountant aid in making modifications. Subscribing to one of the Sage plans is necessary to set up payroll tax manual formulas.

Types of Sage 50 Payroll Formulas

Category of payroll formulas:

There are two types of payroll formulas found in Sage 50 i.e.

  • Sage-Maintained formulas:

This formula acts as the pre-defined formula including federal, local, and state tax calculations. These are maintained by Sage experts. You need to become a subscriber.

  • User-maintained formulas:

These formulas act as customized or local calculations that users maintain. This company formula comprises state unemployment rates, accrued vacation formulas, contribution scenarios, etc.

To edit a user-maintained payroll formula

Contact your state or local tax authority for the latest information on state or local taxes. For information about federal taxes, visit

  • Open the File menu and choose Payroll Formulas, then select User-Maintained. This action will prompt Sage 50 to display the User-Maintained Payroll Formulas window.
  • In the User-Maintained Payroll Formulas window, click on the drop-down arrow next to the Formula ID field. Choose a formula from the list.
  • Make the necessary changes to the formula based on the provided field information.
  • Once you have made the desired changes, click on the Save button to save your modifications.
  • When you have finished modifying the formulas, select the Close option to exit the User-Maintained Payroll Formulas window.

Note: You must subscribe to a plan that includes payroll to use and set up payroll formulas in Sage 50.

Payroll formulas must be changed or created in the window named User-Maintained Payroll Formulas. In Sage maintained formulas users will not get any access to these payroll formulas until they become Sage Business Care plan subscribers. Get detail about what is Business Care and how it’s beneficial let’s connect with the Sage 50 Support team now.

Where Is Payroll Formula In Sage Accounting Software

Get information about Payroll Formulas:

  • Locate the Help option and then choose About Sage 50 Accounting
  • If you have installed the latest update then the initial four digits of the version display the current payroll tax year, if the version is not identical to a current year then you require the latest tax update
  • In case the tax version found is 19000101 then it represents the generic series of payroll formulas installed on the computer. These series formulas will not permit accurate tax amounts calculations.

How to install the Sage 50 Manual Payroll formula

  • To begin you need to locate the ‘File’ menu and then click on ‘Payroll Formulas’
  • Choose User-Maintained formula
  • Discover the drop-down named formula ID and choose the previous year’s formula
  • Now, edit the Formula ID to the present year
  • After selecting the current year Formula ID to modify the Name to the Next year
  • Choose the Percent, Limit, and adjust it to the new percent and limit
  • Hit on the save button to save all manually performed modifications
  • You need to repeat the same process for other user-maintained formulas. Select them specifically and perform the same modifications to edit them to the current year.
  • Now you need to close the window named User-Maintained Payroll Formulas
  • After this verify they are executing properly

 User- Maintained Formulas updates:

  • Navigate TASKS and then choose PAYROLL ENTRY
  • Hit on EMPLOYEE ID
  • After this, there require to write DATE & PAYEND PERIOD and then click on the Ok option
  • A window named FORMULA UPDATE will display on the screen
  • Select the specified formula that you wish to update and then click on UPDATE FORMULA NOW and then proceed with clicking on the Continue button
  • Do all the modifications needed to the RATES and LIMITS fields of the USER-MAINTAINED FORMULAS as needed and then Hit on OK
  • Verify the PAYROLL boxes to check whether the updates are accurately appearing or not
  • User-maintained formulas for Sage 50 allow a user to integrate any new formula based upon the manual modification in the payroll system, or their local taxes.
  • Users can embed a formula into the system by the below-mentioned procedure:
    • Integrating a New Formula:
    • To embed a new Formula you need to write a unique FORMULA ID that does not match with the existing formula ID listed in the Formula List box.
    • Verify the name conventions verified through SAGE 50 before writing the ID. A Formula ID must begin with a two-letter postal acronym of the native State.
    • Give a relevant NAME for the formula
    • The FORMULA NAME comprises the following category:
  • Calculation name – It represents the Name of the plan or tax
  • The Payee – (wherever applicable employee pays)
  • Payroll Tax Year – The last two digits of the Tax Payroll Year Formula Name.
  • This updated /created Formula ID can be utilized for the payroll objectives whenever needed. You need to update this ID to the present year during the beginning and end of the year.

Note: Whenever you install an update, these Sage-maintained changes will be overwritten. If you enter changes to the user-maintained formulas, these will not be overwritten.

Help For Payroll Formula Issues & Errors

Hopefully, the topic provided useful information on the Sage 50 Manual Payroll formula. This formula is powerful and needs to create it more carefully. In case you face any other hitches found while operating Sage 50 or to know more information about payroll formulas like classifying payroll formula, filing status, and tax agency connect AccountsPro Toll-Free 📞 +1-800-983-3089. AccountsPro professionals will clarify your queries through chat or an email address. Even Sage 50 Chat is available 24×7 for USA and CA customers.

Frequently Asked Questions (faq)

What are payroll formulas?

The formula for calculating payroll:
Net Pay = Gross Salary – Gross Deduction. Where, Gross Salary = Basic salary + HRA + DA + Allowances + One-time payment/incentive (Reimbursements, Arrears, Bonus, etc.)

How do I update payroll formulas in Sage 50?

To edit a user-maintained payroll formula
✅ Select User-Maintained Payroll Formulas from the File menu.
✅ The User-Maintained Payroll Formulas window appears in Sage 50.
✅ Select a formula from the drop-down arrow beside the Formula ID field.
✅ Once you have made your changes, click Save.
✅ Select Close when you are finished.

What are common payroll calculations?

Hourly Workers
✅ Pay frequency and hourly wage are used in manual payroll calculations.
✅ For someone making $11 an hour on a biweekly pay schedule, the calculation would look like this: 40 hours x 2 weeks = 80 hours x $11/hour = $880 (gross regular pay).

What is the accrual formula for payroll?

✅ Calculate the accrual amount by multiplying the employee’s hourly wage by the number of unpaid hours.
✅ Salaried employees multiply their daily wage rate by the number of unpaid days in a month.

How do I set payroll default in Sage 50?

Choose Employees from the Maintain menu to set up or review employee defaults. In this section (and in the Payroll Setup Wizard and Payroll Settings), you enter basic information about your employees and payroll transactions.

How to Link Payroll Formulas in Sage 50?

To link payroll formulas in Sage 50, follow these steps:
✅ Launch Sage 50 and open the company file for which you want to link payroll formulas.
✅ From the main menu, click on “Maintain” and select “Payroll Formulas” from the drop-down menu. This will open the Payroll Formulas window.
✅ In the Payroll Formulas window, select the formula you want to link to another formula by clicking on it.
✅ Click on the “Link” button located at the top of the Payroll Formulas window. This will open the Formula Linking window.
✅ In the Formula Linking window, you will see a list of available formulas. Select the formula that you want to link to the originally selected formula by clicking on it.
✅ Once you have selected the formula to link, click on the “Link” button in the Formula Linking window.
✅ The linked formula will now appear in the “Linked Formulas” section of the Payroll Formulas window.
✅ Repeat the process if you want to link additional formulas.
✅ After linking the necessary formulas, click on the “Save” button in the Payroll Formulas window to save your changes.

How do I add a payroll field in Sage 50?

Using the Maintain menu, select Payroll and then Payroll Settings. Click Taxes and then Assign Tax Fields. Click the W-2 Fields button. Sage 50 displays the Assign Tax Fields for the W-2s window.

Speak to A Specialist about QuickBooks Software

Headache🥺. Huh, Save time & money with QuickBooks Support 24×7 @ +1-800-983-3087, we provide assistance to those who face problems while using QuickBooks (Support all U.S. & Canada Editions)

 Support – We provide solutions for the following QuickBooks (Pro, Premier, Accountant, Enterprise, Payroll, Cloud) 

  • Error Support
  • Data Import
  • Data Conversion
  • Payment Solutions
  • Upgradation
  • Payroll Support
  • Data Export
  • Software Integration
  • QuickBooks Printer Support
  • Complete QuickBooks Solutions
  • Tax-Related Issues
  • Data Damage Recovery
  • Installation, Activation Help
  • QuickBooks Windows Support

8 thoughts on “Sage 50 Manual Payroll Formulas – Install, Setup, and Use”

  1. I use sage 50 2021 software. This year I cancelled my payroll subscription due to high cost. I want to know if you can help creating manual formuals similar to the sage maintained for FIT, FICA anfd MEDICARE ?

  2. I can’t get the vacation pay to pull into paycheque in Sage 50. using Sage 50 Pro Accounting release 2021.1.1 , have entered the employee information (birthday etc), I have set vacation at 6%. I have unchecked the ‘Retain vacation’ box to have it paid out each period.,But when I do a pay cheque the field is 0.00 and it does not allow me to enter any amount or hours

  3. I just noticed in a payroll that I ran today that the vacation earned is not automatically calculating. I had to go in and manually calculate. Not sure why the change today.using 2021 SAGE Premium Accounting 2021.1.1, but I found the issue by check box on my salary income line for “Calc Vac” was removed…I am good now – thank you

  4. got PIER reviewed on payroll this year and owe CRA hundreds of $. first year this has ever happened (been doing this since 1998). can’t figure out what is going on. program looks to be up to date and correct…… using Sage 50 (release 2021.1.1)

  5. looking to add a formula to payroll that will accrue 1 hour of sick time per 30 hours worked. I thought this was Sage

  6. I have Sage 50 Quantum and need to setup a new employee based in CA. I figured out how to set up withhold and unemployment but need help with State Disability Insurance withholding and State Training Tax.Is it possible to just email the procedure. I would think that it would be pretty common issue

  7. I need help with adjusting some pension and group insurance amounts on the Rel 1 and T4 , using Sage 50 Premium Accounting version 2022.2

Leave a Reply

Your email address will not be published. Required fields are marked *



Accountspro Tollfree Number
Toll Free: 1800-983-3087