Skip to main content

Report Data Glossary: Bills

Field definitions for fields available in the Bills data source in Productive Reports.

The Bills data source lets you report on bills created from purchase orders, including payment status, amounts, and vendor details.

👉 To learn how to create and customize reports, see Getting Started With Reports.

When to Use Bills

Use it when you need to see the bills from your vendors, one by one, and how much of each purchase order has been received. Here are some common reports and the fields to build them with.

Bills coming due

  • Due date is already in a new report. Sort by it.

Bills per vendor

  • Vendor and Total cost are already in a new report. Group by Vendor.

Bills per budget

  • Add Budget and group by it.

Purchase orders not fully received

  • Payment status is already in a new report. Group by it.

📌 Bills belong to purchase orders, so some fields show the purchase order’s values. The Note column in the table below says which.

Example: Two Bills on One Purchase Order

A purchase order of 1,000 has two bills. The numbers are for illustration.

Bill number

Total cost

Received

Payment status

B-1

600

600

Partially received

B-2

400

0

Partially received

Both bills show Partially received, because Payment status compares the whole purchase order: 600 of 1,000 received.

Some Fields Show the Purchase Order, Not the Bill

Payment status, Sent status, and Status reflect the bill’s purchase order. Despite its name, Payment status shows how much of the purchase order has been received, not whether the bill was paid. For purchase order totals, use Purchase orders.

Add Details From Related Items

Bills has no related items with their own fields. For the purchase orders behind your bills, use Purchase orders.

Fields

Field

Description

Note

Attachment

The files attached to the bill.

Bill number

The number of the bill.

Budget

The budget of the purchase order the bill belongs to.

Creator

The user who created the bill.

Date

The date the bill was issued.

Description

The notes added to the bill.

Due date

The date the bill is due for payment.

Payment status

Whether the bill’s purchase order has been fully, partially, or not yet received.

Reflects the parent purchase order. Calculated by comparing the purchase order's received amount with its total cost.

PO number

The number of the purchase order the bill belongs to.

Received

The amount received on the bill.

Sent status

Whether the purchase order has been sent to the vendor.

Reflects the parent purchase order. Sent/Unsent.

Status

Whether the bill’s purchase order is a draft or finalized.

Reflects the parent purchase order. Draft/Finalized.

Total cost

The total cost of the bill.

Vendor

The vendor the purchase order was issued to.

Did this answer your question?