Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work
Accountants use Excel all the time. This video, which is excellent for Accounting students, looks at a Accounts Receivable (AR) or Accounts Payable (AP) exercise. Accounts Payable is what your company owes to vendors and suppliers. Accounts Receivable is what is due to your company from your customers. A lot of companies use the term Net 30. That means an invoice for AR is due in 30 days. For AP, the vendor wants their money in 30 days. Both AR and AP are listed on the balance sheet. AR shows up under current assets. AP is a liability and shows up under current liabilities.
Chapters:
00:00 Introduction
00:50 Sample data presentation
00:59 Insert current date
01:13 TODAY function
01:47 Accounts Payable/Receivable
02:27 TEXT function
03:37 LEN function
03:53 TEXT with zero-padding
05:24 Increase/Decrease Indent
05:53 Comma style
06:32 Invoice due date
06:57 Age of invoice
07:52 Days overdue
08:21 Average nr of days overdue
08:55 AVERAGEIF
11:30 Conditional Formatting
13:50 Closing remarks
Download file - Blog post chrismenardtraining.com/post/...
#msexcel #microsoftexcel #accountingexercise #chrismenard #chrismenardexcel
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZread keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Пікірлер: 37
Thank you so much Mr Chris. So amazing. Keep up the good work ❤️🔥
Simple and to the point. Thank you!
@ChrisMenardTraining
Жыл бұрын
You're welcome. Thanks, Raúl.
Thank you Sir for both, tutorial and gratis spreadsheet to follow along! Exactly what I needed!
@ChrisMenardTraining
11 ай бұрын
You're very welcome!
This was so easy to understand, Thank you.
Keep more videos like this coming please. The more in depth and detailed they are the more helpful they are.
@ChrisMenardTraining
Жыл бұрын
Will do!
@danielsmithiv1279
6 ай бұрын
Hey there Chris! What aspects of excel would I need to know to do well in this type of job position?@@ChrisMenardTrainingProficiency with Microsoft Office including Outlook, Teams, Word, and Excel · Excel knowledge is required (Mandatory) · SAGE 100 experience a plus · Punctual · Works well under pressure, ability to meet deadlines and thrive in fast paced environment. · Highly organized, trustworthy, and self-directed · Ability to identify and solve problems efficiently and with good judgment. · Desire to move up within the company by demonstrating the highest quality ethics and work standards. · Excellent written and verbal communication skills · Proficient in 10-key pad by touch to process data with speed and accuracy. Job Responsibilities: · Receive, verify, and validate invoices. · Research and work with other departments and customers to resolve invoice discrepancies, claims, and receivables issues. · Correspond with Customers/Vendors and respond to inquiries. · Process Accounts Receivables Payments and Chargebacks Claims · Review accounts receivable aging and reconcile accounts. · Accounts Receivables cash receipt postings · Prepare reports and analysis as needed. · Monitor accounts to ensure payments are up to date. · Assist in month end closing. · Assist Billing Department as Needed processing invoices. · Other tasks as assigned by management. Please take the Skills test: Spreadsheets with Microsoft Excel on Indeed and submit the results with your resume. All interested candidates will be Tested on Excel Skills during the interview.
This was great, thank you so much !!!!
This is exactly what I am looking for!!!
@ChrisMenardTraining
6 ай бұрын
Glad to help.
Thank you so very Much ❤😊🙏🏾
Thank you
Very simple, clearly and slowly teaching, also very useful, good video. I learn a lot Thank you!
@ChrisMenardTraining
Жыл бұрын
You're very welcome!
Thank you so much
@ChrisMenardTraining
2 жыл бұрын
You're most welcome
Thanks.
Way of Teaching Interesting, Very Simple & Slowly Teaching.its very useful
@ChrisMenardTraining
Жыл бұрын
Glad you liked it
thank u so,much
@ChrisMenardTraining
Жыл бұрын
You are most welcome
Very good explanation method.
@ChrisMenardTraining
Жыл бұрын
Thank you.
Very good video ❤️
@ChrisMenardTraining
Жыл бұрын
Thank you 🤗
Super interesting, thank you! I'm doing finance right now and too much manual input will break my fingers...
@ChrisMenardTraining
2 жыл бұрын
Thanks, Hannah.
it was very good keep it up
@ChrisMenardTraining
11 ай бұрын
Thank you.
Hello. Thank you very much for your video, excellent. Can I ask you a question, please? I would like to know what type of value I must to consider in the sale (accounts receivable) : net sale (without VAT) or with VAT? I understand that the sales values, cost, expenses, must always be recorded without VAT. Thank you so much!
this is great i am not sure if i can get a replay but what if you want to add more invoices than the 13 he is using it does not affect invoice entered after i did this formatting. I am not great at all with this I am very new to spread sheets I am sure a 13 year old knows more than myself.
first thanks for sharing this skills , but the general not appear in cell when the text formula in moving the cell to else,how i solve it
is this what account recv interns will need to do ?
I just want such accounts program.
Hello Chris am from Papua New Guinea am very interested to join you in excel accounting