Skip to content

Monthly store sales into bookkeeping drafts

Pulls a month of paid consumer orders from your store and prepares the bookkeeping entries: a sales draft with tax, a separate draft for payment fees, and a PDF laid out like the paper receipts book. Nothing is posted until you apply it.

OperationsWorks with Cursor · Claude CodeCommunity example
Build your promptSee requirements

What it does

  • Pulls paid consumer orders for the month from the store
  • Builds a sales draft with tax included
  • Builds a separate expense draft for payment processor fees
  • Writes a PDF grid matching the paper receipts book for manual copying
  • Writes everything to a local plan folder first

Your approval boundaries

Creates drafts

These actions always wait for your yes:

  • Pushing drafts to the accounting portal with apply
  • Closing the month

You decide what happens next.

More about this workflow

This setup is for operators and managers who keep the busywork moving. It takes a repeat chore off your plate and hands back something you can check quickly.

First, it pulls paid consumer orders for the month from the store. Next, it builds a sales draft with tax included. Then it builds a separate expense draft for payment processor fees. After that, it writes a PDF grid matching the paper receipts book for manual copying. Finally, it writes everything to a local plan folder first. It works with your store admin and accounting app, each on its own login with limited access.

You get the prep work done and waiting for you. The agent stops and asks for your yes before pushing drafts to the accounting portal with apply and closing the month, and says plainly if a step cannot be undone.

“Credentials are never stored in this repo”
c1sc0c0 c1sc0c0 on GitHub · Oct 5, 2026
Before you startStore admin · Accounting app accessScoped permissionsCursor or Claude Code
Explore required tools and model recommendations

Tools and access

  • Shopify

    Handles the store admin part of this job. Grant read orders and products.

    API required: Yes. Needs a Shopify app with an access token and the admin scopes you approve.

    Sign up: Shopify

  • QuickBooks

    Handles the accounting app part of this job. Grant accounting data, no payments.

    API required: Yes. Needs an Intuit developer app with OAuth.

    Sign up: Intuit Developer

Official links only. Not sponsored, no affiliate links.

Model recommendations

Best pick

GPT-6.1 Sol

Cheap cached input suits jobs that rerun the same instructions each week.

$2 per million input tokens, $10 per million output tokens, for prompts up to 272K tokens. Longer prompts cost $4 in and $15 out.

OpenAI docs as of October 11, 2026

Cheaper backup

Gemini 3.5 Flash-Lite

Low cost for simple data pulls and matching.

$0.30 per million input tokens, $2.50 per million output tokens.

Google docs as of October 11, 2026

Our own picks. Not sponsored, no affiliate links.

Build your prompt

Add your details, then copy the prompt into your tool.

1Your details

Fill these in and the prompt updates as you type.

yyyy-mm

read orders only

kept out of the repo

2Your prompt

4 of 4 still empty
Fill these in before you run it: [MONTH: yyyy-mm] [STORE ADMIN TOKEN: read orders only] [ACCOUNTING PORTAL LOGIN: kept out of the repo] [RECEIPTS BOOK START MONTH] You are the Monthly store sales into bookkeeping drafts agent. Pulls a month of paid consumer orders from your store and prepares the bookkeeping entries: a sales draft with tax, a separate draft for payment fees, and a PDF laid out like the paper receipts book. Nothing is posted until you apply it. Use only the details filled in above. If any [BRACKETED] item is still blank or unclear, stop and ask for it first. Do not guess. What you do on your own: - Pulls paid consumer orders for the month from the store - Builds a sales draft with tax included - Builds a separate expense draft for payment processor fees - Writes a PDF grid matching the paper receipts book for manual copying - Writes everything to a local plan folder first What you must never do without a yes from a person: - Pushing drafts to the accounting portal with apply - Closing the month Rules: - Before any step on the list above, stop and ask. Say in plain words what you want to do, who it affects, and whether it can be undone. - If something cannot be undone, say so first, in one short line. - Write drafts, not final actions. A person sends, pays, posts, or deletes. - Keep a short log of every action you took and every source you read. - If you are unsure, ask instead of guessing.
View run instructionsPaste into: Cursor, Claude Code

Your answers stay in this browser only.

Run your workflow

Connect your tools with only the access this setup needs, then follow these steps.

Steps

Do these in order. Test on old data before it touches live work.

  1. 1Connect Shopify with its own login, not yours. Grant read orders and products.
  2. 2Connect QuickBooks with its own login, not yours. Grant accounting data, no payments.
  3. 3Paste the prompt where your harness takes instructions. See the note under the Copy button.
  4. 4Do a dry run on old or test data first. Check every draft and every stop point by hand before you let it near live work.
  5. 5Read its log after the first real run. Only widen access once a week of runs looks clean.

Safeguards and trust score

The score describes this example setup’s access, approval boundaries, ability to undo changes, and scope.

Access24 / 30

Writes drafts and notes inside your tools, nothing leaves on its own.

Human approval30 / 30

Waits for a yes on: pushing drafts to the accounting portal with apply, closing the month.

Undo and logs14 / 20

Proposes changes to live records, so the setup needs a change log and a way back.

Scope18 / 20

Runs on its own login across 2 tools. Fewer connections means a smaller blast radius.

How to raise it

  • Undo and logs: Stop it from editing live records. Have it write the change as a proposal you apply, and keep a log of every change with a way to roll it back +3
  • Scope: Run it on one tool only, with its own login that can see just what this job needs +2

Do all of these to reach 91, up from 86.

Want help getting there? Get an AI Trust Audit from Pixeldesigns

Reviewed by Trustcase (example setup). How scoring works

Embed badge

Show this trust score on your site or README. It links back here.

Trustcase trust score badge
Markdown
[![Trustcase trust score for Monthly store sales into bookkeeping drafts](https://trustcase.dev/badge/monthly-store-sales-into-bookkeeping-drafts.svg)](https://trustcase.dev/use-cases/monthly-store-sales-into-bookkeeping-drafts)
HTML
<a href="https://trustcase.dev/use-cases/monthly-store-sales-into-bookkeeping-drafts"><img src="https://trustcase.dev/badge/monthly-store-sales-into-bookkeeping-drafts.svg" alt="Trustcase trust score for Monthly store sales into bookkeeping drafts" height="20"></a>

More operations workflows

Other workflows that use the same tools

  • Refund checker

    Support. Checks refund requests against your policy and lays out the facts.

  • Order exception handler

    Ecommerce and resale. Catches orders that need attention before buyers complain.

  • Inventory count match

    Ecommerce and resale. Checks that what your store says matches what is on the shelf.