Overview
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 template 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 from the detail records when doing the import. The Data Loader App and Data Import Wizard tool will not support multiple worksheets imported.
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 located on the top row to help you determine the data needed for each column. This row should be deleted prior to saving in *.csv format. Also, remove the legend key.
Access the Data Loader App and Data Import Wizard
- Salesforce Classic: Setup | Data Management
- Lightning Experience: Setup | Integrations
Master Data Import Templates
- Accounting Periods
- Accounting Variables
- Accounts (Customers & Vendors)
- Billing and Labor Rates
- Chart of Accounts (GL Accounts)
- Contacts
- Financial Report Definition
- Project/Job
- Products
- Tax Rate Import Template (HLP)
- Tax Rate Import Template (LLP)
- Purchase Price Import Template
- Recurring Billings
- Recurring Payables
- Taxes
- Time Card Periods
- Warehouses & Locations
Opening Balance Import Templates
Transactional Import Templates
- Amortization Entries (Depreciation, Recognition of Future Revenue/Expense)
- Billings
- Budgets (For PC Only)
- Budgets (For Mac or PC)
- Cash Disbursements and Applications (AP Disbursements)
- Cash Receipts and Cash Applications (Billing Cash Receipts)
- Expense Reports
- Inventory Balance and Inventory Movements
- Journal Entries
- Payables
- Purchase Orders
- Recurring Billings
- Sales Orders
____________________
Comments
12 comments
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!
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.
Another question: Is there a specific reason why the "Use 1904 date system" is marked true on the Journal Entry template?
Hi Rebecca,
I am not seeing this. Is this a setting in excel you are looking at?
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.
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.
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
No Recurring Payable template?
Hi Rebecca,
We are updating these and plan to have them all up by the end of July. For now, you may want to use the recurring billing template and modify it for the payable fields.
Thank you,
Ryan
Is there a template for billig Rates/Cost Rates?
Hi Rebecca,
No there is not, however, you can easily create one on for any object utilizing the field names displayed on the object.
Thanks
Hi Rebecca,
That's a great suggestion, I will create one and put it in the Master Data section.
Thank you,
Ryan
Article is closed for comments.