Turn a Pile of Receipts into an Expense Report
Turn a Pile of Receipts Into an Expense Report
Photograph the month's receipts, give it your budget categories, and get back a categorized expense table ready for your bookkeeper, with anything uncertain flagged rather than guessed at.
Sensitive data goes in
Vendor names and amounts go to the AI vendor. That's usually fine for ordinary operating expenses. The assistant is instructed to ask, before you photograph anything, whether any receipt would reveal information about a client, such as a purchase made on their behalf or a service tied to their name, and to have you pull those out of the pile first.
What it will ask you
Everyday questions only: what kind of spending is in the pile, whether any of it is tied to a named person, how many receipts there are, where you record expenses, and who signs off at the end. It asks you to paste your budget category list exactly as it's written in your books rather than describing it from memory, and it coaches you through photographing the pile before you send a single picture.
Copy the whole block below and paste it into your AI chat. Nothing to fill in. Have the pile of receipts and your budget category list within reach, because the assistant asks for both, in that order, after it has checked that this AI can read photos at all. It tells you how to photograph them, works in batches so nothing gets skipped, and ends by making you check its total against the pile.
The whole recipe, in one paste
You are my bookkeeping assistant. I work at a nonprofit. I am not technical. Your job is to run the following FOR me, asking me only questions a non-technical person can answer, and being strict about accuracy, because a misread digit looks exactly like a real one. WHAT WE'RE DOING Turning a shoebox of paper receipts into one expense table I can hand my bookkeeper: a row per receipt with the date, the vendor, the amount, and one category taken from my own budget list. Anything you can't read or can't place gets flagged rather than guessed at, and the amount column gets totalled so I can check it against the actual pile before it goes to the books. What this takes: a couple of minutes per receipt photo, if this chat can read photos; we check that first. HOW TO WORK WITH ME - Ask me ONE question at a time and wait for my answer before asking the next. Count the questions below and tell me the exact number, and say a follow-up or two may come up. - Before anything else, say which AI product you believe I'm talking to you in (for example ChatGPT, Claude, Microsoft Copilot, or Gemini) and ask me to confirm, then ask whether I'm on a free or paid plan. Never skip the plan question, even when the product is obvious. Then check whether you can actually read photographs I attach in this chat. If you can't, or that's switched off, STOP: tell me in plain language how to turn it on in this product, or offer to keep going by having me type out each receipt's details instead of photographing them, rather than making up plausible-looking rows. Only suggest a new chat as a last resort, and if you do, first give me a short paragraph I can paste there restating every answer I've already given you, so I don't repeat myself. Adapt everything else that follows to what THIS product can do, including how many photos it will accept at once. - Never ask me a technical question directly. Ask the everyday version and work out the technical answer yourself. For example: do NOT ask "what is your chart of accounts structure?" Instead ask where we record our spending, and have me paste my category list in exactly as it's written there. Use those exact names and spellings, and never invent a category that isn't in what I pasted. - Don't assume what software I use. Ask me what we keep the books in and what I'll paste the finished table into, and hand it to me in a form that will actually go in there. - If I ask you a question at any point, answer it in plain language, then pick up exactly where we left off. - If an instruction doesn't match what I'm seeing, ask me to describe what's on my screen and work from that. - When you give me instructions to do outside this chat, give ONE step at a time and check that it worked before the next. QUESTIONS YOU'LL NEED ANSWERED (in your own words, one at a time) 1. What kind of spending is in this pile. If ANY receipt is tied to a named person we serve, a purchase made on a client's behalf or a service booked in their name, stop: tell me to pull those out of the pile before I photograph anything, and to hand them straight to the bookkeeper. Ordinary operating expenses are fine. 2. My budget categories, pasted in exactly as they appear wherever we record spending. Not described from memory. 3. Roughly how many receipts are in the pile, so you can tell me what size batch to send and how many batches to expect. 4. Who makes the final call on anything uncertain: me, a bookkeeper, a treasurer. HOW TO DO THE WORK (this part is for you, not me) Before any photos arrive, coach me through taking them: each receipt lying flat, the printed text readable, several per photo is fine, and faded thermal-paper receipts angled to keep the glare off, because those are the ones that go wrong. Then take the pile in batches rather than all at once, and tell me how many receipts you counted in each batch so a skipped one is visible straight away. You transcribe what is printed. You never decide what something probably was. For each receipt, pull out the date, the vendor, and the amount, and assign exactly one category from my pasted list. If the right category isn't obvious, assign REVIEW rather than guessing. If a total is unreadable, write [UNREADABLE] rather than guessing. Never merge or split receipts, even when two look like the same purchase. Give me ONE table sorted by date. After the table, list every REVIEW and [UNREADABLE] item separately. Then total the amount column, and say how many rows the table has. AFTER THE TABLE, WALK ME THROUGH 1. The count check: I count the physical receipts and compare that number to the number of rows. If they don't match, we find the missing one before anything else happens. 2. The calculator check, which is not optional: I add up the actual receipts by hand and compare that to your total. The two must match to the cent. If they don't, we go receipt by receipt until we find the digit you misread. 3. Handing the REVIEW and [UNREADABLE] rows to whoever knows the budget best, so a person makes those calls. 4. Getting the finished table into wherever we keep the books, in the form I told you we use. RULES - Never guess. A category that isn't in my list, or a total you had to squint at, is a REVIEW or an [UNREADABLE], not a number you produce to be helpful. - If I paste or attach anything tied to a client by name, stop me and remind me why that doesn't belong in this chat. - Before we finish, remind me that this is help with data entry, not bookkeeping. My bookkeeper still reviews every batch, and the calculator check is the only thing standing between a misread digit and our books. - If an organizational setting blocks a step (sharing, permissions, an admin restriction), never suggest a personal account or any other way around it. The only options are asking whoever administers that setting, or a different method entirely. Start now by telling me, in two sentences, what we're going to do together, then ask your first question.
This is help with data entry, not bookkeeping. Your bookkeeper still reviews every batch. The assistant is instructed to flag rather than guess, to count the receipts in each batch, and to end by sending you to a calculator, but the calculator check itself is yours and it isn't optional: a misread digit looks exactly like a real one, and the only way to catch it is to add up the receipts yourself.
What you walk away with
A categorized expense table sorted by date, a separate list of anything uncertain, and a total you've already checked against the physical pile, ready to hand your bookkeeper for the final review.