<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=984096836450318&amp;ev=PageView&amp;noscript=1">
Back to all recordings
The 5 Reports Your Accountant Wishes You'd Send Them
This recording is locked
Fill out the short form below to unlock and watch instantly.
Unlock this recording

Enter your details to watch

By submitting, you agree to receive occasional emails from Webgility. Unsubscribe anytime.

John May
About the author

John May

Ecommerce Expert

Ecom Clinic Recording

The 5 Reports Your Accountant Wishes You'd Send Them

About this session

Closing ecommerce books shouldn't require detective work. This webinar walks through the five essential financial reports that help accountants reconcile settlements, analyze profitability, classify fees, track returns, and complete month-end close with confidence.

Key learnings
  • Why ecommerce accounting breaks down during month-end.
  • The five essential reports every accountant should receive.
  • How channel-level P&L improves profitability decisions.
  • Simplifying Amazon settlement reconciliation.
  • Why fee classification matters more than total fees.
  • Measuring the true cost of returns.
  • Creating a month-end close checklist.
  • How automation reduces reconciliation time.
Full article

The 5 Ecommerce Financial Reports Every Accountant Should Receive

For many ecommerce businesses, month-end closing becomes a frustrating exercise in piecing together fragmented data. Revenue lives in Shopify, settlements come from Amazon, advertising costs are elsewhere, and bank deposits rarely match individual orders. Instead of providing strategic advice, accountants often spend hours reconstructing transactions just to produce accurate books.

This webinar explains that the problem isn't the accountant. It's the quality of information they're receiving.

The solution is surprisingly simple: provide five standardized ecommerce financial reports every month.

The first report is a Channel-Level Profit and Loss Statement. Rather than viewing the business as one combined operation, this report separates Amazon, Shopify, wholesale, and other sales channels. It includes revenue, cost of goods sold, channel fees, shipping, advertising, returns, and margin percentages, making it easy to identify which channels actually generate profit. Often, the highest-revenue channel isn't the most profitable.

The second report is Settlement Reconciliation. Marketplace payouts arrive as one bank deposit, but they're made up of sales, referral fees, fulfillment charges, storage fees, advertising costs, and refunds. Breaking each settlement into these components allows accountants to reconcile deposits in minutes instead of hours while quickly spotting any discrepancies.

Third is a Fee Classification Report. Amazon alone can generate dozens of different fee types, including referral fees, FBA fulfillment, storage, aged inventory, removal fees, and advertising. Grouping everything into one expense category hides opportunities to reduce costs. Classifying fees individually helps businesses understand exactly where margin is disappearing.

The fourth report is a Returns and Refunds Ledger. Most sellers monitor return rates, but few calculate the full financial impact of returns. A complete report includes refund amounts, return shipping, restocking, unsellable inventory, processing fees, total return cost, and cost per return. These insights reveal opportunities to improve product quality, packaging, and fulfillment.

Finally, every business should maintain a Month-End Close Checklist. This checklist confirms settlements are reconciled, bank deposits match payouts, reports are attached, variances are documented, and outstanding inventory or purchase orders are identified before closing the books. It creates a consistent handoff between ecommerce teams and accountants while reducing delays during month-end.

Together, these reports transform accounting from reactive cleanup into proactive financial management. Instead of spending weeks reconciling transactions, accountants can focus on identifying profitable channels, reducing unnecessary costs, and helping ecommerce businesses make smarter decisions.

Frequently asked questions
What are ecommerce financial reports?

Ecommerce financial reports provide detailed visibility into sales, profitability, settlements, fees, returns, and financial performance across every sales channel.

Why do accountants need channel-level P&L reports?

Channel-level profit and loss statements show which marketplaces or stores generate the highest profit after accounting for fees, shipping, advertising, and returns.

What is settlement reconciliation?

Settlement reconciliation matches marketplace payouts with orders, fees, refunds, and deposits to ensure accounting records accurately reflect cash received.

Why should Amazon fees be categorized separately?

Different fee categories highlight opportunities to reduce storage costs, fulfillment expenses, advertising waste, and other operational costs that affect profitability.

How does Webgility help automate ecommerce reporting?

Webgility automates order posting, settlement reconciliation, fee classification, and QuickBooks synchronization, giving accountants accurate financial reports without manual spreadsheets.

50+
Channels connected to QuickBooks
One close
Covers every channel, same books
30 min/week
Down from 8 hours, same volume
Same rules
New channels apply existing configuration
The Demo

Find out what your operational gaps are actually costing you.

Our team of experts will help surface your operations and finance concerns. In 30 minutes, we will discuss your channels, accounting setup, leakages, inventory inconsistencies, and close process.

Operational Snapshot ● Live
Orders reconciled today 1,247 ✓
Amazon payout tied out $47,241 ✓
Exceptions resolved 3 cleared
Inventory synced All channels ✓
Books status Certified ✓