HOW-TO

How to run the AP aging report in Sage Intacct

Short answer

In Sage Intacct, run the AP aging report as at your chosen date. Check the total ties to your accounts payable balance and look at items over 30 days.

Last checked

An aged payables report lists what you owe each supplier, grouped by how overdue each bill is. What is accounts payable?

Before you start

  • Accounts Payable subscription
  • Vendor aging reports and graphs: Run permission

The Sage Intacct way

Where to find it: Accounts Payable > All > Reports > Vendor aging

  1. Go to Accounts Payable > All > Reports > Vendor aging.
  2. Select View for the default period or Customize to change the as-of date, aging periods and filters.
  3. Standard buckets are 0-30, 31-60, 61-90 and 91-120 days. You can add periods.
  4. Pick the reporting period or type the date for aging. If you leave it blank the report runs as of today, based on the bill date.
  5. Set filters such as vendor and vendor type. Every box is optional, but running with no criteria can be slow and give too many results.
  6. Use the buttons: View, Print (PDF), Process & Store, Add to Dashboard, Memorize and Export to Excel or CSV. Memorise the report so next month you only change the As of date.
  7. For multi-entity companies at the top level, choose a Reporting currency and Convert currency from (Base currency or Transaction currency). The Txn amount column always shows the bill in its transaction currency.

Limits in Sage Intacct

  • The report shows reversed transactions unless you change the setting in Configure Accounts Payable.
  • Merged or duplicate vendors cannot be combined in the report.
  • If you hide reversed transactions in Configure Accounts Payable, the help warns your subledger and general ledger might not balance.
  • If you inactivate a duplicate vendor, run the report for both vendors because the data cannot be merged.

Good to know in Sage Intacct

  • Can be run per entity or consolidated.
  • To forecast bills coming due, enter the aging groups in descending order, for example 60-31, 30-1, 0, 1-30, 31-60. Groups below zero then show bills that are not yet due.
  • If you compare the top-level and entity-level reports, set Convert currency from to Transaction currency on the top-level report.

Words Sage Intacct uses

  • Entity. A separate company or business unit inside one Intacct company. Multi-entity is a core feature.

Common mistakes

  • Not changing the reversed transactions setting before running it.
  • Running it for one entity when you need the consolidated view.

More help

Sources

Last checked 2026-10-19. Confidence: confirmed.

Common questions

Where is the aging report?

Accounts Payable > All > Reports > Vendor aging. Select View for the default or Customize to change the as-of date, aging periods and filters.

What are the standard buckets?

0-30, 31-60, 61-90 and 91-120 days. You can add periods.

Why does it show reversed transactions?

It shows them unless you change the setting in Configure Accounts Payable. Merged or duplicate vendors cannot be combined in the report.

Does Pulsify run this report?

No. Run it in your accounting system.

Want this done for you?

Book a call to see how Pulsify handles supplier bills in Sage Intacct.

Start free trial Book a call