Accounts Receivable and Payable Invoice Tracking Excel Model Template

Description
This is a highly useful tool that allows any organization to keep track of their ongoing accounts receivable and payable records. Aging reports have been included to show the amount of money that is late per various ranges. Ranges include: Current; 1-30; 31-60; 61-90; 91-120; 121+

Advanced reports include seeing how much is planned to be coming due in future months per the defined due date of the invoice. There is also a report of the top 10 vendors and customers ranked by total balance.

You can look up any given vendor or customer and see all invoice activity over time or just up to a current defined date.

There are visuals and monthly summaries that show the amount invoiced / paid / current balance by vendor/customer and in the aggregate.

As far as the data entry goes, there is a database for receivables and a database for payables. Each allows you to separately define all your customers and vendors and based on those inputs, a drop down will allow you to pick from those lists when entering a given invoice.

The main fields for entry are date, invoice #, invoice amount, payment amount, work type (optional), customer name/vendor name, due date. There are also columns for extra fields if needed (10).

This template is also included in two bundles:
- All Models Bundle: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic
- Accounting Tools: https://www.eloquens.com/tool/axKzHNRV/finance/accounting/accounting-bundle-useful-excel-templates-for-accounting-department