Want FREE Templates on Strategy & Transformation? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

  Please register (it's free!) or login to view the remaining preview.
If you are logged in, your referral link [?] is automatically included below.
EMBED CODE (Copy and Paste)


  1. Assist users in controlling Accounts Receivable and Accounts Payable Balances and produce Aging Reports and Account Statements
  2. Template is suitable for any kind of business


The main purpose of the template is to enable user to monitor Accounts Receivable & Accounts Payable Balances.
The structure is user friendly and practical and is suitable for any type of business.
The template allows user to track Customers and Suppliers Invoices, produces A/R & A/P Aging reports and creates automated customer and supplier statements.

General Note

The template includes Input Tabs (gold color) and Output Tabs (dark blue color).
User needs to complete all the necessary info in the input tabs for the template to function properly.
As a general rule, try to avoid changing the formulas in the cells in the output tabs. Please contact us if you need assistance on the functionality of the template.

Template Instructions

Set Up Tab
-Customize the template for your businesses by entering the appropriate business details and banking details.
-Fill in Customers & Suppliers payment terms that apply in your company in the Payment Terms section

Customers & Suppliers Master Records
-Create Customers & Suppliers Master Database by filling in all columns with the required info

Customers & Suppliers Invoices
-Enter all Customers & Suppliers Invoices and update all columns with the required data.
Data entered in these 2 tabs are the basis of the calculations in the output tabs

Accounts Receivable & Accounts Payable Aging Reports
-These tabs produce an aging report based on the date entered in cell D10.
-All calculations in these tabs are automatic and user only needs to select the report date.

Company Summary
-This tab produces a summary for the total company.
-It includes total aging of A/R & A/P, Aging Reports for Top 5 Customers & Suppliers and Chart presentation of the results

Customer & Supplier Statement
-These tabs produce a detailed account statement including aging analysis and list of outstanding invoices per Customer/Supplier
-All data entered on the input tabs are automatically included on these statements after selecting the statement date in cell D18 and the customer code in cell D19 .

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Accounts Receivable & Accounts Payable Template Excel document

Top Flevy Author [?]

Accounts Receivable & Accounts Payable Template

Sold by Profit Vision (this author has 105 documents)


Add to Cart

This business document is categorized under the function(s):

It applies to All Industries

File Type: Excel (xlsx)

File Size: 1.2 MB

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

Initial upload date (first version): May 2, 2021
Most recent version published: May 4, 2021

Ask the Author a Question

Must be logged in Click here to log in

This document is available as part of the following discounted bundle(s):

All-in-One General Financial Models


This bundle contains 8 additional documents.

View Full Details

Excel workbook
Excel workbook
Excel workbook
Excel workbook
Excel workbook
Excel workbook
Excel workbook
Excel workbook



Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.


22-page Word document
Author: Safwan Khan
26-page Word document
Excel workbook
Author: officehelp
Excel workbook


129-slide PowerPoint deck
28-slide PowerPoint deck and supporting Excel workbook
32-page Word document
Author: noelhan90
Excel workbook
Excel workbook
121-slide PowerPoint deck and supporting Excel workbook



Become your organization's resident expert on...

Digital Transformation
Strategy Development
Post-merger Integration (PMI)
Organizational Design (OD)
Performance Management
Business Transformation
Customer-centric Design (CCD)
Organizational Culture (OC)
Interested in something else? Browse our 500+ Business Toolkits of best practices, each focused on a specific management topic.