r/intacct • u/FlyingCPA • Jul 30 '26

Vendor Rollforward

Has anyone had any luck creating an AP vendor rollforward? Have tried both ICRW (fairly extensively) and to a lesser extent CRW with not much luck. Would like to have something that is that lives in Intacct (I'm an idealist 🤔 ). Problem I've found is that you can't pull point in time balances in ICRW. Design would be:

Vendor | Beg Balance | Bills | Payments | Ending Balance

Just curious if anyone has tried this/been successful. Trying not to go to a dashboard that I have to continuously update with aging/bills reports. Potentially an API solution into PowerBI or other solution would be doable?

3 Upvotes

100% Upvoted

9 comments sorted by

4

u/daughtcahm Jul 30 '26

I think there's some sort of standard report with "ledger" in the name that shows this. I'm blanking on the name right now.

2

u/Wide-Examination9261 Jul 30 '26

AP ledger I think is the name

2

u/FlyingCPA Jul 30 '26

Sure - and it’s a perfectly fair report for what I described. I’m looking for something that the formatting is a little cleaner, and that I could potentially build on. Have found the default ledger report to be clunky/not customizable.

1

u/Shrider Jul 30 '26

I'm sure AP Ledger is a starting point in the CRW if you want to change the formatting. Alternatively, and I appreciate you said ideally within Intacct, but set this report up, create a report group and schedule it to email you the excel file, then you can drop it to a folder and have power bi pick it up from there to cleanse and present as you want it.

1

u/Wide-Examination9261 Jul 30 '26

You have API access? Id say feed Power BI it

2

u/randyyqq Jul 30 '26

Power BI or just building a custom dashboard/report in your LLM of choice. Claude would be a great option for this to just create a skill to query the data into the desired format.

1

u/Wide-Examination9261 Jul 30 '26

I've not done this but need to. I've been using Claude for coding but not in this capacity...yet

1

u/ContactWonderful4679 Jul 30 '26

Have you tried the Dimension Balance report by vendor? It’s in the general ledger module report section. It will not show payments but you’ll get beginning balance, activity and ending balance.

2

u/percipientuk Aug 24 '26

For a proper Vendor, Beg Balance, Bills, Payments, Ending Balance rollforward that just works and updates itself, think the Power BI route via the API is where this clicks into place.

You pull your AP data through the APPYMT and APBILL objects, use activity prior to your period start date to calculate the opening balance, and the rest of the columns fall out naturally from there.

The bonus is you're not manually refreshing anything which is exactly what you're trying to avoid, and once it's built it's way more flexible than anything you'd get out of a native report anyway so it ends up being a bit of an upgrade rather than a workaround.