PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Collapse]Financials
    [Expand]Accounting Basics
    [Collapse]Posting
      Header – Journal Entry
     [Collapse]Toolbar – Journal Entry
      [Collapse]Import/Export Data – Journal Entry
        Show documents
        Import documents
        Show documents in grid
        Import Journal Entry from Excel File
        Import Journal Entry from Excel File - Custom
      [Expand]Wizards – Journal Entry
     [Expand]Lines – Journal Entry
      Additional Journal Entry Fields for Foreign Currency Posts
     [Expand]Journal Entry Buttons
     [Expand]Errors in Journal Entry Creation
     [Expand]Invoices Received in Accounting Firms
     [Expand]Invoices Issued in Accounting Firms
      Deleting of "Invoices in Accounting Firms"
    [Expand]Automatic Posting
    [Expand]Accounting Dashboard
    [Expand]Overview
    [Expand]Close
    [Expand]Accruals and Deferrals
    [Expand]Credits and Leases
    [Expand]Reports
    [Expand]Special Reports
     Consolidated Financials Statements
    [Expand]Fixed Assets
    [Expand]Transactions
    [Expand]Debt Collection
    [Expand]Reminders
    [Expand]Year-end
    [Expand]Interest
    [Expand]Cash
    [Expand]Archive
     ZEUS Planning
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 391.0174 ms
"
   1000005682 | 225087 | 409466 | Updated
Label

Import Journal Entry from Excel File - Custom

010381.gif 010411.gif 010382.gif 010383.gif

This function is used for importing entries from an Excel file according to a predefined structure in a customized manner. 

It can be accessed by clicking the  (Import/Export Data) button.

File Path

File path to the Excel file.

Open

Opens the Excel file before import.

Transfer

Transfers the data into the journal entry.

Register Overview

PANTHEON checks if the prepared data matches the existing registers in the program.

Fill In Missing Registers on Transfer

If checked, enables you to add the missing entries in registers (subjects, chart of accounts, cost centers) upon transfer.

Convert to foreign currency from local currency

Converts to the currency entered in the Excel file based on the entered exchange rate and currency.

Convert to local currency from foreign currency

Converts to the local currency from foreign currency entered in the Excel file based on the entered exchange rate and currency.

Import only data without errors

If checked, the program will only import data with no errors to the journal.

If not checked and if data with errors exists, program will not perform the import (regardless of whether the data contains errors or not) and will display the following information window:

If amounts in colum Debit and/or Credit consist of more than two decimal places, following IRIS appears:

 

In the column of the Custom settings tab, you first need to define the sequence of columns according to the Excel file structure (can be changed any time):

  • Journal entry number (if you want to import data into a specific journal entry)
  • Period date for journal entry (if you want to import data into a specific journal entry)
  • Account
  • Subject
  • Debit
  • Credit
  • Document
  • Linked Document
  • Document Date
  • Value Date (Due Date)
  • Currency
  • Exchange Rate
  • Department
  • Cost Center
  • Note
  • Contra Account
  • VAT Date
  • External Document
  • Status (cannot be automatically populated upon transfer)
  • Status name
  • Value Debit (by default, the currency values are populated according to the exchange rate if there is no value entered here)
  • Value Credit  (by default, the currency values are populated according to the exchange rate if there is no value entered here)
WARNING

To import data to the currently open journal entry, you need to specify the Journal entry number and Period date for journal entry of the given journal entry in the Excel file before import.

 

 

related topics:

  Journal Entry Toolbar  

  Import/Export Data

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!