Skip to content

How to Setup Tax Table Update in Sage 50

    Enter Expenses Into QuickBooks

    Steps to Set Up Sales Tax in Sage 50

    Total Time: 10 minutes

    Setup Sales Tax

    🔷 Go to Settings and click on Sales Taxes in Company.
    🔷 Select Taxes.
    🔷 Enter data in all fields and applicable for your company/area.
    Note: Doing business in multiple areas or provinces? If yes, then you need to set up sales tax for each province separately in Sage 50. If you don’t do this, your taxes won’t be calculated properly. 
    🔷 Select Acct to track tax paid on purchases and pick the Paid tax on Purchase Account.
    🔷 Select Acct to track tax charged on revenues and pick the Charged tax for Sales account.
    🔷 If you want Sage 50 to generate actual Tax reports, then click on Yes for the option report on taxes.
    🔷 Click on OK.

    Setup Tax Codes

    🔷 Select Setup.
    🔷 Click on Settings and choose Company, then Sales Taxes
    🔷 Click on the option Tax Codes.
    🔷 Click on the Code Column and put in up to 2 alphabets so that the code you’re creating can be used by Sage 50. You can use G or GP for GST. Choose according to the system you’ve set up for your company file.
    🔷 Once you’ve inputted the code that you want to create, hit the enter key. When the Tax Code Details option appears, click on the Tax Column.
    🔷 Now select the Tax that you want to apply.
    🔷 Put the correct status code so that calculation is automatically done by the accounting software.
    Taxable: Tax is calculated on the item and charged.
    Non-taxable: Sage 50 won’t calculate the tax on these items. But it will still report the amount of the items.
    Exempt: Sage 50 won’t calculate the tax on these items. But it will report the amount of these items.

    🔷 Input the percentage of your tax in the Rate. You don’t have to put in a percentage sign. Sage 50 will automatically take it as a percentage rate.
    🔷 Set No for the option Included in price. Do so in the case when tax is charged on top of the price of the item.
    🔷 When you want the tax account to track a particular tax, you should set the Refundable status to Yes. So GST should be set to Refundable.
    🔷Click on OK and the Tax code details will be saved by Sage 50.
    🔷 Click on Ok again to view the information screen of Sales tax in Sage 50. 

    To Seek our Sage 50 Assistance:

    You need to get in touch with us via any of the mode of communication that we have made available on our website

    • Visit our website and connect with us via Sage 50 Live Chat Support.
    • Send us email on our official email address and we will get back to you as early as possible.
    • Call us on our Sage 50 experts.

    👉Frequently Asked Questions

    Q 1. What are Tax Tables in Sage 50?

    Ans : A tax table is a graph that shows the tax liability depending on the amount of funds earned. The tax rate in the table might be displayed as a fixed sum, a percentage rate, or a mix of the two. Individuals, businesses, and estates employ tax calculation for both ordinary dividends and capital gains.

    On the left, tax tables are set up with tabular format for each filing jointly and rows of varied taxable income levels. Depending on the individual’s personal filing position – single, married filing separately, couple filing jointly, or head of the family – his or her tax burden may be tracked on the table and the sum moved to the individual’s income tax return. Qualifying widows and widowers are eligible to use the spouses filing jointly category. 

    Q 2. How to check Tax Tables in Sage 50?

    Ans : It is critical to calculate your taxable income and tax amounts correctly. Your calculations will be double-checked for inaccuracies by the IRS. If you owe more tax than you provided, you may be liable to interest and fees on the difference. If you determine that you overpaid throughout the year, you are entitled to a return of the overpayment.

    Using the IRS’s tax tables to compute your amount owed, you need to establish two crucial tax variables: your income taxes and your filing status. It’s also worth noting that in some cases, you’ll need to utilize information other than the final numbers to determine your tax liability. For example, if you have qualifying dividends or capital gains, you may be subject to taxation at various rates for these forms of income. These spreadsheets are used to make adjustments before calculating your total tax liability.

    Q 3. What Preparation is needed to set up Taxes in Sage 50

    Ans : Most firms must levy taxes in accordance with eligibility rules and rules imposed by the federal and regional legislatures. For example, if you market to and ship to consumers across Canada and fulfill the needs to charge taxes across the country, you may need to establish and set up for all tax kinds. When you set up taxes, make sure you have completed all relevant registrations in each area and have your tax numbers accessible.

    The tax types you create will be available in drop-down menus and may be applied to both revenue and expenditure transactions.