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 Spreadsheet copy is broken.

  • Make another copy of the broken spreadsheet.

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


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?