Import Payroll Details/Journal Entries

Menu Navigation

Activities ... Human Resources ... Import Payroll Details

File ... Import Database ... Journal Entries

About Importing Payroll Details/Journal Entries

If you choose to use an external payroll processing company to pay your employees, you can then get all of the financial information they send into ManageMore quickly and easily.  Once you receive their file, simply identify the file type (or define it yourself), tell the software where the file is, and with a couple of mouse clicks, you can have all of your general ledger information updated with your payroll numbers.  This feature can also be used with any other journal entry that needs importing.

This feature requires activation in Setup Human Resources.  Please note that this feature may not be included in your software license.

In this Topic

 Field by Field Help - Import Payroll Details Wizard screen

 Q & A - Import Payroll Details

Related Topics

 14.1        Chart of Accounts

 14.4        Journal Entries

 14.8        General Ledger Posting

 15.10        Import Payroll Details

Field by Field Help - Import Payroll Details Wizard screen

Welcome to the Payroll Import Wizard (Journal Entry Import Wizard)

File Type

Select the type of file to be imported.  Choose from CompuPay, ExecuPay, E-chx, Quickbooks, Paychex, or Other ASCII.

If you select Other ASCII for the File Type, the following field and buttons will be visible:

Import Setup

Select the import setup template to be used in importing this ASCII file.  For more information on how to set up an import template, please see the Importing Data topic.

Edit

Click this button to modify the selected import template.

Delete

Click this button to remove the selected import template from the list.

Select File Name

File Name

Enter or select the name of the file that contains your payroll information.

If you selected Quickbooks for the File Type in the previous wizard screen, the following checkbox will be visible.

Allow only GENERAL JOURNAL transaction types to be imported

Check this box to allow only those transactions marked GENERAL JOURNAL to be imported into ManageMore.

Journal Entry Preview

GL Account

Displays the general ledger account that is being affected by the monies on this line.  This will show as ???? if the GL account number found in the import file does not match one of your general ledger accounts.

If your payroll service is requiring a different GL account number to be used for the payroll of each of the different locations of your company, but you want all payroll to go to one account, you can alleviate this by entering the GL account followed by an asterisk ( * ) or a vertical bar ( | ), followed by the location number.  Upon importing, ManageMore will split the location from the GL account number and place both in the appropriate fields.

Loc

Displays the specific location where this general ledger account is being affected, if any.  If no entry is made here, then the location on the journal entry transaction will be used.

Item No.

Displays the item number from the import file, if any.

Item Description

Displays the description of the monies on a particular line from the import file.

Amount

Displays the monetary amount by which the general ledger account will be affected.

Lookup Account

Click this button to select or change the GL account number for the selected line.

You will not be able to advance to the next screen without having a GL account assigned to each line shown.

Total Debits / Total Credits

Displays the grand total of debits and credits that will post into you general ledger.

Journal Entry Details

Journal Entry ID

Enter an ID for this imported journal entry transaction.

Transaction Date

Enter or select the date on which this imported transaction will reflect.

Location

Enter or select the location on which the imported transaction will reflect.  This location will only affect those lines where a location is otherwise not defined.

Description

Enter an optional description for this journal entry transaction.  This description will also be found on the journal entry transaction.

Date Range

Select a date range that this imported journal entry transaction should represent.  Selecting an item from this list will change the start and end dates below.

Start Date / End Date

Enter or select the start and end dates that this imported journal entry transaction should represent.  Making an entry into either of these fields will change the Date Range field to Custom.

Post Journal Entry to the General Ledger

Check this box to immediately post this journal entry transaction to the general ledger.  Not checking this box will create the transaction, but leave it in an unposted state for further review.

Q & A - Import Payroll Details

	© 2015 - Intellisoft Solutions, Inc. All rights reserved.
	Other Related Links
	Business Software | Cellular Software | Pager Software | Business Management Software