In all screens that have lists, overviews, balances, drafts, etc. you can both export and import between Uniconta and Excel.
Export is used, for example, to read data from posting overviews, balances, reminder lists, etc. to Excel for further processing.
Import is used, for example, to import postings to the accounting draft etc. The possibilities are many.
Watch a short VIDEO on how to update data in Uniconta from Excel.
When all (or the desired) lines are selected:
Key Ctrl+C (Copy) to copy to clipboard.
Or click on the icon Cut to Clipboard icon in the toolbar at the top of the Uniconta screen.
Then open the following Save As-dialog box opens. Select location and enter a file name and click Save as.
You are then automatically back in Uniconta, the Excel file will not open automatically. Open the saved Excel file by selecting it where you chose to save it.
As mentioned above, if you are copying data from Excel to Uniconta, the column headers must be included in the range/cells being copied to Uniconta. Otherwise Uniconta will not know where to place the data.
The function has two methods: The first method is "Update line by line" and is used when you have opened a screenshot, copied all the lines from here to Excel and changed data in Excel. You will now copy the data back into the same screen, which is still open and has exactly the entries that were copied into Excel. This allows Uniconta to assume that line 1 in the screenshot is equal to line 1 in Excel and so on.
The second copy method, "Update from key values" is based on "keys". That is, one or more fields that uniquely identify the line. In master records it is the number field (item number, account number, etc). In other screens, the unique field may not be visible. In the cash journal and order lines, the unique field is "line number", and here you have to drag the field via the layout menu and copy it to Excel. When you copy back, Uniconta uses this field to identify the item to be updated with data from Excel. In price lists, several key fields are needed to identify the unique line (item number, item group, discount group and quantity).
Problems importing data into Uniconta:
Export to Excel
Exporting is basically copying data to Excel. There are two ways:- Export to open Excel sheet, copies only selected lines.
- Export to new Excel file, copies all lines in the screenshot.
When all (or the desired) lines are selected:
Key Ctrl+C (Copy) to copy to clipboard.
Or click on the icon Cut to Clipboard icon in the toolbar at the top of the Uniconta screen.
Export to open Excel sheet
Copies only selected lines. Open the Excel sheet where you want to paste data. Data is pasted into the sheet where the cursor is placed when you select Paste data. Ctrl+V (Paste from clipboard) or right-click and select Paste in the right-click menu.Export to new Excel file
Copies all lines in the screenshot. Click on the icon Export to Excel icon icon in the toolbar at the top of the Uniconta screen.
Then open the following Save As-dialog box opens. Select location and enter a file name and click Save as.
You are then automatically back in Uniconta, the Excel file will not open automatically. Open the saved Excel file by selecting it where you chose to save it.
Column headers are important in Excel
Column headers are copied from Uniconta to Excel. This is useful so you can see which fields the columns and data come from. But especially if you need to get data back to Uniconta, because the column headers must be included in the import file from Excel for Uniconta to place data in the correct columns. In this case, financial records have been copied to Excel, notice the column headers:
As mentioned above, if you are copying data from Excel to Uniconta, the column headers must be included in the range/cells being copied to Uniconta. Otherwise Uniconta will not know where to place the data.
Import from Excel
In all input screens (drafts and lines), data can be imported from Excel. All that is required is that column headers in the Excel sheet match field names/column headers in Uniconta and that the data matches the format in Uniconta. To get the correct column headings, the easiest way is to export the screenshot from Uniconta to Excel, so you automatically get the entire setup from Uniconta to Excel with the correct column headings. It goes without saying that the Excel sheet and the screen imported into Uniconta must be of the same type, e.g. accounting draft to accounting draft, stock draft to stock draft, order lines to order lines. Here's how you do it:- Copy all import data from the Excel sheet, including column headers.
- Open the screen in Uniconta where you want to copy the data to.
- Select the first line/place the cursor in the first line where you want to insert data.
- Key Ctrl+V(Paste) or select Clipboardicon/Paste from Excel at the top of the toolbar. And existing records/lines in Uniconta are not overwritten.
The function has two methods: The first method is "Update line by line" and is used when you have opened a screenshot, copied all the lines from here to Excel and changed data in Excel. You will now copy the data back into the same screen, which is still open and has exactly the entries that were copied into Excel. This allows Uniconta to assume that line 1 in the screenshot is equal to line 1 in Excel and so on.
The second copy method, "Update from key values" is based on "keys". That is, one or more fields that uniquely identify the line. In master records it is the number field (item number, account number, etc). In other screens, the unique field may not be visible. In the cash journal and order lines, the unique field is "line number", and here you have to drag the field via the layout menu and copy it to Excel. When you copy back, Uniconta uses this field to identify the item to be updated with data from Excel. In price lists, several key fields are needed to identify the unique line (item number, item group, discount group and quantity).
Problems importing data into Uniconta:
- Most errors are due to data not matching Uniconta in format or valid value. For example, you can't copy in incorrect account numbers, letters in amount fields or unknown VAT codes. You have to go back and correct, check and try again.
- You have selected the wrong screen to copy to.
- You have not created a new blank line in the screen to copy data to.
- A line to copy data to is not selected.