Your Balance Sheet should include prepaid amounts for any association where owners have paid more than the current charges. This applies to associations using either Accrual or Modified Accrual accounting methods.

Discrepancies usually result from a couple of issues:

  • A common issue is when a payment is applied and unapplied using dates in different months. To correct this, a journal entry needs to be added and then reversed after the original transaction occurs.
  • The import from the prior system was not fully completed.
  • Extra GL entries made manually to the A/R or Prepaid accounts.



To identify the issue, follow these steps:

  1. Run the Report: Go to Report > AR > AR Balance Discrepancy Report. This report shows daily differences between AR and Prepaid amounts on the Balance Sheet versus owner ledgers, helping to pinpoint where the discrepancy started.

By checking the report, you can identify the date when the discrepancy occurred.

If the discrepancy dates back to when you first started working in eUnify, we recommend comparing total amount in the imported file from the prior system to the beginning balance in the GL. After this, corrections should be made either by adding the correct import or by adjusting the GL amount as needed.


 From the screen above, the report indicates that the discrepancy began on 05/14/22. Let's start analyzing it:

  • The Owner AR increased from $417.00 to $667.00, an increase of $250.00.
  • However, the GL AR column did not reflect this change and remained at $417.00 from the previous day.



This indicates that while the total owner balances increased, the GL did not reflect this change. To address this, you should start by comparing two AR reports:

  1. Run an ‘Open Balance’ AR report for the date before the discrepancy began.
  2. Run another ‘Open Balance’ AR report for the day when the discrepancy started.

You can easily export these reports to Excel for a more convenient detailed comparison.




Afterward, you can determine which homeowner’s balance changed by comparing the two reports. If a charge was added to a homeowner’s account but did not hit the GL, you can add a Journal Entry to correct it.

You can also conduct a deeper investigation by including the General Ledger report for the day when the discrepancy occurred. To do this, go to Report > Accounting > General Ledger Report and run the report for the specific account in question. Also, you can export the report to Excel from the GL Account Inquiry page for further analysis. Feel free to use the method that works best for you.

Each charge added to a homeowner’s account should be reflected as a debit in the GL AR, and each payment applied to the charge should be reflected as a credit in the GL AR. To verify this, you need to:

  1. Select the homeowner's balance from the day before the discrepancy occurred.
  2. Add the charge if it was newly added or subtract it if the charge was applied.
  3. Compare this adjusted balance to the amount in the AR on the day the discrepancy occurred.

The result should match the AR amount for that date.


If not, you need to determine what is causing the issue and make corrections if needed.