Page History

...

1. Click the Billing tab at the top of the page.
2. Click the Account Ledger tab in the left-hand navigation bar.
3. Click the Crosswalk tab. The GL Crosswalk page appears.
4. Click the GL Settings button, and then enter your eSignature password.
   Image Added
   
5. Select the entities – Facility, Insurance, or Service - for which you want to create crosswalk entries in the Select GL Parameters section.

6. Define the format of accounts included in crosswalks in the Other Settings section. The following table describes the properties you set:

   Separator for Revenue Account Number	The separator to use when the application generates account numbers using the Ledger Account Number for each selected entity. For example: <Insurance Account Number>-<Facility Account Number>
   Length of GL Account Numbers	The maximum number of characters that you can include in account numbers. All characters in the string, including the separator, are included in the length.
   Records to display on the page	The maximum number of crosswalk entries to display in the Export Data window.
   GL Number for patients with no insurance	The value to display for patients that do not have insurance. The value is appended to Revenue and Cash account numbers in the crosswalk. You must specify a numeric value.

   The following image shows the settings defined to create crosswalk entries that include the combination of Insurance and Facility. Account numbers for patients without insurance will include 0000.
   
    Image Modified

7. Click Save to save the crosswalk settings.

...

1. Click Add to create a new crosswalk entry.
   Image Added
2. Select a value for the facility, insurance provider or service code.
   When you select more than one entity, the application concatenates the general ledger account number for each entity into a Revenue Account number and a Cash Account number in the crosswalk.To differentiate between the Revenue and Cash accounts, you might want to change one or more values in one of the account number fields.
3. Enter an accounts receivable account number in the A/R Account field.
   In the following image, the Ledger Account Numbers for the Insurance and Facility (Program) entities are concatenated into Revenue Account and Cash Account numbers. The last two digits in the Cash Account number are changed to allow you to differentiate between the accounts.
    
4. Click Save.

...

When you export data, you select the month and year for the accounting period for which you want to export data. Close the accounting period before you export data to ensure that you do not export unwanted transactions to your general ledger.

Note: After you close an accounting period, no new transactions can be posted to the period. In addition, all encounters created during the accounting period are also closed, and cannot be edited or updated.

For more information on accounting periods, see Managing Accounting Periods.

1. Close the accounting period for which you want to export data. Click the Billing tab at the top of the page. The Accounting Period tab appears in the left-hand navigation bar.
2. Click the Accounting Periods tab.
3. Select the year for which you want to view data in the Accounting Periods page.
4. Click Edit in the Action column, and then change .
   Image Added
5. Change the status to Closed.
   Image Added
6. Click Save.

Export the Data

After you create your crosswalk entries, you can export billing and payment data associated with each crosswalk. The application generates a .zip file containing the exported data in two the following comma-separated value (.csv) files named :

• billing_data.csv

...

• :  contains submitted claim amounts (revenue recognized)
• cash_data.csv

...

• :  contains cash, check, insurance, and patient payments received (revenue realized)

DrCloudEHR downloads the .zip file to your computer. Open each .csv file within the .zip file, and import the data from these files into your general ledger system.

1. Click the Account Ledger tab, and then click Export.
2. Select the month and year that correspond to the accounting period for which you want to export data.

3. Click Search to load the data for the selected accounting period. 
   The following image shows a summary of the export data for each crosswalk. For each claim or payment included in the data, the GL Account column contains two accounts. The account number in the first row is the Revenue or Cash account number as defined in the crosswalk. The second row contains the A/R account number.
   

   Image Removed 

   
   Image Added

4. Enter a title for the export.
5. Click Export. The application generates a .zip file containing two .csv files, and downloads the file to your computer.
   
   The Export button is disabled if the data contains entries without general ledger account numbers. Click the Download Records with missing GL A/C button to download the entries that contain missing account numbers.

...