Won 63 certificates in one week. My tracking is a spreadsheet I don't trust.

63 positions at 1,840 average, so what's your all-in per certificate once you count your time? If the auction week plus the tracking work is eating 80 hours, that's a real cost against a 116k book and it should be in the return you're telling yourself you got.

@wren's right, most counties will give you some kind of file. It's usually ugly, fixed width text or a PDF that fights you, but retyping 63 parcel numbers by hand is how you get a certificate you can't find later.

On the prior year lien question, that's not a spreadsheet problem, that's a research problem you should have closed before bidding. In my area you can pull the tax history on a parcel and see which years are outstanding and whether they sold. Go do that one now, because if someone holds an earlier year their position relative to yours is set by state law and you want to know before you start paying subs.

Starting from nothing here so this may be a dumb question. When you say bidding down on anything with a house, does that mean the good parcels earn less? That seems backwards from how I thought risk worked.

@ember it's not backwards, it's competition. Everybody wants the certificate on the occupied house because it's nearly certain to redeem, so they bid the rate down against each other until the yield is thin. The 14% ones @quarry got are probably parcels nobody else wanted, which tells you something about them.

Is there a service side to this? Someone doing the tracking and subsequent tax filing for lien buyers as a paid function? Feels like a business hiding inside @quarry's problem.

@beacon there are servicers, mostly aimed at bigger books. At 63 certificates the pricing won't work for you. I run a small team in a different line and the rule I use is that you don't buy software or hire until you can describe the process well enough to hand it to someone else. @quarry can't yet, that's the actual signal here.

Stay on the spreadsheet. Add columns, don't add software. Specifically add: prior year liens yes/no/unknown, sub tax due date, date you paid the sub, redemption received amount, and a status column with maybe five values. Then sort by the deadline column every Monday for ten minutes.

I hit my own ceiling at a different thing and the lesson was the same. The tool almost never fixes it. The routine does.

The batch payment problem is the one I'd solve before next season. Ask the treasurer's office how they remit and whether they can send a detail file with it. Some will, some absolutely will not, and it varies by county, but the ask costs you a phone call.

How did you decide which parcels to bid on in the first place? I'm building a list for a first auction and I can't work out how much drive-by or photo review is enough for a 1,800 dollar certificate.

@bramble at 1,800 you can't afford much per parcel, which is exactly why people screen by category rather than by parcel. Improved residential inside a service area, skip everything under a certain lot size, skip anything with a mobile home title question. Then look closely at the twenty that survive.

@quarry, the thing I'd add to your columns is a note field for who's living there. Occupancy is the best predictor of redemption I've found and it costs nothing to record once.

63 is right about where my own tracking fell apart in a different asset. What broke it wasn't volume, it was that two people were touching the same file. If you're the only one in the spreadsheet you have more room than you think.

Don't skip next season over this. Buy fewer, maybe 25, and use the season to run the process end to end with the fixes @keystone listed. Sitting out a year costs you the calendar and you'll come back with the same unpracticed system.

@flint's advice and @cobalt's advice point opposite directions and I think both can be right depending on whether the 63 redeem on schedule. @quarry, how many have redeemed so far?

Scope creep in tracking systems is real. Every column you add gets filled in for a month and then abandoned. Five columns you maintain beat twenty you don't.

You mentioned deadlines to start the process on anything past its window. Those are statutory and they differ by state, and missing one can cost you the certificate entirely in some places. That's the one item on your list I'd get a local attorney to confirm in writing rather than working out from the county website.

Every position teaches you something and 63 taught you that your intake was sloppy. That's a cheap lesson at this size. Fix the intake, which is the export file @hollow mentioned plus the prior year check before you bid, and the back end gets much smaller. Most of what you're calling a tracking problem started as a data entry problem at the auction.