Import with a plan first

Switching from Excel or spreadsheets

Bring what the next month needs: your customers and suppliers, your chart of accounts, items, opening balances and the invoices and bills still open. Aqid ERP shows you the plan before it writes a row.

Start now for free No credit card needed. Invoice in minutes

What moves over

  • Customers and suppliers
  • Chart of accounts
  • Items and services
  • Opening balances at the cut-over date
  • Open customer invoices
  • Open supplier bills

What stays in Excel or spreadsheets

  • Paid and closed documents: history is read where it was made.
  • Posted journals, payroll runs and fixed-asset registers.
  • Attachments and audit logs.

How it goes

  1. Export each list from Excel or spreadsheets as CSV or Excel.
  2. Upload it to Imports in Aqid ERP and pick Spreadsheet (CSV or Excel) as the source.
  3. Read the plan: every row says what it will do and why, and a skipped row says why it was skipped.
  4. Approve. The same file cannot be imported twice by mistake.
  5. Match the trial balance at the cut-over date before you send the first invoice.

Questions

How long does it take?

An afternoon for a small company: five exports, five imports, one trial balance check.

Do my invoice numbers continue?

Open invoices keep their original numbers as references. New invoices follow Aqid ERP's numbering.

Can I run both for a month?

Yes, and you should: post the same month in both and compare the trial balance before you stop Excel or spreadsheets.

In Saudi Arabia

Invoices typed into a spreadsheet stopped being acceptable when Phase 1 began on 4 December 2021: since then, invoices and credit and debit notes must be generated and kept by a compliant system. Moving off Excel is a compliance step as well as a bookkeeping one. Use the generic import and map your columns once. After the cut-over, invoices carry the QR code and Arabic fields, and you can still upload many invoices at once from a sheet once its plan has been checked.

Read next for Saudi Arabia

Your first compliant invoice is minutes away

Start now for free No credit card needed. Invoice in minutes