Payable and Receivable Tracking (Google Sheets)

This is a Google Sheets version of the financial model template for tracking accounts payable and accounts receivable

Payable and Receivable Tracking (Google Sheets)
, , ,
, , , , , ,

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.

Here are a few screenshots of what the model looks like:

Accounts Payable and Receivable Tracking

Accounts Payable and Receivable Tracking in Google Sheets

Accounts Payable and Receivable Tracking in Google Sheets2

Accounts Payable and Receivable Tracking in Google Sheets1

Accounts Payable and Receivable Tracking in Google Sheets

 

Write a Review

Get these templates too for a discount!

Price: $225.00

This is a combined collection of Excel and Google Sheets financial model templates for Accounting and related uses, such as:…

Add to wish list
Add to cart Excluding 0% tax

Price: $200.00

This is a collection of financial model templates for Real Estate businesses and its related sectors. The models included in…

Add to wish list
Add to cart Excluding 0% tax

Price: $170.00

  This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are…

Add to wish list
Add to cart Excluding 0% tax