???? LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... ???? EXCEL SPREADSHEET FREE DOWNLOAD: https://excelentejoao.com.br/wp-conte... In this video free Excel class, we will learn how to create an Accounts Payable Spreadsheet in Excel that you can download for free. In other words, free Excel spreadsheet. With the Excel accounts payable spreadsheet we are able to have the information: DATE, MONTH, SUPPLIER, DESCRIPTION, TOTAL INSTALLMENTS, CURRENT INSTALLMENT, INSTALLMENT VALUE, DUE DATE, PAYMENT DATE, STATUS, TYPE OF PAYMENT. This way, we can carry out several important analyzes and controls that can help us a lot in our daily lives to automate tasks and also save time with Excel. The analyzes we can do can be based on the Sumase function, or the somase formula, that is, add with criteria and this way we can see everything that is open, everything that is due and everything that is paid for each of the months that we have registered in the spreadsheet each of the dates as criteria. The sumase function in the Excel spreadsheet can help you automate repetitive tasks and automate processes that you do daily in your daily life and in your company. The sum function in Excel helps us to add values. We can select values ​​individually, cell by cell, one at a time, or we can select a large range of cells in Excel to add up the values ​​contained in the cells we select. The sumase function in Excel allows us, instead of adding up all the values ​​selected from the spreadsheet, to add only the values ​​that correspond to the criteria we want to be met. That is, every time a criterion is met, every time a criterion is true, the sumase function returns the sum value of that specific range. An accounts payable spreadsheet offers several benefits and practical uses for a company's financial management. Here are some of the main ones: Benefits: Organization: Centralizes all accounts payable in one place, facilitating monitoring and avoiding forgetfulness. Financial Control: Allows you to monitor cash flow and plan payments according to financial availability. Prevention of Fines and Interest: By following due dates, it is possible to avoid late payments and, consequently, fines and interest. Expense Analysis: Facilitates the identification of spending patterns and allows a more detailed analysis of the company's expenses. Budget Planning: Assists in budget planning, allowing you to predict and provision the resources needed for future payments. Transparency: Provides a clear view of financial obligations, facilitating accountability for managers and stakeholders. Practical Uses: Daily Monitoring: Consult the spreadsheet daily to check which payments are close to due date and which have already been made. Financial Reports: Use the spreadsheet to generate monthly or quarterly expense reports, helping with decision making. Negotiation with Suppliers: With a clear view of payments, it is possible to negotiate better terms and conditions with suppliers. Payment Planning: Plan payments according to available cash flow, avoiding embezzlement. Internal Audit: Facilitates internal auditing as all transactions are recorded and can be easily verified. Cash Management: Contributes to better cash management, allowing the prediction of periods of greater or lesser disbursement. Usage Examples: Small Businesses: A small business can use the spreadsheet to manage its monthly bills, such as rent, utilities, and material suppliers. Finance Departments: In a larger company, the finance department may use the spreadsheet to consolidate all payables and provide reports to managers. Self-Employed and Freelancers: Self-employed professionals can use the spreadsheet to track their expenses and ensure that all their financial obligations are met. #ExcelenteJoão #Excel #Dashboard