Revised: 05/28/2020
NOTE: In order to use the drag-n-drop feature, users must have Microsoft Excel 2003 or higher installed on the workstation that will be used to drop the journal vouchers into Horizon. The worksheet can be created and saved by workstations with earlier version of Excel. The spreadsheet must be saved as format .xls or .xlsx.
IFC Code usage in Journal Entries became functional in Financials Version 16.190.4.10 - 05/08/2020. IFC should not be used in earlier versions.
In MS Excel, you must have a worksheet with the following column headings in Row 1. You may also download a sample file from ftp://ftp.horizon-is.com/documents/Downloads/Drag N Drop JV.xls to use.
Column A: Account
Column B: IFC - Horizon Financials Version 16.190.4.10 or later is required for this feature
Column C: Memo
Column D: Date
Column E: Debit
Column F: Credit
Column G: Source
Column H: Reference
Starting in Row 2, enter your line items for your journal voucher
Every row should contain a Journal Entry. Do not leave any blank rows, the first Column "account" must be filled in. Do not place documentation or calculations in rows between entries. Calculations and documentation may be placed in columns to the right of the required columns or on another sheet. Add a column heading such as "Documentation" to each column containing information you wish to save. (Error messages will overwrite columns with no header.)
The Drag n Drop process only imports information from the first sheet.
Your worksheet should look like this:
The IFC, Source and Reference columns are Optional.
The Debit and Credit columns can be formulas to calculate the amounts. The displayed answer will be imported.
If you are calculating the entries in other Excel worksheets that do not match this format, you can copy and paste the figures from that worksheet into a template you save for Drag-N-Drop. You should use the Paste Special command and paste Values Only.
When your worksheet is complete, save the worksheet as you normally would and close the Excel file. Import process may not work if the spreadsheet is open in Excel.
Open the folder that contains your Excel File and resize the Horizon program window so that you can see the unopened Excel file and the Journal Entry screen simultaneously.
TIP: You may also leave both windows full screen, start with the folder containing your Excel file. Left click the file and hold while dragging it down to the Start bar to the Horizon Financials button. This will cause Horizon Financials to maximize and you may drag the file to the journal voucher screen.
Drag the Excel file onto the Journal Entry screen and Drop it on the Journal Entry screen. (You should see a “+” sign indicating that you can drop the file.)
The line items on the Journal Entry screen will fill from your excel file.
If you receive the error message "Errors found - please refer to spreadsheet" press OK to close. No data will be saved in the JV if an error was detected. Open your spreadsheet. In the first column with no header an error message will save in rows in which an error was detected. Correct the spreadsheet then try to Drag N Drop again.
Check that the entry is in balance.
Press Save or Apply and follow the normal Edit and Posting procedure.