You can use words or symbols called search operators to filter your Bkper search results. You can also combine operators to filter your results even more.
How to use a search operator on Bkper:
Go to Bkper
In the search box, type the search operator.
Search for any of the following elements:
- Accounts
- Groups
- Hashtags
- Descriptions
- From: or To:
- Types
- Users
- Dates & Periods
- Is:
- Amount:
Examples:
Accounts or groups
What you can search by | Search operator | Examples |
Specify the account | account: | account:cash |
Specify the origin account | from: | from:cash |
Specify the destination account | to: | to:expenses |
Specify the group | group: | group:expenses |
Transactions
What you can search by | Search operator | Examples |
Status of the transactions | is: | is:draft |
Users
What you can search by | Search operator | Examples |
Specify for users | createdBy: | createdBy:john |
Dates and periods
Dates can be used on Book's format or, preferably, on yyyy-mm-dd
ISO format
What you can search by | Search operator | Examples |
Transactions during a certain time period |
| on:2018-01-01 on:2018-01 on:2018
before:2019-01-01 before:2019-01 before:2019
after:2018-01-01 after:2018 |
Get balance detail by periodicity |
| Display chat results by days.
Display chat results by months.
Display chat results by years. |
Search transactions periodically |
| $d-15 (fifteen days ago) |
Amounts
What you can search by | Search operator | Examples |
Amount | amount: | amount:2000 |
Search for an range within the amount of transactions: amount>10000 amount<10200
Descriptions
Hashtags
Bkper Search Examples
1. Who paid any transport or lodging costs with cash in june 2016?
2. Any consolidated transactions that ended up in the trash bin?
3. Month Profit Report
How to use a search operator on Bkper Sheets add-on:
Go to Google Sheets
In the search box, type the search operator.