Search operators help you quickly find specific records in Juan by refining your search parameters.
These are the commonly used operators:
AMOUNTS | |
Exact | ₱500 | PHP500 |
Range | PHP100-500 | PHP100 to PHP500 |
Min/Max | PHP500+ | PHP<200 to $>=1000 |
DATES | |
Relative | date:today | date:this month | date:last quarter |
Range | date:jan-mar 2026 | date:-30d |
Due | due:today | due:>2025-06-01 |
FIELDS | |
Status | status:paid | status:overdue | status:paid,void |
Contact | customer:bravo | supplier:acme |
More | currency:PHP | tag:priority | ref:INV-2026 | ref:INV-* |
ADVANCED | |
Search Help | help:operators | ?:operators |
All Match | status:overdue PHP500+ | status:unpaid AND supplier:acme |
Any Match | status:paid OR status:void |
Exclude | NOT status:paid |
Sort By | sort:amount:desc | sort:date:asc |
Combine | (status:paid OR status:overdue) PHP500+ NOT customer:bravo |
Search operators can be used in all Juan features with a search bar in it such as business transactions, journals, bank records, and more.
Type operators directly into the search bar or click the operator icon.
The basic format is as follows: <operator>:<keywords>
Example: contact:fruit planet
Note: there should be no space before and after the colon “:”
Note: the easiest way to use it is by typing “?:” which will open all the possible operators in the feature you are currently in.


To combine different operators, you can use the following combine functions:
AND: Shows results that match both conditions
Example: “amount:PHP500+ AND contact:Fruit” — will show results that has an amount of 500+ with contacts that has the keyword Fruit
OR: Shows results that match either condition
Example: “contact:Fruit OR contact:Pacific” — will show results that has either of the two.
NOT: Excludes results that match a condition
Example “amount:PHP500+ NOT customer:Fruit” — will show results of amounts of 500+ of contacts that don’t have “fruit” in their name.

There is no limit to how many operators you can combine.
The key term input will be highlighted in red if the entry is invalid.

Search operators and keywords are not case sensitive.