AdvancedMD Quickbooks

3 Simple Steps to Track Revenue, Deposits, and Write-Offs (by CPT Code) from AdvancedMD to QuickBooks

Are you struggling to reconcile your financial data between AdvancedMD and QuickBooks? You are not alone! Many professionals face the same challenge when managing accounts receivable and ensuring accurate financial reporting.

This guide offers a straightforward method to simplify the process without complex journal entries. By following these 3 simple steps to track revenue, deposits, and write-Offs (by CPT Code) from AdvancedMD to QuickBooks, you’ll achieve better reporting, simplify deposit and payment reconciliations, and have more time to focus on your business. Don’t hesitate to reach out for personalized support.

If this process still seems overwhelming, don’t worry-I’m here to help! I offer direct assistance, and I have developed an Patent-Pending AdvancedMD QuickBooks Integration (App) that automates these daily updates for you, saving your 10+hours/week of manual work. Ready to make the switch? Learn more about the app here: https://qbsolutioneers.com/quickbooks-autosyncmd/ and discover how effortless financial tracking can be!

analysis of services summary report sample, dvancedMD QuickBooks integration, QuickBooks medical billing, AdvancedMD financial tracking, QuickBooks for healthcare, medical billing reconciliation, CPT code revenue tracking, QuickBooks automation for healthcare, AdvancedMD payment reconciliation, medical practice accounting, healthcare revenue cycle management, QuickBooks deposit tracking, medical billing software integration, streamline medical payments, QuickBooks write-off management, automate AdvancedMD reports, healthcare accounting software, AdvancedMD to QuickBooks automation, QuickBooks for medical professionals, financial reporting for medical practices, AdvancedMD daily reconciliation, QuickBooks revenue management, healthcare payment tracking, medical billing efficiency, QuickBooks for private practice, AdvancedMD revenue tracking, automate medical accounting, QuickBooks invoicing for healthcare, AdvancedMD credit memo tracking, medical billing optimization, AdvancedMD transaction management, advancedMD to quickbooks

3 Simple Steps to Track Revenue, Deposits, and Write-Offs (by CPT Code) from AdvancedMD to QuickBooks

Step 1 – Gather Your Data from AdvancedMD Reports

  1. To Start, make sure the “End of Day” Routine has been run in AdvancedMD.
  1. Then, pull these two reports from AdvancedMD:
  1. Go to “Reports” then “Financial Totals” then “Analysis of Services Summary.”

Set Parameters to:

  • Group By: Procedure
  • Date Type: Date of Entry
  • Date Range: Prior Day
  • Export the Report to Excel
  • Create a Sub-total Column, to Sub-Total Each Row and Sub-Total the Prior Day’s Activity
  • Refer to Exhibit A – for an example of a completed report.
  1. Build a Custom Payments Report in AdvancedMD showing the “Total Deposits by Day.” 
  • Groups Payments by: Payment Method
  • Sub-Totals Payments by: ACH/Check and/or Voucher Number
  • Export the Report to Excel
  • Refer to Exhibit B – for an example of a completed report.

     ** AdvancedMD’s support team can assist you with building the custom report, subject to an additional fee.

          (The standard “Deposit Summary” Report provided by AdvancedMD is insufficient for this exercise.)

Step 2 – Add  “Accounts” and “Product/Service” Codes in your QuickBooks Set-up

This step is mostly a one-time set-up. However, when your billing team adds new CPT and/or write-off codes in AdvancedMD, you will also need to add the new CPT and write-off codes to QuickBooks.

First – Identify and add the income and write-off accounts you want to use, for tracking and summarizing. 

       your revenues and charges for your Profit & Loss Report. In QuickBooks, go to the “Chart of Accounts.” 

       and add the relative income and write-offs accounts. Some examples might be: 

  • Medication Management Revenue
  • Therapy Revenue
  • Evaluation Revenue
  • Write-Offs – Insurance & Contractual Adjustments
  • Write-Offs – Small Balances, Discounts, Other

Second – Add your CPT Service Codes and Write-Off Codes to QuickBooks.

       In QuickBooks, go to your “Products and Services” list and add each procedure code, write-off code. 

       and payment code, as shown on your AdvancedMD Analysis of Services Report

       When adding your “Service” codes, use the appropriate:

  • “Income Account” for Procedure Code Revenue (to track types of Revenue)
  • “Income Account” for Write-Off Code Revenue (to track and post negative adjustments to Income)
  • “Bank Account” for Credit Card Payments (to post to your bank account)
  • “Undeposited Funds Account” for Patient Payments & Insurance Payments (for deposit reconciliation)

Step 3 – Finally, Enter Your AdvancedMD Report Data into QuickBooks

  1. Now, review the “Analysis of Services Summary” Total

If the total amount is “Negative” (decrease to Accounts Receivable) you will create a Credit Memo in QuickBooks -or- If the total amount is “Positive” (increase to Accounts Receivable) you will create an Invoice in QuickBooks.

  1. Login to QuickBooks and go to “Create Invoice” or “Create Credit Memo” (whichever is applicable) 

and enter:

  • Add a New Customer Name Called: AdvancedMD
  • List line-by-line, the procedure details found on the Analysis of Services Summary.
  • Refer to Exhibit C – for an example of a completed invoice transaction.

Exhibit A – Sample “Analysis of Services Summary” Report (Charges & Write-Off’s from AdvancedMD)

In this example, Accounts Receivable Increased on 12/1/XX by the amount of $ 12,307.76:

  • $ 13,550.50 / Total Patient Charges
  • $     – 536.04 / Total Patient Write-Off’s
  • $      -706.70 / Total Patient & Insurance Payments

analysis of services summary report sample, dvancedMD QuickBooks integration, QuickBooks medical billing, AdvancedMD financial tracking, QuickBooks for healthcare, medical billing reconciliation, CPT code revenue tracking, QuickBooks automation for healthcare, AdvancedMD payment reconciliation, medical practice accounting, healthcare revenue cycle management, QuickBooks deposit tracking, medical billing software integration, streamline medical payments, QuickBooks write-off management, automate AdvancedMD reports, healthcare accounting software, AdvancedMD to QuickBooks automation, QuickBooks for medical professionals, financial reporting for medical practices, AdvancedMD daily reconciliation, QuickBooks revenue management, healthcare payment tracking, medical billing efficiency, QuickBooks for private practice, AdvancedMD revenue tracking, automate medical accounting, QuickBooks invoicing for healthcare, AdvancedMD credit memo tracking, medical billing optimization, AdvancedMD transaction management

Exhibit B – Sample “Total Deposits by Day” (Payments Entered – Per AdvancedMD Custom Report)

In this example, Accounts Receivable Payments on 12/1/XX total to amount of $ 706.70:

  • $ 140.00/Patient Payments (Including Three American Express Payments)
  • $ 566.70/Insurance Payments (Including Three ACH/ERA Payments)

total deposits by day sample report, dvancedMD QuickBooks integration, QuickBooks medical billing, AdvancedMD financial tracking, QuickBooks for healthcare, medical billing reconciliation, CPT code revenue tracking, QuickBooks automation for healthcare, AdvancedMD payment reconciliation, medical practice accounting, healthcare revenue cycle management, QuickBooks deposit tracking, medical billing software integration, streamline medical payments, QuickBooks write-off management, automate AdvancedMD reports, healthcare accounting software, AdvancedMD to QuickBooks automation, QuickBooks for medical professionals, financial reporting for medical practices, AdvancedMD daily reconciliation, QuickBooks revenue management, healthcare payment tracking, medical billing efficiency, QuickBooks for private practice, AdvancedMD revenue tracking, automate medical accounting, QuickBooks invoicing for healthcare, AdvancedMD credit memo tracking, medical billing optimization, AdvancedMD transaction management

Exhibit C – Sample “QuickBooks Invoice” – Summarizing Daily Update from AdvancedMD Analysis

In this example, notice that Accounts Receivable (in QuickBooks) is increased by: $ 12,307.76:

  • $ 13,550.50 / Total Patient Charges
  • $     – 536.04 / Total Patient Write-Off’s
  • $      -706.70 / Total Patient & Insurance Payments

*** Notice that Payments are itemized by Check Number, found on the Report from Exhibit B

        (for Bank Deposit Reconciliation Purposes)

sample quickbooks invoice, dvancedMD QuickBooks integration, QuickBooks medical billing, AdvancedMD financial tracking, QuickBooks for healthcare, medical billing reconciliation, CPT code revenue tracking, QuickBooks automation for healthcare, AdvancedMD payment reconciliation, medical practice accounting, healthcare revenue cycle management, QuickBooks deposit tracking, medical billing software integration, streamline medical payments, QuickBooks write-off management, automate AdvancedMD reports, healthcare accounting software, AdvancedMD to QuickBooks automation, QuickBooks for medical professionals, financial reporting for medical practices, AdvancedMD daily reconciliation, QuickBooks revenue management, healthcare payment tracking, medical billing efficiency, QuickBooks for private practice, AdvancedMD revenue tracking, automate medical accounting, QuickBooks invoicing for healthcare, AdvancedMD credit memo tracking, medical billing optimization, AdvancedMD transaction management

I hope you find this instructional guide to track revenue, deposits, and write-Offs (by CPT Code) from AdvancedMD to QuickBooks helpful. I know for me, it saved me a ton of reconciliation hours. 

If you have a different or better way to accomplish this, please share it.

Thank you,

Dawn Scranton, CQA

dvancedMD QuickBooks integration, QuickBooks medical billing, AdvancedMD financial tracking, QuickBooks for healthcare, medical billing reconciliation, CPT code revenue tracking, QuickBooks automation for healthcare, AdvancedMD payment reconciliation, medical practice accounting, healthcare revenue cycle management, QuickBooks deposit tracking, medical billing software integration, streamline medical payments, QuickBooks write-off management, automate AdvancedMD reports, healthcare accounting software, AdvancedMD to QuickBooks automation, QuickBooks for medical professionals, financial reporting for medical practices, AdvancedMD daily reconciliation, QuickBooks revenue management, healthcare payment tracking, medical billing efficiency, QuickBooks for private practice, AdvancedMD revenue tracking, automate medical accounting, QuickBooks invoicing for healthcare, AdvancedMD credit memo tracking, medical billing optimization, AdvancedMD transaction management

Cell: (561) 291-3445  

E: dawn@qbsolutioneers.com

Frequently Asked Questions:

  • How does this help me Reconcile Payments and Deposits?

Checks will now be listed and identified by ACH, check or transaction ID, making it easier to reconcile deposits with bank transactions.

  • How does this help me with Reporting?

Revenue and Write-Offs are now listed and identified by CPT or Write-Off Codes in QuickBooks, making your information available to analyze “Sales by Service Summary” for various periods comparisons.

  • How does this help me with Accrual Accounting?

Revenue and Write-Offs are now updated daily (in QuickBooks) for two benefits: (a) True & Historical A/R will now appear on your Balance Sheet and (B) Your Profit & Loss Revenues are recognized when entered, rather than when paid, for accurate “Accrual” Accounting 

  • Where can I get more information on the AdvancedMD QuickBooks Integration App?

I offer direct assistance, and I have developed a Patent-Pending AdvancedMD QuickBooks Integration (App) that automates these daily updates for you, saving your 10+hours/week of manual work. Learn more about the app here: https://qbsolutioneers.com/quickbooks-autosyncmd/ and discover how effortless financial tracking can be!

Leave a Reply

Your email address will not be published. Required fields are marked *