Import Journal Entries - Drag N Drop 

If you have standard journal entries that you need to make each month, you can setup an Excel Drag n Drop file that can be used to populate the distribution lines in the journal entry. You can use formulas to calculate the amounts and the displayed answer will be imported. 

NOTE:  The drag-n-drop feature can process Password Protected Excel files. If the .xls or .xlsx spreadsheet is password protected, Excel must be installed on the computer.  Spreadsheets without a password does not require an Excel installation.

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. 

Create Excel File

  1. In MS Excel, you must have a worksheet with the following column headings in Row 1.
    1. Column A:  Account
    2. Column B:  IFC  (Optional) Horizon Financials Version 16.190.4.10 or later is required for this feature
    3. Column C:  Memo
    4. Column D:  Date
    5. Column E:  Debit
    6. Column F:  Credit
    7. Column G:  Source (Optional)
    8. Column H:  Reference (Optional)
  2. Starting in Row 2, enter your line items for your journal voucher
  3. Every row should contain a Journal Entry.
    1. Do not leave any blank rows, the first Column "account" must be filled in.  
    2. Do not place documentation or calculations in rows between entries.
    3. Calculations and documentation may be placed in columns to the right of the required columns or on another sheet.  
    4. Add a column heading such as "Documentation" to each column containing information you wish to save.
    5. Error messages will overwrite columns with no header.
  4. The Drag-n-Drop process only imports information from the first sheet.
  5. Your worksheet should look like this:
  6. The IFC, Source, and Reference columns are Optional.
  7. The Debit and Credit columns can be formulas to calculate the amounts. The displayed answer will be imported.
  8. 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.
  9. 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.

Drag n Drop Excel File

NAVIGATION: ACTIVITIES menu > Journal Entry

  1. 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.
    1. 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.
  2. 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.)
  3. The line items on the Journal Entry screen will fill from your excel file.
  4. If there are any errors in the spreadsheet, you will receive the error message "Errors found - please refer to spreadsheet".
    1. Press OK to close the error message.
    2. No data will be saved in the JV if an error was detected.  
    3. Open your spreadsheet.  
    4. In the first column with no header an error message will save in rows in which an error was detected.
    5. Correct the spreadsheet then try to Drag-N-Drop again.
  5. Check that the entry is in balance.
  6. Press SAVE or APPLY and follow the normal Edit and Posting procedure.

See: How to Enter a Journal Voucher or Cash Receipt

Sample DND File

Drag N Drop JV.xls

4/2021

 

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388