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 
poster:robert.drumonds@gmail.com
draftPoster:robert.drumonds@gmail.com
robert
Note: the name must be unique to the book to be used in a query.


System Tags
#show            The recorded transactions
#hide              The reverts and reverted transactions
#checked       The checked transactions
#unchecked   The unchecked transactions
#reverts         The counter transactions of the reverted transactions
#reverted       The reverted transactions
#draft             The draft transactions 
#trash            The deleted drafts or The reverted transactions 
Note: deleted drafts are moved to the trash bin and are actually deleted after 30 days.
Note: System hashtags are ignored when recorded by the user

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


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.

Note: Mixing Groups and Accounts of different Account Types might return empty result sets. 

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