To enable Lucanet to identify which data are to be imported, one of the two keywords must be specified in column A. It is also possible to specify both keywords together as frequently as desired and in any order.
Together with the Value column, the keywords Posting and Auto posting form a matrix structure whose interfaces define the values to be imported.
For postings of one-off or rare business transactions.
Note: To ensure an integrated balance sheet, P&L, and cash flow statement at this time, only complete postings can be imported into Lucanet. The following applies for every column containing postings: Debit = credit.
By entering the Auto posting keyword, Lucanet recognizes that the delivered account description is for an account for which a contra entry has been defined in the Lucanet journal. This contra entry is listed automatically.
You can use the Posting keyword to reflect business transactions with the Excel workbook LUCANET in Lucanet. These postings can also be made directly in Lucanet via a manual posting.
The following keywords are required and must be included in the Column definition row in MS Excel.
Keyword
Parameter
Account
Defines that this column contains the account/item descriptions for the import
Value
Defines that the column contains the values to be imported
Debit
This keyword can be used instead of the keyword Value in order to assign additional information to the corresponding value, indicating that it is a debit value.
Credit
This keyword can be used instead of the keyword Value in order to assign additional information to the corresponding value, indicating that it is a credit value.