Skip to main content
Showing IndiaShowing UAEShowing United Kingdom

Moving from your old system

Bring over your masters first, then your balances, then the open documents. Bizconnekt has no one-click migration; you use Bulk Import, the opening balance screens and, for Tally, the connector.

5 min readYou need: Add/Edit on Bulk Import and on each module you import intoBefore you start: your old system's exports as spreadsheets

Quick add​

About an hour for a first import
  1. Export items, customers and suppliers from your old system to spreadsheets.
  2. Go to Utilities › Bulk Import and pick Item. Download the template, paste your data and upload.
  3. Repeat for Customer and Supplier. Fill Opening Balance and Opening Balance Date here if you want party balances in the same import.
  4. Continue with the checklist.

Done. Your items, customers and suppliers exist and are ready for opening balances.

Video coming soon: Import customers from Excel

Full guide​

What to bring, and the order​

Work in this order. Later steps need the earlier ones.

OrderWhatHow
1Items, customers, suppliersBulk Import, or the connector for Tally
2Go-live dateAdmin console, see Choose the go-live date
3Account balances, bank and cashChart of Accounts
4Opening stockStock Adjustment, by form or Bulk Import
5Customer and supplier balancesOpening Balance on the party, or Bulk Import of parties
6Open invoices, bills and settlements from before go-liveForms or Bulk Import, see Old documents

Bulk Import​

Bulk Import runs the same checks as the form. It is under Utilities › Bulk Import, and from the Import button on each list. You need Add/Edit on Bulk Import and on the module you import into. Entities offered include Item, Customer, Supplier, Invoice, Bill, Credit Note, Debit Note, Payments Received, Payments Made, Stock Adjustment, Store and Batch.

Fields in this section
FieldRequiredWhat to enter
Opening BalanceNoOn the Customer and Supplier templates. A plain number; positive is the party's usual side. For the other side type a negative number such as -500. "500 Cr", "(500)" and "500-" are rejected.
Opening Balance DateWith the amountThe go-live day. Amount and date go together.

Stock does not come in with the Item sheet. Items carry no opening quantity; use a Stock Adjustment of type Opening Stock, which also has a Bulk Import sheet.

Moving from Tally​

The Tally connector and Data Sync bring masters and vouchers from Tally. Masters are your accounts, customers, suppliers and items. Vouchers are pulled by type and date range.

What the connector does not bring: party opening balances and stock quantities. Tally's closing value is used only to set an item's purchase rate. Enter opening balances and opening stock as described in Opening balances.

Vouchers go through the same checks as an import, so a voucher before your go-live date is accepted only if it is an invoice, bill, receipt, payment, credit note or debit note. Pull only the period from the go-live date onward, and bring older open items in as old documents.

Moving from Excel or another ERP​

Export masters and open items to a spreadsheet, match columns in the Bulk Import mapping step and fix flagged rows before confirming. For another ERP, ask for the same reports as for Excel: open customer and supplier bills, stock with value, trial balance.

India

Enter your GST credit ledger balance after go-live. See Tax Compliance main screen.

On the mobile app​

Bulk Import, Data Sync and the Tally connector are not on the phone. Same on iPhone and Android. Add parties by hand on the phone if you need to.

Scenarios​

Excel to BizconnektBulk Import masters, then balances by form.
Tally, keep TallyConnector for masters and vouchers; enter balances once.
Part-year startPick the day after your last closed month.

Problems and fixes​

My Tally customers came over with no balance

The connector does not carry opening balances. Enter them on each customer or in a customer import.

A Tally voucher before go-live was refused

Only invoices, bills, receipts, payments and notes may be dated before go-live. Skip the rest; their effect is inside your opening balances.