ProConnect HelpIntuit HelpIntuit

Transferring data from QuickBooks to EasyACCT

SOLVEDby IntuitEasyACCTUpdated August 04, 2021

How do you transfer data from QuickBooks to EasyACCT?

Transferring data from QuickBooks to EasyACCT

Before you start:

  • You must have one of the three most recent QuickBooks year versions installed on your EasyACCT host computer.
  • EasyACCT will only import the QuickBooks Working file, which has a .QBW extension.
    • Make sure you can open the company in QuickBooks on your EasyACCT computer.
    • QuickBooks backups, copies, or accountant transfer files won't import.
    • Open the transfer file received in your QuickBooks program before trying the transfer.
  • Make sure you back up your data before beginning the import process.

To transfer data from QuickBooks to EasyACCT:

  1. Go to EasyACCT Utilities and select QuickBooks Transfer.
  2. Select the DateRange you'd like to transfer.
    • It's faster to import a month or quarter of the year at a time, rather than the whole year at once.
    • If you transfer more than one month, the transactions are stored in the month indicated in the 'to' field.
  3. Select to transfer Payroll Checks in Summary or in Detail.
    • If you select Summary, a payroll journal entry will be made to the Enter Transactions screen.
    • If you select Detail, the individual checks will be imported into the Payroll Entry screen accessible from Enter Transactions.
  4. Select to transfer GL and Other Transactions in Summary or in Detail.
    • Either selection will create an entry in the Enter Transactions screen.
    • If you select Summary, there will be just one line item per account.
    • If you select Detail, all transactions for the period will import.
  5. Select Browse to locate the company's QBW file, typically located in C:\Documents and Settings\All\Users\Documents\Intuit\QuickBooks.
    • To locate the file path of the QuickBooks file: 
      1. Open Quickbooks.
      2. Go to your client.
      3. Press the F2 key, and on the Product Information screen, look for the Location.
    • If the QuickBooks file has a password, QuickBooks will prompt you to enter the password before transferring your data.
  6. Select Continue. If there are already transactions in the month that you're transferring to, you can either Append or Overwrite the files.
  7. Map the QuickBooks accounts to EasyACCT accounts.
  8. Import Vendors and assign IDs.
    • You can't map preexisting EasyACCT vendors to ones set up in QuickBooks.
  9. Import Employees and assign IDs.
    • It isn't possible to map preexisting EasyACCT employees to ones setup in QuickBooks.
  10. Complete the Payroll Account Posting screen by filling in account numbers for each field.
  11. Complete the Payroll Mapping screen.
    • Since QuickBooks has numerous pay and withholding categories, you may have to combine several pay categories from QuickBooks into one EasyACCT pay category (group items with the same tax treatment).
  12. Select Continue until the transfer is complete.

Chart of accounts matching

QuickBooks provides a field in the company's chart of accounts to hold an optional account number.

EasyACCT requires an account number for each item in its chart of accounts.

The program can create a suggested list of account numbers to match with the QuickBooks accounts coming into EasyACCT (See step four below).

There are four possible scenarios that apply only to the initial transfer:

  1. Both EasyACCT and QuickBooks have existing account numbers. No suggested chart of account matching occurs so you must manually enter an account number for every QuickBooks account.
  2. Only EasyACCT has existing account numbers. No suggested chart of account matching occurs so you must manually enter an account number for every QuickBooks account.
  3. Only QuickBooks has existing account numbers. QuickBooks account numbers, types, and descriptions are copied directly to EasyACCT.
  4. Neither EasyACCT nor QuickBooks have existing account numbers.  EasyACCT creates a suggested chart of accounts based upon the total of all accounts in the company you're transferring.
    • If there are fewer than 63 accounts, EasyACCT uses three-digit account numbers.
    • If there are 64 or more accounts, EasyACCT uses four-digit account numbers.
    • Account numbers are incremented by 10s except for sub accounts.
    • All accounts end with 0 except for accounts that were listed as sub accounts in QuickBooks.
    • Sub accounts, once transferred to EasyACCT, end with 5 to make them easier to identify.

EasyACCT imports the following from QuickBooks:

  • Chart of Accounts
  • General Ledger Account Balances
  • Vendors
  • General Ledger Transactions
  • Employees
  • Payroll Posting
  • Payroll Transactions

EasyACCT doesn't import the following from QuickBooks:

  • Accounts Receivable Customers
  • Accounts Receivable Transactions
  • Accounts Payable Invoices

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

Ask questions, get answers, and join our large community of Intuit Accountants users.