Exporting your data to Sage 50 is a two step process:
1. Exporting your data from DealerKit
Follow these steps to export your accounting data:
Log in to your account.
Select your name in the top-right corner, then choose Settings.
From the menu on the left, select Accounting.
Click Start Export.
Choose the date up to which you want to export your data. The export start date will have been configured during your onboarding session.
Click Next. The system will create an export batch.
Review the batch to confirm that it contains the expected data. You can use the search and filter options to find specific entries.
When you are satisfied with the batch, click Finish Export.
The system will create the export file and download it to your computer.
The file is now ready to be imported into Sage 50. Continue to the next section for instructions on completing the import.
2. Importing data into Sage 50
Before starting, make sure you have created a backup of your Sage 50 data.
a. Extract the downloaded files
Open File Explorer and go to your Downloads folder.
Find the ZIP file downloaded during the export process.
Double-click the ZIP file, then select Extract all.
Click Extract. This creates a folder containing the files you need to import.
b. Import customer records
Open Sage 50.
Select File, then Import.
Click Next and select Customer Records.
Confirm that:
Comma-separated (CSV) is selected.
First row contains headings is selected.
Click Browse and open the folder you extracted.
Select the Customers file, then click Next.
Check that both mapping columns are populated with the correct information.
Click Next, then select Import.
After the import, all successfully imported records should appear in the top results window. The bottom window should be empty. If any records are shown as not imported, contact your support team for assistance.
c. Import supplier records
Return to File and select Import.
Click Next and select Supplier Records.
Confirm that:
Comma-separated (CSV) is selected.
First row contains headings is selected.
Click Browse, open the extracted folder and select the Suppliers file.
Click Next and confirm that both mapping columns contain the correct information.
Click Next, then select Import.
d. Import audit trail transactions
Return to File and select Import.
Click Next, then select Audit Trail Transactions – Grouped.
Confirm that:
Comma-separated (CSV) is selected.
First row contains headings is selected.
Click Browse, open the extracted folder and select the Audit Trail file.
Continue through the import process and select Import.
Sage will begin importing the transaction data. This may take some time, depending on the amount of data and whether it is stored locally or on a network.
When the import is complete, check the results. Successfully imported records should appear in the top window, with no records shown in the bottom window.
