Create a Bookkeeping Spreadsheet using Microsoft Excel - Part 2
HTML-код
- Опубликовано: 27 сен 2024
- Part 2 of 6 - Learn how to create a bookkeeping spreadsheet using microsoft excel.
In this video I will show what equations to include in your bookkeeping template.
Need help with Sage or other accounting software? Drop us an email at info@bpfs-online.com
Take our Online Sage training course
www.bpfs-online...
Bookkeeping Tutorial/Training
Learn more at www.bpfs-online.com
Thanks for this wonderful videos , I,m studying account and your videos help me a lot to understand what I'm preparing my self .
+Wanda Cintron No problem. Please check out my website for more FREE accounting videos www.freebookkeepingaccounting.com. Thanks for watching.
Your the best. As am an Accountant and you have taught me a lot from these vid's.
No, you're the best!
thanks, for making this video it really helps a lot.God bless
No problem. God bless you too.
You're welcome
Hi, Bookkeeping Master, thank you so much for your videos! I went through all 6 videos and did learn a lot. I simply have one question. In the opening balance, why the total amount does not equal to zero? I am confused because of the equation: asset= liability+equity. Thank you!
The opening balances are purely an example. You are right, they should equal zero - good spot! Thanks for watching.
because he keyed in information offhead..so not actual. But should be zero if actual
This awesome. These videos have really helped me.
What does the products for resale represent and why is this different from the other expenses? It may sound like a silly question but when adapting the spreadsheet I want to make sure the figure add up correctly on the p&l sheet. And I you add tabs for consecutive months will the formulas be carried over? Thanks
Great video...
Hi Book Keeping Master, I have found your videos really helpful. I am busy setting up the spread sheets and filling it in, but as I am a new start up business I have put some cash from my personal account into my business account, where does this go on the spread sheet, and do I show as a plus or minus, as its not really income?
i think it goes in capital account but please feel free to take a second opinion
So would you have eftpos transactions in its own box.
Also does the petty cash account? represent literally cash in hand as this is something I deal with before banking often. Thanks
Hi, if I put money into my company from my own money in a sole trader enterprise, does this have to be from a "capital account"? I guess it has to come from somewhere? thanks very helpful video
Hello, whenever I try to minus the expenditure from the equation (sum), it goes red instead of green and won't format properly?
Or any of the closing balance row for-that-matter
Hi , Thanks for your video , I would like an advice how will add I columns for Vat and Gross Amt ect for Expenditure Codes and in the future to know the VAT expenses Thanks for your help
.
Hi there BookkeepingMaster! Nice Video. Can I ask why you entered the loan payment under income/assets/liabilities and not under expenditure?
Because a loan payment is not an expense to the business, it is a reduction of the businesses liability. I have a free bookkeeping course on my website, it may be good to take it. No registration or payment is required. Thanks for watching.
Thank you very much for your videos! They help me a lot in understanding bookkeeping.
I wonder would you be so kind to answer few of my questions?
1. We have an account with a supplier which issued invoices for materials on amount of £3100 but we paid only £2000. How would you enter these data in the Bookkeeping Spreadsheet? Shell I add another column in INCOME, ASSETS and LIABILITIES for Supplier Credit Account? or just leave it in EXPENDITURE?
2.We bought a peace of used but expensive machinery does it go to EXPENDITURE or ASSETS? (Paid in full)
3.We bought some used tools on Ebay from privet sellers so we do not have invoices for those but the amount of money paid shown on bank statement. We shouldn't put this transaction in the books, or should we?
Really hope for your help.
+Masha V Thanks for watching and for the comment. If you could make a small donation through my website and email me, I will be happy to answer your questions. Thanks again.
I'm so sorry I figured it I was ahead of what you had done lol that's what I get for trying to do it on my own before finishing the video.. I will follow you then I will practice lol..
+Aida Rivera No problem. Please check out my website for more free videos. Thanks for watching.
+BookkeepingMaster sure will txs.
I've created a liability "Shareholder Loan a/c" for any personal funds I use for the business. Since the loaned money was used for business expenses how do I record those expenses? I am looking to reimburse myself, and want to avoid being taxed on the income the business will reimburse me with.
You need to record the money-in and money-out just the same as any of the bank and other asset and liability accounts - ensure the account is on both sides of the spread-sheet, use part 1 for the reimbursements and part 2 for the expenditure. I hope this helps.
How do I deal with credit card opening and closing balances if I do have credit card account?
I'm probably being a bit simple but how do I deal with the next month? I've watched all of the 6 videos and you don't touch on how you do your next month - is it on a new sheet?
Sammi Sparke Yes, copy and paste the template on a new sheet. Use the closing balances of the previous month for the opening balances of the new month. Thanks for watching.
Thank you :)
thank you! I thought I had to have an engineering degree to know how to just create a basic spread sheet to track my profits/losses for my direct sales business.
Haha! Thanks for watching.
When I am paid for several different services (facials, massage, & waxing) on a app such as paypal/cash app/Groupon that deposits into my bank a/c. Would I just put "Groupon deposit" or "Paypal Deposit" in the description for income or does it need to be more specific than that? TIA!
Your suggestions are both fine. Thanks for watching.
Thanks
Welcome
What does the products for resale represent and why is this different from the other expenses? It may sound like a silly question but when adapting the spreadsheet I want to make sure the figure add up correctly on the p&l sheet. And I you add tabs for consecutive months will the formulas be carried over? Thanks
Great video...
thank you
No problem. Please 'like', subscribe, and check out our website for more free videos.
Yes, my life is so much easier! I wonder if you're interested in making a video for calculating net income on eBay where it would require not only (-/+) transactions but also (-/+) percentages, multiplying and dividing?
Thanks for the suggestion and for watching. Much appreciated.
Sir I am from pakistan, I haven't SageOne, I desperately wanted to become accountant
You can download it from the Sage website. Thanks for watching.
Thank you soooooo much for going fast/at a decent speed.... other videos drive me crazy.. I subscribed right away
Thanks a lot
thank you sir!
Thank you for all your help here! Tho I do have a question. How do I enter -500.00 on my cell without it + the next cell I am working on? Thanks a huge bunch!!!
Sorry, I am not sure what you are referring to. Thanks for watching.
can we this sheet chart of accounts????