Export Data from Bkper

You own the data in your Bkper Books and can export it at any time. Common reasons to export:

• Make periodic backups
• Merge or copy transactions to another Book
• Use the data in another system

Exporting to Google Sheets

Use the Bkper Add-on for Google Sheets to export data directly into a spreadsheet.

Open the add-on from Extensions > Bkper > Open:

Select your Book, choose Transactions, enter a query that covers the date range you need (for example, before:$y+10 to include all transactions), and press Fetch.

All matching transactions are exported to the spreadsheet:

Tip

• To export all transactions, use a query that spans the entire date range of your Book, such as before:$y+10.
• Attachments are exported as links.
• Enable the Properties option in the add-on to include custom property keys and values.
• Each time you open the Google Sheet, Bkper Functions automatically refresh the fetched data.
• From Google Sheets you can download the data as CSV, Microsoft Excel, or PDF.

To copy or merge transactions into another Book, export them to a spreadsheet first, then import them into the target Book.

BkperApp for Google Apps Script

The BkperApp library for Google Apps Script gives you programmatic access to export data to any destination you need.

Batch exporting Accounts

The Bkper Add-on for Google Sheets lets you export all Accounts from a Book in one step. This is useful for creating backups, building templates, or reviewing your Account structure outside of Bkper.

Open a Google Sheet and go to Extensions > Bkper > Open. Select your Book, switch to the Fetch tab, and choose Accounts. Click the cell where you want the data to start, then press Fetch.

The Name, Type, and Groups of each Account are listed in the spreadsheet, ready for reuse as a template or further processing.