Vendor Trend and Analysis in Column by period

1 votes

Creating this report will allow your client to know which invoices has not been received and it will assist in the month end expense accrued

Reviewed: Need Further Info Accounts Payable Suggested by: LeeAnn Ford (31 May, '23) • Upvoted: 31 May, '23 • Comments: 2

Comments: 2

01 Jun, '23
John Michael Admin
Hi LeeAnn, thank you for the suggestion! Could you please provide us with a specific example so we can better understand this request? We are wondering if entering a recurring expense with a reminder might work?
02 Jun, '23
LeeAnn Ford
Actually, no recurring entry would be two time consuming and would only work if you only have to change the description and dates.

Example:
Vendor Jan 23. Feb 23 Mar 23
Abila. 800. 800
Metro. 300. 250. 900
Nes. 5000. 1250. 200

So having a report like this tells me allot of things. First we didn't receive an invoice in March for Abila services. So, i need to accrue their invoice. Secondly, I would want a Drill down feature that takes me to the vendor balances where I can further search to see why Nes invoice was so high in January. It could be just high or it could be because someone processed an invoice to the wrong vendor. This report can assist with a lot of front end typing mistakes. It's too time consuming to go into every vendor balances to see if you'd receive a invoice and if you have was it entered in the correct period. This report will help you to see the bigger picture. Hopefully this helps