Skip to content

Why AR aging doesn't match the GL

Mid-month, your AR aging and the AR account in the general ledger usually won’t match, and that’s normal. The most common reason is the customer deposit reclass, which only posts at month end. Other causes are payments not yet deposited, deposits that didn’t post to the GL, and an opening balance difference left over from setup.

At month end, the AR aging should balance to AR on the balance sheet.

  • Customer deposit timing. Payments on folders that aren’t invoiced are credited to AR when deposited. On the last day of the month, Nexsyis moves them to Customer Deposits, and reverses that entry on the 1st. Until month end, the GL and the aging differ by the payments on those folders. If the difference stays the same, nothing is wrong. See Customer deposits and the month-end reclass.
  • Deposit date and payment date. AR in the GL uses the deposit date. The AR screens use the date the payment was entered. A payment that’s recorded but not deposited yet sits in undeposited payments, not in the GL cash and AR entries.
  • A deposit didn’t reach the GL. Occasionally a deposit doesn’t post because of a connection problem. Nexsyis support can run the GL again for that deposit.
  • Opening balance from your old system. At setup, outstanding AR is entered from your previous system. If the GL from your old accounting system was never adjusted to match, the difference carries forward. A one-time adjusting entry fixes it.
  1. Compare them as of the last day of a month, after the customer deposit reclass has posted.

  2. If you’re checking mid-month, compare the difference with the total payments on folders that aren’t invoiced yet. If they match, you’re fine.

  3. Check payments that haven’t been deposited. On the AR payments screen, select Not Deposited to see them. You can also run the Undeposited Payments report; your administrator may need to give you permission to it.

  4. For recent deposits, confirm each one appears in the GL cash account. If one is missing, contact Nexsyis support so the GL can be run again.

  5. If the difference has been there since go-live and never changes, ask your accountant about a one-time adjusting entry so the GL matches the aging.

Example: On the 15th, AR in the GL is higher than the aging. Several cars have deposits but aren’t invoiced yet. Once the month-end reclass posts, the two balances line up.

  • The two don’t match at month end, and the difference isn’t explained by undeposited payments or a known opening balance difference.
  • A deposit you made doesn’t show in the GL.

Send the aging report, the GL balance, and what you think the difference is.