---
title: "Creditor balance"
description: "This article explains how to generate a Regnskabsbasis CSV file in Sapera"
url: https://support.sapera.io/en/articles/24-creditor-balance
collection: "Supplier printouts"
updated: 2026-07-15
language: en
alternates: [da]
---

# Creditor balance

This article explains how to generate a Regnskabsbasis CSV file in Sapera

![](https://www.sapera.dk/wp-content/uploads/2023/04/Skaermbillede-2023-08-26-kl.-16.55.54-768x566.png)

The printout can be generated as PDF, Excel or sent as an attachment by email. See [print dialog](https://support.sapera.io/en/articles/39-udskriftsdialog.md).

### How do I generate a Regnskabsbasis file?

1\. From Financial, go to "Actor library" -> "Suppliers".

2\. From the Suppliers page, you can click the printer icon in the top right corner:

![](https://staticfiles.gleap.io/gattachments/hBHCQjLQG8sQKVPp47PVeTUziuoEK4YjemuIjUP23J1ujh1N8gHuaud4rgqEiigJZauV4NzIlRa.png)

3\. Select the "Creditor balance" printout

4\. Fill in the fields (the fields are described below):  

![](https://staticfiles.gleap.io/gattachments/GECbVjW410Qtt0SAjtZdjGsL66cQ5CUaHH0cH7GgGScWRnws9NxRYZu83ZaEPuPYsQCRLUwZdtF.png)

5\. Click the print format you want to generate the printout in. In this case you should choose the CSV print format, since Regnskabsbasis expects a CSV file.

### Description of the criteria

The printout supports the following criteria

**Org. unit:** You can choose to only show data from one or more of your [org. units](https://support.sapera.io/en/articles/139-org-enheder.md) (store / department etc.)

**Per financial date:** Limit by financial date so that only postings with a financial date before the per financial date are included.

**Due entries:**

Here you can choose whether the printout should only show due entries, non-due entries or all entries with an outstanding balance

**Options:**

**Due only:** Include only creditors with due entries

**Not due:** Include only creditors with a balance that is not yet due

**All:** Include all creditors with a balance

**Account:** If you use several creditor control accounts, you can limit the extract to one of these.

### Theme: Accounting

### Description of the print layout

**Columns**

**Supplier:** Supplier number

**Name:** Supplier name

**Earliest due:** Shows the earliest date on which an entry is due for this creditor

**Not due:** Posting text.

**Balance < 1w:** Amount that has been due for less than 1 week

**Balance < 2w:** Amount that has been due for less than 2 weeks

**Balance < 1m:** Amount that has been due for less than 1 month

**Balance < 3m:** Amount that has been due for less than 3 months

**Balance >= 3m:** Amount that has been due for more than 3 months

**Balance:** The total balance on the account after this posting

* * *

**Want to know more?**

Read more in these related articles:

[

Debtor balance

This article explains how to create a debtor balance printout in Sapera

](https://support.sapera.io/en/articles/25.md)[

Creditor balance

The report shows what the company owes its suppliers as of a selected financial date, aged across due intervals.

](https://support.sapera.io/en/articles/461.md)[

Open entries (purchase invoice)

This article explains how to create a printout of open entries (purchase invoice)

](https://support.sapera.io/en/articles/27.md)