Audit request on AR aging

  • Audit request on AR aging

    Posted by Danita-Simon on March 1, 2017 at 11:32 am
    • Danita Simon

      Member

      March 1, 2017 at 11:32 AM

      at year end, I ran a Sales Trial Balance Aging.  It shows 32 pages of unpaid invoices.  Now we are having an audit, and they are asking how many of those invoices have been paid since 12/31/16.  Is there a way to run a new aging showing the payments on there, but not showing any of the 2017 invoices on there?

      I do have Smartlist Builder if someone already has something ready.

      Thanks,
      Danita
      Detroit Metro Convention & Visitors Bureau
      313-202-1904
      dsimon@visitdetroit.com

      ——————————
      Danita Simon
      Senior Accountant
      Detroit Metro Convention & Visitors Bureau
      Detroit MI
      ——————————

    • Lou Spevack

      Member

      March 1, 2017 at 1:28 PM

      You can add the Current Transaction Amount field to the Historical Aged Trial Balance Report.  I would also add a calculated variance  field:  Original Transaction Amount – Current Transaction Amount.  Any positive amount in the calculated variance field would indicate 2017 payments against your year end open invoices.

      ——————————
      Lou Spevack
      Systems Accountant | Dynamics Credentialed Professional
      American Council on Education
      Washington DC
      ——————————
      ——————————————-

    • Leslie Vail

      Member

      March 3, 2017 at 5:31 AM

      Hi,

      Initially, I really liked Lou’s solution but then I got to thinking about which table holds the actual current document balance. That table, the RM Open table, isn’t included on that report. In order to add the true current balance to your report, I think you will need to create a new relationship between the RM HATB Document TEMP table and the RM Open Table, The screenshot below shows you what the relationship definition window should look like when you create the new relationship.

      Kind regards,

      Leslie

      wrLQprU1SxmD8zvwUWLQ_hatb2.png

      ——————————
      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX
      ——————————
      ——————————————-

    Danita-Simon replied 7 years, 3 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Audit request on AR aging’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!