Bank Balances - Record and Reconcile using Excel Spreadsheets
Recording your Bank Balances in Excel - This is the topic covered in this our 4th Video in the 'Basic Bookkeeping Spreadsheet' design series.
In this video we enter our formulas to calculate bank receipts and bank payments which when combined with our Opening Bank Balance enables us to calculate our 'cumulative' or 'running totals'.
We can then reconcile these against or Bank Statements to validate our Bookkeeping Spreadsheet totals.
In the course of the video we introduce the SUMIF Command and once created we will enhance the formula by incorporating NAMED Ranges within the formula.
The eight videos in this series can all be found in our Basic Bookkeeping Spreadsheet Playlist.
This resource is available Free of Charge enabling you to work through the various design stages at your own pace.
The eight videos comprise:
1. Bookkeeping Basics
2. Cash Accounting
3. Chart of Accounts
4. Bank Balances
5. Gross Profit
6. Error Handling
7. Income Statement
8. The Final Spreadsheet Template
As usual we are offering viewers a FREE copy of the completed template.
Details on how to get this are shown during the course of the video presentation.
We hope you enjoy watching.
.............................................................................................................................
Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks
Visit our websites at:
USA & Canada & World - https://www.MrSpreadSheet.com
UK & Europe - https://www.MrSpreadSheet.co.uk
Our Social channels:-
FaceBook - / mrspreadsheets
Instagram - / mrspreadsheet
Twitter - / mr_spreadsheet
#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting