You may enter client expenses in a spreadsheet to import into Expense Entry.
To do so, set up an Excel spreadsheet. The column headers are as follows. Column headers with an * are required
o TRAN CODE *
o MOD DESC
o TRAN DATE *
o AMOUNT *
o CLIENT *
o PAYGROUP
o VENDOR NUMBER *
o REFERENCE
o AP (VALUE = Y OR N) *
o SC (VALUE = Y OR N)
o INVOICE
You may save the sample spreadsheet which will download from the following link:
ftp://ftp.horizon-is.com/documents/Downloads/RP-import.xls
· Do not add any information below your last line of data.
· Do not insert any blank lines between your data.
· Do not format the number columns with commas or $.
· You may format number columns to show decimal places.
· AP is the checkbox for Interface to AP. Must be Y to send to AP and cut a check.
· SC is for Separate Check.
· If Paygroup is blank the import will use the Client’s default paygroup.
· Make sure the spreadsheet is closed before importing.
In Horizon Rep payee, go to Utilities>>Imports>>Import Expense Information
Import Format: Excel Spreadsheet
Path/File Name: Browse for the spreadsheet location and select it
Press the Import button. When the Activity box disappears, press the OK button.
Go to Activities. Review the Expense Edit List to verify the import is correct.
If the import process detects an error in the file, a stop error will appear Errors found – please refer to spreadsheet. Open the spreadsheet: for each record that an error was detected an error message describing the problem will be save to the right of the record. Please review and fix the file, then import again.
After importing, run the Expense Edit List and Post Expenses as normal.