Accounting, Financial Model, General Excel Financial Models, Service Businesses |
Accounts Payable, Accounts Receivable, Bookkeeping, Excel |
Video Tutorial:
Google sheets version included (see bottom of instructions tab)
*Update: There is now an aging dashboard for receivables and payables to show how much money is passed due that you owe or that customers owe you as well as a summary of how much receivables/payables you have coming due in the next 12 months. Charts included and a top 10 list.
There is a simple database 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 effortlessly 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 on the sheet so you can see example entries.
Similar Products
Other customers were also interested in...
Accounting Financial Model Bundle
This is a combined collection of Excel and Google Sheets financial model templates for Accounting an... Read more
3 Statement Financial Modeling with DCF & Rel...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more
Accounting Firm Financial Model – Dynamic 10...
Financial Model providing a dynamic up to 10-year financial forecast for a startup or existing Accou... Read more
Price Volume Mix Charts and Analysis – On re...
Best practice model for a complete Price Volume Mix (PVM) analysis on revenue and on gross profit by... Read more
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Bookkeeping Agency Financial Model Excel Template
Try Bookkeeping Agency Financial Plan. Allows you to start planning with no fuss and maximum of help... Read more
Financial Advisors Agency Financial Model Excel Te...
Shop Financial Advisors Agency Pro-forma Template. Creates 5-year financial projection and financial... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Small Business Playbook (Financial / Tracking Temp...
About the Template Bundle: https://youtu.be/FPj9x-Ahajs These templates were built with the ... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
You must log in to submit a review.