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!
Sharon, you should probably decide whether you want the payment posted in 2022 or the invoice posted in 2022. In any case the payment will have to be voided and then reposted. This will affect your bank recons too. If you have a consultant that you work with, you should probably get the consultant to help you keep things straight.
Hi Char!
Will do - thank you!
Hi Sharon
If you upgrade to version 24.1175 you can edit the invoice to push it/the cost back to 2021 to match the payment without having to unclear the check and mess with bank recs.
*Community Hub is the new name for Sage City