Accountant Forums


Reply
Thread Tools

How to reconcile Accounts Payable

 
 
Richard
Guest
Posts: n/a
Thanked:
 
      11-14-2006, 06:52 PM
My general ledger A/P account does not match the historical A/P Aging. The
same goes for my A/R. Can anyone help me figure this out?
 
Reply With Quote
 
 
 
 
SumCPA
Guest
Posts: n/a
Thanked:
 
      11-15-2006, 08:25 PM
It might help if you described how you created the balances. Were they
migrated from another program? If so, were individual invoices and bills
added or were the customer and vendor opening balances entered as a single
dollar amount? Are both the general ledger report date and the Aging
reports' dates all set to the same date? I'm really curious how this
happened!

"Richard" wrote:

> My general ledger A/P account does not match the historical A/P Aging. The
> same goes for my A/R. Can anyone help me figure this out?

 
Reply With Quote
 
 
 
 
RICHARD
Guest
Posts: n/a
Thanked:
 
      11-16-2006, 02:58 PM
I have the A/P - A/R defualts set at "Batch entry". The report dates are set
the same. I posted all batches from the A/P and A/R modules. This situation
just happen prior month. I have been trying to figure this out for the last
week.

In the past 5 months, my A/P and A/R balance to my G/L. Therefore, the
problem happened in October. I have tracked down a few Audit trails that did
not post to the G/L. I am in the process of figuring out what accounts did
the entries post.

I am having a problem with my A/P month ending aging report and my month end
A/P G/L account. The balances are off. I have some entries not posted to
the G/L and some not in the A/P module. Therefore, I am trying to reconcile
the A/P Aging vs. the A/P G/L. I am trying to find out what happen and how
to fix it.

This is the same issue with My A/R vs. my G/L.

I REALLY NEED HELP FINDING OUT WHAT POSTED TO THE G/L AND WHAT DID NOT.
I really need some help with this. My CFO needs financial two days ago for
the board meeting. It does not look good that I cannot correct this issue.
HELP. LOL

I am looking at and have ask for help creating a smartlist call A/P
transactions and A/R transactions. Then I will be able to manually track
each day posting to the individual modules.



"SumCPA" wrote:

> It might help if you described how you created the balances. Were they
> migrated from another program? If so, were individual invoices and bills
> added or were the customer and vendor opening balances entered as a single
> dollar amount? Are both the general ledger report date and the Aging
> reports' dates all set to the same date? I'm really curious how this
> happened!
>
> "Richard" wrote:
>
> > My general ledger A/P account does not match the historical A/P Aging. The
> > same goes for my A/R. Can anyone help me figure this out?

 
Reply With Quote
 
SG
Guest
Posts: n/a
Thanked:
 
      11-17-2006, 03:20 AM

RICHARD wrote:
> I have the A/P - A/R defualts set at "Batch entry". The report dates are set
> the same. I posted all batches from the A/P and A/R modules. This situation
> just happen prior month. I have been trying to figure this out for the last
> week.

<******snip******>
>
> I am looking at and have ask for help creating a smartlist call A/P
> transactions and A/R transactions. Then I will be able to manually track
> each day posting to the individual modules.


I almost didn't know what you were talking about until I saw the
reference to "smartlist". That's a Great Plains reference, not an
Office Accounting reference. You are either using Small Business
Manager or some other Great Plains product. Either way, I think you
are in the wrong newsgroup.

-----
SG
http://sba2006.blogspot.com

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Are are liability accounts payable accounts yankitwizzy General Accountancy Discussion 1 02-21-2012 02:04 PM
Trial Balance - Accounts Payable and Accounts Receivable John Dann Quickbooks 4 04-11-2005 12:11 AM
Accounts Payable Specialist, Alpharetta, GA to $34K Ed Freeman, Recruiter Accounting 0 12-02-2004 10:14 PM
Accounts Payable Specialist, Alpharetta, GA to $37K Ed Freeman, Recruiter Accounting 0 08-18-2004 02:50 PM
ACCOUNTS PAYABLE / RECEIVABLE SUPERVISOR!! Prominc Accounting 0 08-19-2003 02:38 PM


All times are GMT. The time now is 04:35 AM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.