Understanding your Vendor Balances report

This feature is available only for those that subscribe monthly to our Accounting and Reporting services. 

If you are NOT a monthly subscriber and would like more information, please view: How to upgrade to add Accounting and Reporting features to my Autobooks account.

Autobooks provides our subscriber users a report to see the total dollar amount you owe a vendor you do business with and how long ago the money was due OR vendors that may owe you a refund on a previously paid (but canceled) invoice. This type of report is also known as an Accounts Payable Aging report.

Accessing your report

Click on the Reports tab on the left side navigation within Autobooks. From there, click on the Vendor Balances option.

Your report may be sorted by an "As of date". The default view is today's date. To change the "As of date", click the down arrow next to Search criteria then change the date that appears.

Understanding the report results

The Venor Balance report displays all of your previously vendor invoices in alphabetical order of the vendors you work with. If owe no money to a vendor, the Total due column will display a balance of $0.00.

If a vendor invoice is currently due (but not late) a dollar amount will appear in the Current column. If the invoice is late past the due date, a dollar amount will appear in the appropriate range of days late. For example, if the vendor invoice is 40 days past due a dollar amount will appear in the 31-60 column.

Note: if you owe the vendor multiple invoices, the columns will show the total dollar amount that is late (not individual invoices).

A vendor may have a negative dollar amount in the Total due column. This will occur if you have canceled a paid invoice but have not yet been refunded the payment to the vendor. If you have received a refund from the vendor, you'll need to categorize the money deposit transaction using the Accounting tool. Check out our article on how to categorize a transaction here.

Exporting the results

To download the report results, click the Export button at the upper right corner of the search results.