Importing and exporting your data
Downloading any master table or a period's transactions as Excel or CSV, and bringing customers, items and more in from a spreadsheet, checked row by row before anything is saved.
Getting a list into BeanDish shouldn't mean typing it. Tables – Utilities has a page to bring data in and a page to take it out, and the two speak the same columns.
Exporting
Open Tables – Utilities › Export data. Under Table, Master data holds your customers, suppliers, items, employees, leads, price rules, supplier price lists and chart of accounts. Choose a table and a format, Excel or CSV, and click Download. The file uses the same columns Import data expects, so you can export a list, change it in a spreadsheet and bring it back.
Transactions are line-level snapshots for a date range: sales orders, invoices, shipments, purchase orders, bills, receipts and inventory movements. Filter them by customer, supplier, item or kind of movement. They are for reading and analysis — they don't import back.
Importing
Open Import data, choose the table under Import into, choose your Excel or CSV file (with headings in the first row) and click Continue.
- Match the columns. BeanDish matches each column it recognises. Set any column it missed (or matched wrongly) by hand, make sure every required field has a column, and leave anything you don't need on Skip this column.
- Preview. Click Preview import. Every row is checked before anything is saved, and each duplicate or problem row says why.
- Import. Click Import to bring in the good rows. The result lists each row that wasn't imported, with its reason, and Download rejected rows gives you just those to fix and try again.
Moving data between BeanDish companies
An Excel file exported from one BeanDish company carries a hidden sheet naming its table. Import it into another company and its columns map by themselves. An item master also brings the item types the new company lacks, with their kind. Upload such a file as the wrong table and it is refused, naming the table to choose.
What else imports
Besides customers, suppliers and items, Import data takes price list rules, customer price rules, supplier price lists, item specifications, employees, leads and fixed assets. Journal entries come in as drafts, for someone to check and post. The chart of accounts exports here too. A chart is imported during setup, for a new company started from a spreadsheet or from QuickBooks, before anything has been posted; a chart exported from another BeanDish company keeps every account number.
See every step
The tutorial below walks through an export, a customer import from the column mapping to the result, and an item master moved between companies. The same tutorial is in BeanDish under Learn › Tutorials.
Import and export your data, step by step
Master tables and transaction snapshots exported as Excel or CSV, customers imported from a spreadsheet with its column mapping and preview, an item master moved between BeanDish companies, a file uploaded as the wrong table refused, and the other tables Import data takes. (3:50)