A Day in the Life of the AP Person Running Everything Through Excel

This isn't one specific person, and it isn't a customer story — it's a composite of a pattern we hear constantly from finance operators, because it's remarkably consistent across companies that have never talked to each other. If you run AP out of a spreadsheet, some version of this week will feel familiar.

Monday: the spreadsheet already has three versions

The invoice tracker lives in a shared spreadsheet, and by Monday morning there are already questions about which tab is current. Someone updated a row from their laptop over the weekend. Someone else has a version open from Friday that's about to overwrite it. Nobody did anything wrong — this is just what happens when the system of record for money owed is a file, not a workflow.

Tuesday: an invoice that definitely came in, somewhere

A vendor calls asking why they haven't been paid. The invoice isn't in the spreadsheet. It's not in the shared inbox either — or it is, but it's buried under forty other emails from the same week. Twenty minutes disappear searching for a PDF that definitely exists somewhere, before finding it in a personal inbox where it was forwarded and never logged.

Wednesday: approval by screenshot

An invoice needs sign-off from someone traveling. It gets sent as a screenshot in a chat message, approved with a thumbs-up emoji, and there's now no actual record of that approval anywhere except a message that will scroll out of view within a day. If anyone ever needs to answer "who approved this and when," the honest answer is: ask around and hope someone remembers.

Thursday: the formula breaks

A running total that's been correct for months is suddenly off by a few thousand dollars. Someone inserted a row in the wrong place last week, and a SUM formula quietly stopped including it. Nobody notices until the number looks wrong on Thursday, and then the rest of the afternoon goes into figuring out which row broke it — which is, in effect, an unpaid audit of the spreadsheet's own formulas.

Friday: close starts with a hunt, not a review

Month-end close should start with reviewing what's outstanding. Instead it starts with reconstructing what's outstanding — cross-checking the spreadsheet against the inbox against what vendors say they're owed, because none of those three sources fully agree with each other. This is the part that actually eats the time, and it happens every single month, in almost exactly the same shape.

Why this happens, and why it's not a discipline problem

None of this is because anyone is bad at their job. A spreadsheet is a genuinely reasonable tool to start with — it's flexible, everyone already knows it, and it's free. The problem shows up later, once invoice volume grows past what one person can track by memory and formula. At that point, the tool that used to be flexible becomes the thing actively working against the team using it.