E-commerce bookkeeping

Sales payouts reconciled across every channel

An online seller's books take in deposits from Shopify, Amazon, PayPal and Square, and none of them arrive as plain sales. An Amazon settlement nets out fees, refunds and a held reserve, so the bookkeeper rebuilds it line by line in a spreadsheet before it matches the bank.

Who it is forBookkeeping firms with 3 to 30 staff serving online sellers, and multi-channel stores with an in-house bookkeeper
Who decidesThe bookkeeper
Where the work livesShopify, Amazon, PayPal and Square payout reports → bank feed → QuickBooks Online
BuildTen business days
A desk with a printed payout statement split into colored columns, a small card reader beside a cardboard shipping box, a calculator, and a bank deposit slip clipped to the statement.

Who does what

The hours go into taking apart deposits that were never just sales.

Collect payout reports Pulls each settlement and payout report from Shopify, Amazon, PayPal and Square for the period.The agent
Split each payout Breaks the payout into gross sales, channel fees, refunds, reserves and currency differences using the client's account mapping.The agent
Match to the bank Pairs each payout with its deposit in the bank feed and lists any payout with no deposit, or a deposit with no payout.The agent
Catch double entries Flags sales or fees that a connection already recorded and that a manual entry would record again.The agent
Approve and decide Reviews the draft entries, decides unclear lines such as a chargeback or an odd adjustment, and approves posting.The bookkeeper

What you get

One draft journal entry per payout, split into gross sales, fees, refunds, holds and currency differences, matched to the bank deposit and waiting for the bookkeeper's approval.

Draft for review

Payout
An Amazon settlement covering two weeks of sales, with referral fees, fulfillment fees, two refunds, a reserve held back and one line labeled as an adjustment.
Draft
A journal entry in QuickBooks Online with sales to the Amazon sales account, fees to merchant fees, refunds to returns, the reserve to the Amazon clearing account, and the net matched to the bank deposit. The adjustment line is left unposted and flagged.
Based on
The client's Amazon mapping rule and how last month's settlement was booked.
How sure it is Moderate
Why a person decides The adjustment line has no matching rule or past example, so the bookkeeper decides whether it is a reimbursement, a fee reversal or something to ask the client about.

The rules it follows

It books each channel the way the client's books already do.

These are your company's own rules, written down and confirmed with your team during the build. It works on its own only within limits you set.

  • Each channel's fees, refunds and reserves go to the accounts in the client's chart of accounts.
  • Each channel has one path into the books: its connection or the payout entry, never both.
  • Lines below the amount the firm sets post without review; anything above it waits.
  • Chargebacks, unknown adjustments and sales tax lines always go to the bookkeeper.

What it learns when your team adjusts its work

Useful from the first day, and it keeps getting better. The bookkeeper reviews its work.

The busywork it takes off the bookkeeper. It takes off the bookkeeper the line-by-line rebuild of every payout in a spreadsheet before it can be posted. That time goes back to the work only they can do.

What it starts out knowing

  • The client's chart of accounts and classes
  • How each channel's fees, refunds and holds are booked today
  • Which channels feed the books through a connection and which through manual entries
  • The review threshold and the month-end checklist

It works from these sources, shows which one an answer came from, and asks when the answer is not there.

Who reviews its work, and when review can stop

The bookkeeper reviews every entry at first. Review stops for a routine payout type, such as a daily Shopify payout, once its record on that type is good and the firm agrees.

Unknown adjustments, chargebacks, sales tax and anything the client needs to be asked about keep going to the bookkeeper.

It no longer needs review once its record on them is good and you agree, one type of task at a time. New, unusual and high-stakes work stays with a person.

When your team adjusts its work

When the bookkeeper changes how an Amazon reserve release was booked, moving it from sales to the Amazon clearing account, the change is saved as a rule for that client, and the next settlement books the release to the clearing account. The bookkeeper decides whether a change becomes a rule, an example or a one-time exception.

It learns how your company does this job. It does not watch, rate or profile your employees. Your team decides what it learns. You can read everything it has learned and remove anything. Whoever runs it, your team or our engineers, makes sure on a regular cycle that what it learned stays inside the bounds you agreed.

From a request a business posted

A bookkeeper, on a bookkeeping forum.

A bookkeeper working a client's books found that the PayPal connection and the manual entries were both landing, so income and expenses showed up twice. Square added a flood of small charges that had to be folded into each day's card and cash totals. The bookkeeper could not tell whether to keep the app connections or the hand-keyed deposits, and asked others how they keep the two from colliding.

Paraphrased from a public post, not quoted, and not a client engagement.

From first principles

Does each deposit in the bank equal the sales, minus the fees, refunds and holds that channel took, booked once and only once?

Before we build anything, we take the work down to what has to be true. What is left over is habit. Habit gets deleted, not automated.

  1. What has to be true

    • Every payout is split into its sales, fees, refunds and holds.
    • Each payout matches one deposit in the bank feed.
    • No sale or fee is recorded twice by a connection and a manual entry.
  2. What is only habit

    Re-entering each payout into a spreadsheet before posting it is habit, not a requirement. So is keeping both the app connection and a manual deposit entry just in case one misses something.

  3. What we delete before building anything

    We remove the duplicate path first: each channel gets one way into the books, either its connection or the payout entry, never both. We drop the side spreadsheet once the payout entry carries the same split.

  4. What is left

    The agent. We build an agent that reads each payout report, splits it by the client's own booking rules, matches it to the bank deposit and drafts the entry in QuickBooks Online. For bookkeeping firms, this can become a service they offer their e-commerce clients.

    A person. The bookkeeper approves the entries, decides lines the agent cannot place, and owns sales tax and anything that touches the client's tax position.

The kind of work: Checking and matching. Checking and matching is the work of holding one record against another: a bank line against the books, a delivery ticket against an invoice, a payout against the sales behind it, a customer's request against the price list. People still do it by hand because the records never line up exactly, and someone has to decide what each mismatch means.

What the engagement needs

What we need from you, and how it runs.

Read access to each sales channel's payout and settlement reports, the bank feed, and draft-entry access in the client's QuickBooks Online file. We also need the client's chart of accounts, a few months of booked payouts as examples, and the firm's notes on how each channel is handled.

How the engagement runs

  1. 01

    Fit test first

    We check the time this job takes, access to your systems and how you would review the result. If a ready-made tool is enough, we say so.

  2. 02

    Build in ten business days

    Senior engineers agree the rules with the bookkeeper, test on past cases and set approval limits and a way to switch it off.

  3. 03

    Ninety days of support, included

    Work with the agent in Slack, Teams or text messages. We fix problems and adjust it as unusual cases come up.

  4. 04

    Keep improving it, with your choice of operator

    You own the agent and keep its source, tests and guide either way. Your team runs it, or our engineers run it with a monthly report. Learning continues on your own servers, in your own cloud account or in our data center.

When we'd point you elsewhere

Sometimes a ready-made tool is enough.

The fit test checks this first. If one of these covers your case, we tell you, and you keep the map of the work.

  • The store sells on one channel and its connector already books payouts with fees and refunds split out. The sales channel's own accounting connector is enough.
  • A client sells on two or three large channels, in one currency, with no unusual adjustments. A ready-made payout reconciliation app for e-commerce is likely enough.

Honest limits

What this page does not claim.

It does not decide sales tax across states or currency treatment for tax purposes; those stay with the bookkeeper or the CPA.

The situation on this page is drawn from a public request a business posted, paraphrased, not a client engagement.

Show us the work

More use cases

More work of the same kind: checking and matching.