The Vendor Balances report shows a breakdown of the Vendor balances. This report is often used to archive Vendor balances at month end.
Note: That the Vendor Balance report with the Aged Balances selection cannot be recreated once the fiscal month is closed.
Setup:
Navigate to Accounting Reports/Accounts Payable/A/P Status
On the A/P Status Reports screen select Vendor Balances. There are a few different ways that the report may be run, depending on what information is desired.
- Current Balances style will display vendor balances for regular, prepay and overall. Choose which fiscal month balances to display.
- Aged Balances style will display vendor balances broken down into the appropriate aging brackets.
- 1099 Summary style will display vendor 1099 paid amounts. The Print 1099 Candidates Only option is available with the 1099 Summary balance style and will display only vendors with a 1099 type set on the 1099/Payment tab of the Vendor file.
- 45 Day Aged Balances style will display vendor balances in aging brackets up through 45 days.
The Include Zero Balances option is available on all Balance styles and will display a Vendor even if they have a zero balance. The Show Detail option is available with the different aged balance styles, displaying invoice numbers and totals that make up the Vendor balance.
