Bookkeeping Spreadsheet using Excel - The completed template
ฝัง
- เผยแพร่เมื่อ 14 ก.ค. 2024
- Hello and WELCOME to the Mr.SpreadSheet TH-cam Channel where we create and design spreadsheet templates for you and your business.
In this video series we are designing a Bookkeeping Spreadsheet using Excel, and in this presentation we complete the final template.
This Basic Bookkeeping Spreadsheet can be adapted and expanded to meet your individual requirements.
During the course of this series we use many of Excel Commands, Formulas, Functions and Techniques and we recognize that on occasions you may need additional help. If this is the case then please leave a comment.
We hope you enjoy watching.
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 - www.MrSpreadSheet.com
UK & Europe - www.MrSpreadSheet.co.uk
Our Social channels:-
FaceBook - / mrspreadsheets
Instagram - / mrspreadsheet
Twitter - / mr_spreadsheet
#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting - แนวปฏิบัติและการใช้ชีวิต
![[TH] Esports World Cup : Grand Final](http://i.ytimg.com/vi/sedbKhFYDMo/mqdefault.jpg)
I just wanted to say all your videos are incredibly useful, I am really grateful!
Glad you like them!
Thank you for this series, I used all your explanations to write a similar application for a small business on MS Access :)
Nice work!
I just finished the entire report and it was a learning experience. I hope you guys keep building on this report. Things such as a data entry page that would make it look as a data base. Also a way to put scanned or pic receipts attached to the transaction.
I have been following you guys for a bit and you guys rock, this one takes the cake.
You have earned a new subscriber. keep up the good work!
P.s Not all of us have Facebook or want to ever get it.
2thumbs up!👍👍
Thanks, Glad you found it useful :-)
Thanks For all the great content! 👍
You just earned a subscriber!
Thanks and welcome
that is great i need it
Glad you found it useful :-)
HELP! First, I have to say that your spreadsheet tutorial videos are exactly what I needed. I was handed the books for a "very small" town historical society and was able to watch all 8 videos to create a professional Bookkeeping Spreadsheet. But...I noticed I have an issue with a line or two of expenses not transfering to my report. Should I go back to the COA video and reapply setup from there forward, or should I scrap the spreadsheet and start completely over again? Any help would be greatly appreciated! Thank you!
Hi, You can download a copy and check your work, follow the instructions on one of the video series :-)
Thank you!@@MrSpreadSheet
Ready for a stupid question.. please prove my point for someone.. in cash basis accounting do you record deposits and payments after they clear the bank? Would like to prove a point to someone... Thanks!
That's the general idea, if they are on the Bank Statement, then you record the transaction. :-)
@@MrSpreadSheet does that include checks as well? So the check that say I wrote in oct 23 didn't clear till Jan 24 it would be recorded for Jan 24? And this is what my books would look like..just like my bank statement?