Accounting Documents Import
The online accounting program mKsiegowa.pl allows you to import accounting documents from text files. Such files can be prepared, for example, using Excel and saved in CSV format.
Introduction
You can perform the import is in the module General Ledger → Import Multiple Journal Entries
You need to provide the location of the previously prepared file and provide the following parameters:
- the character that separates the fields in the file (usually a comma or a semicolon)
- format of Polish characters
- check the checkbox, if the file has a header row (column names)
The files should be prepared according to the following rules:
- all numbers are in PLN; the decimal position should be separated by a period
- dates given in YYYY-MM-DD format
- in the file, you must use accounts that exist in the chart of accounts; otherwise, the program will generate an appropriate error message
- text fields must be enclosed in apostrophes
- blank lines are skipped
Notes:
- You must import purchase and sales invoices using the correct functions Import of Purchase Invoices or Import of Sales Invoices
- The CSV file should not exceed 1000 accounting lines
File format
| No. | Field Name | Field Type | Comments |
|---|---|---|---|
| 1 | nr_ewid | varchar(100) |
Document reference number. Note: the numbers should be different from the numbers of existing accounting documents in the system. Consecutive lines of the same document should have the same number. |
| 2 | data_ks | date | Accounting date |
| 3 | data_dok | date | Date of the source document |
| 4 | data_op | date | Date of operation / date of economic event |
| 5 | konto | varchar(15) | General ledger account number |
| 6 | projekt1 | int(11) | Project number. Leave blank if the field is not used. |
| 7 | projekt2 | int(11) | Sub-project number. Leave blank if the field is not used. |
| 8 | kwota | double | Posting amount. Positive, if Debit. Negative, if Credit. |
| 9 | opis | tinytext | Description of the items in the accounting document. |
| 10 | suma narastająco | double | Optional field. If it is given, the program indicates on which line there is the difference between the sum calculated cumulatively for the consecutive lines of the document and the value entered in this field. It helps in diagnosing CSV files. |
Notes:
- accounting documents must balance; each value is rounded to the penny;
- documents can be prepared without a header; if the document doesn't have a header, then uncheck the option skip headers
- the program in the current version doesn't support posting in a foreign currency;
- there can be several accounting documents in one text file; documents are distinguished by a reference number;
- a business transaction for a customer's or supplier's account should be given in the format, e.g. 201-xxxxx, where xxxxx - a five-digit contractor's number;