The Open Invoice Register w/ cut off date for 12-31 is more than my Balance Sheet account. So it would seem that something is in the AP detail and not the GL. I do not have any unposted invoices. Is there a report I can run to identify this?
The Open Invoice Register w/ cut off date for 12-31 is more than my Balance Sheet account. So it would seem that something is in the AP detail and not the GL. I do not have any unposted invoices. Is there a report I can run to identify this?
General Ledger journal entries might be the difference.
I checked, there are no direct GL entries.
I would run the AP/GL Reconciliation/Period End Report for AP Accts and see if that ties to your Balance Sheet Account. Then you can compare the two reports for any invoices on one but not the other.
Most often, for us, it's becasue a posted transaction didn't actually post to the GL. The first thing I do is post the general ledger and see if anything has been rejected. then I check the balances again. If that didn't work, I do the Reconciliation RachelleS mentioned.
It could be an Accounting Date issue. Try running an Open Payables with no cut off date, and compare it to your Future G/L balance to rule that out.
Yes, it was date issue with a future accounting date on a recurring invoice that I voided, but will not post to GL.
Thank you all.
It may be a posting issue. When this happens, I first check for direct GL entries. Then, I do a post in AP and a post entries in GL. Sometimes the data does not come over and this may clear up the issue. Run your open invoice register and compare to GL total after doing the post process.
*Community Hub is the new name for Sage City