Query Guide

Get a lot more out of bkper!

Search through transactions and get to generate the right reports fast, easy and dynamicly.

Groups/Accounts/Tags
group:”Expenses”  
acc:”Visa”
#Tags


Date variables
($y|$m|$d)(-|+)(1-999).
See more bellow:
Name Type Description
$d string The current day. Example: $d-15 (fifthteen days ago) / $d+1 (one day ahead)
$m string The current month. Example: $m-1 (one month ago) / $m+2 (two months ahead)
$y string The current year. Example: $y-1 (one year ago) / $y+1 (one year ahead)


Specific Dates
after:dd/mm/yyyy  
before:dd/mm/yyyy 
on:dd/mm/yyyy 
Note: that the date format depends on your book settings.


Date Type
using:informedDate   
using:postedDate 


Users
robert.drumonds@gmail.com 
createdByEmail:robert.drumonds@gmail.com
updatedByEmail:robert.drumonds@gmail.com
robert

Charts 
by:d Displays chart results by days 
by:m Displays chart results by months 
by:y Displays chart results by year 


Drafts
in:draft

Trash
in:trash

Putting it all together
group:"expenses" #newyork   after:$m-1 using:informedDate
Show all the expenses made in New York made in during the last month.

acc:"transport" #newyork
Show all the transportation entries made in New York at any time.

acc:"food" #newyork #losangeles
Show all the food account entries for New York and Los Angeles.

acc:"food" acc:"transport" #draft robert.drumonds@gmail.com
Show all the food account and transport account entries that are not posted yet and recorded by the user robert.drumonds@gmail.com.

You can also build queries with the query wizard.

Facebook
Twitter
Bkper Channel on Youtube
Share this article on Linkedin

Still need help? Contact Us Contact Us