# Google Sheets Add-on

> Connect your Bkper Books to Google Sheets for custom reporting, data analysis, and automated Transaction recording.

The Bkper Add-on for Google Sheets connects your Bkper Books to Google Sheets in both directions — fetch live data from Bkper for reports, and record data from Sheets into your Books.

For the complete reference — all Bkper Functions, column headers, recording behavior, and Auto Record — see the <a href="https://github.com/bkper/bkper-sheets#readme" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_readme" data-analytics-label="Google Sheets Add-on README">Google Sheets Add-on README</a>.

## Tutorials

- <a href="/docs/guides/google-sheets/install" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_install" data-analytics-label="Install the Add-on">Install the Add-on</a> — step-by-step installation and sidebar walkthrough
- <a href="/docs/guides/google-sheets/first-report" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_first_report" data-analytics-label="Build Your First Report">Build Your First Report</a> — hands-on tutorial from zero to a working balance report
- <a href="/docs/guides/google-sheets/identifiers" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_identifiers" data-analytics-label="Unique, Transaction, and Remote IDs">Unique, Transaction, and Remote IDs</a> — understand how identifiers work together to prevent duplicates and enable updates

## Report Templates

Working examples of complete reports built with Bkper Functions:

- <a href="/docs/guides/templates/financial-statements" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_financial_statements" data-analytics-label="Financial Statements">Financial Statements</a> — Balance Sheet, Income Statement, and Retained Earnings on Google Sheets
- <a href="/docs/guides/templates/profit-and-loss" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_profit_loss" data-analytics-label="Profit and Loss">Profit and Loss</a> — Dynamic P&L report using balance period functions

## Troubleshooting

For common issues with Bkper Functions, see <a href="/docs/guides/troubleshooting/known-issues-google-sheets" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_known_issues" data-analytics-label="Known Issues - Google Sheets">Known Issues - Google Sheets</a>.

## Source

The Add-on is free and <a href="https://github.com/bkper/bkper-sheets" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_github" data-analytics-label="open-source on GitHub">open-source on GitHub</a>. Install it from the <a href="https://workspace.google.com/marketplace/app/bkper/360398463400" data-analytics-event="cta_click" data-analytics-id="docs_google_sheets_marketplace" data-analytics-label="Google Workspace Marketplace">Google Workspace Marketplace</a>.

- [Build Your First Report](https://bkper.com/docs/guides/google-sheets/first-report.md): A hands-on tutorial that walks you through fetching live balance data from Bkper into Google Sheets and building a simple financial report.
- [Unique, Transaction, and Remote IDs](https://bkper.com/docs/guides/google-sheets/identifiers.md): Understand the differences between Unique IDs, Transaction IDs, and Remote IDs when working with Google Sheets and Bkper.
- [Install the Add-on](https://bkper.com/docs/guides/google-sheets/install.md): How to install and authorize the Bkper Add-on for Google Sheets from the Google Workspace Marketplace.