Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

AP Trial Balance Posting Date Problem

AP Trial Balance Posting Date Problem

AP Trial Balance Posting Date Problem

Someone here entered a large number of AP Invoices with a posting date of December 3, 2008.

Then they issued checks against them with a posting date of November 30, 2008.

Sounds pretty trivial to me, but the beancounters here are really upset and want this fixed somehow so that the payments are not in a period before the invoices.

Any recommendations?  I would appreciate it.   

RE: AP Trial Balance Posting Date Problem

Being an ex bean counter, I can see the auditors getting mad at that.  Did these AP Invoices have November or December invoice dates? We're the checks dated November or December?   

RE: AP Trial Balance Posting Date Problem

Thanks.  This was random.  There were a lot more invoices that weren't misposted.  Just someone being careless.

About $800,000 worth of invoices.  Most of the invoices with December 3 posting dates had November invoice dates.  So most likely the mistake is in the invoice posting date, not the check posting date.   Probably all.   Checks were actually issued in December, with posting dates in November.

We've had a lot of temps and new people.  

I don't know what they plan to do.  


RE: AP Trial Balance Posting Date Problem

This seems to be a simple fix. A reversing journal entry can be done to place the AP expenses in the correct accounting period (November).  As for the checks, if they had December check dates but a November posting date, then you can do a reversing journal entry can be done to properly show the outflow of cash in the correct accounting period (December).  The AP invoice entry will be more lengthy than the AP Check entry.  This may be too much accounting talk but this can be corrected without entering credit memos and voiding checks (which takes way longer).  Basically, with a reversing entry, you have one opposite journal entry in the incorrect period (to reverse it) with a reversing date of the correct period.  This is one entry in MAS90 but adding a reversing date makes it 2 entries (but half the work).

I used to fix this all the time when my AP clerk didn't understand the matching principle so there were timing issues non-stop.  Issues like this will cause a mismatch between your AP Aging reports and the AP account in the General Ledger. Issues will also come up when reconciling the Bank Reconciliation module with the cash account in the General Ledger.   

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close