Go to Easy Invoice Cloud
PepperTools Guide
Invoicing & Accounting

OPOS list: reading open items, debit and credit, plus a template

The open items list shows who still owes you money and whom you still owe money. How to read debit and credit on the OPOS list from your tax adviser (Steuerkanzlei), find items that were paid long ago, and keep your own list with a template.

OPOS list: reading open items, debit and credit, plus a template

An open items list (Offene-Posten-Liste), OPOS or OP list for short, shows all invoices that have not yet been paid: your invoices to customers and your suppliers' invoices to you. On a customer's account, an open amount on the debit side (Soll) as a rule stands for money they still owe you. An open amount on the credit side (Haben) there points to an overpayment, a credit note or a payment that has not yet been allocated to an invoice. On a supplier's account, it is the other way round. If you receive the list from your tax adviser (Steuerkanzlei), check each item: really open, already paid or wrongly allocated.

Contents

What is on an open items list?

The list answers two questions: who still owes you money, and whom do you still owe money? An "item" (Posten) is a single invoice, credit note or payment that has not yet been settled.

In accounting, the two sides are called debtors (Debitoren) and creditors (Kreditoren):

TermWho is that?What is open?
Debtor (Debitor)your customeran invoice you have written and they have not yet paid, i.e. your receivable
Creditor (Kreditor)your supplier or service provideran invoice you have received and not yet paid, i.e. your liability

In the DATEV charts of accounts (Kontenrahmen) SKR 03 and SKR 04 for 2026, construction and trades edition (Bau und Handwerk), the numbers 10000 to 69999 are intended for customer accounts (debtors) and the numbers 70000 to 99999 for supplier accounts (creditors). If your tax adviser works with these ranges, an account number such as 10010 stands for a customer and a number such as 70010 for a supplier. If in doubt, ask your tax adviser which numbers they use.

The tax authorities (Finanzverwaltung) recognise open-item accounting (Offene-Posten-Buchhaltung) as a form of bookkeeping. Under the German Income Tax Guidelines (Einkommensteuer-Richtlinien, EStR), non-cash transactions, broken down by business partner, can be kept either in separate accounts for each customer and supplier or by "an orderly filing of the unsettled invoices (open-item accounting)" (R 5.2(1) sentences 5 and 6 EStR). The law expressly allows bookkeeping in the form of an orderly filing of documents if it complies with the principles of proper bookkeeping (Grundsätze ordnungsmäßiger Buchführung) (§ 239(4) of the German Commercial Code (Handelsgesetzbuch, HGB), § 146(5) of the German Fiscal Code (Abgabenordnung, AO)).

In the office1.cloud dunning module, Easy Invoice shows all unpaid invoices with due date and days overdue. The bank import matches the payments, and paid invoices disappear from the overview.

Debit and credit: how to read the OPOS list

If there is an open amount on the debit side of a customer's account, they as a rule owe you money. If there is an open amount on the credit side of a supplier's account, you as a rule owe them money. The two other cases as a rule point to an overpayment, a credit note or a payment that has not been allocated to an invoice.

AccountAmount on the debit side (Soll)Amount on the credit side (Haben)
Customer (debtor)your invoice is open, the customer owes you moneythe customer has paid too much, a credit note for them is open or their payment has not been allocated to an invoice
Supplier (creditor)you have paid too much, a credit note from the supplier is open or your payment has not been allocated to an invoicethe supplier's invoice is open, you owe them money

The background: in double-entry bookkeeping, your invoice to a customer is usually posted to the debit side of their account, and their payment to the credit side. For a supplier, their invoice usually appears on the credit side and your payment on the debit side. When invoice and payment offset each other, the item disappears from the list. The balance (Saldo) is the difference between all debit and credit amounts of an account.

An example of what an extract can look like:

AccountNameDocumentDateDebitCredit
10010Schreinerei YilmazInvoice RE-2026-04128 Sep 20261,190.00
10010Schreinerei YilmazPayment18 Sep 20261,166.20
10020Praxis Dr. NowakPayment without invoice number24 Sep 2026250.00
70010Druckerei OkaforInvoice 553115 Sep 2026595.00

How to read the four lines:

  • Schreinerei Yilmaz: 23.80 euros remain open on the debit side. That is exactly 2 percent of the invoice. If your invoice offered a 2 percent cash discount (Skonto) and the customer paid within the period, they were allowed to deduct the amount. In that case, let your tax adviser know so that they post the remainder as a cash discount. More on this in the article Cash discount on an invoice.
  • Praxis Dr. Nowak: 250 euros on the credit side without an invoice. Money has come in here that has not been allocated to any invoice. Look up the matching invoice and give your tax adviser the invoice number.
  • Druckerei Okafor: 595 euros on the credit side of a supplier account. You have not yet paid this invoice, or your payment has not yet been posted.

The list looks different depending on the software and the tax adviser. For each item, look out for these details: customer or supplier, invoice number, date, amount and whether it is on the debit or the credit side.

Why is an item open even though it was paid?

Then the payment has not been allocated to its invoice, or a remaining amount is rightly missing. Before you send a customer a formal reminder, it is worth looking at these reasons:

Possible reasonWhat you see on the listWhat helps
Payment without an invoice number or with the wrong one in the payment referenceinvoice on the debit side and a payment on the credit side, both opentell your tax adviser how to allocate it
A customer pays several invoices with one transferseveral invoices open, one larger payment on the credit sidename the invoices that belong to the payment
Customer has deducted a cash discountsmall remaining amount on the debit sidecheck whether the deduction was justified, then have it written off
Partial payment or payment in instalmentsremaining amount on the debit sidekeep following up the remainder; if there is an agreement, count the instalments
Credit note or cancellation not postedinvoice on the debit side although the order has been cancelledsend your tax adviser the credit note or cancellation invoice (Stornorechnung)
Payment in cash or to a different accountinvoice on the debit side, no payment receivedgive your tax adviser proof of the payment

Duplicate or wrong invoice numbers make allocation more difficult. How to assign numbers that remain unique is explained in the article Assigning invoice numbers. How to cancel an invoice correctly is explained in the article Correcting an invoice.

Do you have to keep an open items list?

If you keep books and regularly prepare financial statements, the Income Tax Guidelines require your transactions on account to be shown in accounts for each business partner. An orderly filing of the unpaid invoices is a recognised way of doing this. The guidelines do not set out these rules for the cash-basis income statement (Einnahmenüberschussrechnung). Your own list is useful all the same.

If you keep books and prepare financial statements. In double-entry bookkeeping, according to the Income Tax Guidelines, "as a rule a current account (Kontokorrentkonto), subdivided by debtors and creditors, is to be kept" for transactions on account (R 5.2(1) sentence 2 EStR). The requirement to show transactions for each business partner can be met by separate accounts for each customer and supplier or by an orderly filing of the unsettled invoices (R 5.2(1) sentences 5 and 6 EStR). If you have engaged a tax adviser to do your bookkeeping, they keep these accounts in their software.

Who has to keep books and prepare financial statements is set out in the German Commercial Code and the German Fiscal Code:

WhoBooks and financial statementsReference
Merchants (Kaufleute), including commercial companies such as the GmbHyes§§ 238, 242 HGB, § 6 HGB, § 13(3) GmbHG
Sole traders (Einzelkaufleute) with no more than 800,000 euros in turnover and 80,000 euros in net income for the year on two consecutive balance sheet datesnot obliged under commercial law§ 241a HGB, § 242(4) HGB
Commercial businesses (gewerbliche Unternehmer) with more than 800,000 euros in turnover in the calendar year or more than 80,000 euros in profit in the financial yearyes, from the financial year following the tax office's notification§ 141 AO

Your tax adviser can clarify whether the thresholds apply to you. § 141 AO does not mention the liberal professions (freie Berufe); it refers to commercial businesses and to farmers and foresters.

If you prepare a cash-basis income statement. R 5.2 EStR belongs to § 5 of the German Income Tax Act (EStG). This provision concerns commercial businesses (Gewerbetreibende) that keep books and regularly prepare financial statements (§ 5(1) sentence 1 EStG). With a cash-basis income statement, income in principle only counts for income tax when the money reaches you (§ 11(1) EStG). For VAT, the law requires records of the agreed consideration (vereinbarte Entgelte), or, if you pay tax based on payments received, of the consideration received (vereinnahmte Entgelte) (§ 22(2) no. 1 of the German VAT Act (UStG)). If in doubt, your tax adviser can clarify how exactly you keep these records.

Your own list helps even without an obligation: you see which customer is overdue before the money is missing from your account. And if you pay VAT based on agreed consideration, you see for which invoices the VAT has already arisen, even though the money is still missing. More on this in the section VAT.

Template: keeping your own open items list

For your own list, a table with eight columns is enough, in Excel, in another spreadsheet program or on paper. Each row stands for one invoice. As soon as an invoice has been paid in full, mark the row as done or move it to a second sheet.

ColumnWhat goes in itExample
Invoice numberthe number of your invoiceRE-2026-0412
Invoice datedate of the invoice8 Sep 2026
Customername of the customerSchreinerei Yilmaz
Amountgross invoice amount1,190.00
Due ondate from your payment term22 Sep 2026
Paid ondate the payment was received18 Sep 2026
Paidamount received1,166.20
Openamount minus paid23.80

Two additional columns help if you send reminders: "Days overdue" and "Reminder or formal reminder sent on". In Excel, the formula =TODAY()-E2 (in a German-language Excel: =HEUTE()-E2) calculates the days since the due date if the due date is in column E. A filter on "Open greater than 0" shows only the invoices you should take care of.

For supplier invoices, create a second sheet with the same columns, with "Supplier" instead of "Customer". This way you also see which invoice you should still pay yourself, for example to take advantage of a cash discount.

When an invoice is due depends on your payment term. How to word it is explained in the article Payment terms on an invoice.

What to do with items that have been open for months?

The longer an item is open, the closer it gets to the limitation period running out (Verjährung). Tackle it in this order:

  1. Check whether it really is open. Go through the reasons in the section Why is an item open? before you contact the customer.
  2. Send a friendly reminder. Templates are in the article Writing a friendly payment reminder.
  3. Send a formal reminder. If the customer does not respond, the formal reminder (Mahnung) follows, see Writing a formal payment reminder. How to calculate interest for the delay is explained in the article Calculating late payment interest.
  4. Keep an eye on the limitation period. Claims as a rule become time-barred after three years (§ 195 of the German Civil Code (BGB)). The period in principle begins at the end of the year in which the claim arose (§ 199(1) BGB). A claim from 2023 therefore as a rule becomes time-barred at the end of 31 December 2026. The limitation period can be halted, for example, by service of a court order for payment (gerichtlicher Mahnbescheid) (§ 204(1) no. 3 BGB). More on this in the article Dunning for the self-employed.
  5. Write it off if nothing more is coming. If the customer is insolvent or the claim cannot be enforced in the foreseeable future, pass this on to your tax adviser. For VAT, there is then a correction, see the next section.

VAT on invoices that are still open

If, as in the normal case, you pay VAT based on agreed consideration, the VAT arises for the period in which you performed the supply, even if your customer has not yet paid. If, with the tax office's permission, you pay VAT based on payments received, it only arises for the period in which the money comes in. If your sales are tax-exempt as a small business owner (Kleinunternehmer), the question does not arise.

Your situationWhen the VAT on an open invoice arisesReference
Taxation based on agreed consideration, the normal caseat the end of the advance return period (Voranmeldungszeitraum) in which you performed the supply, paid or not§ 13(1) no. 1 letter a UStG
Taxation based on payments received, on applicationat the end of the advance return period in which the money comes in§ 13(1) no. 1 letter b UStG, § 20 UStG
Small business owneryour sales are tax-exempt§ 19(1) UStG

You may pay tax based on payments received if the tax office permits you to do so on application. Among other things, the law names a total turnover of no more than 800,000 euros in the previous year or working as a freelancer (§ 20 sentence 1 UStG). When you report the tax is explained in the article on the advance VAT return (Umsatzsteuer-Voranmeldung).

If a customer ultimately does not pay. If the agreed consideration has become uncollectible (uneinbringlich), the law requires the VAT owed on it to be corrected (§ 17(1) sentence 1 and (2) no. 1 UStG). In the view of the tax authorities, a claim is uncollectible in particular if the customer is insolvent or if, on an objective view, it must be expected that you will not be able to enforce the claim in the foreseeable future. A correction may also be considered if the customer disputes the existence or amount of the claim in a substantiated manner (section 17.1(5) sentences 2 and 4 UStAE).

Three points on this from the same passage of the German VAT application decree (Umsatzsteuer-Anwendungserlass, UStAE):

  • An agreed payment in instalments does not make a claim uncollectible (sentence 6).
  • You do not have to inform your customer if you treat a claim as uncollectible (sentence 10).
  • If the customer pays after all, the law requires a further correction (§ 17(2) no. 1 sentence 2 UStG).

Whether one of your claims is already uncollectible is best decided together with your tax adviser.

The OPOS list at the year-end closing

At the year-end closing (Jahresabschluss), what counts is which items are really open on the reporting date. Merchants draw up an inventory (Inventar) for the end of each financial year in which they record, among other things, their receivables and debts precisely (§ 240(1) and (2) HGB). This does not apply to sole traders who are exempt under § 241a HGB. For commercial businesses that keep books under § 141 AO, § 240 HGB applies accordingly (§ 141(1) sentence 2 AO).

If you receive the list for this from your tax adviser, go through it like this:

  1. Tick off every item that was really open on the reporting date.
  2. Mark items that have been paid and attach the payment receipt or bank statement.
  3. For items you do not recognise, note a short question for your tax adviser.
  4. Name claims for which you no longer expect any money so that your tax adviser can value them.

Frequently asked questions

What does OPOS mean?

OPOS stands for "offene Posten" (open items). The OPOS list is the overview of all items that have not yet been settled.

What is "offene Posten" called in English?

The English translation of the German Commercial Code provided by the language service of the Federal Ministry of Justice calls Forderungen aus Lieferungen und Leistungen "trade receivables" and Verbindlichkeiten aus Lieferungen und Leistungen "trade payables" (§ 266 HGB). For the list itself, "open items list" is the literal translation.

Does every invoice have to go on the list, even if it is paid immediately?

For your suppliers' invoices, the tax authorities allow a simplification: they do not object if invoices for goods and expenses (Waren- und Kostenrechnungen) that are paid within eight days of receipt of the invoice or within the time they normally take to pass through the business are not recorded in the current account, i.e. not in a separate account for each supplier (R 5.2(1) sentence 3 EStR). Cash sales that are paid immediately never become an open item in the first place.

How often should I check the open items?

For bookkeeping, the tax authorities allow the transactions on account of one month to be recorded by the end of the following month, provided no documents can be lost (R 5.2(1) sentence 4 EStR). For your own list, a fixed date helps, for example once a week or before each advance VAT return. Then an overdue invoice stands out while a friendly reminder is still enough.

Try Easy Invoice free for 10 days — no payment details, the trial ends by itself.

Sources

About the author

Charles Imilkowski

Software developer · PepperTools

Charles Imilkowski has been developing and selling his own software for invoicing and accounting since 2014, through his company PepperTools. He has also worked as a software developer since 2004, today for medium-sized companies, building interfaces between ERP systems such as SAP and accounting solutions such as DATEV.

Handle invoices more easily

Easy Invoice combines quotes, invoices and customer management in the cloud.

Try Easy Invoice

Language versions