All Collections
Using Bkper
Import and export accounts quickly
Import and export accounts quickly
Streamline the chart of accounts management by importing and exporting accounts in a bulk
Raquel Esper avatar
Written by Raquel Esper
Updated over a week ago

Use Bkper add-on for Google Sheets to quickly manage accounts. It's a direct way to import or export an existing chart of accounts between Bkper and Google Sheets. With this solution you can easily create accounts in batch.

Import accounts from Sheets to Bkper (Record)

  1. On your computer, open a Google spreadsheet.

  2. Click Add-ons > Bkper > Open.

  3. Select your book.

  4. Click Record tab.

  5. Choose Accounts.

  6. Highlight the cells you want to import data.

  7. Click Record button.

  8. That's it! Now, the accounts appear on your book.

Note: Observe that the account background on Sheets will have the same color as its Type if the "Highlight" checkbox is selected.

Export accounts from Bkper to Sheets (Fetch)

  1. On your computer, open a Google spreadsheet.

  2. Click Add-ons > Bkper > Open.

  3. Select your book.

  4. Click Fetch tab.

  5. Choose Accounts.

  6. Select the cell you want.

  7. Click Fetch button.

  8. That's it! Now the Name, Type and Groups of your accounts appear on Sheets.

Did this answer your question?