MAP CHANNELS TO REPORT SOURCES
Use labels, system names and report categories only. Repeat this page for more channels; mark unknowns plainly.
Financial & Accounting · FREE PREPARATION PACK
Ecommerce bookkeeping report-source and settlement-question workbook
A selling channel, payment provider and bookkeeping system may each show a different slice of the same activity. This helpful preparation resource from PickYourPro.ai helps you describe where reports come from and what you need a bookkeeper to investigate. It is a source map and conversation record, not a reconciliation procedure. Use channel labels to connect report questions, missing information and the proposed deliverables without copying transactions into the worksheet.
Download free PDF ↓Ready for proposals? Start a request ↗
Preparation only, not bookkeeping, reconciliation, accounting, tax, payment-processing, records-retention, cybersecurity or legal advice. This workbook does not classify activity, validate balances, calculate differences or choose tax treatment. Do not enter transaction amounts, customer or order identifiers, bank details, credentials or private exports. Arrange any record exchange privately with the professional.
START HERE
How to use this resource
Give each selling channel a label such as C1 or C2. For each label, name the system that produces order, payment, payout and refund information if known; write unknown when you need help. Ask the bookkeeper to confirm which reports, periods, date definitions and currencies are relevant. Record unresolved questions by topic and responsible role, not by amount or customer. Repeat the channel page as needed and give every provider the same non-sensitive map.
Open the PDF in a form-capable viewer, save a copy, then fill it in. Reopen your saved copy to check your answers. You can also print the blank pages and write by hand. Your answers are not submitted to PickYourPro.ai.
LABEL REPORTS AND OPEN QUESTIONS
Do not copy transaction data. Ask the bookkeeper to define the source coverage and investigation needed.
CHECK THE SOURCE MAP
Tick what is ready to discuss. An unchecked item is an open question, not evidence of an accounting error.
QUESTIONS FOR THE BOOKKEEPER
Use your channel labels in the answers. Let the professional define the review, not this worksheet.
COMPARE ONE CHANNEL MAP
Use A and B in each box. Compare the specific investigation and handoff, not just a monthly service label.
USE IT RIGHT NOW
Ecommerce Bookkeeping preparation checklist
- Assign a short label to each selling channel and name its storefront, marketplace or payment system.
- For each label, identify where order, payment, payout and refund reports originate, or mark the source unknown.
- List report titles or categories only; do not attach exports, copy transactions or enter customer information.
- Ask the bookkeeper to confirm the relevant report period, date definition, time zone and currency for each source.
- Flag possible coverage gaps or overlapping sources as questions, without calculating or diagnosing differences.
- Separate a missing-report question from a settlement question and identify which role can answer it.
- Request a written list of reviewed channels, source reports, unresolved items and proposed handoff records.
- Compare the same channel map and investigation boundaries; keep processor selection and tax work separate.
Questions to ask an ecommerce bookkeeper
- Which source reports do you need for each channel, and how will you confirm whether the available reports cover the requested work?
- Which period, date definition, time zone and currency questions must be resolved before you review the records?
- How will you distinguish a missing source from an unresolved payout, refund, fee or adjustment question?
- Which questions will you handle, and which require the client, platform support or another professional?
- What review results, unresolved-item list and source references will you deliver without implying that every question has been resolved?
- What initial review, exclusions, fee basis and change approval apply if the source map reveals additional channels or work?
Write down the answers and any exclusions. If two proposals describe different work, clarify the difference before comparing their totals. Leave unanswered points blank until the professional confirms them.
A CLEARER NEXT STEP
Ready to hear from pros?
Create an account on PickYourPro.ai only if you choose, then start a Bookkeeping request. Share a non-sensitive channel and report-source map so participating pros can compete with proposals. Compare review scope, unresolved-item handling, deliverables, fees and fit. Availability varies.
Start a new request ↗Participation and availability vary. A private source-report review may be needed before a final engagement scope.
Keep the useful part.
The worksheets are free to use whether you hire through PickYourPro.ai or elsewhere. No account is needed to download them.
Download the five-page pack ↓One request. Every pro’s best offer.
More help with your next step
Official references and scope
These are original planning prompts, with AI assistance, prepared by PickYourPro.ai. Official links checked October 15, 2026. This pack has not been independently reviewed by a licensed specialist.
- Shopify Help Center: Payout details ↗
Primary platform documentation used to distinguish transaction and payout report concepts and prompt questions about report scope, dates and currencies. Features vary. This original workbook provides no export steps, payout timing, calculations or accounting treatment.
Linked organizations do not endorse PickYourPro.ai. Report a correction.