Understand the gap between marketplace totals and bank payouts.

A comparison your accountant can follow

See the comparisons separately

The workflow covers monthly gross totals, account activity and payout-to-bank matching, so a difference has a place to be explained.

Keep the source beside the number

Source references and an unresolved-question list make the handoff easier to follow when records are missing or timing differs.

Know what the finished work can look like

The download includes a sample spreadsheet and a sample accountant memo, alongside the records used for the example.

From a confusing difference to a specific question

The companion brings marketplace gross, fees and other account activity, payouts and bank receipts into separate comparisons. The result is a clearer explanation of which figures agree, which differences the records support and what still needs your accountant’s attention.

A look inside

In the included example, a December payout reaches the bank in January. The workbook and memo keep the sent date and bank-posted date separate instead of treating the timing difference as missing money.

Get the Payout Reconciliation Pack — $9

What’s in the download

• Ten-page Prompt-Companion.pdf and two-page Getting Started Guide
• Sample-Reconciliation.xlsx and a one-page sample accountant memo
• Sample-Records.zip with six example inputs: payments, statement, payouts, bank, controls and intake

Formats and requirements

This edition covers one US Etsy shop, one calendar year and USD records. It works with manual spreadsheet review or an optional AI assistant that can inspect files and calculate. A spreadsheet app opens the XLSX example; PDF guides open in a PDF reader. No skill-installation files or Etsy/bank connection are included. It organizes records rather than calculating taxable income or preparing a return.