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. |