Sort a Bank Export into Schedule E Categories with Gemini in Google Sheets

What This Does

Every rental transaction lands in one of two buckets at tax time: a repair you expense this year, or a capital improvement you depreciate over years. Gemini in Google Sheets reads a raw bank export, suggests a Schedule E category for each line, and flags anything that looks like it should be capitalized instead of expensed, so fewer of those judgment calls slip past you and reach your CPA already miscategorized.

Before You Start

• You have a Business Standard account ($14/user/month) with Gemini enabled: workspace.google.com
• Your bank or credit card export is a native Google Sheet, not an Excel file (use File > Save as Google Sheets first if it downloaded as .xlsx)
• You have removed or masked full account numbers from the export before this step

Steps

1. Find the AI feature

Open the spreadsheet holding your transaction export. At the top right, click Ask Gemini to open the side panel.

2. Tell it what you need

In the side panel, describe what you want done with the transaction column. For example: "For each row, suggest a Schedule E expense category (repairs and maintenance, insurance, utilities, management fees, or supplies) based on the vendor and memo text in column C, and flag any transaction over [your capitalization threshold] that looks like it improves the property rather than just repairs it." Gemini can also build the categories as a dropdown column if you ask: "Add a dropdown column named 'Schedule E Category' next to column C with those five options."

3. Review and use the result

Gemini returns an action preview card describing what it's about to do. Click Apply to add the suggested categories or dropdown. Go line by line through anything flagged as a possible capital improvement. A full roof replacement or a new HVAC system gets set aside for your CPA to confirm the correct treatment under IRS depreciation rules (see IRS Publication 946, How to Depreciate Property) rather than expensed outright on your say-so.

Real Example

Scenario: A landlord pastes a year of bank and credit card transactions into a Sheet before their annual CPA meeting.

What you type: "Suggest a Schedule E category for each row using the vendor name in column B and memo in column C. Flag any transaction over [your capitalization threshold] that looks like a capital improvement instead of a repair."

What you get: Most rows get a clean category label ("Repairs and Maintenance," "Utilities," "Insurance"). One row, a full roof replacement, gets flagged with a note that it likely needs to be capitalized and depreciated rather than expensed, so it goes into a separate list for the CPA instead of getting buried in the regular repairs total.

Tips

• Ask Gemini to "explain why this one got flagged" on any row you're unsure about. It shows its reasoning, not just the label.
• Run this pass monthly instead of once a year. Twelve small categorization passes catch fewer misfiled roof jobs than one annual scramble.
• Keep a running "CPA questions" tab in the same spreadsheet for anything Gemini flags as ambiguous, so nothing gets lost between now and tax season.

Tool interfaces change. If a button has moved, look for "Ask Gemini" near the top right of the Sheets window or a similar AI icon nearby.