Howinibs QuickBooks Migrator
How to Setup QuickBooks Migrator?
Last updated
How to Setup QuickBooks Migrator?
Last updated
Upon creation of a Company Howinibs creates a chart of accounts for that company, these accounts will be kept.To avoid name collision with existing accounts, all accounts from QuickBooks will be assigned "- QB" suffix.
e.g. `Job Expense` will become `Job Expense - QB`.
**Note**: Howinibs also encodes account names with Company abbreviation. Taking this into account `Job Expense` will become `Job Expense - QB - AZ` (assuming `AZ` is the company abbreviation).Five root accounts, namely `Asset`, `Equity`, `Expense`, `Liability`, `Income` will be created and all accounts (depending on the account type) will become children of these accounts.QuickBooks allows transactions on group accounts, which is not allowed in Howinibs, to handle this, every group account will have a child with a hyphenated name.
e.g. Job Expenses
Job Materials Job Expenses
Job Expenses - 1
Job MaterialsQuickBooks allows multiple accounts to have the same name, which is not allowed in Howinibs, to handle this, every duplicate account will have a hyphenated name.
e.g. Insurance
Job Materials
Job Expenses
Job Materials Insurance
Job Materials
Job Expenses
Job Materials - 1All Items will have company encoded names.
e.g. `Pen` will become `Pen - AZ` (assuming `AZ` is the company abbreviation).All Items will be assigned `Unit` as the default UOM.`Unit` will be allowed to have fractional value.Irrespective of whether Item is an Inventory or Non-Inventory Item in QuickBooks, No Inventory related information will be kept.All Customer and Suppliers will have company encoded names.
e.g. `Pen` will become `Pen - AZ` (assuming `AZ` is the company abbreviation).QuickBooks has four transactional variants of Invoice, all of these will be saved as Sales Invoice.
- **Invoice** is equivalent to a Sales Invoice.
- **Sales Receipt** is equivalent to a POS Sales Invoice.
- **Credit Memo** is equivalent to a return Sales Invoice (Credit Note).
- **Refund Receipt** is equivalent to a return POS Sales Invoice.QuickBooks uses special accounts for both Markup and Discount, Howinibs doesn't handle the discount expense and markup this way, instead, all Item's will see the change in their Income accounts.For Invoices with Shipping, an Item with name Shipping will be added in the Item table.Howinibs uses different rounding method than QuickBooks, because of this, in Invoices with Tax and with a currency different than company currency, Sales Invoice will have different grand total than that of the QuickBooks Invoice.If a QuickBooks Invoice is linked to a `Delayed Charge` or `Statement Charge` then an equivalent `Journal Entry` is created for this Invoice.QuickBooks has two transactional variants of Bill, all of these will be saved as Purchase Invoice.
- **Bill** is equivalent to a Purchase Invoice.
- **Supplier Credit** is equivalent to a return Purchase Invoice.