Bookkeeping
Red flags of fraud your books can reveal
November 19, 2026 · 10 min read

Quick answer
Your books can show fraud before anyone confesses to it. The patterns to look for are round-dollar payments, new vendors with PO boxes or addresses that match an employee, duplicate or near-duplicate invoices, voided and reissued checks, credit memos and write-offs posted after a month is closed, payroll for people who've left, and reconciling items nobody can explain. None of them proves anything on its own. Each one is a question that deserves an answer and a document.
Most employee fraud in a small business isn't clever. A vendor that didn't exist last year starts getting paid $3,500 every month. A check gets voided, then reissued to a different payee. A customer's balance is quietly written off two weeks after the month was closed. Every one of those leaves a mark in the ledger, and the marks sit there for months because nobody goes looking.
This post is about detection: what those marks look like and how to run simple tests for them in QuickBooks Online or Xero. Prevention (splitting duties, approving payments, positive pay) is covered in fraud controls that work with 2 or 3 people. Read that one too. Controls stop most schemes; looking at the ledger catches the ones that get past them.
How often do the books actually catch fraud?
Less often than they could. The Association of Certified Fraud Examiners' Occupational Fraud 2026: A Report to the Nations studied 2,402 cases. The median loss was $104,000 per case, and the typical scheme ran 12 months before it was found. Billing schemes ran a median 14 months; check and payment tampering and payroll fraud, 13.
Here's how those frauds were first detected:
How occupational fraud was first detected
Percent of cases, ACFE 2026 study (selected methods)
Source: ACFE, Occupational Fraud 2026: A Report to the Nations, Figure 13. Values are percentages of cases.
Show the numbers
| Tip | 43 |
| Internal audit | 15 |
| Management review | 13 |
| Document examination | 5 |
| Account reconciliation | 5 |
| By accident | 4 |
| Automated data monitoring | 3 |
| External audit | 2 |
Document examination, account reconciliation and data monitoring together found about one fraud in eight. A small business usually has no internal audit team at all, so management review and the books are what's left. And here's the encouraging part: the same report found that only 11% of frauds involved no concealment at all, and the most common method was creating fake physical documents (39% of cases). Fake invoices and altered records have to be entered somewhere. That somewhere is your ledger.
Which payment patterns are red flags?
Start with money going out, because that's where small-business fraud concentrates.
Round-dollar amounts. Real invoices are messy: $2,317.48 for parts, $1,186.20 for freight. A vendor paid exactly $3,500.00 every month, with no contract that explains it, is worth a look. Rent, retainers and loan payments are round too, so expect plenty of innocent hits.
Amounts just under an approval limit. If payments over $5,000 need the owner's sign-off, a cluster of $4,850 and $4,975 invoices from the same vendor is a pattern, not a coincidence.
Payments with thin support. An invoice with no phone number, no invoice sequence, or a PDF that looks like a template filled in yesterday.
Changed payment details. A long-standing vendor whose bank account changed this year. That's also the classic sign of an outside scam, so it gets checked either way.
Voided and reissued checks. A check voided and a "replacement" issued to a different payee, or a void that never appears on the bank statement because the original actually cleared.
Which vendor patterns should you look for?
Pull the vendor list sorted by date created and look at everything added in the last year:
- PO box or mailbox-store address with no street address anywhere on file
- Address, phone or bank account that matches an employee's (compare against the payroll master file)
- No tax ID or W-9 on file, or a W-9 collected after payments started
- Similar names to a real vendor ("Metro Supply" and "Metro Supply Co")
- Only one person ever enters its bills, and it's the same person who added it
A vendor matching an employee's address is the strongest single signal on this list. It's rarely innocent, and when it is, there's usually an obvious answer (an employee's spouse runs a legitimate business, which you should have known about anyway).
What do duplicates, credit memos and write-offs reveal?
Duplicate invoices. Same vendor, same amount, invoice numbers one digit apart or with a suffix ("4471" and "4471A"), paid within a few weeks of each other. Sometimes it's an honest double-entry. Sometimes one of the two payments went somewhere else.
Credit memos and write-offs after the close. On the sales side, the classic small-business fraud is skimming customer payments and then hiding the gap. The hiding usually happens with a credit memo, a bad-debt write-off or a "discount" posted to a customer account, often after the month was closed so nobody reviews it. Watch for write-offs on customers who are still buying, and for credits entered by someone who also handles deposits.
Customer payments applied to the wrong invoices. If one customer's payment keeps getting applied to another customer's older invoice, someone may be covering a stolen payment with the next one in (lapping). Your AR aging report shows it as balances that stay current overall while specific old invoices never clear.
Entries in closed periods. QuickBooks Online and Xero both let you set a closing date or lock date. If entries keep appearing in months that should be locked, find out who's changing them and why. The audit log in each tool shows the user and the time.
What about payroll and reconciliations?
Payroll after termination. Compare the payroll register with your termination list. A paycheck after someone's last day might be a final commission or accrued vacation. Three paychecks is a ghost employee.
Pay changes nobody approved. Rate increases, extra hours or new bonus lines with no signed approval behind them. Look especially at whoever runs payroll: their own pay history should be reviewed by someone else.
Unexplained reconciling items. A bank reconciliation that "balances" thanks to a $1,840 item called "adjustment" that's been carried forward since spring is a red flag in itself. Old outstanding checks, deposits in transit that never arrive and plugs to make the numbers match all deserve an answer. See reconciling items for what legitimately belongs there.
A worked example: one year of ledger tests
Say you own a hypothetical 30-person wholesale distributor. Over the last 12 months the company made about 3,400 payments. At year end you (or your accountant) run eight simple tests on the ledger and payroll exports. Here's what came back:
| Test | Items flagged | Explained | Still open |
|---|---|---|---|
| Round-dollar payments of $1,000 or more | 41 | 38 | 3 |
| New vendors with PO box, no phone or no W-9 | 9 | 7 | 2 |
| Vendor address or bank matches an employee | 1 | 0 | 1 |
| Possible duplicate invoices | 14 | 12 | 2 |
| Voided or reissued checks | 11 | 9 | 2 |
| Credit memos posted after the close | 6 | 4 | 2 |
| Payroll after a termination date | 2 | 1 | 1 |
| Reconciling items older than 60 days | 3 | 1 | 2 |
| Total | 87 | 72 | 15 |
Ledger test results: flagged vs still open
Hypothetical 30-person distributor, 12 months of payments
- Flagged
- Still open
Hypothetical example. 87 items flagged, 72 explained with documents, 15 still open.
Show the numbers
| Flagged | Still open | |
|---|---|---|
| Round $ | 41 | 3 |
| New vendors | 9 | 2 |
| Employee match | 1 | 1 |
| Duplicates | 14 | 2 |
| Voids | 11 | 2 |
| Late credits | 6 | 2 |
| Payroll | 2 | 1 |
| Recon items | 3 | 2 |
Most of the 87 hits are boring: rent, a retainer, a monthly software contract, a reprinted check because the first one was mailed to an old address. That's normal. Of the 15 open items, the ones to chase first are those that point at the same place. In this example, the vendor whose address matches an employee is also behind all 3 open round-dollar payments and one of the open new-vendor items. Four flags, one name. That's where you'd stop testing and get help, not start asking the employee questions.
How often should you run these tests?
You don't need software for most of them. A vendor list sorted by date created, a payments report exported to a spreadsheet, the payroll register and the bank reconciliations cover all eight.
Every month
- Read the vendor list for anything added, and ask for the W-9
- Scan payments for round amounts and new payees
- Check that every reconciling item has a reason and a date
- Compare the payroll register with your headcount
Every quarter
- Run the duplicate invoice and voided check tests
- Review credit memos and write-offs, and who entered them
- Look at the audit log for changes in closed months
Once a year
- Match vendor addresses, phones and bank accounts against employee records
- Review pay history for the people who run payroll and AP
- Run all eight tests over the full year
Common mistakes
Treating a balanced reconciliation as proof nothing's wrong. If the money really left the account to a fake vendor, the bank reconciles perfectly. Reconciliations catch missing money, not money sent to the wrong place.
Letting the suspected person run the test. If the office manager pulls the vendor report for you, you're relying on the person you're checking.
Ignoring the sales side. Owners watch payments and forget credit memos, write-offs and discounts, where skimming gets hidden.
Explaining hits away without paper. "That's the cleaning company" isn't an explanation until you've seen the contract and an invoice.
Testing once and stopping. The typical scheme in the ACFE study ran a year. A test run every quarter cuts that window.
When to get help
If you have a handful of vendors and you approve every payment yourself, the monthly checks above take an hour and you can do them yourself.
Get help when you can't run the tests independently (because the only person who knows the system is the person you'd be checking), when the books are months behind and reconciling items have piled up, or when a test points at someone. Every bank and card account is reconciled each month at Fintrix Consulting, and a qualified professional who didn't prepare the work reviews every close; here's what our monthly bookkeeping covers. That's the base these tests rely on. If something looks like actual fraud, though, you want a forensic accountant or an attorney, not a bookkeeper.
Frequently asked questions
Can a bookkeeper detect fraud?
A good bookkeeper notices patterns: vendors that appear from nowhere, reconciling items that don't clear, credits that don't make sense. That's detection by noticing, not a fraud investigation or an audit. If you want someone to look specifically for fraud, that's a forensic accounting engagement.
Does a bank reconciliation catch fraud?
It catches money that's missing or recorded wrongly. It doesn't catch money that was recorded correctly but paid to the wrong person, like a fake vendor. That's why vendor and payment reviews matter as much as reconciliations.
Will my annual tax return preparer catch fraud?
Usually not. Preparing a return relies on the books as they are. Your CPA may spot an odd number, but they aren't testing your vendor file or payroll register.
What's the single most useful test?
Matching vendor addresses, phone numbers and bank accounts against employee records. It's quick, it rarely produces innocent hits, and fake vendors are behind billing schemes, one of the most common frauds in small businesses.
What should I do first if I suspect fraud?
Preserve the records, don't confront the person, and get professional advice before you act. Changing or deleting entries can destroy the evidence you'll need later.
The bottom line
Fraud in a small business usually leaves a trail in the ledger: round payments, look-alike vendors, duplicates, voids, late credits, payroll for people who've gone and reconciling items nobody can explain. Run a few simple tests every month and quarter, insist on a document for every hit, and pay attention when several flags point at the same name. When they do, stop testing and get professional help. The books find the questions; someone else should answer them.
Sources
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Who should have access to your accounting system?
November 20, 2026
- 25 bookkeeping terms every business owner should know
November 20, 2026
- The most expensive bookkeeping mistakes, ranked by cost
November 20, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.