Problem
The invoice is in the system. The work is in Excel.
You have accounting software. Maybe you’ve invested in an ERP that brings finance and operations into one system. But when it’s time to work through invoices, someone opens Excel. There’s a spreadsheet for jobs waiting to be billed. Another tracks invoices that need checking. Someone adds notes about missing purchase order numbers, disputed charges, promised payments, and who needs a follow-up. The invoices are in the accounting system. Managing the work around them still depends on the spreadsheet.
That’s a frustrating result after paying for software that you expected to make this easier. It also gives you a specific place to investigate: what is Excel doing that your accounting workflow still leaves someone to handle?
Examples
What the spreadsheet is actually tracking
Consider a hypothetical service business that uses an ERP and keeps a separate invoice tracker. The tracker contains more than invoice numbers and amounts. It answers questions people need resolved before they can move on:
Questions the tracker helps answer
Someone built the spreadsheet because those answers needed a place to live. It may be familiar, flexible, and easy for the team to scan. The repeated work starts when keeping it useful requires checking the ERP, reading emails, asking colleagues, and updating rows by hand. When something changes in the accounting system, someone has to remember to change the tracker too.
- Is the completed work approved for billing?
- Does the amount include the agreed changes?
- Is the customer’s purchase order number attached?
- Has someone checked the draft?
- Is an unpaid invoice overdue, disputed, or waiting for a payment to be matched?
- Who is responsible for the next action?
Why another system hasn’t removed the manual work
Existing software and manual administration can coexist. Intuit’s August 2024 survey of 630 U.S. owners and executives at businesses with 10–99 employees found that 54% identified manual and repetitive tasks as a challenge with their current business applications. The research covers business software generally; it does not establish how many firms manage invoice tasks in Excel. In your business, the reason for the spreadsheet needs a closer look.
Your system might record an invoice’s financial status while the team needs a view of the work still required. A report might show an unpaid balance without explaining that the customer has questioned a charge and someone is reviewing it. The relevant information might also be spread across the ERP, job records, and email. Or the system may already support the workflow, but the feature was never configured, the right people cannot access it, or the available view is difficult to use.
Each possibility calls for a different fix. Start by asking the person maintaining the tracker to explain why each column exists and where its information comes from.
Solutions
Follow one row from beginning to end
Choose a recent invoice and walk through every update made to its spreadsheet row. For each update, ask what changed, where the person found out, and what they did next. Pay particular attention to columns that duplicate information already recorded elsewhere: amounts, due dates, invoice numbers, and payment status. Then look at the columns that hold additional context: a missing document, a reason billing is on hold, a promised action, or a reviewer’s name.
That distinction gives you a useful design brief. Some information needs to arrive automatically. Other information needs a clear place for someone to enter a decision or explain an exception. A spreadsheet can remain useful. The question is whether someone must keep reconstructing the invoice’s situation to maintain it.
What a useful change could look like
Suppose the team checks every invoice draft against approved job charges and a customer purchase order before sending it. A scoped automation could gather the agreed records, compare the fields the team has defined, and identify missing references, amount differences, or possible duplicate billing. It could prepare a review list showing the invoice, the specific issue, and the person responsible for resolving it.
The reviewer would still decide whether the charge is correct and approve the invoice for sending. The routine collection and comparison would already be prepared. For payment follow-up, a separate improvement could refresh the outstanding balance from the accounting system and retain the team’s dispute or hold notes. An invoice with an unclear payment match would go to a person for review before another reminder is prepared.
The result should give the team a reliable view of what needs attention, with less copying and cross-checking to keep that view current.
Improve the work behind the spreadsheet
Check the features, reports, and connections available in your existing system first. Sometimes the next step is configuration or a clearer approval process. A custom automation becomes worth considering when a recurring gap remains. Measure the work before changing it: time spent updating the tracker, checking routine fields, locating missing information, and correcting stale entries. Afterward, include the effort needed to review exceptions and maintain the new process.
Someone inside the business should also know when information was last refreshed, where failed updates appear, and how to correct them. A tracker that looks current while quietly missing changes creates another problem to investigate.
How Zoevin helps
Start with the invoice tasks your team repeats
At Zoevin, I build scoped automations in your business’s own environment and hand them over on an agreed date. If Excel is still where you track, verify, and chase invoices, tell me what your team has to update by hand.
- A scoped automation built in your business’s own environment.
- An agreed handover date and ownership of the workflow.
Zoevin has no delivered automation projects yet. Discovery names the seam. If I build, I hand it over on a written date. You get the workflow, the logins, and the write-up. I don't stay on to run it. You buy the software.
Evidence
Sources
Primary reporting first. Open the sources yourself rather than taking this account alone.
primary source
Intuit Business Solutions Survey, 2024Vendor-commissioned August 2024 survey of 630 U.S. owners and executives at businesses with 10–99 employees. The 54% finding concerns manual and repetitive tasks in business applications generally, not the prevalence of invoice trackers in Excel. The workflow example in this article is hypothetical.