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 import 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 accounts on Sheets appear as the same color as the accounts type.

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 sell you want.
  7. Click Fetch button.
  8. That's it! Now the Name, Type, Group of your accounts appear on Sheets.
Did this answer your question?