Guide · 3 ways compared

How to track bills and catch duplicate invoices as a bookkeeper

There are three honest ways to track bills and catch duplicate invoices: manually (about 1-2 hours a week, plus the cost of misses), with DIY AI prompting, or with a free ready-made agent. This guide compares all three with real pros and cons.

It captures new bills and invoices, runs duplicate checks and builds a due-item review queue: vendor, invoice, amount, due date, duplicate check, review status. Here are the three honest ways to get it done, with real trade-offs.

Way 1: without AI (the manual way)

Honest cost: 1-2 hours a week, plus the cost of misses.

  1. Capture each bill from email and post into the tracker.
  2. Check new bills against recorded ones for duplicates.
  3. Sort by due date and flag what is urgent.

Tracking bills in an inbox means the due date lives in an email subject line. The method below builds a proper bills run with any assistant: extract the key fields per invoice, flag duplicates against what is already logged, and draft the approval and query emails for you to send.

Pros of doing it manually

Cons of doing it manually

Way 2: with AI, but without AI Agent Skills (DIY prompting)

A chat assistant genuinely helps here. The catch is that you become the workflow designer. What you have to figure out yourself:

Here is a starter prompt that works - copy it and bring the inputs listed:

Process these new bills: [paste vendor, invoice number, amount, due date]. Check each against my recorded bills for duplicates by vendor, number and amount: [paste sheet]. Output a review queue with a DUPLICATE CHECK column. Flag suspects, do not delete or pay anything.

More on this prompt: the free ai bill and invoice tracking prompt page.

Pros of DIY prompting

Cons of DIY prompting

Way 3: with AI Agent Skills (free, Free)

The Bills & Invoices Agent is this job already designed: fixed evidence rules, output contract, test fixtures and stop points. You ask once:

Hello, process these new bills and invoices

And a finished, review-ready artifact lands in your own Drive:

VendorInvoiceAmountDue dateDuplicate checkReview status
PrintWorksPW-2291$380Sep 20No duplicate foundReady to schedule
CloudNine SaaSCN-8821$2,400Sep 15Matches CN-8801 amount - possible duplicate billingHeld for review

Sample data shown. Your workspace fills with your real work.

Setup takes about 10 minutes: download, hand the Included files to the assistant you already use (Instinct, ChatGPT, Claude, Gemini or any other assistant that reads files), approve the fictional-data test. Then it runs on a standing cycle or a one-line ask, and stops at every human gate. Full method.

Pros of the ready-made agent

Cons of the ready-made agent

Download free agent pack

The honest comparison

Way 1: manualWay 2: DIY AIWay 3: free agent
Time to first result1-2 hours a week, plus the cost of missesAn afternoon of prompt tuningAbout 10 minutes, tested setup
Every run afterSame hours, every timeRe-paste the rules, sheet and context each runOne short ask, or a standing cycle
ConsistencyDepends on the dayDrifts between sessionsSame output shape every run
CostYour hoursFree, plus your timeFree, files kept forever

The manual way teaches you the job. DIY prompting is fine for a one-off. The agent wins when the job repeats every week.

More: the Bills & Invoices Agent product page · the AI bill and invoice tracking guide · AI agents for bookkeepers

Questions people ask

What is the fastest way to track bills and catch duplicate invoices?

The free ready-made agent: about 10 minutes of setup, then one short ask per run. Manual takes 1-2 hours a week, plus the cost of misses; DIY prompting takes an afternoon of tuning plus upkeep.

Can I track bills and catch duplicate invoices without AI?

Yes - the manual steps are on this page. Expect 1-2 hours a week, plus the cost of misses each time the job runs.

Is the free agent worth it over DIY prompting?

If the job repeats weekly, yes: you stop rebuilding prompts and re-pasting context every run. For a one-off, DIY prompting is fine and free.

Last updated 13 September 2026 · Reviewed by the AI Agent Skills team.