Exporting and Importing Transactions to Quickbooks (Desktop)
For Lab Enterprise customers, invoice transactions can be exported from EasyRx in CSV, allowing for import into accounting systems like Quickbooks, Xero, etc. Here are the instructions to export and import into Quickbooks Desktop:
**Video attached**- Go to the Invoicing tab, after in the second menu line click “export
invoices” and scroll down to the bottom of the page and below Bulk Export click onto “Export unexported invoices”. A report box comes up
titled “export-date.cvs. Save file.
- Minimize
EasyRx
- Open
QuickBooks (QB)
- Open
Transaction Pro program
- In
the first window in Transaction Pro “select your file source” click “Browse” to
find the correct file export-date.cvs file.
- All
other info in Transaction Pro stays the same.
- Click [Next] and follow prompt to start import process
- Once the process is complete two scenarios can happen:
- if no issues click [Next]
- If a warning window
comes up push [OK] (15), and a list of invoices (15A) appears and a yellow highlighted field
indicates what additions are needed, usually, there is a missing account number
which needs to be entered. If that’s the case, scroll over to the right to the
missing item field and input 4000 in the field and click out of the field to
enter and keep moving down till all missing fields are filled.
- After the fields are filled and completed
click [Next] or [Save]
- Transactions
ID now checking all columns
- Once complete a window will appear
and click finish, then [OK] and this starts the transfer
- Once
imported to QB’s save file
- In
QB, Go to reports then sales and print sales (Sales by Customer Summary) to the required date needed. (Usually
dates range from 1st to the last day of the month.
- Compare
this report to the report you printed from #3 above. The report totals will be
off a bit as accounts change with changes and credits from day-to -day. If they
match, you’re done, if not go on.
- Go
down both lists and compare totals from EasyRx report using the “Sales with
discount” column on example data sheet with the QB’s report. If there are differences you
can look and see why in QB’s customer list. Once the reports are in balance
proceed to next step
- Credits can now be processed in QB
for volume discounts derived from the EasyRx report from #4 above. Go to Home
Page Refund/Credits.
- TIP: When applying credits always
enter a date that’s inside of the month your billing for. Example- if your
billing for March and its April 1st change and use a day in March
like March 31st. this way the credit goes on the Statement for April In the dollar amount area click onto the
arrow on the right of the total credit and select “no tax”. (this can be
discussed further as need be)
This process is reviewed in detail during Enterprise on-boarding. This KB serves as a reference tool as needed.
As always, we are here to help.
The EasyRx Team
Related Articles
How to add a desktop shortcut for EasyRx [Windows OS]
We all love fast and efficient ways to organize our workplace. Here we will show you a cool tip on how to add a Desktop Icon that instantly takes you to the EasyRx login. You may repeat this process for as many desktops and laptops that you or your ...
"ICAST", "Exporting to Dr. Site" scan status under iTero integration
Hello, This is what you'll want to do on the iTero scanner to clear up this issue with this new iTero status "Exporting to Dr. Site" that prevents scans from attaching. If you are saving the scans on your iTero as IRECORD or Invisalign + IRECORD you ...
Manually Exporting scans from MyiTero.com
If your scans did not attach through the iTero integration and you want to manually export the scans from iTero's website the old-fashioned way, here is how to get a .zip folder onto your computer, and then two short videos to show you how to get ...
Exporting an EasyRx prescription as a PDF into Dolphin Management
As part of the Dolphin / EasyRx integration, you will have the ability to use the Dolphin Document Organizer to push the EasyRx prescriptions into the Patient's Documents in your Dolphin Management software! It will store an electronic copy of the ...
Carestream CS3500 scans - How to Export and Import into EasyRx
If you are using a Carestream CS3500 digital scanner, use this article on how to properly export your STL files, then import them into EasyRx. Export .STL file(s): Locate the patient scans / files in your Dental Imaging Software. Click the [Send To] ...