Skip to content

Finding and filtering expenses

Table View turns the claims into one row each with every field as a column. It is the view for questions about a lot of claims at once — what is still unpaid, what one fieldworker has claimed this month, what a job really cost in fuel.

Expenses in Table View: the search and filter row above a table of claims with columns for name, date, category, amount, description, group, status, link to, user and actions

Expenses → Table View

ColumnWhat it shows
NameThe claim, and a link into it
DateThe day the money was spent
CategoryThe kind of spend
AmountWhat it cost
DescriptionWhatever detail was added
GroupThe group it was filed under
StatusOpen, Approved, Reject or Paid
Link toThe job or client it belongs to
UserWhose claim it is
ActionEdit and delete, without opening the claim

The arrows next to Date and Amount sort by them — largest claims first, or oldest first.

User and Status together are the pair to read when you are paying people: filter to one worker, sort by date, and you have what the company owes them.

The toolbar above the table: a dropdown set to All, a search box, Show Filtering Options and the column picker

Expenses → Table View

  • The search box finds a claim by what was typed on it, and the dropdown beside it narrows what is being searched.
  • Show Filtering Options opens the full set of filters above the table.
  • Columns Selected decides which columns the table shows — untick what you do not use and the rest get the width.

Item per Page and the arrows underneath the table page through longer lists.

Clicking a claim’s name opens it. Simple View returns you to the list-and-detail layout described in how expenses work.