Import from Invoicex
Bring the Invoicex archive into Nanus from its backup file: customers, suppliers, items, invoices with their XML, purchases, due dates, RiBa batches, journal, serial numbers and the other documents. Before importing you choose what to bring.
- Where to find it
- Settings → Import and backup → Import from Invoicex
What it is for
If you worked with Invoicex you do not have to start from scratch: Nanus reads the backup file Invoicex saves, without needing Invoicex or its database, and brings over contacts, items and documents from every year at once. It works in the cloud and on the desktop app.
The file to upload
- The Invoicex backup is a text file with the
.txtor.sqlextension that holds the whole archive. Upload it as it is. - If the backup is inside a
.zipfile, you can upload the.zipdirectly: Nanus finds the file inside it.
Nanus reads the file without running anything in it: it only takes the data of the Invoicex tables. The file can be up to 300 MB.
Import the archive
- In Nanus open Settings → Import and backup and tap Import from Invoicex.
- In Invoicex backup choose the file. Nanus uploads and reads it but writes nothing yet.
- In What to import you find the categories in the archive (company details and settings, customers and suppliers, items and price lists, issued invoices, purchase invoices, delivery notes, orders and quotes, due dates and payments, stock, journal, commissions and agents, attachments) with how many records are new and how many are already in Nanus. Only those the archive contains are shown, all ticked.
- Untick what you do not want to bring over. Whatever the chosen data needs comes in anyway, and the page says so under the category: if you untick Customers and suppliers but import the invoices, the customers of the invoices still come in. If you untick Issued invoices, their due dates stay out, and this too is written under Due dates and payments.
- Tap Import with the number of records. At the end you find Go to documents and Go to customers and suppliers.
If the company details are not in Nanus yet, they are taken from Invoicex. If the archive belongs to a different VAT number, Nanus tells you: the invoices keep the header they had in Invoicex.
You can import the same backup again, or a more recent one: only what is missing comes in, with no duplicates. So you can also import in stages, one category at a time.
What comes into Nanus
- Company details, payment terms, price lists, warehouses and numbering series: the main invoice series continues in Nanus numbering (after “A/106” comes “A/107”), the others, such as those of credit notes and self-billed invoices, become separate numbering series.
- Customers and suppliers with delivery addresses, contacts and notes; items with price lists, supplier and category; agents.
- Invoices, accompanying invoices and credit notes. When Invoicex kept the XML file sent to the SDI, the invoice is the one in the file; otherwise it is rebuilt from the Invoicex data. Pro forma invoices become pro forma quotes.
- Self-billed invoices for purchases from abroad (TD17, TD18, TD19), linked to the purchase invoice they supplement, so VAT is not counted twice in the registers.
- Purchase invoices, also from their XML, with the deductible VAT percentage.
- Delivery notes and goods receipts, customer and supplier orders, quotes, due dates with payments and partial payments, stock movements, document attachments, and recurring invoices, which arrive switched off: check them and turn them on in Nanus.
- The due dates of credit notes, on the side of whoever has to pay: a supplier’s credit note is a credit under Due dates → Receivable, one issued to a customer and not yet refunded is under Payable; both carry a label that says so.
- Serial numbers on invoice, purchase, delivery note and order lines, also on stock movements: in Stock you find where each serial number is and its history. Items that had serial numbers in Invoicex already have serial number tracking on; in rebuilt invoices the serial number is at the end of the line description.
- Packages: the contained item takes the package’s pieces per pack, and the notes of both items say what contains what.
- RiBa and direct debit batches with their due dates, in the Nanus batch numbering. Those whose due dates are all collected show as credited.
- The journal and the entries made by hand in Invoicex, also those of older backups: movements between the cash desk or a bank and a single other account go into the Journal, with the account as category; the others, such as opening balances, become double-entry records. Banks after the first one become new Nanus accounts.
- Invoicex accounts: those that have a role in Nanus (customers, suppliers, cash, bank, VAT, revenue) go to the Nanus account; the others are added to the chart of accounts, under the group of the same nature and with the Invoicex code in the name. Journal categories go to those accounts, unless you have already linked them.
- Notes in full, up to 20,000 characters each.
Numbers, dates and totals stay as they were in Invoicex. Imported invoices are not sent to the SDI again, do not count toward the plan’s documents and do not start automations.
The entries Invoicex made on its own for imported invoices, purchases and payments do not come in: Nanus derives them from the documents and the due dates, so they are not counted twice.
What does not come in
- Entries that do not balance (debit different from credit): the warning says which, and you enter them by hand.
- Batches with no imported due dates, for instance those of invoices you chose not to bring over.
- The VAT detail of journal entries: it stays in the record’s notes, while Nanus builds the VAT registers from the documents.
- Serial numbers in the XML file of invoices already sent to the SDI: the invoice stays the one sent, and the serial numbers stay on the stock movements.
- The make-up of item kits, receipts and simple daily takings, and the due dates of VAT integrations and self-billed invoices (TD16–TD19), which have no due dates in Nanus.
- Invoicex settings, such as print templates and users: in Nanus you choose them in Settings.
Everything skipped or adapted appears in the preview warnings, with one example and how many other identical cases there are.
Common problems
- “This file is not an Invoicex backup”: check you chose the backup file, not an export or a PDF.
- “The Invoicex backup has no data to import”: the backup is empty; make it again from Invoicex.
- “Everything in the archive is already in Nanus”: the backup had already been imported.
Frequently asked questions
Do I need Invoicex or MySQL on the computer where I use Nanus?
No. Nanus reads the backup file on its own.
Are imported invoices sent to the SDI again?
No. They stay transmitted and are not sent again.
Can I import only customers and items?
Yes: untick the other categories. Whenever you like, import the same backup again with the others: only what is missing comes in.
Does the Invoicex journal end up in Nanus bookkeeping?
Yes: entries made by hand come in as journal movements or double-entry records, on the accounts of the Nanus chart. Those generated from documents Nanus derives on its own.