Skilled Nursing Facilities

Reconciliation - Accounts Receivable Overview

The G/L Reconciliation and Month End Close process occurs after you close the same period on the Admin module. Do 2 steps before you begin the Month-End Reconciliation process for G/L:

  1. Ensure that the period you are planning on reconciling and closing in GL/AP is closed and rolled into the next period on the Admin side.

  2. For new implementations and facilities in the transitional phase, ensure the A/R chart of accounts are mapped correctly using the GL chart of accounts on the consolidation side. Double check that account segments are correct and that all Day Accounts are listed as admin and consolidated accounts.

Then you review the following reports and, if necessary, reconcile any differences.

  • A/R Aging *New* report for the closed month

  • A/R Reconciliation Report

  • G/L Trial Balance for A/R Accounts

  • G/L Transactions Report for A/R

  • Cash Receipts Journal

  • Journal Entries Report for the closed period by G/L account and also by consolidated account.

  • Run the A/R Aging *NEW* report for the reconciliation month using the options of By: Payer Type and Group Totals By: Payer Account to create a report that has a final Totals summary on the last page that lists the totals Payer Account showing the Admin G/L Account Number. Use the report to balance to the G/L Trial Balance report. To determine the which Admin G/L Account ties to the Consolidation account, go to Admin>Setup>Billing Chart of Accounts>select Show Accounts for A/R and click Printable View.

  • Compare the totals on the A/R Aging to the G/L Trial Balance report run for the range of A/R G/L accounts. If the totals do not match, then you should check that the opening balances in both reports are matching. Print a copy of the Journal Entries Report and ensure that all entries were carried over correctly to the A/R accounts. Also, check that there are no adjustments posted to the A/R accounts. Any adjustments posted result in circular entries and the A/R account are not balanced.

  • Generate the Journal Entries Report for the closed period, run summary and group by GL account. Print the report. Then run the report again using the Group By of Consolidation Account. Compare reports and ensure that all the G/L Accounts are mapped correctly to the consolidation accounts.

  • Compare the Cash Receipts total from the Cash Receipts Journal to the total on the Cash Receipts column of the A/R Reconciliation Report and the Cash Receipts section of the Journal Entries Report.

  • Compare the A/R Aging total with the closing balance on the A/R Reconciliation Report and the balance on the A/R accounts on the G/L side. Reconcile any differences. Regenerate the A/R Aging Report, if necessary then print the summary page.