Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921.
From excelisfun · · 11 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download: 1) Excel File: https://excelisfun.net/files/EMT1920-1921-1922.xlsx Buy excelisfun’s Excel Books: https://www.amazon.com/stores/Mike-excelisfun-Girvin/author/B009Q5T4P2?ref=ap_rdr&ccs_id=6f8ce877-462f-447e-b825-7ede1f72a9d3 Free Excel Class from excelisfun: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo Learn how to create an amazingly efficient set of formulas to calculate the book balance and the bank balance for a checking or savings account. See an amazing SUM function trick to avoid errors. See how to automatically reconcile an account with Excel Formulas. Topics: 1. (00:00) Introduction. 2. (00:38) Fundamental problem with tracking bank account balances, and thus why bank reconciliation is such an important accounting task. 3. (02:31) Data Validation dropdown list feature to verify that only a y value can be added to the reconciliation column. 4. (03:11) #1 Formula to calculate “My Book Balance” using the SUM, IF, and ISNUMBER functions. (03:52) SUM function trick to reference the previous bank balance (Relative Cell Reference) and not get a #VALUE! Error. 5. (04:29) Angry Rabbit (Crosshair) Trick #1. 6. (06:52) Angry Rabbit (Crosshair) Trick #2. 7. (07:50) #2 Formula to calculate “Bank Balance” using the SUM, ISNUMBER, and two back-back nested IF functions. 8. (09:16) Angry Rabbit (Crosshair) Trick #3. 9. (10:34) Next video: Dynamic Spilled Array Formula. 10. (10:59) Closing.
#excel #microsoft #excelisfun #excelcourse #mikegirvin #excel365 #BankReconciliation #accountreconciliation #accounting #accountingtask #accountingtricks #accountingtips #isnumber #if #sum #sumfunction #ifformula #iffunction #isnumber #isnumberfunction #nestedif #nestedfunctions #runningtotal #runningtotalformula
This video has subtitles or audio translations in these languages: Abkhazian, Afrikaans, Amharic, Arabic (experimental), Armenian, Bangla (experimental), Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Chinese, Chinese (China), Chinese (Hong Kong), Chinese (Taiwan), Croatian, Czech, Danish, Dutch, Dutch (Belgium), Dutch (Netherlands), English (Australia), English (Ireland), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (Belgium), French (Canada), French (France), French (Switzerland), Georgian, German, German (Austria), German (Germany), German (Switzerland), Greek, Haitian Creole, Hebrew (experimental), Hindi, Hungarian, Icelandic, Indonesian, Irish, Italian, Japanese, Kazakh, Khmer, Korean (experimental), Lao, Latin, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malagasy, Malay, Malay (Singapore), Malayalam, Maltese, Mongolian, Nepali, Norwegian, Papiamento, Pashto, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese, Portuguese (Brazil), Portuguese (Portugal), Punjabi (experimental), Romanian, Russian (experimental), Sanskrit, Scottish Gaelic, Serbian, Serbian (Cyrillic), Serbian (Latin), Sicilian, Slovak, Slovenian, Somali, Spanish, Spanish (Latin America), Spanish (Mexico), Spanish (Spain), Spanish (United States), Swahili, Swedish, Tajik, Tamil (experimental), Tatar, Telugu (experimental), Thai, Tibetan, Tongan, Tsonga, Tswana, Turkish, Turkmen, Ukrainian, Urdu, Uzbek, Vietnamese, Welsh, Western Frisian, Zulu. Click gear icon below video to set subtitles, audio and language.