Goldmary
Create a free account Sign in
MenuClose

Switching over from Excel or another package

What you need

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

  • 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.

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.

Markdown · All manuals