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.

How to use a search operator on Bkper Sheets add-on:

  1. Go to Google Sheets

  2. Open Bkper add-on for Google Sheets.

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

Search for any of the following elements: accounts, groups, transactions, users, dates and periods, hashtags, descriptions, amounts.

  • 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:
postedBy:
editedBy:
deletedBy:
restoredBy:
checkedBy:
uncheckedBy:

createdBy:john
postedBy:mary
editedBy:john
deletedBy:john
restoredBy:john
checkedBy:john
uncheckedBy:mary

  • Dates and periods

What you can search by

Search operator

Examples

Transactions during a certain time period

  • on

  • before

  • after

on:2018

on:dd/mm/yyyy

before:2018
before:dd/mm/yyyy

after:2018
after:dd/mm/yyyy

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 

Did this answer your question?