# Receivables and payables reports

Section: Reports. Address: https://vende.id/docs/laporan/piutang-dan-hutang?lang=en

See who still owes the shop and whom the shop still owes, with how long each amount is past due and a card for each party.

There are four reports for receivables and payables. **Receivables** and **Payables** show today's position. **Receivable Card** and **Payable Card** show the history of one party.

## Receivables report

**Reports → Receivables** shows the money the shop is still owed, as of today. From the top:

1. **Customer Receivables**: per customer, the unpaid notes grouped by how long they are past due. The groups are: not yet due, 1 to 30 days late, 31 to 60 days, 61 to 90 days, more than 90 days, and no due date. Then that customer's credit balance and order down payments are taken off, giving the **Net Balance**.
2. **Advances by Borrower**: the [advances](https://vende.id/docs/kas-dan-keuangan/kasbon?lang=en) not paid off yet.
3. **Income Not Yet Received by Category**: the [income](https://vende.id/docs/kas-dan-keuangan/mencatat-pendapatan-lain?lang=en#income-not-yet-received) and [unearned income](https://vende.id/docs/kas-dan-keuangan/pendapatan-di-muka?lang=en#unearned-income-not-yet-received) not received yet, per income category. It works like the expenses in the [Payables report](#unpaid-expenses-by-category).
4. **Total Net Receivables**.
5. A breakdown per document: **Unpaid Sales Notes** with their due dates and age, then the advances and the income not yet received. Each income sits under its category, with the **Received from** and **Description** columns when one of them is filled in.

While the Sales feature is on and some customers have a [region](https://vende.id/docs/pelanggan/menambah-pelanggan?lang=en#regions-and-the-sales-in-charge), the **Receivables by Region** table adds those customer figures up per region, with the customers without a region on the last row. Choose **Region** in the filter to see only that region's customers, with their unpaid notes. Advances, income not yet received and loans have no customer, so they are left out while one region is picked.

Receivables can also be filtered by **Customer**, **Customer group**, **Sales agent** (while the Sales feature is on) and the **Warehouse** the note was made from; Payables by **Supplier** and **Warehouse**. The filters can be used together, left empty means all, and they are written in the PDF and Excel header. As with a region, loans, advances and unpaid expenses do not carry that attribute, so they are not shown while a filter is on, and deposits and order down payments are left out when Sales agent or Warehouse is picked, because they belong to the customer, not to one note.

![The Customer Receivables table per customer by age from the due date](https://vende.id/images/docs/en/laporan/piutang-dan-hutang-laporan-piutang.webp "The Customer Receivables part of the Receivables report")

Credit balances and order down payments are recorded for the whole shop. If the shop has several branches, their columns only show when **All branches** is selected.

How to set payment terms and receivable limits, and how to record repayments, is in [Setting and monitoring customer receivables](https://vende.id/docs/pelanggan/piutang-pelanggan?lang=en).

## Payables report

**Reports → Payables** shows the money the shop still has to pay, as of today. From the top:

1. **Supplier Payables**: per supplier, the unpaid purchase notes by how long they are past due, less credit balances and order down payments.
2. **Loans by Lender**: the [loans](https://vende.id/docs/kas-dan-keuangan/pinjaman-toko?lang=en) not paid off yet.
3. **Unpaid Expenses by Category**: the [expenses](https://vende.id/docs/kas-dan-keuangan/mencatat-biaya?lang=en#unpaid-expenses) and [prepaid expenses](https://vende.id/docs/kas-dan-keuangan/biaya-di-muka?lang=en#unpaid-prepaid-expenses) not paid yet, per expense category.
4. **Total Net Payables**.
5. A breakdown per document: **Unpaid Purchase Notes**, the unpaid freight costs and courier shipping, then the loans and expenses not paid off yet.

How to pay suppliers is in [Paying what you owe suppliers](https://vende.id/docs/pembelian/membayar-hutang-pemasok?lang=en).

> **Tip:** The Receivables and Payables reports show today's position. To see receivables and payables per party on a past date, open **Reports → Balance Sheet**, choose the date, then turn on [Breakdown by party](https://vende.id/docs/laporan/neraca?lang=en#breakdown-by-party). There, expenses and income with a supplier are broken down per supplier, and those without one per category.

### Unpaid expenses by category

Unpaid expenses are grouped by [expense category](https://vende.id/docs/kas-dan-keuangan/mencatat-biaya?lang=en), following the parents and their children. For example: Electricity and Marketing sit under Operations, and Online Ads under Marketing.

- A child category is stepped in under its parent. A parent's figure is the sum of the rows one step under it.
- Expenses recorded on the parent itself show as the first row under it, for example **Operations (no breakdown)**, and are part of that sum. So Operations = Operations (no breakdown) + Electricity + Marketing, and Marketing already holds Online Ads.
- In **Unpaid Expenses**, the expenses are grouped per category under its full name, for example **Operations › Marketing › Online Ads**. The category's row carries the sum of the expenses under it.
- An unpaid prepaid expense sits in its category too, with its own number (BM). What shows is what is still unpaid, not what has not become an expense yet. Its number opens that prepaid expense's page.
- The **Paid to** column only shows when an expense fills it in. An expense without a supplier is left blank in that column.
- The **Description** column holds the expense's Note and only shows when an expense has a note. A long note is cut short. To read all of it, point at it on a computer, or open the expense from its number. The Excel file holds the whole note.

## Empty parts

A part with nothing in it is not shown, on the screen, in the PDF or in Excel. For example, a shop with no unpaid purchase notes and no loans only sees the unpaid expenses and the total. When nothing is owed at all, the Payables report is one sentence, for example **No payables as of 19 Oct 2026.** The Receivables report works the same: **No receivables as of 19 Oct 2026.**

## Receivable Card and Payable Card

A card shows every movement of one party over one period, with a running balance.

1. Open **Reports → Receivable Card** for a party who owes the shop: customers, borrowers of advances, and suppliers who have not paid an income yet. Open **Reports → Payable Card** for a party waiting for payment from the shop: suppliers, including for unpaid expenses and prepaid expenses, and lenders.
2. Choose **Party**, for example Bu Siti. The party list is grouped by type.
3. Fill in **From** and **Until**.

It holds: the balance before the period, every note, payment, return and note offset with a running balance, then the closing balance.

Loans and advances from the opening balances read **Opening loan** or **Opening advance**. Those whose money did not go through cash read **Loan not through cash** or **Advance not through cash**, and those only partly through cash are marked "partly not through cash". Their balance counts like any other loan.

> **Tip:** A Receivable Card is handy to send to a customer as a breakdown of what they owe. Press **Download PDF** above the report.

## Reminders for overdue items

The dashboard shows a warning when a receivable note, a payable note, an advance or a loan is overdue, with what is left of it. This warning only appears when something needs attention.
