Menu

Search

Knowledge Base


15103: Import a Spreadsheet (DAS)


Tools

Drake Accounting®: How do I import information from a spreadsheet?

 

In Drake Accounting®, you have the option to import spreadsheets for as many clients as desired. Here is an example of how to import employees.

Go to Tools > Spreadsheets.

Select the Import tab at the top.

Click Browse and find the .CSV file you wish to import for your client and click Open.

The spreadsheet you wish to import must have the same layout as the blank template in order for the import to be successful.

You are given a list of options that you can import including: EmployeesVendorsCustomersSales TaxJournal Entries, Chart of AccountsInvoice ItemsEmployee BenefitsEmployee DeductionsMICR BankDivisions, Report Options, and Bank Import.

Note: When choosing the Bank Import option, transactions may be created from the selected file. These will appear under Accounting > Transactions > Unposted.

You can choose which properties within a group you wish to export in the middle of the window. You can either select each property individually, or you can check the box next to Properties Detected which will select all available properties.

Click Import.

You are given a data preview to make sure that the data about to be imported is correct. You can either select the individual employees you wish to import or you can check the box next to Employee Code to import all of the employees from the spreadsheet.

Click Import when you have finished previewing the spreadsheet data, if the information looks correct.

Once the spreadsheet has been imported, you can now double check the entries within Employee Setup. Go to Employees > Employee Setup.

Go through each employee to double check the entries. If there are any setup items that need to be adjusted, you can make the changes on this screen.

Below are the blank templates you may use to get the correct format to import spreadsheets. ​ After editing, be sure to save the file as a .csv file type.


Attachments

Blank Employee Template.csv 1.00 KB, 1.2K views
Blank Crystal Reports Template.csv 387 bytes, 955 views
Blank Divisions Template.csv 32 bytes, 721 views
Blank MICR Bank Template.csv 272 bytes, 1.1K views
Blank Invoice Items Template.csv 992 bytes, 962 views
Blank Journal Entries Template.csv 68 bytes, 2.3K views
Blank Sales Tax Template.csv 204 bytes, 737 views
Blank Customer Template.csv 460 bytes, 939 views
Blank Vendor Template.csv 216 bytes, 1.1K views

Also In This Category


On a scale of 1-5, please rate the helpfulness of this article


Not Helpful
Very Helpful
Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


Details
Article has been viewed 17K times.
Last Modified: Last Year
Rated 2 stars based on 1 vote
Options