Start with Etsy Payments Deposits
Etsy offers separate CSV exports for order items, orders, Etsy Payments sales, and Etsy Payments deposits. For a bank check, use the deposit export because it represents Etsy Payments deposits made to your bank account.
The official deposit CSV is documented with Date, Amount, Currency, Status, and Bank Account Ending Digits. Date and Amount are the essential fields for the reconciliation.
Do not compare the deposit directly with gross sales
Etsy explains that the Amount in the deposit CSV reflects available sales funds after refunds, fees, taxes, and funds placed in reserve. That is why a deposit can differ from sales or net-profit figures shown elsewhere in the account.
Allow normal bank posting delay
Standard deposits can take several business days to appear after they are sent. This tool therefore uses a configurable date window instead of requiring the Etsy date and bank posting date to be identical.
Do not require the word Etsy in the bank description
Etsy says deposits can appear at the bank under payment processor names such as WorldPay, Envoy, Stichting Custodian, or Adyen. The bank description filter is optional so those legitimate postings are not accidentally discarded.
Read the exceptions separately
Etsy deposit not in bank
The Etsy CSV contains a deposit but no eligible bank posting was found. Check the bank date range, amount-sign convention, posting delay, and receiving account.
Bank-only deposit
A bank row did not match any Etsy deposit in the uploaded scope. It may belong to another source, or the Etsy export may not cover the same period.
Ambiguous
More than one one-to-one assignment is possible. The tool leaves the item unresolved rather than choosing a row by order.