To delete columns, highlight the column you want to remove, right-click your mouse, and then select “Delete.” The rules are the same if you delete a column from the “Set Up Employee Data” tab. For the “Year-to-Date Payroll” tab, which contains the summary of the 12 months, you also need to add any new columns so that it correctly reflects details from the monthly payroll tabs. If you add a “Local NYC Tax” column in column O on the “January Payroll” tab, you must add it in the same place on other month tabs. When adding new columns to the month tabs, you must be consistent. Go to all the month tabs (from “January Payroll” to “December Payroll”), including the “Year-to-Date Payroll” tab, and enter a new column between columns N and Q (the tax columns). Right-click your mouse and then select “Insert.” Enter a header (in row 3) for your new column (for example, “Local NYC Tax”) and input the rates for applicable employees. To add a column, choose the column letter (e.g., G, H, or I) you want your new column to come before. This is where you should always start when making changes because all of the remaining payroll tabs pull their source data from here. You can do this by adding the required information in the “Set Up Employee Data” tab. For example, if your business is located in a place that charges local income tax (like New York City), you need to reflect that in the payroll Excel template. You may need to add or delete columns to meet the needs of your small business.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |