The Accounts Receivable Report, located in the Accounting/Financial section of the Reports Ability, calculates and tracks the status of your practice's Accounts Receivable (A/R).
The Accounts Receivable report is considered a "real-time" report. This means that at the moment it is run, it will calculate your practice's A/R for all data that's entered within MacPractice and present the status of your A/R as of that moment.
You cannot run the Accounts Receivable report for a specific time-range. If you want to review how your A/R looked at a specific time, you'd have to retrieve a backup from that day. You can also run the A/R Report every day and when printing, you can save a copy of the A/R report as a PDF for your records.
NOTE: The A/R is based upon the charges' Procedure Date.
NOTE: The A/R Report will still list all providers, including any inactive providers that may have been filtered out by the "Hide inactive providers from report filter" checkbox in Preferences > Reports.
Filter Options
Like most other reports, at the top of the Reports window you'll see several filters and options to control what results are displayed when you click the "Apply" button off to the right.
If you filter the A/R report, the Total and Net A/R results at the bottom of the report will reflect only those accounts that are included in the filters. For an accurate total A/R for your practice, we recommend running the report with all filters unchecked.
Filter Providers: Filters the report based on the provider listed on the outstanding charges.
Filter Offices: Filters the report based on the office listed on the outstanding charges.
Filter Financial Status: Filters the report based on the Financial Status listed in the Account tab.
Any filters applied will exclude those accounts from impacting the Accounts Receivable report, meaning that the total A/R information at the bottom of the report will be impacted. For a complete A/R for your practice, ensure no other filters are set.
Below the Provider, Office and Financial Status filters are three tabs with additional options.
General Tab
The General Tab contains several different options to control how results are displayed.
Show Primary/Show First Patient Name: If you have the Show Primary radio button selected, you will see the Primary's name and phone number on the report. If you select Show Patient, it will show the name of the first patient on the account.
Hide Patients: This checkbox allows you to hide the list of accounts and their aging analysis. With this box checked, you will see only the aging of the A/R for your office as a whole.
Hide Financial Status list: Checking this box will omit the list of financial statuses that print at the bottom of the report.
Show Archived Patient Only: This option will display your archived patients in the report results.
Show Patient Portion Balance and Show Insurance Portion Balance: Each of these checkboxes will add a line to the report that shows the aging analysis of the Patient and Insurance portions from the patient's account.
NOTE: These checkboxes will not filter what accounts are shown on the report. Checking Show Patient Portion Balance and leaving Show Insurance Portion Balance unchecked will not bring up a list of accounts that only have a patient portion. It will simply hide the insurance portion information on the report.Show Last Payments: Checking the Show Last Payments box will add a Last Payment area to the report for each patient. This area contains two lines: Last Patient Pay and Last Insurance Pay. The Last Patient Pay line will show the type of the payment (Check, Card, Cash, and so on), the amount of the payment, and the posted and procedure dates associated with the payment. The Last Insurance Pay line will always have Payment Insurance listed for the description. It will also show the amount of the payment, as well as the posted and procedure dates.
Show Last Statement Date: The Show Last Statement Date checkbox will add a line to the report that tells you the date of the most recent statement on the patient's account.
Show phone number: If this box is checked, the first phone number listed on the account will be displayed on the report.
Balance Filter Tab
The Balance Filter Tab contains two options. You can filter results by either the Minimum Account Balance, or the Minimum Credit Balance. These fields allow you to enter a dollar amount.
You may find it useful to run the report with a credit balance of $0.01, and a $0.01 account balance. This will display a list of patients that have unapplied payments that should be applied in order for the Provider that performed the procedure to finally earn credit. The Unapplied (Credit) Balance report will show any accounts with unapplied balances, but it does not allow you to filter the report to show only accounts with a balance.
Aging Options Tab
Show Accounts With Overdues: This menu will allow you to filter out any patients that do not have overdue balances in the selected range. For example, if you select "91 + Days", only patients who have balances that are over 91 days will be shown. A patient will still be shown on the report if they have a more recent balance than the selected Overdue Days filter, provided they also have a balance that has reached the selected age.
Overdue Evaluation Date: These selectors allow you to determine the type of date used to determine Overdue balances. You can choose from the Service Date (determined in the Service Date Calculation selector), or the last Insurance Payment's Posted Date.
Service Date Calculation: This selector determines what is considered a Service Date for the purposes of the Overdue Evaluation Date. You can choose either Posted or Procedure Date.
NOTE: As with the Provider/Office/Status filters, the "Overdue Days" filter will cause patients to be omitted from the A/R report, and consequently from the total A/R information at the bottom of the report. For a complete A/R for your practice, select "All" from the Overdue Days menu.
Results Columns
There are two sections to the results in the A/R report.
The first thing you will see on the report (assuming you do not have the Hide Patients checkbox checked) will be a list of all accounts that match your filters and their balances. The information shown on the breakdown depends on the filters you've selected.
In the example below, the Show Last Payments, Show Last Statement Date, Show Patient Portion Balance, Show Insurance Portion Balance and Show Phone Number checkboxes were all checked:
The Account Number and Primary Name are listed, as well as the Financial Status and Primary Phone number. If you have the preference checked to include anticipated write-offs, the Pending Write Offs will be displayed in parenthesis, and the Expected A/R (actual A/R minus Pending Write-Offs) will be displayed in green.
It is important to note that even if an account has a zero dollar balance, if there are unapplied credits tied to an included Provider that you've selected in the Filter Providers box, that account will still appear regardless of any Balance Filter options set.
Below the information for individual patient accounts is a breakdown of the A/R for the practice as a whole. If you have the Hide Patients checkbox checked, this will be the only part of the report you will see.
This area breaks down the money owed by the same criteria the patient accounts' balance is broken down: 0-30 days, 31-60 days, 61-90 days, and so on. For each aging range, there are multiple rows that display additional information, depending on what Balance options are checked in the General Tab.
The Account Balance column shows the dollar amount of monies owed for that time period.
The % of Total column shows the percentage of the amount owed, out of all money owed to the office. After the "% of Total" column is a bar graph that represents this percentage. The blue portion of the bar represents the amount that is patient portion, and the red amount reflects the insurance portion.
Next, the PAT PORTION and INS PORTION columns. These columns display the dollar amount of money owed from that time period that is in the patient or insurance potion, respectively.
Below the total aging analysis is some additional information on your office's A/R.
Total number of Accounts: Lists the total number of accounts that fit the selected filters.
Total Patient Balance: Lists the total for money owed to the practice that is in the patient portion. If you add all the amounts in the patient portion column together it should equal this number.
Total Insurance Balance: Displays the total amount owed that is listed in the Insurance Portion. Like patient portion, this should equal all the amounts in the Insurance portion column added together.
Accounts Receivable: This is the total unpaid balance for all accounts, whether in Insurance or Patient portion. If you have the "Show Pending Write Offs" option enabled, the Expected A/R (actual A/R minus Pending Write-Offs) will be displayed in green.
Total Unapplied Balance: This amount reflects any unapplied patient payments, insurance payments, or negative adjustments. If there are any unapplied bulk payments, it will be noted here. This should match the total on the Unapplied (Credit) Balance report, assuming you have all providers selected for each, and no date range on the Unapplied report. if you filter by provider, the reports will not match, as the unapplied report filters based on the provider listed in the payment/negative adjustment window, and the A/R report filters based on the provider in the account window.
Net Billed A/R: This is the Accounts Receivable amount, minus the Unapplied Balances. The Net A/R is calculated with the following equation: Net A/R = Production + Tax + Pos. Adj. + Refunds + Finance Charges - Deposits - Gross Neg. Adj. - Write-Offs If you have the "Show Pending Write Offs" option enabled, the Expected A/R (Net A/R minus Pending Write-Offs) will be displayed in green.