Accounting, Financial Model, General Excel Financial Models, Service Businesses |
Accounting, Accounts Payable, Accounts Receivable, Bookkeeping, Financial Model, Google Sheet, Performance Tracking |
This is a Google Sheets version of the financial model template for tracking accounts payable and accounts receivable (see Excel Version here Accounts Payable Template | Receivable | Tracking. Included are the following:
- Aging dashboard for receivables and payables to show how much money is passed due that you owe or that customers owe you
- Summary of how much receivables/payables you have coming due in the next 12 months
- Simple database-type tab for receivables and payables
- Monthly graph showing balances owed, amounts paid, and bills/receipts entered to be paid later
- Built for a few hundred vendors and customers (can be expanded if needed)
- Option to pick any date and see what the net balances are for a given customer or vendor
- Charts and Top 10 list
You will need a Gmail account to open the Google Sheet file via Google Drive.
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
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
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
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
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... 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
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
Small Business Playbook (Financial / Tracking Temp...
About the Template Bundle: https://youtu.be/FPj9x-Ahajs These templates were built with the ... Read more
You must log in to submit a review.