This page contains Import Templates for key Objects (Data Tables) in Accounting Seed. Import Templates can be opened in Excel and must be saved in *.csv format for uploading with the Salesforce Data Loader App or web-based Data Import Wizard tool.

Several of the files contain two worksheet tabs for master/detail records. For example: Billing [Header] (master) and Billing Line (detail). The master records should be saved in a separate *.csv file, than the detail records, when doing the import. The Data Loader App and Data Import Wizard tool will not support multiple worksheets in an Excel workbook.

If you are modifying your Chart of Accounts, then create a map from your legacy GL accounts to your new GL accounts so that the opening trial balance is easy to import into Accounting Seed. You can use the Chart of Accounts Import Template to keep everything in one file.

There is an instructional text row to help you determine the data needed for each column. This row should be deleted prior to saving in *.csv format.

 

Access the Data Loader App and Data Import Wizard:

  • Salesforce Classic: Setup > Data Management
  • Lightning Experience: Setup > Administration > Data

 

Master Data Import Templates
Transactional Import Templates

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

7 Comments

  • 0
    Avatar
    Rebecca Ralls

    Hi there,  I was wondering if you have updated templates for Customers & Vendors (and any other objects that might require it?) reflecting the new default GLAV fields.  Also - I don't see a template for contacts - is that just because there aren't any AS specific fields on the contact record? I had thought it might be a separate tab on the Customer & Vendor template, but there isn't one there. Thanks!

  • 0
    Avatar
    Tony

    Thanks Rebecca. We will update the account import template for the new variables. We don't have a contact import as there is nothing really significant for AS on this object. We are also trying to discourage the use of a contact as a payee and setup all payees as accounts.

  • 0
    Avatar
    Rebecca Ralls

    Another question: Is there a specific reason why the "Use 1904 date system" is marked true on the Journal Entry template? 

  • 0
    Avatar
    Tony

    Hi Rebecca,

    I am not seeing this. Is this a setting in excel you are looking at?  

  • 0
    Avatar
    Rebecca Ralls

    Yes. When I download a new copy of the  template, and you go to File -> Options -> Advanced and scroll down to "When Calculating this workbook:" there is an option called "Use 1904 date system". and it is checked.   

    When it is checked, you'll notice that if  you copy a date from a 'regular' spreadsheet  into a spreadsheet with the 1904 system active that the displayed date is 4 years and a day different than the original date.

    If  you copy and paste dates into the template and then upload them, Salesforce gets the date right,  but if you type the dates directly into the template the underlying serial number is different and you get the wrong dates when you do the upload.

  • 0
    Avatar
    Rebecca Ralls

    Idea/Feature Request: https://support.accountingseed.com/hc/en-us/community/posts/115008290787-Implementation-Mapping-Templates

    It would be helpful to explicitly remind users (or even provide them with templates) to maintain mapping documents from old values in their legacy system to new values in the SF/AS system  for Chart of Accounts, Accounts/Contacts & Products.

  • 0
    Avatar
    Ryan Faulkingham

    Hi Rebecca,

    With our adoption support package, if clients are modifying their chart of accounts, then we do instruct them to map old accounts to new ones so that the opening trial balance is easy to export and import into Accounting Seed. Most clients will do this directly in the chart of accounts import template so that everything is in one file and not two separate files. 

    Thank you,

    Ryan

Please sign in to leave a comment.