Interested in Low-code and No-code Tech? Download our FREE whitepaper on LC & NC Tools. 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)


BENEFITS OF DOCUMENT

  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

DOCUMENT DESCRIPTION

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

 

Accounts Receivable & Accounts Payable Template

Sold by GL Consulting (this author has 26 documents)

$49.00

ALL FEES INCLUDED
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

$209.00

This bundle contains 8 additional documents.

View Full Details

Excel workbook
$49.00
Author:
Excel workbook
$29.00
Author:
Excel workbook
$49.00
Author:
Excel workbook
$29.00
Author:
Excel workbook
$49.00
Author:
Excel workbook
$59.00
Author:
Excel workbook
$29.00
Author:
Excel workbook
$29.00
Author:




CUSTOMER TESTIMONIALS




SELECT CUSTOMERS

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.



CUSTOMERS ALSO BOUGHT THESE DOCUMENTS

286-slide PowerPoint deck
$39.00
Author: Samir Faraj
56-slide PowerPoint deck
$65.00
13-slide PowerPoint deck and supporting Excel workbook
$20.00
Excel workbook and supporting PDF
$20.00
Author: EdmeadFlevy
Excel workbook
$49.95
32-slide PowerPoint deck and supporting Excel workbook
$49.00
Author: LearnPPT
35-slide PowerPoint deck
$49.00
5-page Word document and supporting Word
$29.00
35-slide PowerPoint deck
$24.97
Excel workbook
$20.00

 
RELATED TOPICS

TOP 10 TOPICS

Become your organization's resident expert on...

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