# Switching over from Excel or another package

Source: https://goldmary.eu/en/manual/switching

When you have followed this manual your customers and open invoices are in Goldmary, and your invoice numbering carries on where it was.

## What you need

- An export from your old package: an audit file (XAF), or your customers and open invoices as Excel or CSV.
- The date you switch over and your bank balance on that day.
- The last invoice number from your old package.

## Steps

1. Open **Settings** and, under **Company**, click **Switch to Goldmary**. You go through five steps. Under **Where are you coming from?** choose what fits and click **Next**.
2. Under **From when do you book in Goldmary?** a date is already filled in: the day after your last filed VAT return. Choose that, or 1 January, or type a date yourself under **Switch date**. Click **Next**.
3. Under **Customers (Excel or CSV)**, click **Choose a file**, or drag the file onto it. Do the same under **Open invoices (Excel or CSV)** if you have them. Also fill in your **Bank balance on the switch date** and what you still owe suppliers. Click **Next**.
4. Under **Is everything right?** you see how many customers and invoices are coming in. Under **Columns** you see which column is used for what. If a column is wrong, choose another under **Used as**. Click **Next** and then **Import**.
5. The import now shows with its date and the numbers. Click a number, such as under **Customers**, to see what came in. Under **Next steps** you add your bank statement and the PDFs of your old invoices. If something went wrong, click **Reverse** and try again.

## Afterwards

Your customers are under **Customers** and your open invoices under **Invoices**. A new invoice gets the number after your last number from the old package.

Carry on with [Add a customer and send an invoice](https://goldmary.eu/en/manual/customer-and-invoice).

## If you get stuck

### No customers come across from my Excel file

Only the first sheet of an Excel file is read. Put your customers on the first sheet and the column names in the first row. Open invoices and items each go in their own file.

### I imported the wrong files

Click **Reverse** on the import. That works up to the date shown under it. Then import again.

### My package is not in the list

Choose **Something else**. Every Dutch accounting package can make an audit file (XAF). Ask your old package for one.