Your Shopify sales, ready for your tax adviser
Close the month, download the file, hand it over. The app turns your sales and refunds into booking records in DATEV format. No more typing them up.
The app only reads. It changes nothing in your orders, products or theme.
One closed month is free, for as long as you use the app. Paid plans start with a 14-day free trial.
How a month goes
Set it up once. After that a month takes a few clicks.
-
01
Close the month
When the month is over, you open it in the app and close it. The app reads that month's orders and refunds from your store.
-
02
Check the figures
The completeness line shows what is booked and what is not, and why. Put it next to the finance summary in your Shopify admin. If the two agree, the file is ready to go.
-
03
Hand the file on
You download the file and send it to your tax adviser, by email or however you usually share documents.
Once, before the first month
You enter the consultant number, the client number and the start of your fiscal year in the settings. Your tax adviser has the numbers.
What is in the file
An example, booked with SKR03. Each line is one booking record: what happened in your store, and which account it belongs to.
| Date | Document | Text | Amount (EUR) | Debit/Credit | Account | Contra account |
|---|---|---|---|---|---|---|
| 03.09. | 1001 | Bestellung #1001 | 119.00 | Debit | 10000 | 8400 |
| 03.09. | 1002 | Bestellung #1002 | 32.10 | Debit | 10000 | 8300 |
| 04.09. | 1005 | Bestellung #1005 | 45.00 | Debit | 10000 | 8400 |
| 04.09. | 1005 | Bestellung #1005 | 12.84 | Debit | 10000 | 8300 |
| 12.09. | 1003 | Erstattung #1003 | 29.75 | Credit | 10000 | 8400 |
Reading the lines
On the left, what happened: an order or a refund, with its day and amount. On the right, where it goes. 10000 collects all your customers in one account; 8400 and 8300 are revenue at 19 % and 7 % VAT. When an order has both, like #1005, each rate gets a line of its own.
A booking batch in DATEV format, one CSV file, with the consultant number, client number and fiscal year in its header. SKR03 or SKR04, 10000 as the collective debtor, the order number in Belegfeld 1. For every file the app shows a checksum (SHA-256). No customer names or addresses are in it.
What you can set
Your accounts, not ours
The app suggests revenue accounts from SKR03 or SKR04. If your tax adviser books to others, you enter them once. You can change any account and any tax key.
Small business rule in one switch
If your store charges no VAT, you turn on the § 19 UStG small business rule. Every sale then goes to the small business revenue account.
One Stop Shop and tax-free sales
Sales charged at another EU country's VAT rate and tax-free sales get their own accounts, which you assign. An EU sale charged with German VAT is booked like any other sale (8400 or 8300 in SKR03).
On Pro: a link for your tax adviser
You make a link, and your tax adviser downloads the month's file themselves, with no login. Pro also brings cost centres (KOST1) and revenue accounts per product type.
Why it is safe to install
Read only
The app reads orders and refunds. It changes no order, no product and no theme.
Nothing gets uploaded
It sends nothing to DATEV or to any accounting tool. You download the file and decide who gets it. We keep no copy.
See it before you download
The month's page shows the booking records with their accounts, and the completeness line with every count, before you download the file.
Plans
You pay through your Shopify bill. Paid plans start with a 14-day free trial, and you change or cancel the plan in the app whenever you want.
Support
Write to support@larchline.co, in German or in English. We answer within 24 hours. What to set up before the first export, and what the app does not do, is on the support page.