company logo

Help center

Go to Juan Accounting
All collectionsNavigating JuanSearch Operators

Search Operators

Use search operators in Juan to quickly find specific records by filtering results with simple, flexible search rules.

Q1. What are search operators?

  • 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

Q2. Where does the search operator apply to?

  • Search operators can be used in all Juan features with a search bar in it such as business transactions, journals, bank records, and more.

Q3. How do I use search operators?

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

Q4. How do I combine search operators?

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

Q5. Is there a limit to the number of combinations I can do?

  • There is no limit to how many operators you can combine.

Q6. How do I know if a search operator is invalid?

  • The key term input will be highlighted in red if the entry is invalid. 

Q7. Are search operators case sensitive?

  • Search operators and keywords are not case sensitive.

Did this answer your question?
😞
😐
😁