This article was created with the AI assistant Claude and published by Peter Hoenig.

Every quarter, the same routine: gathering receipts from e-mails, downloads and piles of paper, copying amounts into a spreadsheet, adding up the input VAT, entering the totals in ELSTER, the German tax authorities' online portal – and hoping that nothing is missing and nothing has been entered twice. For a long time, that is how I kept my own books, using Excel lists. Many self-employed people and small businesses probably find themselves in a similar situation. That is why I have built a tool that brings together the whole path from receipt to advance VAT return (Umsatzsteuer-Voranmeldung) – in the browser, without a subscription and without your data leaving your computer.
How do you record receipts with tax in mind?
A receipt is quickly recorded: date, receipt type, seller, invoice number, amount and tax rate. You simply drag the receipt file – PDF, photo or scan – into the window. The tool files it in your document store under a consistent name, for example with receipt number, date, receipt type and seller. You can define your own naming pattern.
What matters is the tax case: if German VAT is shown on the invoice, it can usually be deducted as input VAT. If the invoice comes from a business in another EU country without VAT, you owe the tax yourself and deduct it as input VAT at the same time (reverse charge, Section 13b of the German VAT Act, UStG) – this often applies to software and cloud services. Foreign VAT, on the other hand, is not input VAT in the German procedure. It is precisely these cases that easily lead to errors in self-kept lists. The tool therefore points out, among other things, when
- a tax rate is not a German rate,
- a foreign provider charges German VAT – often a sign that it treats you as a private customer,
- an invoice over €250 has no invoice number,
- a receipt may have been recorded twice,
- a business entertainment receipt lacks the occasion and the participants.
For purchases such as computers, software or office furniture, the tool decides on the basis of the amount: up to €250 net, they are deducted immediately as a business expense; up to €800, they are treated as a low-value asset; above that, they are depreciated over their useful life. The special rules for business entertainment (70% deductible) and gifts (limit of €50 per recipient and year) are also built in. Existing Excel or CSV lists can be imported.
E-invoices in XRechnung or ZUGFeRD format are also simply dragged into the window. The tool displays them in readable form, suggests the receipt and keeps the original file – with an e-invoice, the XML file is the original.
Writing invoices – including as e-invoices
When you write an invoice, the tool checks the mandatory details under Section 14(4) of the German VAT Act: name and address of both parties, tax number or VAT identification number, invoice date, sequential number, type and scope of the service, date of supply, net amount, tax rate and tax amount – or the necessary note instead, for example that the recipient of the service is liable for the tax (reverse charge) in the case of customers in other EU countries.
As long as the invoice is a draft, it can be edited freely. Only when it is issued does it receive its sequential number and become locked. The tool saves it as a PDF in letter format and as an e-invoice in XRechnung format. An issued invoice can no longer be changed; corrections are made with a cancellation invoice and a new invoice. You record incoming payments with date and amount – or take them over from the bank statement. The overview shows open and overdue invoices. If you maintain customers and contact persons centrally in the master data tool, you can take over invoice recipients and their addresses from there – provided you switch on the master data connection in the accounting tool.
To send invoices, the accounting tool passes the PDF and e-invoice to your e-mail program, where the browser offers this. Otherwise, it prepares the e-mail with recipient, subject and text and has both files ready for attaching. The dispatch is noted on the invoice.
The most convenient way to put together invoices for projects is in the project management tool: working hours, materials, third-party services as well as licences, maintenance and operation, with an attachment that documents every hour and every expense. One click passes the invoice to the accounting tool. There you take it over as a draft, check it and issue it. The accounting tool reports the number, dispatch and receipt of payment back to the project.
If you win a new customer in my Vertriebs-Navigator, you take them over with one click; the customer number goes back to sales. If you look after your existing customers in the Kunden-Navigator, the accounting tool can, if you wish, provide it with revenue, open invoices and payment behaviour for each customer. Services you record there arrive as drafts, just like project invoices. Incoming invoices from your own service providers that you have filed there appear, file included, at the top of the “Receipts” tab. Number and payment are reported back in each case. Invoices, receipts, numbers and payments are only ever created in the accounting tool.
For context: in Germany, businesses have had to be able to receive e-invoices since 2025. Transitional periods apply to sending them to other businesses; from 2028, the e-invoice is generally mandatory between domestic businesses. Exceptions include small-amount invoices of up to €250 and invoices from small businesses (Section 19 UStG); invoices to private individuals are not affected. Before you send your first e-invoices, I recommend checking them with a validation tool, for example the validator of the Koordinierungsstelle für IT-Standards (KoSIT, the German coordination office for IT standards).
How do you chase unpaid invoices?
If an issued invoice remains unpaid, the accounting tool alerts you to the next level: payment reminder, 1st reminder, 2nd (final) reminder, each with a new deadline; you set the texts and deadlines yourself. The reminder is created as a PDF on your invoice letterhead, always in German; the invoice remains unchanged, and every reminder appears in the change log.
If you wish, the tool calculates default interest to the day under Section 288 of the German Civil Code (BGB): 5 percentage points above the base rate (Basiszinssatz) for consumers, otherwise 9. You enter the Bundesbank's base rate yourself; without it, there is no interest. The €40 late-payment lump sum is only an option for business customers, once per invoice. These are suggestions, not legal advice: whether and from when a customer is in default, and which dunning charges are permissible, depends on the individual case.
Reconciling bank statements – keeping an eye on open items
What often takes the most time is reconciling with the bank account: which invoice has been paid? Which debit still has no receipt? For this, you download the transactions of your business account from online banking – as a CSV file or in CAMT format, which most banks offer as a “bank statement as XML” (Kontoauszug als XML) – and drag the file into the window. The usual formats are recognised by their column headings; if a bank supplies an unfamiliar format, you assign the columns yourself once. The tool recognises transactions that have already been imported and skips them.
It then suggests a match for each transaction:
- Incoming payments are matched to open invoices – via the invoice number in the payment reference, the outstanding amount and the customer's name. Partial payments are possible.
- Debits are matched to receipts that are still recorded as unpaid.
- Payments already recorded are recognised and simply linked; the payment date is set to the bank's booking date.
- New receipts: for transactions without a counterpart, it suggests a receipt type, for example from earlier payments to the same payee, and creates the receipt with one click if you wish. You then compare the tax rate and amount with the invoice and attach the invoice as a file – a bank statement does not replace an invoice for deducting input VAT.
- Private drawings and capital contributions, as well as transactions that do not need a receipt, are marked accordingly.
Clear suggestions are highlighted in green, uncertain ones in yellow. One click accepts all suggestions; a click on the undo arrow reverses them. Reconciliation is doubly worthwhile with the cash basis of VAT (Ist-Versteuerung) and in the cash-basis income statement, because there the date on which the money actually changed hands is what counts.
The advance VAT return as a filling-in aid
For each month, each quarter or the whole year, the tool compiles the figures of the advance VAT return – according to the official 2026 form, with line and box number (Kennzahl), just as you enter them in ELSTER. Below them are the receipts for each box, so every figure remains traceable. Among other things, the following are taken into account:
- Cash or accrual basis of VAT (Ist- or Soll-Versteuerung): with the cash basis, the VAT from your invoices counts in the period in which the payment is received; with the accrual basis, in the period in which the service is performed.
- Input VAT: it counts once the service has been performed and the invoice is available. If an invoice arrives later, its input VAT counts in the period in which it is received.
- Deadlines: the overview shows by when each advance return must be filed, including with a permanent deadline extension (Dauerfristverlängerung).
- Recapitulative statement (Zusammenfassende Meldung): supplies to businesses in other EU countries are listed for reporting to the Federal Central Tax Office (Bundeszentralamt für Steuern).
Instead of typing in the figures, you can generate an ELSTER file and upload it in Mein ELSTER via the XML import. This pre-fills the form; you check and submit it there as usual. To do this, you enter your federal state once in the settings; the tool then converts your tax number into the 13-digit format that ELSTER expects and displays it for comparison. After submission, you mark the advance return as transmitted in the tool. It remembers the values, locks the period if you wish and warns you if the figures change later – in that case, a corrected advance return may be needed.
How do you reclaim VAT paid in other EU countries?
VAT charged in another EU country can, under certain conditions, be reclaimed via the input VAT refund procedure (Vorsteuer-Vergütungsverfahren). For such receipts, you enter the country; the report “Input VAT refund (other EU countries)” compiles them per year and country and shows the application deadline and minimum amounts, as I have built them in. Please check these details with your tax adviser. You submit the application yourself to the Federal Central Tax Office; the tool does not transmit anything.
Cash-basis income statement or double-entry bookkeeping – which suits you?
For the cash-basis income statement, the tool assigns all income and expenses, by payment date, to the lines and box numbers of Annex EÜR – including depreciation, low-value assets and the rule under which a VAT prepayment made at the beginning of January is still attributed to the previous year. A fixed asset register is kept as well. The Annex EÜR forms 2025 and 2026 are built in (BMF letter of 1 September 2026); later years are assigned according to the 2026 form, and the report points this out.
If you use double-entry bookkeeping, switch over in the settings. The tool then creates journal entries from every receipt, every invoice, every payment and every depreciation, using a chart of accounts based on the DATEV standard charts of accounts SKR 03 or SKR 04. Your own entries, such as the opening balance sheet or reclassifications, are added. From these, it produces a trial balance, account ledgers and a simplified balance sheet with a profit and loss account – a good basis for discussion with your tax adviser, but not audited annual financial statements.
Analysing costs by cost centre and cost type
What does each of your lines of business cost? To find out, you assign receipts, invoices (individual line items too), your own entries and fixed assets to a cost centre. The tool suggests the cost type per receipt type, for example “Licence costs” for software; a single receipt may differ. You maintain both centrally in the master data tool; invoices from project management and incoming invoices from the Kunden-Navigator bring their details with them.
The report of the same name shows the expenses of a freely selectable period per cost centre, per cost type and as a cross table, as a PDF and CSV: excluding input VAT but including non-deductible portions, because costs remain costs. For a whole year, it reconciles its total with Annex EÜR or the profit and loss account. In more detail: cost centres, dunning and input VAT refund.
Handing over to your tax adviser in DATEV format
Many tax advisers work with DATEV. For them, the tool generates – with a cash-basis income statement as well as with double-entry bookkeeping – a posting batch in DATEV format for a month, a quarter or the year: all journal entries from receipts, invoices, payments, depreciation and your own entries, with accounts based on SKR 03 or SKR 04. Input VAT and output VAT at 7% and 19% can optionally be passed on with the usual tax key; special cases such as Section 13b or business entertainment remain as separate tax entries. Your tax firm will give you the adviser and client numbers. The tool remembers which periods have already been handed over and warns you before exporting the same period twice.
Assigned cost centres appear with their number in the KOST1 column. By agreement with your tax adviser, the tool can also post receivables and payables to personal accounts (Personenkonten), one debtor account per customer and one creditor account per supplier, and also creates the master file “Debitoren/Kreditoren” in the DATEV format with name, address, contact details, VAT ID, customer number and – from the master data – the bank details; the account list is also available as CSV for your tax firm. The master file has not yet been tested in DATEV itself. Please have the first file imported as a test and agree the chart of accounts and tax keys with your tax adviser.
Recording private receipts separately
Many private expenses matter for the income tax return: pension and insurance contributions, donations, medical expenses, household-related services and tradespeople's services, childcare or investment income. You record these receipts in the “Private” area, per person if you wish. They never appear in the business accounts, only in a separate summary organised by the annexes of the tax return. For tradespeople's services and household-related services, the tool records which share is attributable to labour costs, because only this share qualifies for tax relief.
Transferring values to your tax return
At the end of the year, the figures have to go into the tax return – in Mein ELSTER or in tax software. Tax software generally does not offer an open import for data from other programs; Lexware QuickSteuer, for example, according to the manufacturer’s product descriptions (as of November 2026), takes over data from the previous year and from ELSTER, but no values from other bookkeeping programs – neither as a CSV nor as a QIF file. That is why the tool compiles all values in the report “Transfer to tax programs” so that you can transfer them quickly and without searching:
- Annex EÜR: every value with line and box number in the order of the form, non-deductible portions before the deductible amount – according to the form of the respective year (2025 or 2026).
- Annual VAT return: the annual values with their description and the box number from the advance return, as well as the total of the prepayments from the advance returns marked as transmitted. In the annual return, some lines have different numbers – please assign the values there by their description.
- Private details: per person and annex; donations as well as tradespeople's services and household-related services individually, with recipient or type of service and labour costs.
Totals such as business income, business expenses and profit are included for comparison: if your tax software shows the same totals once you have entered everything, nothing has been forgotten. The list can be saved as a PDF and printed.
You do not have to retype the values. Two aids bring them into your tax software:
- Step by step (on any computer, including Mac, Linux and tablets, without an additional program): the tool shows the next value with its line and description. One click on “Copy and next” puts it on the clipboard; in your tax software you paste it with
Ctrl+V. A bar shows how far you have got. - Transfer Assistant (Windows, automatic): “File for the assistant” saves all values as a file. The small program Transfer Assistant – free of charge and free software – shows the next value in a window that always stays in the foreground. You click in the matching field of your tax software and press
F8: the assistant types the value in and moves on to the next one. It records every entry in a log file on your computer; it sends nothing to the internet. It needs Python for Windows, which you can install free of charge from python.org or from the Microsoft Store – without administrator rights. Try it out in Windows Notepad first.
I deliberately do not offer a ready-made program file (.exe) without Python: antivirus programs often classify an unsigned program that sends keystrokes to other windows as suspicious. With Python, the complete source code is open in front of you. If you do not want to install Python, use “Step by step”.
I describe both routes in detail – with the assistant's settings, tips and answers to common questions – in the article Accounting: transferring values to your tax return.
What do proper records under the GoBD mean?
The tax authorities expect electronic records to be traceable and unalterable. The tool ensures this as follows:
- Change log: every change is saved with its time and the old and new state. Checksums chain the entries together; the tool detects if the data has been changed outside it.
- Locking: completed periods are locked; after that, corrections are only possible by cancellation.
- No permanent deletion: files go into a recycle bin, and the data is backed up continuously.
- Data package: for your tax adviser or a tax audit, all data including receipts can be exported as a ZIP file with machine-readable lists.
- Procedural documentation (Verfahrensdokumentation): a template describes your procedure based on your settings; you only need to add your own workflows.
Accounting vouchers must be retained for eight years, books and records for ten years – in each case from the end of the calendar year.
Data and notes
The tool runs entirely in your browser. Ideally, choose a dedicated folder on your computer when you start (in Chrome or Edge); this is where the data, the receipts, your invoices, the reports and the backups are then kept. Nothing is transmitted to me or to anyone else. A fictitious example shows all functions before you enter your own data. The tool is free of charge and available as free software under the GPL: Open the accounting tool.
The tool is an aid for small businesses doing their own bookkeeping. It is not tax or legal advice, not a program certified by the tax authorities, and it does not transmit anything to ELSTER. The German tax rules have been built in to the best of my knowledge (as of November 2026); what is authoritative are the laws, the official forms and the advice of your tax adviser. Please check every figure before you use it, and if you use double-entry bookkeeping, agree the chart of accounts with your tax adviser.
Functions at a glance
- Storage at the start: “📁 Choose folder …” (Chrome and Edge) keeps all data in a folder. “🌐 Save in browser” keeps it in the browser – that is the way in Safari and Firefox; please then download a data package regularly via “📁 Storage”. “📄 Open data backup (buchhaltung.json or ZIP) …” opens a backup, “🧪 View example” the fictitious example.
- Tabs: Overview, “Receipts”, “Bank”, “Invoices”, Customers, “Private”, “Fixed assets”, “Entries” (double-entry bookkeeping only), “Reports” and “Settings”.
- Saving: every change is saved automatically; the indicator at the top shows the status.
- “📁 Storage”: “📦 Download data package (ZIP: data, CSV, log, receipts, invoices)”, “💾 Download data only (buchhaltung.json)”, “📤 DATEV export for your tax adviser (posting batch) …” and “🔁 Open another storage …”.
- Several tax rates: one receipt can be split across several tax rates, for example books at 7 % and accessories at 19 %.
- Transfer to tax programs: in the “Reports” tab with “📋 Step by step …” (clipboard, progress bar, “Back”, “Skip”, “Decimal comma”) and “📤 File for the assistant” for the Transfer Assistant under Windows.
- In the MC4Y suite: the storage is on the server (“🗄 Open accounting on the server …”); one person at a time edits it, others can read it meanwhile.
- Keys:
Nnew receipt or invoice,Ctrl+Ssave form,Ctrl+Z/Ctrl+Yundo and redo,Esccloses the form,F1opens the help.
Frequently asked questions
Can I import the values into QuickSteuer?
No – the program does not provide for it: according to the manufacturer, Lexware QuickSteuer does not take over values from other bookkeeping programs, neither as a CSV nor as a QIF file. Instead, the accounting tool gets the values across without retyping – with “Step by step” via the clipboard or, on Windows, with the Transfer Assistant. The article Transferring values to your tax return shows how.
Does the accounting tool submit my advance VAT return to the tax office?
No. The ELSTER file only pre-fills the form in Mein ELSTER; you check and submit it there yourself. Afterwards, you mark the return as transmitted in the tool.
Does it run on a Mac, a tablet or a phone?
Yes, in the browser and without installation. Storing your books in a folder is only possible in Chrome and Edge; in Safari and Firefox you save in the browser and download a data package regularly. “Step by step” works everywhere, the Transfer Assistant only on Windows.
Does it replace my tax adviser?
No. It takes the recording, compiling and transferring off your hands and, if you wish, gives your tax adviser a posting batch in DATEV format. The assessment for tax purposes remains with you and your tax adviser.
Conclusion
Proper bookkeeping does not need expensive software, but it does need clear processes: record every receipt correctly once, issue invoices properly, close periods. The tool saves you the gathering and recalculating and shows where something does not add up – so that the advance VAT return becomes routine. I am continuing to develop it and welcome feedback. If you would like to simplify the administrative processes in your company as a whole and digitalise them sensibly, I will be glad to support you with IT-supported organisational consulting and process management. Talk to me in a free initial consultation.
Sources: German VAT Act (Umsatzsteuergesetz, UStG), in particular Sections 13b, 14, 15, 18, 19 and 20; VAT Implementing Ordinance (Umsatzsteuer-Durchführungsverordnung, UStDV), Section 33; Income Tax Act (Einkommensteuergesetz, EStG), Sections 4(3), 6, 7, 11 and 35a; Fiscal Code (Abgabenordnung, AO), Sections 146 and 147; Civil Code (Bürgerliches Gesetzbuch, BGB), Sections 247, 286 and 288. – Council Directive 2008/9/EC on the refund of VAT to taxable persons established in another Member State. – German Federal Ministry of Finance: Muster der Vordrucke im Umsatzsteuer-Voranmeldungs- und -Vorauszahlungsverfahren für das Kalenderjahr 2026 (specimen forms for the advance VAT return and prepayment procedure for the 2026 calendar year), circular of 29 December 2025. – German Federal Ministry of Finance: Grundsätze zur ordnungsmäßigen Führung und Aufbewahrung von Büchern, Aufzeichnungen und Unterlagen in elektronischer Form sowie zum Datenzugriff (GoBD), circular of 28 November 2019 as amended. – Koordinierungsstelle für IT-Standards (KoSIT): XRechnung, version 3.0. – European standard EN 16931 on electronic invoicing. – DATEV eG: format description “DATEV-Format” for posting batches (EXTF), DATEV Developer Portal. – ISO 20022, bank statement messages camt.052/053/054.
Trademark notice: SKR 03 and SKR 04 are standard charts of accounts of DATEV eG; the tool's accounts are my own selection based on them. Names and formats mentioned, such as DATEV, ZUGFeRD or ELSTER, are used for descriptive purposes only; there is no connection with their owners. “Lexware” and “QuickSteuer” are trademarks of their respective owners; Lexware QuickSteuer is a product of Haufe-Lexware GmbH & Co. KG. The accounting tool and the Transfer Assistant use no interface of these programs.
Open or download the tools
- Transfer Assistant for the bookkeeping tool (Windows, ZIP)Download (22 KB)
- Bookkeeping toolOpen Download (1.2 MB)
Thinking further
You can find more on this topic under resources and downloads – or talk to me directly in a free initial consultation.
Comments
Comments are published immediately with your name. Only the name, title, comment text and time are stored – see the privacy policy.
Loading comments …