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
2 - Your Google Spreadsheet Locale does not match your region locale.
- Set your Spreadsheet Locale to a locale close related to your region
2. Error: Bkper API Unauthorized
Authorize the Bkper API by opening the Add-on for the first time:
1) On sheets menu, click on Add-ons >> Bkper >> Open
2) On sidebar, click on "Get started" and authorize the API
3) After the Add-on authorized and opened, reload your Spreadsheet
3. 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:
- 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.
4. 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: