Does Acumatica have a build-in tool to reconcile a Vendor Statement of Account?
Best answer by TimRodman
View original
Userlevel 5
+2
Are you looking to reconcile the total AP Balance to the GL or an individual AP Vendor Balance to something?
Individual vendor.When we get a Vendor Monthly Statement, our office manager is spending too much time (and with mistakes) comparing our open and paid invoices with the open and paid invoices on the Vendor Statement. I was hoping acumatica had a tool like credit card or bank statement reconciliation for Vendor Statements.
Userlevel 5
+2
Ah, interesting. I’m not aware of anything in Acumatica that does that, but it seems like it could be a good job for Excel, flagging missing transactions with Conditional Formatting.
Individual vendor.When we get a Vendor Monthly Statement, our office manager is spending too much time (and with mistakes) comparing our open and paid invoices with the open and paid invoices on the Vendor Statement. I was hoping acumatica had a tool like credit card or bank statement reconciliation for Vendor Statements.
I have the same needs. We have some vendors who routinely apply payments on their end differently than we have them applied on our end so we end up with discrepancies that need resolved before the next months bill is paid. It would be very helpful to have a way of marking individual bills and adjustments as “reconciled” or something similar and have the ability to filter by that parameter when preparing payments.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.