How to Import From Excel in Bookkeeper

In Bookkeeper, we can import all data from excel however there are some specific formats for ledgers and transactions.

Import item/services from Excel

Go on Dashboard > Tools > Import item/services from Excel

There are 3 steps to import Items/Services:-

Select Inventory Items/services.

Download the sample excel file from the below link to import new items.

If you want to update the existing items then you can download existing items in excel and then update them.

Fill data in according to the fields given in the sample excel file and save it.

Browse the excel file and open it to import it.

If you are updating the existing items then you need to click on Update Existing Items.

If you are importing new items then you need to click on Ignore Existing Items.

Click on Start Import

Then you can check the imported items and services.

Import Customers/Suppliers from Excel

Go on Dashboard > Tools > Import Customers/Suppliers from Excel

There are 3 steps to import Customers/Suppliers:-

Select Customer/Supplier/Other Accounts/Employee (For Payrolls).

Download the sample excel file from the link enclosed just below the Import type option to import Customers or Suppliers. Fill data in according to the fields given in the sample excel file and save it.

Browse the excel file and then open it.

Click on Start Import.

Then you can check the imported data of customers and suppliers.

Import Transactions from Excel

Go on Dashboard > Tools > Import Transaction from Excel.

Here you will get the option to import any kind of transaction shown in the dropdown list in the image.

There are 3 steps to import Transactions:

Select Import Type

Download the sample excel file from the link enclosed just below the Import type option to import the transaction. Fill data in according to the fields given in the sample excel file and save it.