Yes. On the Settings tab of a ProfitDrawer bookkeeping spreadsheet you can rename, add or remove income and expense categories by typing in the white boxes, and the dropdowns on Income and Expenses update to match. The small business version has room for 12 income and 20 expense categories. Each expense category has a Business? setting: choose No for money that is not a business cost, such as owner draw.
How to change them:
- Open Settings.
- Type over a category name to rename it, type in an empty white box to add one, or clear a box to remove one.
- For each expense category, set Business? to Yes or No. Categories set to No, such as Owner draw or Personal, stay out of profit, total deductions and the tax set-aside; the Tax Summary still lists them with 0 deductible, and its Spent total includes them.
The categories start out set up for the trade the file is named for. For example, many beauty and service trade versions include a Tips income category.
Before you rename a category you have already used: totals match entries to categories by name. Rows that still carry the old name will no longer match, so re-pick the new name on those rows, or rename categories at the start of the year before you enter data.
Tip: name expense categories so they line up with the IRS Schedule C expense lines, such as supplies, insurance or utilities, which makes the year-end totals easy to hand to your accountant.
In Excel the rest of each tab is locked so formulas cannot break by accident; in Google Sheets, type only in the white boxes.
Source: Small Business Bookkeeping Spreadsheet · Updated
Tools and spreadsheets for this
Related questions
- What are the main categories of business expenses?
- What is in a ProfitDrawer bookkeeping spreadsheet?
- Which ProfitDrawer spreadsheet should I buy for my trade?
- How do I separate personal and business expenses when I use one card?
- Can I use a ProfitDrawer spreadsheet for more than one year?
- What is ProfitDrawer?
All questions on ProfitDrawer Answers →
General information, not tax, legal or financial advice. Check the rules for your state and your situation.

