Monthly filing with sales across several channels: pulling the information together

Selling on one channel makes the monthly filing almost mechanical: one report, one withholding, one deposit. Selling on three turns it into a puzzle where no piece fits the one beside it. Amazon closes settlements every couple of weeks and by posting date; MercadoLibre shows the charges tied to each sale and releases funds on its own rhythm; your own store collects through a payment gateway and deposits whenever the processor decides.

The outcome is predictable. Filing day arrives and your accountant asks how much you sold last month. You open three dashboards and pull three different numbers, none of which is the one that gets declared. Amazon’s is in settlement dates, Meli’s includes charges that are not sales, the store’s arrives without VAT separated. And the most important part is still missing: how much was withheld per channel and how much creditable VAT you accumulated.

The underlying problem is not that the information does not exist. It exists, and it is more complete than it looks. The problem is that each channel slices it differently, names it differently, and delivers it on a period that is not the calendar month. Consolidating without a method guarantees either double counting or gaps.

This article lays out what you need from each channel, how to consolidate without duplicating, and why the timing gaps are structural rather than your mistake. It is educational material, not tax advice: what you declare, under which regime and on which line is your accountant’s call.

the tax month is not the bank’s month

This is the distinction to make before opening a single report. The period you declare is a calendar month, from the first to the last day. Channels, however, do not run on calendar months: they run on settlement cycles.

Amazon generates settlement reports by settlement period, not by month, and the dates in that file correspond to the moment an amount was credited or debited to your account, not to the moment the buyer placed the order. That nuance is enormous: a sale on the 28th can land in the report paid out in the first half of the following month, and a November refund can be netted inside a December period.

MercadoLibre shows the same phenomenon in a different shape. Its reconciliation reports distinguish between the sale detail and the money movement in the account, and fund release follows its own rules, which do not match the order date. Your own store adds a third logic: the payment processor’s, with its own cut-offs and its own commissions netted before the deposit.

So the first practical rule is to pick one criterion and hold it. Which one — sale date or settlement date — is a decision for your accountant, based on your regime and how you recognize income. What never works is mixing: taking Amazon by deposit date and Meli by order date guarantees the numbers will never close.

what you need from amazon

Amazon gives you three different things, and all three are worth downloading, not just one.

The first is the settlement report, which lives in the payments area of Seller Central and downloads as a flat file per period. That is the transactional detail: sales, referral fees, fulfillment fees, refunds, adjustments and advertising. It is the document that explains why the deposit was the size it was.

The second is the set of tax documents Amazon issues to your RFC for its own charges, found in the reports area inside the Mexican fiscal document library. Those back the commission expense and its creditable VAT.

The third is the withholding certificate, the one that proves what the platform withheld and remitted on your behalf. That piece can also be checked in the SAT portal, in the section for received withholding CFDIs, which works as a cross-check on what actually got recorded under your name.

The dashboard’s sales reports are useful for operating and spotting trends, but they do not replace the settlement report when you are tying out money; we cover that in what sales reports Amazon Seller Central offers. And since Seller Central reorganizes its navigation regularly, confirm the current paths in the platform’s help center before assuming something disappeared.

what you need from mercadolibre

On MercadoLibre the information is split between the seller panel and Mercado Pago, which throws off anyone arriving expecting a single file.

On the seller side sits the period detail: the report that breaks down the charges tied to each sale, with the listing, the shipment and the buyer. That is the source for understanding what the platform kept, by concept and by order.

On the money side sit the accounting reconciliation reports: the settlements report and the account statements, which show the actual balance movement. Meli’s official help describes how to generate them and how they relate to one another, and the classic reconciliation is precisely the cross-check between the sales report, the account statement and the commission detail.

And, as with Amazon, there are the tax documents: the ones Meli issues for its commissions and charges, downloadable by period from the billing section of your account. The same warning applies here: the interface changes, menus move, and the current path is worth confirming in MercadoLibre’s help center.

One detail that saves pain: always download the full period rather than eyeballing a date range. Adjustments and late refunds show up outside the block where you expect them, and a badly placed filter leaves them out of the consolidation.

what you need from your own store

Your own store looks like the easy part and is usually the most neglected. There you are directly responsible for issuing documents for your sales, with no platform withholding or invoicing on your behalf, and that changes the treatment of the income completely.

You need three pieces. The period’s order report, broken out into product, shipping charged to the customer, and discounts applied. The payment processor’s report, showing the commission it netted before depositing — for which you should also hold a document. And the record of the documents you issued, which is what actually backs the income.

There is a very common carry-over mistake here: counting the gateway’s deposit as if it were the income. It is not. The income is the gross sale; the processor’s commission is a separate expense with its own VAT. If you record only the net deposit, you are under-reporting income and losing a deductible expense at the same time.

Your own store changes the economics of the channel in other dimensions too, not just the tax one; we get into that in from marketplace to D2C: why your own store matters.

how to consolidate without double counting

With the pieces on the table, consolidation becomes an exercise in structure. What works is building a single monthly table where every channel contributes the same columns, even when the original report calls them something else:

• Channel gross revenue, split into base and VAT collected.
• Platform charges, also split into base and creditable VAT: commission, logistics, advertising, subscription.
• Withholdings applied, income tax and VAT, per channel.
• Refunds and adjustments for the period, with the right sign.
• Net deposit received, which is your control number against the bank.

When those five columns tie out per channel and the sum of deposits matches what hit the bank, the consolidation is sound. When it does not, the break is almost always an adjustment, a refund or a charge that landed in another period.

Glossary: unified catalog, one real product across many listings →

The other thing to watch is double counting. If you sell the same product on three channels and consolidate by SKU without distinguishing the channel, you will add units correctly but lose the traceability of the withholding, which is per channel. Tax consolidation needs both dimensions at once: what sold and where.

the timing gaps that always show up

Four of them repeat, and it is better to expect them than to discover them late.

The cut-off gap: sales in the last days of the month that settle in the following period. It is not an error, it is how the settlement cycle is designed. You handle it with a fixed criterion and a clearly stated reconciling item.

The refund gap: an October refund that appears as a negative charge in November. Ignore it and you over-report one month’s income and under-report the next.

The advertising gap: campaign spend usually bills on its own cycle, separate from commissions, with its own document. It is the concept most often left out of consolidation.

And the processor gap in your own store, where the sale happens one day and the deposit arrives days later, already netted. That hole confuses most people reconciling against a bank statement.

None of the four is fixed with more hours in a spreadsheet. They are fixed by documenting the criterion, keeping the reconciling item visible, and repeating the same procedure every month. That discipline is what turns a three-day scramble into a two-hour task. And keep in mind that the SAT calendar puts the regime’s monthly filing in the middle of the following month — the seventeenth is the usual reference — so the consolidation has to be ready before that, not on the day itself. Confirm the exact date that applies to you with your accountant.

how this reads in iqseller

Worth saying plainly: iqseller does not file returns, does not issue tax documents and does not replace your accountant. What it does is keep the operational half of that puzzle ready at all times.

The Profitability module consolidates the channels into a single view and separates exactly the columns a filing needs: the VAT base on one side, the real commissions taken from Amazon’s settlement and MercadoLibre orders on the other, the FBA and Full fees, shipping, advertising and the withholdings per channel. The COGS you load enters the same breakdown, so net margin per SKU and the month’s tax information come from one source instead of two competing spreadsheets.

The Parent → Model → SKU tree also lets you look at the same product above the channels without losing sight of where each unit sold, which is precisely the double dimension tax consolidation requires. And the Alerts module flags when a charge concept breaks its usual pattern, which is normally the early signal of an adjustment about to throw off the month’s reconciliation.

What comes out of that is not a tax return: it is the tidy package you hand to the person who actually files it.

Glossary: real net margin, with everything deducted →

what to take away

A multichannel monthly filing is not harder than a single-channel one, it just has more pieces. From Amazon you need the settlement report, the documents for its charges and the withholding certificate. From MercadoLibre, the period detail, the reconciliation reports and its tax documents. From your own store, the orders, the processor report and the documents you issued yourself.

The periods will never line up, because each channel settles on its own cycle and by posting date, not by order date. The fix is not forcing them to match but fixing a criterion, documenting the reconciling items, and repeating the same method every month.

And the standing reminder: this describes how to gather the information, not how to declare it. Which regime applies to you, how income is recognized and how each withholding is treated are your accountant’s decisions. Your job is to arrive with everything, complete and on time.