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?