Invoices

Invoices List

Learn how to view, search, sort, filter, and export your invoices efficiently in PineBill.

Invoices List and Filtering

Access all your invoices from the Invoices page with powerful search and filtering capabilities.

List View Features

Table Columns

ColumnDescription
CheckboxSelect invoice for bulk actions (owners only)
Invoice #Unique invoice identifier
Customer NameName of the customer
AmountTotal amount with currency
StatusCurrent status (color-coded pill)
Issue DateWhen invoice was created
Due DatePayment deadline
Assigned ToEmployee assignment (if applicable)
ActionsQuick actions (view, edit, change status, delete)

Sorting Options

FeatureDescription
Column SortClick any column header to sort
Sort DirectionToggle between ascending/descending
Default SortNewest first (by creation date)

Pagination Controls

OptionDescription
Items per Page10, 25, 50, or 100 invoices per page
NavigationPrevious/Next buttons
Page JumpJump to specific page number
First Invoice Screenshot

Search and Filtering

Find invoices quickly with powerful filters:

Search TypeDescription
Invoice NumberSearch by unique invoice ID
Customer NameSearch by customer name
Customer EmailSearch by customer email address
DescriptionSearch in invoice description
Real-time SearchResults update as you type

Status Filter

FeatureOptions
Available StatusesDraft, Sent, Paid, Overdue, Cancelled
Selection TypeMulti-select to show multiple statuses
Filter DisplayActive filters shown as removable chips

Date Range Filter

Filter TypeOptions
Range TypeFilter by issued date range
Quick PresetsLast 7 days, Last 30 days, Last 90 days, This Year
Custom RangeCustom date range picker

Employee Filter

FeatureDescription
Filter by EmployeeShow invoices assigned to specific employee
UnassignedShow invoices without employee assignment
Use CaseUseful for team organizations

Active Filters Management

FeatureDescription
DisplayShown as chips above the table
Remove FilterClick X on any chip to remove
Clear AllReset all filters at once
First Invoice Screenshot

Bulk Actions

Select multiple invoices to perform batch operations, saving time when managing large numbers of invoices.

First Invoice Screenshot

Selecting Invoices

FeatureDescription
Checkbox ColumnClick the checkbox next to any invoice to select it
Select AllUse the header checkbox to select all invoices on the current page
Indeterminate StateHeader checkbox shows a minus icon when some (but not all) are selected
Selection CountShows how many invoices are currently selected

Available Bulk Actions

When you have invoices selected, a bulk actions bar appears with the following options:

ActionDescription
Change StatusUpdate the status of all selected invoices at once
Delete SelectedRemove all selected invoices (with confirmation)
Clear SelectionDeselect all invoices

Bulk Status Change

Change the status of multiple invoices simultaneously:

  1. Select the invoices you want to update
  2. Click Change Status in the bulk actions bar
  3. Choose the new status from the dropdown (Draft, Sent, Paid, Overdue, or Cancelled)
  4. Confirm the change in the dialog

When changing status to Paid, the paid date is automatically set. When changing from Paid to another status, the paid date is cleared.

Bulk Delete

Remove multiple invoices at once:

  1. Select the invoices you want to delete
  2. Click Delete Selected
  3. Review the confirmation dialog showing the number of invoices to be deleted
  4. Confirm to permanently remove the selected invoices

Bulk delete is permanent and cannot be undone. All associated data including PDFs will be removed.

Bulk actions are only available to organization owners.

Exporting Invoices

Download invoices as a single ZIP file containing every invoice PDF and an Excel spreadsheet — useful for sharing with your accountant, archiving, or reconciling payments.

How to Export

  1. Open the Invoices page and apply any search, filters, or sorting you need
  2. Optionally select specific invoices using the checkboxes
  3. Click Export in the table toolbar (next to Columns)
  4. Wait for the progress notification to finish — the ZIP downloads automatically
SelectionWhat gets exported
No invoices selectedAll invoices on the current page are selected and exported
Some invoices selectedOnly the selected invoices — the button shows the count, e.g. Export (5)

Export works on the current page. To export more invoices at once, increase Items per Page (up to 100), or export each page one after another.

Export button on the Invoices list with 10 invoices selected

What's in the ZIP

FileContents
invoices.xlsxExcel workbook with an Invoices sheet and a Line Items sheet
pdfs/invoice-<number>.pdfThe PDF of each exported invoice

Invoices sheet — one row per invoice:

Column groupColumns
InvoiceInvoice #, Status, Description, Created At
CustomerCustomer, Customer Email, Customer Phone, Customer Address, Zip Code, Country, Customer Tax ID
DatesIssued Date, Due Date, Paid Date
AmountsCurrency, Subtotal, Discount, Tax Rate, Tax Type, Tax Included, Shipping, Total
OtherItems (count), Project, Assigned To, PDF File

Line Items sheet — one row per invoice item: Invoice #, Customer, Item, Model, Description, Quantity, Unit Price, Line Total, and Currency.

Dates and amounts are stored as real spreadsheet values, so you can sort, filter, and sum them immediately. The header row is frozen and column filters are enabled.

File Names

Each export gets a unique name so multiple downloads never overwrite each other:

invoices_2026-09-14_1.zip
invoices_2026-09-14_2.zip
invoices_2026-09-14_3.zip

The number increases with every export on the same day and restarts the next day.

If an invoice has no generated PDF (or it can't be downloaded), the export still completes. A notification lists the affected invoice numbers, and their PDF File column in the spreadsheet shows "Not available".

Export is available to all organization members who can view invoices — not only owners.

Use the search bar for quick lookups by customer or invoice number. Combine multiple filters to narrow down results when managing large invoice lists.

  • Combine multiple filters for precise results
  • Use status filters to focus on actionable invoices (e.g., Overdue)
  • Save time with date presets for common reports
  • Use bulk actions to update multiple invoices at once
  • Filter first, then click Export to download exactly the invoices you need
  • Clear all filters to start fresh

On this page