TidyAgree the starting point.
List the client’s stores, payout currencies and reporting periods. Identify what already records sales and which payout starts the new process.
A clear trail.
For every client payout.
Bring marketplace reports, account mappings and payout reviews into a repeatable bookkeeping workflow. Keep the source details close to the entries you prepare for QuickBooks Online.
✓ Free during beta✓ Reusable mappings✓ Source records for review
ONE CLIENT. ONE REPEATABLE PROCESS.From source report
From source report
to a reviewed entry.
Establish the workflow once.
Use the same checks each period.
Keep the source close.
Choose the supported report format for the channel. Retain its payout ID, dates and currency beside the review.
Use the client’s accounts.
Review where sales, refunds, fees and balance movements belong. Reuse mappings and resolve unfamiliar lines before preparing the entry.
Complete the handoff.
Review the prepared entry and its source totals. Check posting availability, retain the entry reference and compare the actual bank credit.
A PLACE FOR EACH AMOUNT.Mappings you
Mappings you
can explain.
A visible account choice
for the details in a payout.
Account choices stay explicit
Use sales, refunds, fees and reserve categories as a starting point for the client’s chart. Review tax treatment separately for the client’s jurisdiction and records.
Exceptions deserve a review
Investigate unfamiliar types, missing mappings and incomplete cost data. Keep a note of the decision with the supporting source records.
A SIMPLE REVIEW EXAMPLE.What you hand
What you hand
back to the client.
A fictional USD payout.
Illustrative accounts, before tax or reserves.
| Source amount | Illustrative account | Entry |
|---|---|---|
| Sales $1,000 | Marketplace revenue | Credit $1,000 |
| Refunds $50 | Sales returns | Debit $50 |
| Fees $30 | Marketplace fees | Debit $30 |
| Payout $920 | Bank | Debit $920 |
Keep the payout reference, source report, account choices and review notes together. Debits and credits each total $1,000; the bank credit to check is $920.
PREPARE FOR THE NEXT CLIENT.A useful
A useful
onboarding pack.
Make the first handoff
easy to review.
Before the first import
- Store names, countries and payout currencies.
- The client’s accounting system and chart of accounts.
- One completed payout and its bank reference.
- Current apps, recording responsibilities and cutover date.
Before the next period
- Resolve outstanding mapping and source questions.
- Check changes in currencies, stores and report formats.
- Review missing costs when using cost-of-goods figures.
- Keep entry references and bank checks with the review.
CHANNEL BY CHANNEL.The right report
The right report
for each store.
Amazon reports
Amazon settlement Flat File V2 (.txt / .tsv)
See format and sample →Shopify reports
Shopify Payments data bundle (.json) or TidyPayouts CSV
See format and sample →eBay reports
eBay Finances data bundle (.json) or TidyPayouts CSV
See format and sample →Etsy reports
Etsy payment-ledger data bundle (.json) or TidyPayouts CSV
See format and sample →Walmart reports
Walmart reconciliation report (.csv / .json)
See format and sample →A FEW PRACTICAL QUESTIONS.Plan the
Plan the
first review.
Can I use this alongside an existing bookkeeping tool?+
Compare previews for a closed payout first. Agree which process records each event and a clear cutover point before posting anything new. The comparison checklist can help organize that review.
Where do I check report formats?+
Each integration guide lists supported import layouts and links to a fictional TidyPayouts summary CSV. Native marketplace exports may use a different layout.
What should I prepare for beta setup?+
Bring one representative payout, the source report, the client’s accounting platform and the chart-of-accounts choices you want to review. Connection availability varies by channel and account.
Start with
one payout.
Bring the report. Review the mapping. Build a repeatable workflow.
Join the free beta →Free during beta. No credit card.