Exporting Accounts

When you are finished editing the R.O. Writer accounts, you are ready to export the chart of accounts. Click the Export Accts toolbar button. This creates the .IIF file to be imported into QuickBooks and stores it in the Export File Directory.

The next step is to create a new company in QuickBooks with no accounts (Skip the Interview), which is the easiest way. Then, you can add other accounts and payroll information after the R.O. Writer chart of accounts is imported.

You may use an existing company as long as there is no preference set up as yes you charge sales tax. If this is set to yes, QuickBooks will never let us post sales tax from R.O. Writer to the Sales Tax Payable account even if you uncheck the option.

Also be prepared when using an existing company that your accounts match with R.O. Writer accounts including the type. A couple of examples that would be different:

Change the account names in R.O. Writer to "RO-Accounts Payable" or "RO-Accounts Receivable."

 

Creating New Companies in QuickBooks

The process of creating new companies in QuickBooks is different in different versions of QuickBooks.

To Create a New Company in QuickBooks 2011 and Earlier

Complete these steps:

  1. Open up QuickBooks for Windows.
  2. Click on File and new company.
  3. Click Next.
  4. Click Next again.
  5. Click SKIP INTERVIEW in the middle of the screen.
  6. Enter your Company Name, Address, etc. and click Next.
  7. Select (No Type) (No Accounts) and click Next.
  8. Click Save to create the new company.

To Create a New Company in QuickBooks 2012, 2013, and Higher

Complete these steps:

  1. Open up QuickBooks for Windows.
  2. Click on File and new company.
  3. Select Create a new company button.
  4. Click the Express Start button.
  5. Type Other/None for Industry type.
  6. Click the Start Working button.

To Import the Chart of Accounts

NOTE: This only needs to be done one time on a new QuickBooks company not already used with R.O. Writer.

  1. Click File > Import iif files.
  2. Select the file named "Accounts.iif" and click OK.
  3. You should then get the message, ”Your data has been imported.” Click OK.

To See the Chart of Accounts

To see the chart of accounts, click Lists and Chart of Accounts. If trouble is encountered during the import, check for conflicts in either names of accounts or the account types already set up in your accounting system. This is the most common cause of difficulties.

Balance Forward Charges

Entering Balance Forward charges in Accounts Receivable for each customer does not transfer to QuickBooks. The only time we transfer charges is when a repair order is closed to Accounts Receivable. You would have to enter that balance into QuickBooks directly.

Entering Balance Forward charges for Accounts Payable must be done by posting invoices; therefore, all those balances are transferred to QuickBooks.

You may also wish to enter your Inventory beginning balance which you can get from the Parts Stock Value Report.

If you are not using the date range option, you will most likely want to begin importing only new information to QuickBooks and will need to do a Reset.

For details, click the following link: Accounting Interface - Frequently Asked Questions.