Fintrix Consulting LLC

Bookkeeping

Red flags of fraud your books can reveal

November 19, 2026 · 10 min read

← All articles
Close-up of a person checking a thick stack of stamped documents with a pen in one hand and a calculator in the other
Photo via Pexels

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)

TipTip: 4343Internal auditInternal audit: 1515Management reviewManagement review: 1313Document examinationDocument examination: 55Account reconciliationAccount reconciliation: 55By accidentBy accident: 44Automated data monitoringAutomated data monitoring: 33External auditExternal audit: 22

Source: ACFE, Occupational Fraud 2026: A Report to the Nations, Figure 13. Values are percentages of cases.

Show the numbers
Tip43
Internal audit15
Management review13
Document examination5
Account reconciliation5
By accident4
Automated data monitoring3
External audit2

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:

TestItems flaggedExplainedStill open
Round-dollar payments of $1,000 or more41383
New vendors with PO box, no phone or no W-9972
Vendor address or bank matches an employee101
Possible duplicate invoices14122
Voided or reissued checks1192
Credit memos posted after the close642
Payroll after a termination date211
Reconciling items older than 60 days312
Total877215

Ledger test results: flagged vs still open

Hypothetical 30-person distributor, 12 months of payments

  • Flagged
  • Still open
0204060Round $ · Flagged: 41Round $ · Still open: 3New vendors · Flagged: 9New vendors · Still open: 2Employee match · Flagged: 1Employee match · Still open: 1Duplicates · Flagged: 14Duplicates · Still open: 2Voids · Flagged: 11Voids · Still open: 2Late credits · Flagged: 6Late credits · Still open: 2Payroll · Flagged: 2Payroll · Still open: 1Recon items · Flagged: 3Recon items · Still open: 2Round $NewvendorsEmployeematchDuplicatesVoidsLatecreditsPayrollReconitems

Hypothetical example. 87 items flagged, 72 explained with documents, 15 still open.

Show the numbers
 FlaggedStill open
Round $413
New vendors92
Employee match11
Duplicates142
Voids112
Late credits62
Payroll21
Recon items32

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.

A detection routine for a small business

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.

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.

Have a question about this article?

Ask us. A real person will reply by email within one business day. Your question isn’t published.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms apply.

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.