How do I stop doing the same two-hour job every Friday

I used to block 2pm to 4pm on Fridays for a job that did not deserve a calendar square. Forty vendor PDFs. Totals into a sheet. Then the same eight columns into QuickBooks. I got good at it, which made it worse, because then it was "just two hours" and nobody was going to hire it out.

The search I typed at 1:50pm, more than once: how do I automate this spreadsheet. Also: I do this every week by hand. Both are honest.

There isn't one move. There are three I have actually used, and I still pick the wrong one when I'm tired.

Stay in the file you already have

I dont mean a new app. I mean the sheet. One tab that is the template, frozen header row, the columns named the way QuickBooks wants them, a blank row that already has the date formula. Friday you paste and you delete the junk rows. That cut me from two hours to fifty minutes and I did not install anything. It feels too small to count. Count it.

If the mess is always the same shape, a saved cleanup in Excel (Power Query, a recorded thing, even a ugly macro from 2019) will do more than a chatbot, because the chatbot was not there last Friday. I have a query named friday_vendors that I am not proud of. I run it anyway.

Stop retyping the bridge

The two hours is often not thinking. It is moving. PDF to sheet, sheet to QuickBooks, email to sheet. If either program will spit out a CSV, take the ugly CSV. Ugly is faster than typed. If they both talk to Zapier or Make, or they have a native sync that is not a lie, use that for the part that is the same every week.

I had a Square export landing in a folder and I still typed it into a workbook because the columns were in a stupid order. I spent a Saturday making a mapping tab. Sunday I felt like I had overreacted. Next Friday I left at 3.

You will still check a few rows. Checking is not failure. Checking is the job now, and it is shorter.

Make a tiny thing that only does Friday

Not a platform. Not invoice management. A thing that takes this week's folder of PDFs and writes the eight columns. I have used a script a bookkeeper sent me, a messy notebook, and a page a stranger wired up for a stack that looked like mine. I still opened three PDFs by hand to see if the totals matched. They mostly did.

The tiny thing dies if you ask it to also do expenses and payroll and the year-end binder. Let it be Friday.

If you cannot tell which of the three to start with, start with the template in the file you already have. If Friday is still two hours after that, you do not have a spreadsheet problem. You have a typing-between-programs problem, or you have a this-should-be-a-tiny-thing problem. Pick one. Do not pick all three in the same afternoon. I did that in March and I still had the PDFs on Sunday.

A two-hour Friday is allowed to stay two hours if the other options cost you a week. I am not selling you a new stack. I am saying the job is probably smaller than the tools you are shopping for.

The Friday PDF stack is the try here if you want to see what other people posted.