Email search for bookkeepers: finding the email that explains a charge

To find the email that explains a charge, start from the bank-feed line, not from the client. The line gives you three things to search: the amount, the date and the name the bank printed. Search the exact amount first, written the way a receipt would write it. Then search the vendor’s real name inside a window that starts a week before the charge posted. Add an attachment filter when you’re looking for a receipt or an invoice. If none of that finds it, the email is probably in the client’s mailbox, and one short question gets it.

That’s most of it. The rest is making the answer stick, so the same charge never costs you a search twice.

• Search the amount, exactly. It’s the one detail the receipt, the invoice and the feed all share.
• Clean up the bank’s name for the vendor. Drop the processor prefix and the store number, and search the first real word.
• Search a window, not a day. Receipts arrive before the charge posts, and renewal notices arrive weeks before.
• Look for the “yes” as well as the receipt. Some charges are explained by a client’s approval, not an invoice.
• Put the answer on the transaction. Attach the email or the receipt, and write one line in the memo.

Email search for bookkeepers starts with the feed line

A mystery charge usually arrives as a line like this:

09/15/2026   SQ *HARBOR PRINT CO*#0412   -318.40

Each part of it is a search term, once it’s translated.

The prefix is the part that throws people. Square’s own documentation says its card statement descriptions start with the identifier SQ *, followed by the business name. Its example is SQ *MYPHARMACY*#02943. PayPal, Amazon, app stores and online checkouts do something similar, so the first word in the feed is often the processor. Search the word after the asterisk.

The amount needs one more thought. Receipts write money in different ways: 1,482.17, 1482.17, $1,482.17. If the charge is over a thousand dollars, try it with and without the comma. If the amount includes tax or a tip, the email may show the subtotal instead. In that case, the vendor name and the date window will do more work than the number.

Searches to copy, in Gmail and Outlook

These cover most of the charges a client asks about. Swap in your own names, amounts and dates.

A few details make these work.

Gmail’s operators are documented in one place. Google’s search operators page lists every one of these, including filename: and in:anywhere. Its line for in:anywhere is short:

“Find emails across Gmail. This includes emails in Spam and Trash.”

That matters for receipts. A vendor’s billing email can land in Spam the first time, and a client sometimes deletes a forward after sending it on.

Outlook wants capital letters and whole numbers. Microsoft’s search syntax page says AND, OR and NOT have to be uppercase. It also says this about numbers:

“Strings of numbers less than five digits are ignored. If you want to search for 98101, entering 9810 will not return any results.”

So type the amount in full, with the cents, and don’t search a partial invoice number. The same page says Outlook returns only the first 1,000 results, which is another reason to search narrow.

Outlook reads inside many attachments. Microsoft says the search box scans “both email messages and many types of attachments” for the words you type. Google’s operator page doesn’t say whether Gmail does the same for PDFs. When the amount only lives inside a PDF, search Gmail by vendor, date window and filename:pdf instead of the number.

Five charges from one client’s September

Here’s what a real batch looks like. Lakeside Bakery’s September feed has five lines nobody recognizes. Each one was found a different way.

Three things show up in a batch like this.

The amount finds receipts. The print shop and the designer were found by the number alone, in one search each.

The approval explains payments to people. A Zelle or a check to a person rarely has a receipt. The explanation is the client saying yes, so you search their messages for the payee’s first name.

Some emails were never sent to you. The Amazon order confirmation went to Maria. No search on your side will find it. That isn’t a failed search. It’s the point where you ask.

When the email went to the client

Most receipts go to whoever paid. For a small business that’s the owner, not you. So before you write to the client, check the two places on your side that might still hold the answer.

• Your sent mail. Recurring charges come back every year. Search in:sent adobe, and you may find last October’s explanation in your own words.
• The client’s forwards. Some clients forward receipts in batches. Search from: their address with has:attachment across the month.

Then ask. A question the client can answer from their phone names the charge the way their bank shows it:

Hi Maria,

One charge from September I can't place:

Sept 15, AMZN Mktp US*2K4LM0, $482.17

Could you forward the Amazon order confirmation, or tell me
what it was for? Reply here and I'll attach it to the books.

Thanks,
Sam

Ask in one email, for all the month’s unknowns at once, in the thread you use every month. Then every answer lands together, and next year’s search finds them all. How to hold those questions for one day a month is in email management for bookkeepers. Ready answers for the questions clients send you back are in the same question again.

For clients who generate a lot of receipts, a standing routine beats asking every month. The client forwards receipts as they come, to one place you check. How to set that up is in receipts and statements.

Putting the answer on the transaction

Once you’ve found it, take thirty seconds to keep it. The next person to ask about the charge might be you in March, the client’s accountant, or an auditor. Each of them should find the answer in the books.

Attach the document. In QuickBooks Online, Intuit’s help gives the steps for attaching a file to an existing transaction:

“Open the desired transaction. Select Attachments. Browse and select the document you want to attach. Select Open, then Save and close.”

PDFs, images and spreadsheets are all supported. Save the receipt, or print the email to PDF when the email itself is the explanation.

Write the memo line. One line, in the same shape every time:

Per Maria email 9/22/2026: patio repair, Rosa Martinez

The memo names who said it, when, and what it was for. It answers the question without opening anything. It also tells you exactly which email to search for if anyone wants the original.

Keep the thread findable. If you ask about unknown charges in one thread a month, give it the same subject every time: “Lakeside · September charges to explain.” The answers collect there, and one search for the client’s name and “charges” brings back every month’s.

When you can’t remember the words

Sometimes the question comes without a feed line. The client’s accountant writes, “Do you have the email where they agreed to the equipment lease?” You don’t remember the vendor or the amount. You remember roughly what it was about.

Keyword search is weak here, because it needs the words that are in the email. Search by meaning works from what you remember instead. How that kind of search works is in find an email when you can’t remember the words.

If the long thread you find is forty messages, the agreement may be on message twenty-six. Turning that thread into a short note is in the long thread.

Asking Point what a charge was

Point reads the mail in the Gmail or Microsoft 365 account you already have. When a charge needs explaining, you ask it the way you’d ask a colleague.

• Ask in plain words. “What was the $318.40 Harbor Print charge at Lakeside in September?” Point reads the mail and answers in a sentence. Every answer links to the original email, so you can check it before it goes in the memo (find and do in plain language).
• Ask about the PDF without opening it. “What’s the total on the designer’s invoice?” Point reads the attachment and links back to it (ask a question, get the answer out of the attachment).
• Search everything at once. Command-K looks across your mail, tasks, calendar and files in one box. Type “Lakeside,” and the September thread sits beside the task to send the close note (one search across everything).
• Find the file, not the thread. Documents gathers the attachments from your mail into one list. Each file stays tied to the email it came in.

Point searches the mailboxes you’ve connected. An Amazon confirmation that only ever went to the client is still in their inbox. For that one, Point helps you write the question. More on what Point does is on the benefits page.

When another tool fits better

If a client sends you dozens of receipts a month, a receipt-capture app may suit them better than email. Those apps read each receipt as it’s forwarded or photographed and match it to the bank feed. You do the searching once, when you set the routine up.

If the same charge comes every month, a bank rule in your bookkeeping software categorizes it before you see it. The search is only for the first time.

If the client has five transactions a month, the feed line and one question to the client are all you need.

Common questions

How can bookkeepers quickly find a client’s email or attachment?

Start from what you know for certain, usually the amount and the date. Search the exact amount in quotes. Then search the vendor’s name inside a date window, and add has:attachment in Gmail or hasattachment:yes in Outlook for a receipt. Searching from the client’s address narrows it to what they sent you.

Why can’t I find the receipt for a charge in my email?

Usually one of three reasons. The receipt went to the client, not to you. The bank printed a processor’s name, like SQ * or PAYPAL *, instead of the vendor’s. Or you searched the posted date, and the receipt arrived days earlier. Check your sent mail and the client’s forwards, then ask the client with the date, the amount and the feed description.

How do I search Gmail for a dollar amount?

Put the amount in quotes with the cents, like "482.17". If nothing comes back, try it with a dollar sign or a comma. Add in:anywhere to include Spam and Trash. If the amount only appears inside a PDF, search the vendor name with filename:pdf and a date range instead.

Can Gmail or Outlook search inside PDF attachments?

Microsoft says Outlook’s search scans many types of attachments for the words you type. Google’s search operator page doesn’t say whether Gmail searches inside PDFs. In Gmail, it’s more reliable to search the vendor, the date window and filename:pdf.

What should a bookkeeper write in the memo when a client explains a charge?

Who explained it, the date of their email, and what it was for. For example, “Per Maria email 9/22/2026: patio repair, Rosa Martinez.” Attach the receipt or the email as a PDF if your software allows it.

Is AI replacing bookkeepers?

The US Bureau of Labor Statistics projects employment of bookkeeping, accounting, and auditing clerks to decline 6 percent from 2025 to 2035. It says software has automated many of their tasks. It also projects about 144,100 openings a year over the decade, mostly to replace people who retire or move on. Software is good at matching a receipt to a line. Knowing which client to ask about a Zelle payment, and what they meant by “go ahead,” is still the bookkeeper’s job.