Expense Categorization for Bookkeeping Clients

Expense categorization for bookkeeping clients works best with a short category list tied to the chart of accounts, a pass through each credit card export with the receipts beside it, vendor rules for the obvious payees, and a written reason for every split or judgment call. The same list, applied the same way each month, keeps categories consistent.

Building an expense category list for bookkeeping clients

An expense category list is the set of names a bookkeeper may assign to a client's spending. For most small clients it should be short, between fifteen and twenty-five categories, and each category should map to one account in the chart of accounts and, for a sole proprietor, to one line of the tax return.

Starting from the return keeps the list honest. Part II of Schedule C (Form 1040) lists the expense lines a sole proprietor reports, among them line 8 Advertising, line 9 Car and truck expenses, line 17 Legal and professional services, line 18 Office expense, line 21 Repairs and maintenance, line 22 Supplies, line 24a Travel, line 24b Deductible meals, line 25 Utilities and line 27b Other expenses. A category that rolls up to one of those lines can be totalled at year end without a second sort. A category that rolls up to two lines will have to be split later, which is the work the list was meant to remove.

The chart of accounts can be more detailed than the return. A client who wants to see software subscriptions apart from paper and toner can have two accounts that both land on line 18. The rule is that detail runs downhill: several accounts may feed one return line, but one account should never feed several lines.

A few habits keep the list usable:

• Name categories the way the client talks. "Fuel" is clearer to a contractor than "Car and truck expenses: operating costs", even if both map to the same place.
• Keep one holding category. "Ask client" or "Uncategorized" collects lines that need an answer, so nobody guesses to clear the queue.
• Write a one-line definition for each category. "Supplies: items used up in the work, not office items" settles arguments the definition was written for.
• Freeze the list for the year. Adding categories mid-year splits history and breaks comparisons with last year.

The list belongs to the client file, not to one bookkeeper. Store it with the engagement so whoever picks up the work next month applies the same names.

How to categorize a credit card export line by line?

Categorizing a credit card export means assigning one category to each transaction row in the statement data, with the matching receipt open beside it. The export gives the date, the merchant text and the amount. The receipt shows what was bought. Most rows need only the merchant text; the hard ones need the receipt.

The export has to be a clean table before any of this starts. If the client sends a PDF statement, convert it first; the guide to turning a credit card statement into Excel covers getting the columns out intact. Receipts work best in their own sheet with a fixed column layout, set out in the post on a receipt-to-Excel column layout.

With both sheets ready, work in this order:

1. Sort the export by merchant. Grouping all rows from one merchant lets you categorize ten fuel stops at once instead of one at a time.
2. Apply vendor rules. Fill the category for every merchant that has a rule, covered in the next section, and mark those rows as rule-applied.
3. Match receipts to the remaining rows. Match on date and amount first, then confirm the merchant name on the receipt.
4. Categorize from the receipt. Read the items, not the store name. A hardware store receipt for a ladder and one for a desk lamp go to different places.
5. Move unmatched, unclear rows to the holding category. Each one becomes a question for the client.
6. Total by category and compare with last month. A category that doubled is worth a second look before the books close.

Re-sort by date at the end so the sheet matches the statement order again. That makes the reconciliation easier, because the statement total and the sum of categorized rows should agree. The steps for reconciling a credit card statement pick up from there.

Receipts that arrive as a pile rather than a steady stream slow step 3 down. When a client hands over a year of paper at once, the guide to digitizing a shoebox of receipts shows how to get it into a sheet before categorizing begins.

Vendor rules for expense categorization, and when they misfire

A vendor rule assigns a category automatically whenever a merchant name appears in the export. Rules save time on payees that only ever sell one kind of thing, such as a fuel station, a phone carrier or a software subscription. They misfire on merchants that sell many kinds of things, where the merchant name says nothing about what was bought.

The table below is an example rule set for a fictional client, Ridgeway Landscaping LLC. The vendors and categories are made up for the example.

The last two rows are the ones that matter. A rule that maps a warehouse club to "Supplies" will be right often enough to be trusted and wrong often enough to cause trouble, such as a television or a month of groceries landing in a business account. Flagging those merchants as "needs receipt" forces a look at the items every time.

Other ways rules go wrong:

• Merchant text changes. Card processors shorten, truncate or prefix names, so "NORTHFIELD FUEL #2214" and "NFLD FUEL 2214" may both appear. Match on a stable fragment and review new merchant strings each month.
• The client's use changes. A vendor that sold only seed last year may start selling equipment. Review rules once a year against the receipts.
• Refunds inherit the wrong sign. A return from a ruled merchant should reduce the same category, not land as income.

Keep the rule table in the client file next to the category list. When a rule is changed, note the date and why, so the change can be traced when someone compares two months that were categorized differently.

Split and mixed-use expenses in client categorization

A split expense is one charge that belongs in two or more categories. A mixed-use expense is a charge that is partly business and partly personal. Both need the receipt, because the export shows only one total, and both need a note saying how the amount was divided.

The IRS treats separate payments as separate expenses for travel and entertainment records. IRS Publication 463 says, "Each separate payment is generally considered a separate expense," and gives the example of a dinner and theater tickets that "are two separate expenses" to be recorded separately. One charge covering two things raises the opposite problem: one payment, two kinds of cost.

A worked example, with example figures. Ridgeway Landscaping's owner pays $412.67 at the Maple Street Warehouse Club on a card ending XXXX-4821. The receipt shows:

The bookkeeper records three lines that add back to the card charge: $189.99 to tools and equipment, $74.18 to office expense and $148.50 to owner's draw or a personal category, as the firm's chart of accounts handles personal charges. The sum must equal the export row so the statement still reconciles.

Personal charges on a business card are common and should not be deleted from the books. Recording them to a draw or shareholder account keeps the card balance correct and shows the client how much personal spending went through the business account. How that account is treated on the return is a decision for the preparer, not the bookkeeper.

Sales tax, tips and fees on a split receipt follow the items. If the receipt shows tax per line, use it. If it shows one tax figure, the firm needs a consistent method, written down, for spreading it across the lines.

Should the client or the bookkeeper choose the expense category?

The bookkeeper should choose the expense category, using facts only the client can supply. The client knows what was bought and why. The bookkeeper knows the category list, the chart of accounts and how last month was recorded. Splitting the job that way keeps categories consistent across months and across staff.

In practice the client answers questions and the bookkeeper assigns. A good question names the row and asks for a fact, not a category: "Maple Street Warehouse Club, March 14, $412.67: what was bought, and was any of it personal?" Asking a client "Is this Supplies or Office expense?" invites a guess based on the words, not the item.

Clients who want to choose can still help. Some prefer to tag receipts as they go with a word or two, such as "job: Alder St" or "personal". Those tags feed the bookkeeper's decision without replacing it. The post on tracking receipts for taxes covers a simple routine clients can keep up during the year.

Record the reason whenever a category is not obvious from the merchant. A short note on the row, "Split per receipt; groceries personal per client email 4/2", lets a reviewer or next year's bookkeeper see why the line was treated that way without asking again. Notes also make the yearly rule review faster, because repeated notes on one vendor suggest it needs a rule or a "needs receipt" flag.

Reading the receipts is the slow part of this process when they arrive as photos and scans. Schema CPA reads receipts and vendor invoices, alongside credit card statements, and exports what it reads to Excel or CSV, so the bookkeeper starts categorizing from a filled sheet rather than a folder of images. The document types Schema CPA reads are listed on the homepage. Choosing the category stays with the bookkeeper.