Accounts Payable and Receivable Tracking Template

There is a simple data base type tab for receivables and payables. Drop-downs are applied where it makes sense. The best feature is the monthly graph showing balances owed, amounts paid, and bills/receipts entered to be paid later.

The current template is built for a few hundred vendors and customers. It can effortless be expanded to many thousands if needed.

You can pick any date and see what the net balances are for a given customer or vendor. Also, you can see a running 10 year monthly summary of amounts owed to others / amounts owed to you all in one spot.

*Note the full version has more filters applied and I did leave a few lines of data into the sheet so you can see example entries.

 

Users who purchased Accounts Payable and Receivable Tracking Template, also purchased:
Valuation Model (Gordon)
Valuation comparison
Add to wish list
Purchase Excluding 8% tax
Gold Mine Investment Model
Gold Mining
Add to wish list
Purchase Excluding 8% tax
Paid Online Marketing Model
Paid Advertising
Add to wish list
Purchase Excluding 8% tax
Industry , , ,
Summary A simple template to keep track of the amount of money you owe other companies and how much other companies owe you.
Screenshots / Pictures


Use Cases , ,

Reviews

You must log in and be a buyer of this download to submit a review.