Bringing in your records
Import brings in customers, what they owe (open balances), your price list, your inventory or your vendors from a spreadsheet saved as CSV. QuickBooks, Excel and Google Sheets can all save one. Bring in customers first.
- Click Customers, then Import (or Bring in a spreadsheet in setup).
- Pick what you're bringing in, then drop the file on the page or click to choose it.
- Check which column goes where. Ask Ed to match them does it for you.
- Check it shows what will be added and what will be updated, before anything changes.
- Click Import now.
Rows that match a customer you already have (by email, then name) update that customer instead of adding a second one. Undo this import takes a whole import back out.
Open balances: what each customer owes on the day you switch.
- In QuickBooks, open Reports, then Open Invoices (or A/R Aging Detail).
- Click Export to Excel, then save the file as CSV.
- In ExpressFab, go to Import and pick Open balances.
- Drop the file on the page. The customer, invoice number, date and balance columns match by their headings.
- Click Check it. A row whose customer isn't in ExpressFab yet is left out, and says why.
- Click Import now.
Each balance becomes an open invoice on that customer, so statements, aging, reminders and the cash forecast are right from day one. Payments you get later apply to them like any invoice. They aren't sent to QuickBooks, because they're already there.
The day-one check shows what your file added up to, what came in, and the difference. Compare it with the total on your old system's A/R aging report.
This is the manual that's inside the app, where every screen also has Ed to ask. Still stuck? Contact support.