Tonbab Docs

Move Your Data into Tonbab from Other Software via Excel

You can move your data from FlowAccount, PEAK, Express, Xero, QuickBooks and other accounting software into Tonbab via Excel: export from your current software, arrange it in Tonbab's templates, and import. If you'd rather not do it yourself, our team can do it for you.

  1. Master data: products, companies/partners, warehouses and BOMs
  2. Opening stock
  3. Chart of accounts and opening balances (if you use Accounting, included in every plan)
  4. Employees and payroll

1. Master data from Excel

Go to Settings › Data Import/Export. The Master Data section covers:

  • Products
  • Companies (vendors and customers)
  • Warehouses
  • Bill of Materials

Steps:

  1. Click Download Templates, or export your current data as a template.
  2. Copy the data exported from your old software into the template.
  3. Click Import from file and choose the .xlsx or .csv file.
  4. Check the Import Preview, then click Confirm Import.

Rows whose code matches existing data are updated; new rows are added. Imports can't be undone, so check the preview carefully. The same import menu is on the products, companies, warehouses and BOM pages.

2. Opening stock

On the same page, under Import, choose Opening Balance. Tonbab creates a draft stock adjustment for you to check before posting. Fill in unit costs so stock value and job costs are right from day one.

3. Chart of accounts and opening balances

If you use Accounting, go to Accounting › Accounting setup › Import.

  1. Chart of accounts: an .xlsx or .csv file with account codes and names (type and parent are optional). Click Check file, then add to the current chart or replace it (replacing is only possible before any vouchers exist).
  2. Opening balances: a trial balance as of the day before you start Tonbab, with account codes and debit/credit amounts. Tonbab creates a draft voucher for you to check.

4. Payroll

If you still calculate payroll in your old system during the switch, create a pay run with Enter from another system and click Import CSV using the template: one row per person (employees must already exist). See Payroll.

Past document history

If you also want history such as quotations, sales documents, receipts and journal vouchers, our team can convert and import it. Contact us to assess your data.

Let our team do it

Onboarding costs ฿9,900 (one-time, before VAT). Our team sets up your company, prepares and imports your data from your previous software, and trains your team. For Enterprise customers, onboarding is part of the Enterprise support pack.

Contact sales@codustry.com or 02-873-4448.

Tips

  • Start at the beginning of a month; it makes reconciling easiest.
  • Make your SKU prefix and partner codes consistent before importing.
  • Check units and conversions after importing products. See Inventory and warehouses.

Last updated