Small business TAX PREP 2019 bookkeeping (simple method using Excel!)

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 ก.ย. 2024
  • This is how to do bookkeeping for a super small business in Microsoft Excel. If you're an small business owner that's scrambling to get your bookkeeping done before tax time, hopefully this is helpful for you. Of, if you're a bookkeeper who'd like a simple alternative, check this out.
    My website: www.finepoints...
    ☑️My favorite bookkeeper training (affiliate links)
    💜Bookkeeper Launch free series: sk293.isrefer....
    💜Bookkeeper Launch FAQs: sk293.isrefer....
    💜Bookkeeper Launch checkout: sk293.isrefer....
    ☑️Classes taught by me
    🟢How to start your business in 30 days (Bookkeeper Business Coach): finepoints.new...
    🟢How to get clients (Bookkeeper Marketing Coach): finepoints.new...
    ☑️Free stuff
    ➡Is bookkeeping right for me? (free masterclass): finepoints.new...
    ➡How I got my first 3 CLIENTS (free masterclass): finepoints.new...
    ➡Start a bookkeeping business (free checklist) finepoints.new...
    ➡LEARN bookkeeping (my favorite training options): finepoints.new...
    ➡Where to start bookkeeping (chart): finepoints.new...
    ➡Tax Biz (free intro class on taxes): sk293.isrefer....
    ➡More freebies on my website: www.finepoints...
    ➡ Please SUBSCRIBE! / @finepointsbookkeeping
    ☑️Pass the ProAdvisor Test: Fast and Easy QBO (affiliate links)
    For Basic (code "finepoints" for discount): www.fastandeas...
    For Advanced (code "finepoints" for discount): www.fastandeas...
    ☑️Other awesome classes (affiliate links)
    Booming Bookkeeping: www.boomingboo...
    Nerd Enterprises: www.nerdenterp...
    5 Minute Bookkeeping: courses.5mbaca...
    ▶My Bookkeeping Tech Tools: www.finepoints...
    ▶ Videos to get started bookkeeping:
    Learn bookkeeping: • 10 ways to LEARN bookk...
    Bookkeeper certification for FREE: • FREE ProAdvisor certif...
    How to become a bookkeeper (with chart): • How to become a BOOKKE...
    How to get clients: • 20 ways to get bookkee...
    What does a bookkeeper do? • WHAT DOES A BOOKKEEPER...
    Day in the life playlist: • "Day in the life" of a...
    Bookkeeper Launch video: • 10 FIRST IMPRESSIONS o...
    Client onboarding: • One Client, START TO F...
    How much to charge: • HOW MUCH to charge as ...
    Services to offer: • BEGINNER services to o...
    ▶ More videos you'll like:
    Big, medium & small clients: • CLIENT EXAMPLES: Small...
    Niches playlist: • Niches for bookkeepers
    Before you start: • Bookkeepers: 7 THINGS ...
    Impostor syndrome for bookkeepers: • How to overcome IMPOST...
    10 reasons to start bookkeeping: • WHY START BOOKKEEPING?
    How to clean up a client's books: • How to do a "CLEAN-UP"...
    #bookkeeper #finepoints #bookkeeping

ความคิดเห็น • 56

  • @FinePointsBookkeeping
    @FinePointsBookkeeping  4 ปีที่แล้ว +5

    Thanks for watching! Share this with a small business owner you know. :)

  • @nky.z
    @nky.z 4 ปีที่แล้ว +5

    THANK YOU! I needed something very BASIC to give to my tax guy as I started my business not too long ago. I’ll be giving this a try! Wish me luck! 😭

  • @brmjanyat
    @brmjanyat 4 ปีที่แล้ว +5

    Great vid
    It would be a lot easier to use subtotal button
    Pivot table or sumif are viable options but a little bit more complicated to excel newbies

  • @carolsimpson8163
    @carolsimpson8163 2 ปีที่แล้ว

    Thank you so much! This is the first explanation of EXCEL that has made any to me.

  • @sayorimoonflower9672
    @sayorimoonflower9672 2 ปีที่แล้ว

    Yess! This is so much easier then quickbooks or anything else I could possibly think of!
    Thank you!

  • @manisymone8622
    @manisymone8622 2 ปีที่แล้ว

    This video is awesome! Creating a pivot would be a matter of seconds to getting your totals or having things categorized per month or quarter.

  • @waverlylane1
    @waverlylane1 4 ปีที่แล้ว +3

    PIVOT TABLES!!!
    Learn this feature in Excel, much easier when doing what’s suggested in this video!!

  • @ForensicDreamer
    @ForensicDreamer 4 ปีที่แล้ว

    I use this process as well for the small law firm that I work for. You are correct that this method is a cost saver. It's more efficient to perform this process in QBO

    • @FinePointsBookkeeping
      @FinePointsBookkeeping  4 ปีที่แล้ว

      Nice! Glad it works well for you. Good to hear real-world experience!

  • @johnschulte5820
    @johnschulte5820 3 ปีที่แล้ว

    So helpful for those new startups.

  • @jacobkokanovich7696
    @jacobkokanovich7696 ปีที่แล้ว

    Super Helpful THANK YOU!!

  • @MoggAssassin
    @MoggAssassin 2 ปีที่แล้ว +1

    Sumifs or pivot tables would probably make this simpler.

  • @EarnestTillman
    @EarnestTillman 2 ปีที่แล้ว

    Spot on

  • @SolHersh
    @SolHersh 2 ปีที่แล้ว

    awesome vid thanks!

  • @sherryhergott1502
    @sherryhergott1502 2 ปีที่แล้ว +2

    Do you have an excel template for bookkeeping?

  • @ayansajid1
    @ayansajid1 4 ปีที่แล้ว

    Thanks yes I was looking for it.

  • @ellisdudley
    @ellisdudley 3 ปีที่แล้ว +1

    Pivot table would help yes?

  • @jamr2t
    @jamr2t 4 ปีที่แล้ว +2

    my wife runs a small business but also gets paid as an independent contractor (1099), what software do you recommend? and do we keep those two separate? or combine them?

    • @FinePointsBookkeeping
      @FinePointsBookkeeping  4 ปีที่แล้ว +1

      That gets a bit complex. I would keep them separate if possible. Or, at the very least make two account categories for you P&L. As a bookkeeper, this is the type of thing I would consult with a CPA about.

  • @deltanyc1
    @deltanyc1 2 หลายเดือนก่อน

    Where's the wages? That's the largest expense and it's included in the P&L.

  • @rickeyhughes7380
    @rickeyhughes7380 4 ปีที่แล้ว

    Hello. My name is Rickey Hughes. I have just watched your video about Small Business Tax Preparation. I do have a small business in Bookkeeping and Accounting. I may need to watch the video again, because I know more about Bookkeeping and Accounting than I do about Income Tax Preparation. However, I think you explained it very well. Also, I have a laptop computer; but, I don't have Excel. I may need your suggestions about this. Right now, I am only doing Bookkeeping and Accounting by hand, and I may need your advice on how to do this if I am going to use a computer.
    Anyway, I thank you for sharing this video, and look forward to hearing your response about this. Thank you again, and keep up the good work.

    • @FinePointsBookkeeping
      @FinePointsBookkeeping  4 ปีที่แล้ว

      Thanks for watching! Excel will often come in a package on your computer, but you should be able to buy a download if you don't have it. But, if you're using QuickBooks, I'd stick with that!

    • @rickeyhughes7380
      @rickeyhughes7380 4 ปีที่แล้ว

      Thank you.

  • @ashabakai4626
    @ashabakai4626 2 ปีที่แล้ว

    I want to learn bookkeeping but from scratch. I am really scared and nervous. Can you please help me to get the right information. I don’t know where to start

  • @littleoutlaw4224
    @littleoutlaw4224 9 หลายเดือนก่อน

    The first 20 seconds, she was definitely talking to me.

  • @veronicadoesitall
    @veronicadoesitall 2 ปีที่แล้ว

    When downloading for the entire year, it won’t download 1 month… is there a different way to save.. IDK, I’m missing 1 month🧐

  • @elliswu6087
    @elliswu6087 3 ปีที่แล้ว +1

    HOW ABOUT PAYROLL

  • @ArchangelInk
    @ArchangelInk 4 ปีที่แล้ว

    Great videos! Can you point me toward the 50% QuickBooks link you mentioned? I don't see it in the description here. Thanks!

  • @jenemt06
    @jenemt06 2 ปีที่แล้ว

    Would you recommend getting Microsoft 365 family or Microsoft 365 business if your getting ready to start your own bookkeeping business? As you may use word and excel from time to time.

    • @FinePointsBookkeeping
      @FinePointsBookkeeping  2 ปีที่แล้ว

      Morgan uses her Google Workspace for most things! -Gabe (FinePoints Admin)

  • @juansutton5465
    @juansutton5465 3 ปีที่แล้ว

    Hello FinePoint!
    Do you do bookkeeping I really need my 2019 books done?

  • @jennifergonzales3231
    @jennifergonzales3231 ปีที่แล้ว

    What form do you use to file taxes quarterly?

    • @FinePointsBookkeeping
      @FinePointsBookkeeping  ปีที่แล้ว

      Hi Jennifer! Here is a video Morgan made that may answer your question, " Quarterly Taxes Explained": th-cam.com/video/SRnWBWOvtHY/w-d-xo.html
      Krista (FinePoints Admin)

  • @lupita1114
    @lupita1114 4 ปีที่แล้ว

    Do you do one on one? I need help with my small business

  • @jchung5066
    @jchung5066 3 ปีที่แล้ว

    wouldnt it be easier if u used pivottables

  • @rachelgwin7946
    @rachelgwin7946 4 ปีที่แล้ว

    This is awesome, thank you!

  • @gaarcemail
    @gaarcemail 2 ปีที่แล้ว

    Had to wait to almost halfway through the video to get to the spreadsheet. I really hate all the beating around the bush, to get to the actual information.

    • @FinePointsBookkeeping
      @FinePointsBookkeeping  2 ปีที่แล้ว

      Any downloadables will be listed in the description section, so you can always head there right away to find Morgan's resources :) -Gabe (FinePoints Admin)

  • @juansutton5465
    @juansutton5465 3 ปีที่แล้ว

    Do you do bookkeeping I really need my 2019 books done?

    • @LilOleMeAgain2634
      @LilOleMeAgain2634 3 ปีที่แล้ว

      Finalpiecesbookkeeping@gmail.com
      Let's chat and see if I can help you get your books together.

  • @InIteration
    @InIteration 3 ปีที่แล้ว

    Hmm... Maybe bookkeeping isn't so scary.

  • @richardhay645
    @richardhay645 3 ปีที่แล้ว +1

    Shorten your infomercial.

  • @Dhernandez10
    @Dhernandez10 4 ปีที่แล้ว

    But what about the miles? Lol

    • @FinePointsBookkeeping
      @FinePointsBookkeeping  4 ปีที่แล้ว +1

      Yes! Record those when you're filling out all the info in turbo tax (I assumed those are being tracked separately). :)

  • @binthawwa3532
    @binthawwa3532 3 ปีที่แล้ว

    i didn't get 100% of Christmas party and 50% of meals?

  • @chimewithmaria6510
    @chimewithmaria6510 3 ปีที่แล้ว

    if you are bookeeping all your transactions every year that aint it

  • @MagaWatcher
    @MagaWatcher 3 ปีที่แล้ว

    I don’t have time to listen to a promotion