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:
   • Journal Entry Name 
   • Date
   • GL Account
   • Debit Amount
   • Credit Amount
   • GL Variables 1-4 (Optional columns to add)
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 MyDomain 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.