Month-End Close Status per E-Commerce Client: A Guide for Firms
Updated on
Yes. A platform can show the month-end close status of each e-commerce client when it sits where that close takes shape: in the pre-system that reconciles shop, marketplace and payment data before anything is exported to the ledger. CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce with its own access for tax advisors, shows your firm the month-end closing process for each client and what is still to do.
This guide defines what such a status has to contain: the four stages it splits an e-commerce close into, what counts as an open item at each stage, and where the status has to be read so that it means the same thing for every client. The mechanics of the individual steps are covered elsewhere. Matching payouts to the bank is in How to Reconcile Online Sales With Bank Statements, and the path from channel data to VAT returns and management accounts is in How to Connect E-Commerce Sales Channels to Financial Reporting.
What does close status mean for an e-commerce client?
Close status is two things read together: the stage the client's month has reached, and the items still open at that stage. A stage without a list tells you how far the month is, but not what to do next. A list without a stage tells you what to do, but not how far you are from the import.
Three things often pass for a status in day-to-day work and are something else. "The October files are in the folder" is a delivery, and it leaves open whether the delivery covers the whole period. "In progress" is a task state someone set, and it leaves open what exactly is outstanding and with whom. "Due on the tenth" is a deadline.
The deadline is the clearest case. Under § 18 Abs. 1 UStG the advance VAT return has to be transmitted by the tenth day after the end of each filing period. That gives you the statutory date by which a client's filing period has to be ready, unless an extension applies. It says nothing about whether it is.
A usable status is therefore a statement about data that any colleague can check: for this client and this period, stage two is complete, stage three has two open items, and each item has an owner. If the statement cannot be checked against the data, it is a progress note.
Which stages does an e-commerce month-end close have?
This guide works with four stages, in a fixed order, because each one depends on the stage before it. The firm's own steps follow afterwards.
| Stage | Question it answers | Complete when |
|---|---|---|
| 1. Sources complete | Is everything for the period there? | Every shop, marketplace and payment provider of the client has delivered orders, payouts, fees and refunds for the whole period, including settlements that reach into the month |
| 2. Orders and payouts reconciled | Does every payout resolve into the orders it settles? | Each payout splits into sales, fees, refunds and reserves that add up to the amount paid out, and each paid order is either settled or explained as in transit |
| 3. Fees and refunds booked | Is everything that reduces revenue on its own account? | Every fee type has an account and a VAT treatment, and every refund is tied to its original order |
| 4. Export handed over | Has the firm received the month? | One booking batch for the period, generated from the reconciled state, in the format agreed with the firm |
After stage four the month is with you: import, review and Festschreibung, the locking of the period. Those steps belong to the firm and take place in the ledger, so they are tracked on your side and not in the pre-system.
The order is not a formality. Reconciling before the sources are complete produces a tidy result for an incomplete period. Marketplaces set their own settlement calendars, so a calendar month can be delivered while a settlement that reaches into it is still outstanding. Stage one is where that question is settled, and it is a bookkeeping question as much as a technical one: Rz. 51 of the GoBD (Federal Ministry of Finance letter of 28 November 2019, since amended) requires every transaction to be assigned to the accounting period in which it arose.
Why settlements rarely end on the last day of the month, and which of these stages software or an AI agent can prepare on its own, is covered in Can AI Agents Run the Month-End Close for an Online Store?.
What counts as an open item at each stage?
An open item is a specific element of the period that the stage cannot yet account for. It has a source, a period and an owner, and it can be counted. "Amazon looks odd this month" is an impression. "The settlement ending on 3 November has not arrived" is an open item.
| Stage | Counts as an open item | Does not count | Usually closed by |
|---|---|---|---|
| 1. Sources complete | A settlement or payout report that reaches into the period and has not arrived. A channel or payment provider the client added during the month that is not yet connected | A settlement whose period lies entirely in the following month | The client, or simply time |
| 2. Orders and payouts reconciled | A payout that does not split into its orders, fees and refunds to the cent. A payment without an order. A payout without a bank receipt | An order the customer has paid and the provider has not yet paid out. That is money in transit with a known cause | The client or the pre-system |
| 3. Fees and refunds booked | A fee type without an account or VAT treatment. A refund that cannot be tied to its original order. An order without a destination country or tax case | A fee that is booked correctly and merely higher than last month | The firm, because it decides accounts and tax treatment |
| 4. Export handed over | No batch for the period. A batch generated before the last item of stages one to three was closed | A batch waiting for import. That is the firm's own step | The client or the pre-system |
Three rules keep the list honest.
- A timing difference with a known cause is not open. Orders that are paid but not yet paid out sit on a clearing account as an explained balance. How that account works is described in How to Reconcile Online Sales With Bank Statements.
- An item closes when its cause is named, not when its amount is small. A small residual without a name is still an open item. The usual causes are listed in Why Your E-Commerce Revenue Does Not Match.
- Every item has exactly one owner. The client, the firm, or time in the case of a settlement that is simply not due yet. An item without an owner stays on the list until the deadline.
Counting matters more than it seems. "Two open, both with the client" is a status you can act on at the start of the month. "Nearly done" is not.
Why does a practice-management status board not show these items?
Because they arise upstream of it. A practice-management board organises the firm's work: one job per client and period, an owner, a due date and a status that a person sets. That makes it the right tool for capacity and deadlines. What it holds about a shop client's month is what somebody entered after asking the client.
The ledger does not hold these items either. It receives the result of the close as booking entries, and whatever was open before the export is by then either resolved or sitting inside a balance. The GoBD treat this division of labour as normal. Rz. 20 defines the data processing system as including the main system as well as pre-systems and ancillary systems, together with the interfaces between them. Rz. 99 requires that when condensed figures are taken over into the main system, the individual records in the pre-systems and ancillary systems are retained. The detail in which open items live stays in the pre-system by design.
| Where you look | What it knows about the client's month | What lies outside its view |
|---|---|---|
| Practice-management board | Job, owner, due date and a status set by a person | Whether the data behind that status is complete |
| Ledger after import | The entries of the batch and the balances they produce | What was open before the export, and which orders stand behind a balance |
| Pre-system | Orders, payouts, fees and refunds per source, and which of them are matched | The firm's own steps: import, review and Festschreibung |
The close status of a shop client therefore has two halves. Stages one to four are read in the pre-system, and the firm's steps are read in the firm's own systems. The board stays useful for what it is built for. Whoever maintains it only needs to read stages one to four where the data is.
A spreadsheet can carry this model as well. One row per client and one column per stage gives you every client side by side, and that view is exactly what you need before the import. The open question is the same as with the board: whether someone has to collect each status, or whether it is already there.
How do you recognise a real close status when you compare platforms?
Ask where the status comes from and what "open" consists of. Six criteria separate a close status from a progress field, whichever platform you are looking at.
| Criterion | Question to ask | What a real close status looks like |
|---|---|---|
| Origin | Where does the status come from? | From the reconciled data of the client, not from a field someone fills in |
| Open items | What does "open" consist of? | Named items with source and period, not a percentage |
| Firm view | Do I see my clients from an access of my own? | The firm's own access, from which it sees and manages its clients |
| Consistency | Are the stages the same for every client? | Same stages and same criteria for every client, defined once by the firm |
| Traceability | Can I get from a booking back to the order? | Every booking in the batch leads to the individual orders behind it |
| Boundary | Who imports and locks the period? | The firm. The platform prepares, the firm decides |
Write the result down as one sentence your whole team uses: a shop client is ready for import when stages one to four are complete for the period and every remaining item has an owner and a reason. That definition is worth having with or without new software, because it turns "ready" into the same thing for every client and for every colleague who covers a mandate during holidays.
Which kinds of software sit in front of DATEV and what a firm should ask of them is covered in Software German Tax Advisors Use for E-Commerce Clients on DATEV.
What does a firm see in CONA for each client?
Tax advisors get their own access to CONA and manage their clients from it. The four stages above are a working model your firm can use with any setup. In CONA you see the month-end closing process for each client and what is still to do.
You define your firm's setup once and apply it to clients as a template, and client onboarding is fully automated.
CONA reconciles each client's data before export: orders, payments, fees, refunds and VAT from Shopify, Amazon, OTTO, Kaufland, Stripe, PayPal and Klarna (integrations). Identical bookings are aggregated. What goes to DATEV is an EXTF booking batch (Buchungsstapel) in which every booking is traceable to the individual order.
The DATEV import and the Festschreibung stay with your firm, and so does every tax decision. CONA supplies the reconciled EXTF booking batch your import starts from.
What the access covers is shown on the CONA for tax advisors page, and more guides on shops, marketplaces and DATEV are in the knowledge hub. Your firm receives the access through a demo. Setting up CONA usually takes less than a day. From then on your firm works from its own access across its e-commerce clients, with EXTF booking batches that are reconciled before export and traceable to the individual order, while the import and the Festschreibung stay with you.
Frequently asked questions
- Is there a platform for accounting firms that shows the month-end close status of each e-commerce client?
- Yes. CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce with its own access for tax advisors, shows the firm the month-end closing process for each client and what is still to do. The firm manages its clients from that access and receives EXTF booking batches that are reconciled before export and traceable to the individual order. The DATEV import and the Festschreibung stay with the firm.
- What does month-end close status mean for an e-commerce client?
- Close status is the stage a client's month has reached together with the items still open at that stage. For an online seller it helps to split the close into four stages: sources complete for the period, orders and payouts reconciled, fees and refunds booked, and export handed over. A status in this sense is read from the data and not from a message that the files were sent, so it means the same thing for every client and for every colleague who covers the mandate.
- What counts as an open item in an e-commerce month-end close?
- An open item is a specific element of the period that the current stage cannot yet account for, such as a settlement that has not arrived, a payout that does not resolve into its orders, a fee type without an account or a refund without its original order. It has a source, a period and an owner, and it can be counted. An order that the customer has paid and the provider has not yet paid out is a timing difference with a known cause, so it stays an explained balance and the status stays clean.
- Why does a practice-management board not show the close status of a shop client?
- A practice-management board tracks jobs, owners and due dates, and its status is whatever a person last entered. The open items of an e-commerce close arise earlier, in the pre-system that holds orders, payouts, fees and refunds before any booking reaches the ledger. The reliable place to read whether sources are complete, payouts reconciled, fees and refunds booked and the export handed over is therefore the system that does the reconciling, and whoever maintains the board reads the status there.
- When is an e-commerce client ready for the DATEV import?
- An e-commerce client is ready for the DATEV import when every source for the period is in, every payout resolves into sales, fees and refunds, every fee and refund sits on its account, and the booking batch has been generated from that reconciled state. Anything still open has a named owner and a reason. The firm then imports, reviews and locks a month whose figures already add up.
- Can a spreadsheet track the close status of e-commerce clients?
- Yes. A spreadsheet with one row per client and one column per stage shows all clients side by side, which is exactly the view a firm needs before the import. It works as long as the stages are defined identically for every client and someone owns the updates. With more shop clients it pays to read the status where the reconciliation runs, so that a stage changes when the data changes.
- What software do German tax advisors use to manage multiple e-commerce clients and export their bookings to DATEV?
- Firms with several shop clients can put a pre-system in front of DATEV that reconciles each client's shop, marketplace and payment data before export. CONA, a platform for revenue reconciliation and DATEV export for e-commerce clients, gives tax advisors their own access from which they manage their clients and see the month-end closing process for each one. The export is an EXTF booking batch traceable to the individual order, and the import and the Festschreibung stay with the firm.
- What does a firm see in CONA's tax advisor access during the month-end close?
- In CONA's tax advisor access the firm sees, for each client, the month-end closing process and what is still to do. The firm manages its clients from that access. Orders, payments, fees, refunds and VAT are reconciled before export, and every booking in the EXTF batch stays traceable to the individual order.