Bkper Bkper

Turn Google Sheets into a Powerful Accounting Tool

Connect your Bkper books to Google Sheets. Build dynamic financial reports, dashboards, and custom analyses — all automatically synced.

What You Can Do

Functions

Live financial data in cells

Use custom Bkper Functions to pull balances, transactions, and account data directly into your spreadsheet. Data updates automatically as transactions are recorded.

Get the add-on

Reports

Balance sheets, P&L, cash flow

Create balance sheets, income statements, and cash flow reports that update in real time. Copy and reuse report templates across clients and entities.

Dashboards

Charts and analyses, your way

Combine Bkper data with Google Sheets' powerful charting tools. Build custom dashboards for expense tracking, revenue forecasting, and any financial analysis you need.

Bkper Functions

Four core functions give you full access to your financial data from any cell.

=BKPER_BALANCES_TOTAL()

Fetch total balances for accounts or groups over any period

=BKPER_BALANCES_PERIOD()

Fetch period-by-period balances for trend analysis

=BKPER_BALANCES_CUMULATIVE()

Fetch cumulative balances for running totals

=BKPER_TRANSACTIONS()

Fetch individual transactions with full query support

How It Works

1

Install

Get the Bkper add-on from the Google Workspace Marketplace.

2

Connect

Link your Bkper books to any Google Sheets spreadsheet.

3

Build

Use Bkper Functions to create dynamic financial reports.

FAQ

  • Is the Google Sheets add-on free?
    Yes, the Bkper Google Sheets add-on is included with all plans, including the Free plan.
  • What are Bkper Functions?
    Bkper Functions are custom spreadsheet functions that pull live data from your Bkper books. For example, =BKPER_BALANCES_TOTAL() returns the balance of an account or group for any period.
  • Can I use it with multiple books?
    Yes, you can connect multiple Bkper books to the same spreadsheet, making it easy to consolidate data from different entities or projects.
  • Does it work with bank connection data?
    Yes, transactions imported via Bank Connections are available through Bkper Functions just like any other transaction.
  • Can I reuse reports across clients?
    Yes. Since Bkper Functions reference books by ID, you can copy a report template to a new spreadsheet and simply update the book ID to generate the same reports for a different client or entity.

Ready to supercharge your spreadsheets?

Install the Bkper add-on and start building dynamic financial reports in Google Sheets.

Get the Add-on