Action Required: Bkper Add-on Function Change May Impact Your Periodic Reports

[Jacob van den Berg]

Hi Everyone, 

We have made an important change to the BKPER_BALANCES_PERIOD function in our Google Sheets add-on that may affect your existing reports.

What's Changing

The default output format for the transposed parameter (5th parameter) is being updated to improve usability and align with our Balance Sheet function.

Current Default (transposed = FALSE):

Date                 Account A       Account B
01/01/2022    200                    200
01/02/2022    300                    300

New Default (transposed = FALSE):

                      01/01/2022         01/02/2022
Account A       200                      300
Account B       200                      300

Why This Change

This new format is more intuitive for users and AI tools, and provides better consistency with our Balances function.

How to Fix Your Reports

If your reports break after this update, simply flip the transposed parameter in your function:

• If currently using FALSE, change to TRUE
• If currently using TRUE, change to FALSE

Example: 

Change: =BKPER_BALANCES_PERIOD(bookId, 1, query, FALSE, FALSE, FALSE) 

To: =BKPER_BALANCES_PERIOD(bookId, 1, query, FALSE, TRUE, FALSE)

Timeline

This change is implemented today.

We apologize for any inconvenience and appreciate your understanding as we continue to improve Bkper.

Please let us know if you need any assistance with this change, we are here to help! 

Kind regards, 

Jacob