If you have trouble using the Bkper Functions for Google Sheets you can try solve it with the instructions bellow.

Where can I find the Book ID?

The bookId is located on the URL.

How to Identify an error?

Sometimes when executing a function, you can get to some error. Those errors can be identified by rolling the mouse over the cell with the #ERROR! or #REF results, like bellow: 

1. Error: Unknown function 'BKPER_XXXX'

Sometimes when you copy a spreadsheet, it can suddenly stop recognizing the Bkper Functions. Once the error identified, you can check bellow how to proper overcome those errors.

This can happen due some reasons:

1 - You don't have the Bkper Add-on for Google Sheets Installed

3 - You haven't had opened Bkper add-on for the first time yet

  • Open Bkper Add-on on menu "Add-ons > Bkper > Open"

4 - The Bkper Add-on for G Suite installation is broken.

5 - The copied spreadsheet is broken/corrupted

We identified an issue that happens pretty aleatory when copy a spreadsheet with functions already set. We are currently working closely to Google Engineers to solve it. Here is the internal issue filled.
In the meantime, one possible workaround we have identified is changing the locale and/or timezone of the spreadsheet on menu "File > Spreadsheet settings", like bellow:

After changing and saving it, it should start recognizing the formula. You can set back to the original one after fixed.

2. Error: Invalid Query!

This means the query you are running is not valid. You can copy the query and paste in the Bkper dashboard, to see if it works:

Some tips:

  • When mounting dynamic queries, with TEXT() and '&' concatenation functions, build the query in a cell first, then use this cell as a reference to build the Bkper Formula, like in the Simple General Ledger Report example.
  • Check if the date format of your query matches the same format of the Book Settings.
  • Check quotes around accounts and groups names.
  • Check the operators from the Query/Search guide.

3. Error: Array result was not expanded

This means the result returned from Bkper needs more rows on spreadsheet. Select some in the middle of the dataset and add more rows until the result appears:

Did this answer your question?