All Collections
Using Bkper
Query guide (search)
Query guide (search)

Find anything quickly with Bkper Search, a comprehensive guide to efficient queries

Updated over a week ago

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:

  1. Go to Bkper

  2. 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
is:posted
is:trashed
is:checked
is:unchecked

  • 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

  • before

  • after

on:2018-01-01

on:2018-01

on:2018

before:2019-01-01

before:2019-01

before:2019

after:2018-01-01
after:2018-01

after:2018

Get balance detail by periodicity

  • by:d

  • by:m

  • by:y

Display chat results by days.

Display chat results by months.

Display chat results by years.

Search transactions periodically

  • $d (the current day)

  • $m (the current month)

  • $y (the current year)

$d-15 (fifteen days ago)
$d+1 (one day ahead)

$m-1 (one month ago)
$m+2 (two months ahead)

$y-1 (one month ago)
$y+1 (one year ahead)

  • Amounts

What you can search by

Search operator

Examples

Amount

amount:

amount:2000
(lists all the transactions with 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:

  1. Go to Google Sheets

  2. In the search box, type the search operator.

Did this answer your question?