Moving from Doctor Accounting or another program
Bring products, customers, suppliers, balances and the transaction history from your old program to Vende with Full Data Import.
On this page
Already using another cashier or accounting program? You do not need to type your old data again. Vende has Full Data Import to move everything at once: products, customers, suppliers, balances and the transaction history.
Choose the way that fits
- Only the list of goods and customers. Import them from Excel, then enter the opening balances. See Adding products and customers and Entering opening balances.
- All data and the transaction history. Use Full Data Import. The steps are below.
Preparing the import package
Full Data Import reads one Import package: a ZIP file holding several CSV files, one per kind of data.
- From Doctor Accounting: contact the Vende team. The Vende team makes the import package from your Doctor Accounting data.
- From another program: contact the Vende team first to ask whether the data can be moved. Someone who knows the data well can also build the package themselves. Its layout is in the template you can download on the import page.
Expense and income categories may nest. In the category templates, the parent_key column points to the parent, and the parent's row comes first. From Doctor Accounting, the expense and income groups become parent categories, and their subcategories become their children.
Running the import
Full Data Import is an extra feature, and only the shop owner can run it. If its menu is missing, contact the Vende team to switch it on.
- Open Settings → Full Data Import.
- Choose the file in Package file (ZIP).
- Choose History brought over: All history, or From a date.
- Press Check package. Vende reads the package without saving anything. A big package can take a quarter of an hour or more in the background; you may close or reload the page, because when you open it again it shows "The package is being checked" or the result (kept for 6 hours), and the package does not need to be uploaded again.
- Read the Package check: the number of records, the rows that will be refused, the opening balances that will be added, and the estimated time.
- Press Start import. Vende asks once more whether the shop is the right one. Press the Yes, import into button with your shop's name.
The import cannot start when the package needs a feature that is not on for this shop yet, for example Serial numbers or Services. The package check says what needs sorting out. The Vende team switches features on. See Extra shop features.
When you choose to start from a date, documents before that date are not created. The stock, the cash and the unpaid notes on that date are brought over as opening balances.
Important: While the import runs, it is best not to use the shop for new transactions yet. That way the import can still be taken back cleanly if something is wrong.
During and after the import
The import runs in the background, bit by bit, so it does not get in the cashier's way. The progress bar on the same page shows the time left. The result is also announced on the bell.
When it is done, press Report in the import history. The report shows:
- the refused rows with their reasons;
- the warnings from the import;
- Reconciliation: the cash, receivable, payable and stock balances, and the sales, purchases and profit per month, compared with the figures in the package.
In Activity History the import is kept as one summary: who ran it, when, from which program, and how many records of each type came in. The records the import creates are not recorded one by one, so the shop's history stays short. Changes after the import are recorded as usual.
The opening balances that Vende adds are already shown beforehand in the Package check.
Old note numbers are not lost. Vende gives new numbers, and the old number is written in the document's note.
Stock and cash that used to be negative
An old program sometimes records negative stock. In Vende, stock that used to be negative is given an opening balance on the earliest date, so the figures make sense. Cash that is negative at the end of a day is also given an opening balance, unless the package asks for the cash to be left as it was in the old program. All these opening balances are marked "Opening balance moved from" followed by the old program's name.
Taking an import back
The result is not what you expected? As long as the shop has not been used for new transactions after the import, press Take back import in the import history. A full backup is made first. Only the data from that import is deleted. The shop's data from before the import stays.
When an import stops halfway (status Failed), press Resume. Data that is already in is not created twice.
Supporting reading
Articles on the background and the arithmetic.