Install Bkper Add-on for Google Sheets
The Bkper Add-on for Google Sheets connects your Bkper Books to Google Sheets, enabling custom reports, data analysis, and automated Transaction recording. Here's how to install and authorize it.
Installing the Add-on
Open a new or existing Google Sheet and navigate to Extensions >> Add-ons >> Get Add-ons. Search for "Bkper" and select it from the results. Click Install, then Continue, and choose your Google account. Review the permissions Bkper requires and click Allow to complete the installation.
Authenticating for First Use
The first time you use the Add-on, you'll need to connect it to your Bkper account.
Open the Add-on from Extensions >> Bkper >> Open.
In the sidebar, click Sign in with Google and select the account associated with your Bkper Books.
Once authorized, close the confirmation window and you're ready to use the Add-on.
What's Included
The Add-on provides several features accessible from Extensions >> Bkper:
Bkper Sidebar — Browse and select Books directly within Sheets.
Auto Record — Automatically record Transactions from spreadsheet data.
Update — Refresh all Bkper functions in your sheet with current data.
Generate Transaction IDs — Create unique identifiers for Transactions.
Bkper Functions — Type =BKPER_ in any cell to access custom functions for pulling Account balances, Transaction data, and more.