Orbis Web · Reports
Version 2026.11

Supplier Balance: review your suppliers' documents for any period

Filter by supplier, branch and dates, check each supplier's documents and amounts, and export the result to Excel or PDF. For the agency's accounting and administration team.

Basics

What the Supplier Balance is

It is the report that brings together, in a single table, your suppliers' recorded documents for the period you choose: date, supplier, document, amount, tax ID and ledger sub-account. Use it to reconcile balances, prepare the closing or answer a supplier query without opening their records one by one.

You'll find it in the side menu under Informes › Balance Proveedores. It is a read-only screen: filtering, sorting or exporting does not change any data.

Screen languageThe screens in this manual are shown as they appear in Orbis Web, in Spanish. Control names are given in Spanish in bold, followed by their meaning where helpful.
ColumnWhat it shows
IdInternal record identifier in Orbis Web.
Fecha (Date)Document date.
Proveedor (Supplier)Supplier name.
Documento (Document)Document number or reference (for example, the supplier's invoice).
Importe (Amount)Document amount.
NIFSupplier's Spanish tax ID.
Subcuenta (Sub-account)Ledger sub-account assigned to the supplier.
Proveedor SapSupplier code in SAP, if the agency uses that integration.
Related reportIf you need a supplier's movements with a running balance, use Extracto de Balance de Proveedores (Supplier balance statement), in the same Informes menu.
ImportantThe table is empty when you open the screenThe query hasn't run yet, which is why you see «No hay datos disponibles» (No data available). Check the filters and click Filtrar (Filter) to load the results.
Common procedure

4 steps to get the balance

Open the reportIn the side menu, expand Informes and click Balance Proveedores.
Set the filtersChoose suppliers, branch and the Desde Fecha / Hasta Fecha (From / To date) range.
Click FiltrarThe table loads the documents that match the filters.
Review and exportSort, filter by column and download the result as Excel or PDF.
Module

Filter the balance

What it's for

Limits the report to the suppliers, branch and period you're interested in, so the table only shows what you need to review.

When to use it

Always before querying: at a monthly or year-end closing, when reviewing a specific supplier or when comparing branches.

Task: narrow the balance to one supplier, one branch and one period. Screen recreation with sample data.

Step by step

  1. In Proveedores (Suppliers), open the drop-down and choose one or more suppliers. Leave it empty to include all of them.
  2. In Sucursal (Branch), choose a branch to see only its documents. Empty includes all branches.
  3. Set the period in Desde Fecha (From date) and Hasta Fecha (To date). By default, the From date is 1 January of the current year.
  4. Click Filtrar (Filter) to load the table. Reiniciar Filtros (Reset filters) restores the initial values.
FilterWhat it doesIf left empty
ProveedoresShows only the documents of the selected suppliers.Includes all suppliers.
SucursalLimits the report to the selected branch.Includes all branches.
Desde FechaFirst day of the period.No start limit.
Hasta FechaLast day of the period.No end limit (up to today).
Hide and show the panelThe Filtros button in the top bar collapses or expands the filter panel. Reactivar Resumen de Filtros (Show filter summary again) displays the summary of applied filters above the table.
Common mistakeI change the filters and the table doesn't changeFilters are only applied when you click Filtrar. After changing a supplier or a date, click it again.
Module

Review and export the results

What it's for

Review the documents found, locate a specific one with the column filters and download the report to share or archive it.

When to use it

When reconciling a supplier's balance with their statement, looking for an invoice by number or tax ID, or sending the balance to your accountant.

Task: review the documents found and export them. Screen recreation with sample data; the filter panel is omitted.

Step by step

  1. Use the buttons above the table: the first one chooses which columns are visible, Excel downloads the result as a spreadsheet and PDF downloads it as a PDF.
  2. Click a column heading (for example, Proveedor or Importe) to sort; click it again to reverse the order.
  3. Type in a column's Filtrar... box to search within the results, for example a document number or a tax ID. The crossed-out funnel icon on the right clears these filters.
  4. Choose in Mostrar (Show) how many rows per page (10, 50 or 100) and move with Previo (Previous) and Siguiente (Next).
Column filters vs report filtersThe Filtrar... boxes only search within the results already loaded. To change the period or the suppliers, use the Filtros panel and click Filtrar again.
Common mistakeThe Excel file doesn't include every documentMake sure there is no text in the column Filtrar... boxes: they limit what is shown. Clear them with the crossed-out funnel and export again.
Guidelines

Best practices

Always set the period

Fill in Desde Fecha and Hasta Fecha: the report loads faster and is easier to reconcile with the supplier's statement.

Check tax ID and sub-account

A supplier without a tax ID or sub-account usually means an incomplete record. Fix it in the supplier's record before sending the balance to accounting.

Export what you see

Before downloading, keep only the columns you need visible and clear any column filters you don't want to apply.

Before sending the balance
  • The Desde Fecha and Hasta Fecha period is correct.
  • Proveedores and Sucursal have the selection you want (or are empty to include everything).
  • You clicked Filtrar after the last change.
  • No text remains in the column Filtrar boxes.
  • You downloaded the format the recipient needs (Excel or PDF).
Support

Troubleshooting

I see «No hay datos disponibles».You haven't clicked Filtrar yet, or there are no documents for those filters. Widen the date range or clear Proveedores and Sucursal and filter again.
I can't find a supplier in the drop-down.Check that the supplier exists in Orbis Web and, if you filter by branch, that it has documents in that branch.
The table shows fewer rows than expected.Check the column Filtrar... boxes and the Mostrar selector; use Siguiente to see the remaining pages.
A column is missing.It may be hidden: show it with the columns button above the table.
Still not working?Contact Pipeline Software support through your agency's usual channel and include the screen (Informes › Balance Proveedores), the filters you used and a screenshot of the result.