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

  • @annie.ttan1412
    @annie.ttan14128 ай бұрын

    Thank you so much Mr Chris. So amazing. Keep up the good work ❤️🔥

  • @VistmarTeam
    @VistmarTeam Жыл бұрын

    Simple and to the point. Thank you!

  • @ChrisMenardTraining

    @ChrisMenardTraining

    Жыл бұрын

    You're welcome. Thanks, Raúl.

  • @irynasavchenko91
    @irynasavchenko91 Жыл бұрын

    Thank you Sir for both, tutorial and gratis spreadsheet to follow along! Exactly what I needed!

  • @ChrisMenardTraining

    @ChrisMenardTraining

    11 ай бұрын

    You're very welcome!

  • @victoriaatkins6946
    @victoriaatkins6946 Жыл бұрын

    This was so easy to understand, Thank you.

  • @AdelitaWilliam-dl7ci
    @AdelitaWilliam-dl7ci Жыл бұрын

    Keep more videos like this coming please. The more in depth and detailed they are the more helpful they are.

  • @ChrisMenardTraining

    @ChrisMenardTraining

    Жыл бұрын

    Will do!

  • @danielsmithiv1279

    @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.

  • @DrewandAlly
    @DrewandAlly6 ай бұрын

    This was great, thank you so much !!!!

  • @xianxiong3440
    @xianxiong34406 ай бұрын

    This is exactly what I am looking for!!!

  • @ChrisMenardTraining

    @ChrisMenardTraining

    6 ай бұрын

    Glad to help.

  • @JamieModelvsDirector
    @JamieModelvsDirector5 ай бұрын

    Thank you so very Much ❤😊🙏🏾

  • @user-fu6rw1jd9f
    @user-fu6rw1jd9f Жыл бұрын

    Thank you

  • @gayatribanjara3079
    @gayatribanjara3079 Жыл бұрын

    Very simple, clearly and slowly teaching, also very useful, good video. I learn a lot Thank you!

  • @ChrisMenardTraining

    @ChrisMenardTraining

    Жыл бұрын

    You're very welcome!

  • @Saad.PS2009
    @Saad.PS20092 жыл бұрын

    Thank you so much

  • @ChrisMenardTraining

    @ChrisMenardTraining

    2 жыл бұрын

    You're most welcome

  • @InvestingAwee
    @InvestingAwee7 ай бұрын

    Thanks.

  • @mdnoorulla5618
    @mdnoorulla5618 Жыл бұрын

    Way of Teaching Interesting, Very Simple & Slowly Teaching.its very useful

  • @ChrisMenardTraining

    @ChrisMenardTraining

    Жыл бұрын

    Glad you liked it

  • @rameshraipur3751
    @rameshraipur3751 Жыл бұрын

    thank u so,much

  • @ChrisMenardTraining

    @ChrisMenardTraining

    Жыл бұрын

    You are most welcome

  • @usamaalii
    @usamaalii Жыл бұрын

    Very good explanation method.

  • @ChrisMenardTraining

    @ChrisMenardTraining

    Жыл бұрын

    Thank you.

  • @rofiqulislam7544
    @rofiqulislam7544 Жыл бұрын

    Very good video ❤️

  • @ChrisMenardTraining

    @ChrisMenardTraining

    Жыл бұрын

    Thank you 🤗

  • @hrashidi100
    @hrashidi1002 жыл бұрын

    Super interesting, thank you! I'm doing finance right now and too much manual input will break my fingers...

  • @ChrisMenardTraining

    @ChrisMenardTraining

    2 жыл бұрын

    Thanks, Hannah.

  • @user-lh2fn4yo5n
    @user-lh2fn4yo5n Жыл бұрын

    it was very good keep it up

  • @ChrisMenardTraining

    @ChrisMenardTraining

    11 ай бұрын

    Thank you.

  • @juantapia7832
    @juantapia78329 күн бұрын

    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!

  • @fcg2122
    @fcg21222 ай бұрын

    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.

  • @BeGOoD2022
    @BeGOoD20222 ай бұрын

    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

  • @nisasavenue4419
    @nisasavenue4419 Жыл бұрын

    is this what account recv interns will need to do ?

  • @user-fv9hn5vu5v
    @user-fv9hn5vu5v2 ай бұрын

    I just want such accounts program.

  • @PiuriBeko
    @PiuriBekoАй бұрын

    Hello Chris am from Papua New Guinea am very interested to join you in excel accounting