Payroll File Import

Overview 

Payroll files can be imported into Journal Entries quickly and easily.

Note: This feature is enabled only in the Lightning environment.

Configuration Changes

Important: To use this feature you must enable My Domain in Salesforce. To learn more, view the Salesforce My Domain article. Additionally, set your profile's Payroll File Import Tab setting to Default On.

1. Click the Salesforce Setup icon at the top right corner.
2. In the left menu pane, navigate to  ADMINSTRATION | Users | Profiles and select each profile (one at a time) that should have access to this feature.
3. From the Apps section, select Object Settings.
   
   
   Note: Click here to view the above image in full screen. 
   
   
4. Scroll down the list and select Payroll File Import.
5. If the Tab Settings drop-down list does not display as "Default On," click Edit and select Default On. Then, click Save.
   
   

Import a Payroll File

1. Create a payroll file and save it to your desktop. The payroll file needs to be saved as a .csv file and needs to include the following columns:
   
   Important: These five required columns on the .csv file must be in the order listed below. 
   -- Journal Entry  
   -- Date
   -- GL Account
   -- Debit  
   -- Credit  
   
   The following additional columns are optional and do not require a specific order on the .csv file:
   -- GL Variables 1-4
   -- Account
   -- Project
   -- Project Task
   
   Note: If any of the optional columns are included in the .csv file, they will display when you click Upload File. Additionally, if you include the optional columns, information must already be set up in Accounting Seed. For example, if you include a Project and Project Task, these records must already exist in Accounting Seed. Otherwise, an error message will display when you attempt to create records from the uploaded file.
2. Log into Accounting Seed.
3. Navigate to Accounting Home and click the Create Entries tab. Then, under the Ledger menu, click Payroll File Import.
   Note: If an error message displays when you click Payroll File Import, then you may need to edit your profile's File Import Tab setting. Navigate to Setup | Users | Profiles. Select your profile and edit the Payroll File Import Tab Settings to Default On.
4. On the Payroll File Import page click Upload File.
5. Select a Ledger from the drop-down list, if applicable.
   Note: If you only have one Ledger, it will default. 
6. If you are using a Department as an Accounting Variable, and you have set up Department as one of the fields on Payroll File Import object, select the GL Variable from the Department drop-down list to map your department code to the GL Variable.
7. Click Create Records.
8. Once imported, the Journal Entry will need to be posted to the Ledger.

A sample screen of a payroll import file is below. Or, click here to view a sample payroll import file, which is attached to this article.  

Note: Click here to view the above image in full screen. 

Notes:

• Payroll files can be imported into Journal Entries quickly and easily with this new tool.
• This feature is available for the Lightening UI. 
• Configuration Changes:
  • To use this feature you must enable My Domain in Salesforce. To learn more, view the Salesforce My Domain article.
  • To use this feature, set your profile's Payroll File Import Tab setting to Default On.