Description
Cause
Resolution
Sage 50 does not have the ability to calculate a percentage of an invoice as a line item on the invoice itself. If the amount needs to show in the body of the printed or emailed invoice you must calculate the percentage manually and type it in.
As a workaround, It is possible to create a taxable tax in the sales tax settings that will calculate a percentage of the invoice. See DocLink: How do I set up sales taxes? for details on how to setup a new sales tax.
- Go to setup, settings, company, sales taxes, taxes.
- In the first empty row of the Tax column, enter the name of the charge. For example "Fuel Surcharge".
- The tax ID can be left blank.
- Exempt from this tax should be No.
- Is this tax taxable should be Yes. Make sure to tick the appropriate taxes in the pop up window.
- Link an account to track tax paid on purchases and and account to track tax charged on sales. See How do I create a new account in my Chart of Accounts? to create a new account if necessary. Note that only an asset account or liability account can be linked. A general journal entry may need to be created to move the amount to another account.
- Click OK to save the changes.
- Go to setup, settings, company, Sales Taxes, Tax Codes.
- In the first empty row of the Code column, enter a new Code. Note that only one or two characters can be used for the code.
- Double click on the new code or click the magnifying glass in the Code field for the new code to open the tax code details screen.
- In the tax code details screen, select the taxable tax you created. The status should be taxable.
- Enter the percentage rate in the rate column.
- Select included in price no.
- Select is refundable yes.
- Add additional lines for each other tax that needs to be calculated by this sales tax code.
- Click OK to save the changes.
- Use the new tax code on the invoices you would like to charge the percentage based charge on.
Note: Consult an accountant to confirm this workaround is making the correct entries.