20. Importing from Quickbooks

bMobile Route Training Center

Welcome to the bMobile Tutorial Video Series.

In this video, we will quickly go over the process of importing your information from Quickbooks to the bMobile Route Manager Desktop App. If you are using a different accounting software, make sure to reach out to us to discuss any differences in this process based on which software you are using.

Step by Step

Here are the steps to this process:

  1. Start Quickbooks and Login
  2. Select the bMobile Quickbooks Update application if you’re a bMobile Saas customer, then select “Send to Quickbooks” in the Tools Menu
  3. If bMobile is installed on your local server, open bMobile Route Manager and navigate to tools, then select “Import Quickbooks Data” in the bMobile desktop app from the Tools Menu
  4. Now you need to select the information that you would like to import from Quickbooks. Here’s a quick run down of the import options:
  1. Company, GL ACCTS, Sales Reps, terms – pulls company name and address info, gl account info, employee records(name, initials only), Terms for invoice creation
  2. Customers – Pulls customer name, address, contact info and customer balance
  3. Customer Shipto – pulls additional delivery locations – do not import if each customer is a unique location
  4. Vendors – Pulls vendor list from QB – Used for PO receiving addin – must have user field in vendor record of QB called b-Mobile Vendor with a word starting with Y in the field to import
  5. Inventory – Pulls item number, description, cost and wholesale
  6. Inventory Package- Pulls relevant package info when running multipack addin
  7. Purchase order – imports open PO records for receiving purposes
  8. Invoices- imports open customer invoices for basic statement running
  9. Credit memos – imports open credit invoices for basic statement running
  10. Payments – Imports unapplied open payment amounts for basic statement running
  11. Price Levels – Imports QB price level DO not import if maintaining pricing in bMobile, this will overwrite existing pricing)
  12. Filter transactions by date – Used to reduce invoice, credit memo and payment data; speeds up import process for large QB files
  13. Debug – used to identify problem records with errors are encountered

** Remember that these selections are all optional.

  1. After you are done selecting what you would like to import from Quickbooks, click on the Start button in the upper right hand corner.
  2. A message saying “Update Complete” will appear on successful completion.
  3. If the importer fails to complete, an error message will appear with the record it has stopped on.
    1. Many times, the error has to do with a duplicate record in the bMobile Database. The error message should tell you which record is the duplicate one. Make sure to confirm that the duplicate no longer exists before attempting to import again.

That’s it!

If you have any questions about specifics regarding navigating through this process, make sure to touch base with your Implementation Consultant!

Thanks and have a good day!