What this article covers: How to use the Invoices and Bills pages in BrizoConsol — a flat list of invoice and bill lines for an entity or group, covering every status, with summary tiles, status filters, search, and payment details for each document.

The Invoices and Bills pages list the invoice (accounts receivable) and bill (accounts payable) lines loaded from your accounting system. Unlike the Pulse Receivables and Payables views, which show open items only, these pages include every status — so paid documents can still be found.

1. Opening the Pages

  • Search for an invoice or bill reference or a customer or supplier name in Global Search and click the result. The page opens with the search box pre-filled, so the document you searched for is on screen.
  • Or search for Invoices or Bills in Global Search to open the full list.

For a consolidated organisation the list covers the whole group; for an individual entity it covers that entity only. Invoice and bill data must be loaded first — see Data Loading.

2. Summary Tiles

Tile What it shows
The total of the documents matching the current filter, each counted once at its own stated total, with the number of documents.
The amount still due on overdue documents, with the number of documents.
The amount paid on paid documents, with the number of documents.
The tax across the filtered documents, or Not applicable when there is no tax data.
The number of documents, and whether the list covers the Whole group or This entity.

When the list holds documents in more than one currency, Total Amount, Overdue, Paid and Tax Amount show one figure per currency instead of a single total. Nothing is converted on this page.

3. Filtering and Searching

  • Use the status buttons — All, Overdue, and each status found in the data — to narrow the list. Overdue lines are highlighted in red and paid lines in green.
  • Type in Search by name, ID... to find a document by reference or customer/supplier name.

4. Columns

Each row is one document line: Id, Customer (invoices) or Supplier (bills), Date, Status, Type, Item Name, Qty, Unit price, Amount, and Tax Amount.

🛈 Large lists: Up to 500 of the most recent documents are loaded. When the limit is reached, the page says so under the title.

5. Payment Details

For entities connected to Zoho Books, Xero, QuickBooks Online or MYOB, click a row to expand how that document was settled. The detail needs the Free, Pro or Premium edition. For Xero it also needs additional access switched on and the month’s Transactions loaded, and for Zoho Books its additional access; otherwise the expanded row states what is missing.

Detail What it shows
Cash received against the invoice (or paid against the bill), in the document currency.
Credits applied to the document — credit notes, and for Xero also overpayments and prepayments.
What is still owed, plus the received/paid amount and balance due as at the time the document last changed in the source.
The document’s exchange rate, and the cash in the base currency. For Zoho Books, which states the rate each payment came in at, the cash is shown both at that rate and at the document’s rate — the difference is the exchange gain or loss. Xero, QuickBooks Online and MYOB convert a payment at the document’s rate, so only that figure is shown, and the panel notes that the exchange gain or loss is already posted in the ledger. A figure the source does not state shows Unverified.
One line per allocation: Date, Type, Amount, Rate and the amount in the base currency. Type is Receipt or Payment for money, and Credit note, Overpayment or Prepayment for a credit.

A write-off is stated separately, as the source records no date for it. Draft and voided documents are marked as not posted and are excluded from current receivables and payables. For QuickBooks Online, settlements are read when invoices and bills are loaded, and an invoice paid across several months keeps every month’s payments — see Data Loading.

Related Articles

Global Search Receivables & Payables in Pulse Drill Down in Reports Data Loading