The “Accountant data” window collects your documents and payments for a period: it prepares a file for your accountant and shows what the store earned by product and channel. Elbuz does not keep the books or file tax returns: your accountant does official reporting in their software.
When you need this:
- Your accountant asks for quarterly data — one Excel or DATEV file instead of picking documents by hand.
- Turnover grows, but cash does not — profit by product and channel shows what is losing money.
- A bank statement sits unreconciled — Elbuz matches documents by number and amount; you review the rest.
Where to start: send a quarterly file.
What the window does
- Sends your accountant the sales and purchase ledgers, VAT summary and debts in Excel or CSV, and entries for documents and vouchers in DATEV or FEC.
- Calculates revenue, cost, expenses and result by month, by product and by sales channel.
- Shows lines that are missing data and takes you to where you can fix them.
- Imports CAMT.053, MT940 or CSV statements and allocates payments to documents.
- Summarizes expenses by category and cash movement by vouchers.
Also in this folder: revenue, profit and margin for a period, customer debt, payment links for an invoice and VAT rates.
How to send your accountant a quarterly file
- In the top bar, select the company and click “Last quarter”.
- Open “Overview” and check the “Needs attention” block: lines without a VAT rate and orders left out of the ledger will change the figures in the file.
- Click “Send to accountant”. The period and company are already filled in.
- Choose the report and format, then click “Download file”.
1
Period and company2
Selected report3
File format4
Download file- Period and company — taken from the top bar of the window.
- Selected report — Universal Excel puts the ledgers, VAT summary and debts on separate sheets.
- File format — chip for the output format of the selected report.
- Download file — builds and downloads the file (not pressed in this shot).
Which file to choose depends on your accountant's software:
| Your accountant works | Report and format | What's inside |
|---|---|---|
| Anywhere, prefers a spreadsheet | “Universal Excel” | sales and purchase ledgers, VAT summary, debts at the end of the period on separate sheets |
| In DATEV (Germany) | “DATEV EXTF” | Buchungsstapel for import: one year, configured accounts |
| In French accounting software | “FEC” | draft entries from Elbuz, see limits |
| Asks for a single report | “Sales ledger”, “VAT” and others | Excel or CSV of one report |
The “Export” button inside a report opens the same dialog with that report already selected. If the file is missing something, such as the Beraternummer, a message appears in the dialog and your choices are kept.
How to read the overview
The overview answers three questions: how much you earned, what makes the figures unreliable and where the money is. Tiles open the matching report. The arrow under revenue, profit, expenses and result shows the change from the previous period of equal length; for expenses, growth is marked as bad. No data in the previous period means no arrow.
| Figure | What it is |
|---|---|
| Revenue excl. VAT | sales ledger total for the period |
| Gross profit | revenue minus cost; lines without a cost are not included |
| Expenses | expenses with a category recorded in Elbuz |
| Result | gross profit minus expenses |
| VAT for the period | output minus input VAT, from documents; this is not a VAT return |
| Owed to us, We owe | debts on the last day of the period |
| Net cash by vouchers | cash-in minus cash-out vouchers |
The “Needs attention” block gives the number of problem lines and takes you to where you can fix them. If there are no problems, it says: “All good: there is enough data for this period's reports.”
Which documents go into the sales ledger
Revenue in the overview, profit and channels always equals the sales ledger total excl. VAT. By default, the ledger includes sales invoices, sales receipts, service acceptance certificates, customer returns with a minus sign and invoices without a sales invoice. An invoice closed by a sales invoice or receipt is not counted, because it is the same sale.
Canceled, rejected, voided and failed documents and drafts are not included. Only a live document closes a sale: if the sales invoice is canceled, the sale is counted from the order again.
Posted documents only. By default, the ledgers count posted documents only, and so do VAT, profit, channels and the DATEV and FEC files, because they read the ledger.
The overview shows how many unposted documents were left out and for what amount. If you do not post documents, turn off “Posted documents only” in the settings, otherwise the ledgers will be empty.
Expenses, debts and cash flow do not depend on this switch: vouchers created from a statement are unposted.
Customer orders are not included until you turn on “Customer orders without a sales note” in the settings. If the store does not issue sales invoices, the ledger is almost empty without this switch, and revenue is understated.
The overview warns you about this: “Orders without a delivery note left out of the book: N for …”. Ask your accountant before changing it, because the switch also affects their file. Debts do not depend on it: they always count orders.
The amount excl. VAT comes from the line rate: the code in the line, the difference between the saved price with and without tax, the product rate, the product tax class, the document class. A line without a rate counts as 0% with a warning.
A class with a zero rate and a number in its name, like the typical “VAT 23%” with a rate of 0.00, is treated as not filled in. The overview shows its name and a “Tax classes” button: set the rate there, and the warning goes away.
If your rate really is 0%, name the class without digits, for example “No VAT”: then it is a normal 0% rate with no warning. Elbuz does not change the document total: it assigns any difference from the line sum to the main rate and shows how many such documents there are.
How to read profit
Where cost comes from and why profit can be incomplete
For each sold line, Elbuz looks for the cost in this order:
- Purchase. The latest goods receipt for this product no later than the sale date. A stock surplus act does not count: it holds a valuation of the surplus, not a purchase. The price is taken excl. VAT, in the base currency. This is the most accurate source.
- Card price. If there is no purchase before the sale date, the current purchase price from the product card is used. The figure is approximate, because the price may have changed after the sale, and VAT in it is not recalculated. Such lines are marked separately.
- No data. Revenue from such a line does not go into profit, otherwise the whole line would look like pure earnings. It is shown as a separate “Revenue of lines without cost” row.
So margin is calculated only on revenue with a known cost, and incomplete profit is always flagged. To clear the flag, fill in the purchase price on the product cards from the “No cost” list or post goods receipts.
A document with no lines counts the same as a line without a cost. Shipping and a discount on the whole document go into profit without a cost.
Batches are not used for this calculation: once a product is sold, the batch is written off, and the sales line has no link to the batch. So this is not a FIFO calculation.
Profit and loss
Read the report from top to bottom: revenue, minus revenue of lines without cost, minus cost of goods sold — that is gross profit. Then expenses by category, and the result at the end. The total sits right after the row name, with months to the right; a period longer than 18 months is shown by year.
1
Total column2
Revenue of lines without cost3
Gross profit4
Compare with previous period- The Total column sums the whole selected period.
- Revenue of lines without a purchase price is subtracted so it does not look like pure profit.
- Gross profit is revenue minus cost of goods sold.
- This switch adds the previous period and change columns.
“Compare with previous period” adds the previous period of equal length and the change in percent. Purchases enter as cost of goods already sold. Payroll, rent and advertising count only when recorded as expenses with a category. Expenses without a category get a separate row outside the result. This is a management report, not official reporting.
Profit by product and channel
“Profit by product” shows quantity, revenue, cost, profit and margin per product. Sort by a column header, search by name or SKU: both cover all products in the period. Buttons above the table leave only products without a cost, costed by card price, or loss-making. Below the total are shipping with document discounts and documents without lines: with products, they make up ledger revenue.
1
Search2
Cost filters3
Profit4
Cost source- Search — find a product by name or SKU.
- Cost filters — show all lines, those without cost, costed at the card price, or loss-making.
- Profit — revenue minus cost for each product.
- Cost source — where the cost came from: a purchase, the card price or nothing.
“Profit by channel” groups the same figures by document source: site, marketplace, API. A document created by hand counts as “Channel not set”. The channels add up to revenue. Marketplace fees are not part of channel profit: record them as a separate expense category.
Expenses, cash and bank statements
How to record expenses
An expense in Elbuz is a cash-out voucher not linked to a document. You can record one in two ways:
- in “Expenses” with the “Add expense” button: date, amount in the base currency, category, payment method;
- in the bank statement: for a debit without a document, choose a category and click “Order without document”.
1
Add expense2
Expenses by category chart3
No category filter- Add expense records a cash-out voucher that is not linked to a document.
- The chart and table break expenses down by category, with amount and share.
- The No category button shows expenses that still have no category.
You can change any expense's category right in the table; the “No category” list shows what is not yet assigned. The category list is edited in the settings, separately for each company. A voucher linked to a supplier's goods receipt is not in this list: the purchase is already counted in cost when the product is sold.
If you paid a supplier with a voucher not linked to a goods receipt, choose the “Not an expense: supplier payment, transfer” category in the table. Elbuz cannot tell this on its own, so a voucher without a category is not in the result: otherwise the purchase would be counted twice.
Why the debt differs from the contact card
In “Debts”, the amount is as of the selected date, includes linked vouchers and excludes drafts, voided and failed documents as well as canceled ones. The contact card shows the debt as of now and excludes only canceled and rejected documents. So the amounts can differ.
What cash flow shows
The report counts money only by cash-in and cash-out vouchers: receipts, payments, net flow and a running total from the start of the period. There is no account balance here, because Elbuz does not know opening balances.
Next to it are two columns of payment by status: documents with the “paid” status or a payment amount, except orders closed by a sales invoice. They are not added to the vouchers, because vouchers are rarely linked to documents, and one payment would be counted twice.
If there are no vouchers for the period, the chart shows payment by status and says so plainly: this is a “paid” mark, not money movement. Unreviewed statement lines are listed separately and enter the flow once reviewed.
How to reconcile a bank statement
Download the statement from your online banking in CAMT.053, MT940 or CSV format and drag the file into “Bank statement”. For a CSV, Elbuz shows a preview: map the columns once, and the setting is remembered for this company. Uploading the same file again does not duplicate lines.
1
Statement drop zone2
Status filters3
Review button- Drop a CAMT.053, MT940 or CSV bank statement here, or choose a file.
- Filters switch between rows to review, allocated rows and skipped rows.
- The Review button opens a statement row so you can allocate it to a document.
A payment is allocated to an unpaid document of its own company and direction, so a receipt will not close a purchase. It is allocated automatically only when the currency and the amount due match and one condition is met:
- the payment reference contains the document number (a numeric one must have at least 4 digits); several numbers also work if the amount matches the total due on them;
- or the contact with this IBAN has exactly one unpaid document with that amount due.
The rest stays in “To review”. Click “Review”, tick the documents or create an order without a document for an advance or bank fee. Undoing an allocation restores the document's paid amount and payment status and moves the created voucher to the Trash. If the voucher is posted, undo refuses with its number and changes nothing: unpost it first.
What to set up before the first file
Excel needs no setup; you only decide what goes into the sales ledger. DATEV and FEC need accounts, and your accountant should check them: the default SKR03, SKR04 and PCG values are designed for a typical store.
1
Sales ledger contents2
Expense categories3
Save button- This block decides which documents count in the sales ledger, VAT and profit reports.
- Expense categories appear in Expenses and in the profit and loss report.
- Save stores the settings; it was not pressed.
- What goes into the sales ledger — posted documents only, invoices and orders without a sales invoice.
- Expense categories — your own list; after you delete a category, its expenses become “No category”.
- Accounts — chart of accounts, customers, suppliers, bank, cash.
- Accounts by VAT rate — one row for each rate in your documents. Without a row, documents at that rate stay out of the file, and the window lists such rates.
- DATEV — Beraternummer (1001 or higher), Mandantennummer, financial year start, Sachkontenlänge. FEC — SIREN, 9 digits.
What counts as verified in DATEV and FEC files
DATEV. The file format was checked on samples with an independent EXTF format validator. The file has not been imported into DATEV itself, so your accountant checks the first file on their side. One file covers a period within one calendar and financial year, up to 99,999 entries.
FEC. This is a draft under art. A47 A-1 LPF: only Elbuz transactions, without opening balances, payroll and closing entries. The file has not been checked with the official Test Compta Demat tool. Your accountant completes it in their accounting software for the tax authority.
VAT. The summary counts only Elbuz documents, without expenses and adjustments made outside the system. It is not a VAT return.
Scenarios
An accountant in Germany asks for Q3 data
What to do. In the settings, enter the Beraternummer and Mandantennummer and check the accounts with your accountant. Click “Save”, set the period to July 1 – September 30, click “Send to accountant”, choose “DATEV EXTF” and click “Download file”.
What you get. An EXTF_Buchungsstapel_… file for import into DATEV and, if any rate is missing from the settings, a warning listing those rates.
Revenue grows, but profit does not
What to do. Open “Profit by channel” and compare margins, then in “Profit by product” click the “Loss-making” button.
What you get. You see the channel with the lowest margin and the products sold below their purchase price. Before drawing conclusions, check the flag for lines without a cost.
The store works only with orders, and the ledger is empty
What to do. Open “Settings” (in the overview, the “Set up the book” button sits next to the orders warning), turn on “Customer orders without a sales note” and click “Save”.
What you get. Orders without a sales invoice or invoice go into the ledger, except canceled, rejected and draft ones, and the reports show revenue from them.
What to do when
DATEV: “For DATEV, choose a period within one calendar year and one financial year”
The period crosses the boundary of a calendar or financial year. Split it into two files. The financial year start is set in the settings.
The “No accounts for rates” warning
Your documents have a rate that is missing from the “Accounts by VAT rate” table. Those lines did not go into the file. Add a row, save the settings and download the file again.
Statement: “This is not a CAMT.053 statement”
The bank gave you a different XML type, such as CAMT.052 or a payment order. In your online banking, choose a CAMT.053 statement specifically, or download MT940 or CSV.
Margin looks too high
Most often, an old card price got into the cost. Click “By card price” in “Profit by product”: it shows how many lines were calculated approximately.
FAQ
Can I file a tax return from this window?
No. Elbuz does not keep journal entries, a company chart of accounts, payroll or tax returns. The window prepares the data; your accountant prepares the reports.
What currency are the amounts in?
Totals and management reports are in the base currency at the document's exchange rate. Ledger lines are shown in the document currency, with its code and rate next to it; the Excel file has the base currency amount for each line.
Why does the total disappear when I search for a document?
The bottom total row covers the whole period, not the lines found, so it is hidden during a search. The bar above the table shows the whole period.
Does profit include marketplace fees?
No, the fee is not filled in on documents. Record it as an expense in the “Bank and marketplace fees” category: it reduces the result, but not channel profit.
Does the window change documents?
Yes, in three cases: allocating a statement (document payment, new voucher), “Add expense” (new voucher) and choosing a category (saved in the voucher). Reports only read documents.
How do I handle several companies?
Each company is calculated separately, with its own accounts and categories. A document without a company belongs to the default company.
Where it is and who has access
- Menu
- Directories → Documents → Accountant data
- Access right
- Group permissions: “Accountant data” — view reports and export; “Accountant data: edit” — bank statement and expenses; “Accountant data: settings” — settings. By default, all of these belong to the Management department
- Prepare
- the period your accountant asks for; for a DATEV file — Beraternummer and Mandantennummer, for FEC — SIREN
Export is part of viewing: the file holds the same figures as the reports and changes nothing. So view access is enough for your accountant.
Select the company and period in the top bar; they apply to all reports. The debt date follows the end of the period, but you can change it in “Debts”. Quick buttons set this or last month, quarter or year; the arrows shift the period by its length. Reports recalculate at once, there is no separate “Show” button.
1
Company2
Period buttons3
Send to accountant4
Needs attention5
Gross profit tile- Company — the report is built for the selected company.
- Period buttons — quick choice of this or last month, quarter or year; exact dates are in the fields below.
- Send to accountant — opens the choice of what to export.
- Needs attention — issues that make the figures incomplete, each with a button to fix them.
- Gross profit tile — profit for the period with margin and the change against the previous period.
Related topics
- If lines have no VAT rate — tax classes.
- If you need to see one customer's debt — customer debt and payments.
- If you are looking for a specific document — document list.
- If you need an e-invoice for Germany — XRechnung e-invoices.
