cancel
Showing results for 
Search instead for 
Did you mean: 
DianeMarieCPA
Level 1

Quickbooks online

New client and they use DrChrono to capture medical patient billings and receives payment via square. 

 

The client uses Quickbooks online.  I cannot find info on how to import DrChrono patient billings into Quickbooks online. 

 

Any info or direction to point me to in order to research how to import DrChrono into QBO would be appreciated - I cannot find anything specific to DrChrono and QBO.

 

Thank you, Diane M. Spolar

 

4 Comments 4
ChristieAnn
QuickBooks Team

Quickbooks online

Hi there, DianeMarieCPA.

 

Welcome back to the QuickBooks Community. I'll be sharing about uploading data to QuickBooks Online. Then, ensure you'll be routed to the right support team to assist you further in importing DrChrono patient billings into QBO.

 

You'll have an option to connect other software to QuickBooks Online to automatically sync your data. Since you're using DrChrono to capture billings, I suggest contacting their support. They can verify if you have the option to integrate and import the data directly into QBO.

 

In case DrChrono doesn't support the option you want, I suggest going to the Apps center inside QBO. From there, you're able to see hundreds of apps and search for a specific app to make your goal possible. 

 

  1. Click Apps in the left navigation menu.
  2. Click the Browse Category drop-down menu, select Sync Data.
  3. Select the app you want to integrate.
  4. Click Get App Now and complete the following on-screen instructions.

 

Additionally, you can refer to this article to see details on how you can upload receipts and bills to QuickBooks Online from your computer or mobile device, or even from your email account: Upload your receipts and bills to QuickBooks Online.

 

Lastly, you may refer to this article to see different details on how to import data to QuickBooks Online works: Common questions about importing data to QuickBooks Online.

 

As always, you can leave a comment below or start a new thread if you have any other concerns. I'll be keeping an eye on your response.

DianeMarieCPA
Level 1

Quickbooks online

ChristieAnn - thanks for your reply.  I will investigate with DrChrono and the app for syncs.

 

Take care, Diane.

KimMcCPA
Level 6

Quickbooks online

@DianeMarieCPA ,

 

Greetings, fellow CPA!

 

There is a generic import for invoices that may help... I stepped through all of this using the QBO demo link, downloaded the sample CSV format, replaced with different sample invoice data, and imported... then checked to make sure that the invoices imported properly.

 

First, turn on Custom transaction numbers in Accounts and Settings; otherwise, Dr. Chrono invoice numbers will be replaced by standard QuickBooks invoice numbers.

Next, open Notepad and copy/paste the category:service from within QBO that you want on these imported invoices.  It must be an exact match.

 

Gear > Import data

Invoices

Click on Download sample CSV file

Delete sample data, rename and replace with data from Dr. Chrono, save as CSV.

  • Date format should be MM/DD/YYYY or you'll get an error.
  • Make sure each transaction has exact Category:service in the Item(Product/Service) column.
  • The sample CSV doesn't have Email as the last field, but it will look for it later in the import. If you have email addresses that you want to import, add a column next to Service date, Email is header, and fill those in.

Upload your CSV file

If new customers should be imported, tick Add new customers to Quickbooks

Note:  Existing customers that are not exact matches will be added as new.  I tested this with a transposition in a customer name.  The last screen will both show and count the new customers... if all looks good, tap Complete Import.

 

If you get an error in the import steps, use Previous to get back to first screen, fix CSV, save, then Upload your CSV file again.

 

Fiat Lux - ASIA
Level 15

Quickbooks online

@DianeMarieCPA 

Your clients use DrChrono to create invoices for patients and receive payments through Square, correct? They will need one app to import the Invoice and another app to reconcile the payments from Square.

 

Prepare your Invoice data from DrChrono with the following template

RefNumberCustomerTxnDateDueDateShipDateShipMethodNameTrackingNumSalesTermLocationClassBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgBillEmailBillEmailCcBillEmailBccCurrencyExchangeRateDepositToBePrintedToBeEmailedAllowIPNPaymentAllowOnlineCreditCardPaymentAllowOnlineACHPaymentShipAmtShipItemDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y MP3 PlayerBlue MP3 Player255  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y HandheldsPortable Game Player1100  TAX

 

Check your private message. Hope it helps.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us