What Business Central's documentation says
- The Aged Accounts Payable Excel report (4403) groups vendor ledger entries into buckets using the Aged as of and Period length parameters; the older Aged Accounts Payable report (322) is listed as legacy. Source 1 (opens in a new tab)
- The Aged Accounts Payable report (322) shows outstanding invoices, credit memos and payments for vendors, as a balance per vendor or a breakdown of each open document. Source 2 (opens in a new tab)
Checked against the vendor's documentation on Nov 7, 2026. Products change; the vendor's current help is the final word.
What the aging report shows
In Business Central, the Aged Accounts Payable Excel report (4403) groups vendor ledger entries into buckets using the Aged as of and Period length parameters. Set Aged as of to the date you want to review, then choose a Period length that matches your review cycle. The export is the working file for AP: one row per open entry, with vendor details and amounts. Use External Document No. as the supplier's invoice number. That field is often the difference between a clean review and a pile of rows you cannot match.
The older Aged Accounts Payable report (322) is listed as legacy. For reference, the Aged Accounts Payable report (322) presents outstanding invoices, credit memos and payments for vendors, as a balance per vendor or a breakdown of each open document. On a day-to-day basis, use 4403 for the export you can filter and sort. For anything not covered here, such as how a specific document behaves after a void, check Business Central's own help.
What to look at first. Scan the oldest buckets and any row with a blank External Document No. A blank or generic reference makes matching slow and is a common reason duplicates survive. Then look at vendor totals, not only individual rows. A vendor with a large debit balance or a cluster of open credits deserves a closer look. The aging is a map of open items, not a verdict. You still need the bill, the receipt, the payment record and the supplier statement to decide.
Reading credits and debit balances
In AP, a normal vendor balance is money you owe. A debit balance is usually money the supplier owes you or a credit you have not used. In the aging, an unapplied credit memo can sit alongside open invoices. If you pay the invoices without applying the credit, you turn a credit into an overpayment. The same thing happens when a supplier issues a credit memo for a return and nobody applies it to the next bill.
Read credits by vendor, not by report total. A single vendor can have an old credit memo, a current invoice and a duplicate payment all at once. Netting them into one balance hides the work. Open the vendor record, trace each open entry to its source document, and decide whether it should be applied, refunded or cleared. If the entry came from a payment, compare it with the bank file and the payment run. If it came from a credit memo, find the reason: return, price correction, shortage or rebate. Do not write off a debit balance just to make the aging look tidy.
Watch for credits that never get applied because they arrive after the invoice was paid. A supplier sends a credit memo for a short shipment. AP pays the original bill in full. The credit sits open. The aging then carries a debit balance that nobody owns. Put a name against every open credit and a next action. If the supplier will not refund, ask for a credit against a future bill in writing. Keep that note with the vendor record. For product behavior around applying entries, check Business Central's own help.
Using aging to spot overpayments
Most AP overpayments are boring. A bill gets keyed twice with a slightly different invoice number. The same supplier is set up twice. A statement is paid as well as the invoices. A payment run is sent again after a bank file issue. A credit memo is never applied. The aging will not label these as duplicates. It gives you open items and patterns. You supply the matching rules.
Start with invoice number variants. A supplier bills you as INV-1043. One clerk keys INV-1043 and another keys 1043. If both entries are open, they may be the same bill. Match on vendor, amount and a date window around the bill date. Do not rely on invoice number alone, because suppliers reuse numbers and clerks make typos. If the amounts and dates line up, hold both entries and ask the supplier for a statement. Treat the pair as a possible duplicate until you prove otherwise.
Next, compare vendor records. The same supplier set up twice will split activity across two accounts, so neither aging looks complete. Search the vendor master for near matches in name, address, bank details and tax ID. Run the aging for both records and look for the same invoice, the same amount and overlapping dates. Decide which record to keep only after you check open items. If one record holds the credit and the other holds the invoice, paying the invoice creates an overpayment.
Then look at statements and payment runs. A statement is a summary, not a bill. If AP enters the statement as an invoice and later pays the individual invoices, the statement entry stays open or gets paid twice. Re-sent payment runs do the same thing: the original payment and the re-sent payment both leave the bank, but only one is matched. For each suspicious row, match vendor, amount and date window against the bank statement and the payment file. Ask the supplier for a credit or refund once you have proof. Keep the request, the statement and the corrected entry together.
A monthly routine
Run the Aged Accounts Payable Excel report (4403) in Business Central with Aged as of set to your closing date and a Period length that fits your review. Export it and keep the raw file. Add columns for owner, status and next action. Do not edit the exported amounts; work beside them so you can trace back. Filter for blank External Document No. first, then sort by vendor and amount.
Work the exceptions in a fixed order. Old debits and credits first, because they are the most likely to be forgotten. Then invoice number variants such as INV-1043 and 1043. Then vendors with duplicate records. Then open items that match a supplier statement but not a bill. For each item, write a short note: what you checked, what you found and who owns the next step. A simple routine beats a large cleanup done late.
Close the loop with suppliers. Send a statement request to any vendor with an unexplained debit balance. Ask for a credit or refund in writing when you find an overpayment. If the supplier agrees to apply a credit to a future bill, note the agreement and check the next statement. At month end, compare the aging total with the vendor ledger and the AP control account. If they do not agree, stop and find out why before you pay anything else. Check Business Central's own help for steps not covered on this page.
To review paid bills outside Business Central, export them: Export paid bills from Microsoft Dynamics 365 Business Central. The supplier's invoice number is in the External Document No. column.
Questions
What is the Aged Accounts Payable Excel report (4403) in Business Central?
It is the export that groups vendor ledger entries into date buckets using the Aged as of and Period length parameters. Use it as your working file for AP review. The older Aged Accounts Payable report (322) is listed as legacy.
Why does my AP aging have a debit balance for a vendor?
A debit balance usually means an unapplied credit memo, an overpayment or a payment made without a matching bill. Trace the open entry to its source document before you net it against invoices. If the supplier owes you money, ask for a credit or refund and keep the proof with the vendor record.
How do I find duplicate invoices in the AP aging?
Match open items on vendor, amount and a date window around the bill date, then compare the invoice numbers. A pair such as INV-1043 and 1043 is a common sign that the same bill was keyed twice. Confirm with the supplier statement before you classify it as a duplicate.
Should I pay a vendor statement in Business Central?
A statement is a summary of activity, not a bill. Pay the individual invoices and use the statement to reconcile. If a statement was entered as an invoice, check whether the underlying invoices were also paid and ask the supplier for a credit or refund if you overpaid.
Updated Nov 12, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.