Anyone know how to create a report with a list A/P on a certain date in the past? (For year end review to confirm for Balance Sheet). Thanks in advance!!
You can try 4-1-3-71 through 77.
Thank you Matthew. This gets me close to what I need. I'm trying to tie out my balance sheet to vendor balances to confirm if all are accurate (for cpa)
Sharon, the only reports that are designed to reconstruct balances at the end of a prior period are reports 4-1-3-21, -26, -51 and -56. The period aging reports don't add back subsequent payments and won't help with the issue. My personal preferences are the -26 and -56 reports. Make sure you sort by vendor rather than by record.
Thank you Walt - The 4.1.3.51 gets me close, but doesn't quite match the Balance sheet Trade Accounts Payable figure. (Balance sheet $188674 and the Vendor aging report $190852.) It is troubling that I can't drill down on that balance sheet figure
Sharon, Is your 1-6 General Ledger Audit coming up clean (ie No Errors Found)? It's also possible that there may be a problem with posting periods of Invoices vs Payments, but that is unusual and very hard to find.
No Errors Found. Well, it's not a deal breaker, but a bit flustering : ) When the CPA requests a report showing the Vendor A/P as of end of year, I'd like to be able to produce something that matches the Balance Sheet. Doesn't convey confidence when figures don't match.
Wait! I found it -- searched the exact amount off and found that a payment was posted dated 2021 and the invoice was in 2022!
Sounds like you probably have some invoices posted to the wrong accounting period. You should be able to drill down on the Balance Sheet, but its easier to just run a GL report 2-4-31. Run it for the A/R account, same period you ran the Balance Sheet, sorted by transaction date, and look for any invoices that are dated after the period. Hi Walt!
Sounds like you probably have some invoices posted to the wrong accounting period. You should be able to drill down on the Balance Sheet, but its easier to just run a GL report 2-4-31. Run it for the A/R account, same period you ran the Balance Sheet, sorted by transaction date, and look for any invoices that are dated after the period. Hi Walt!
Hi Char!
*Community Hub is the new name for Sage City