General Ledger Accounting

General ledger accounting is used for recording all the financial transactions of the practice. The setup and configuration for the general ledger accounts are done through the GL Master in the Advanced Setup.

GL Master

1. Go to Advanced Setup-> GL Master. GL Master can be used to view all the accounts created in the practice (Image 1a) and create new accounts.

Image 1a

2. To add a new General Ledger Account, click on the icon on the top right-hand side of the GL Master page; see Image 1b.

Image 1b

3. Enter the details for the new General Ledger account to be set up. All fields are mandatory.

Image 2

4. Table 1 explains the fields in detail.

Field Description
Account # Enter the internal General Ledger Account #
Legal Entity Select the legal entity against which the account is being created
Account Type Select the account type from the drop-down list
Account Name Provide a name for the account being created
Account Balance Type Select the balance type (Debit balance/Credit balance) to which amount is to be added
under this account.
Amount Type Select the type of amount (i.e. Charge, Payment, Adjustment or Balance) to be grouped under
balance type in this account
Active This checkbox is active by default. To make an account inactive, uncheck it.

5. Click on Save after providing all the information and general ledger account gets created. To edit an account already existing, select the edit icon against the account on the GL Master page; see Image 3.

Image 3

GL Report

To run the GL report, go to Advanced Setup->GL Report. Provide appropriate search parameters and click on Search.

Image 4

The report can be exported into PDF and Excel outputs.

GL Detailed Report 

This report displays patient-wise debit and credit amounts generated. To run the GL Detailed Report, go to Advanced Setup ->GL Detailed Report. Provide the necessary search parameters and click on Search; see Image 5b for a sample GL Detailed report.

Search Filters

Image 5a

Search Fields Description
Acct Date Select an accounting date range
Set Batch Source As Provide a name for the batch source
Set Batch Name As Provide a batch name
Set Journal Template As Provide a journal template name
Destination Financial System Drop-down with the following options: Quick Books/Net Suite/ Work Day/Peach Tree/Great Plains

GL Detailed Report

Image 5b

The GL detailed report has two Excel outputs and a PDF output.

Custom GI Detailed Excel

This is a newly created Excel output. The important columns in the Excel, along with their descriptions, are given below.

Column Description
Journal Template Name The Journal template name provided in the search field will appear here
Journal Batch Name The journal batch name given in the search field will appear here
Line No This will contain a serial number with increments of 10,000
Account Type The destination financial system chosen in the parameter section
Account # GL Account#
Posting Date For GL accounts, if the amount type is either Payments or Adjustments, this will be the payment date
Document No –  (Leave it blank.)
Description For Credit Amount, this will be the Legal Entity + insurance company name
For Debit Amount, this will be insurance company name with the prefix “Receivable”
Debit Amount GL Debit Amount
Credit Amount GL Credit Amount
Source Code Batch source (provided in the search section)
Your Reference Patient PCRef#
External Document No.
Dimension Set ID
Transaction Information
Comment
Class Code (Dimension) “00”
Department Code (Dimension) LE code of the concerned legal entity
SubAccount Code(Dimension) Subpayer ID in the Insurance Master