How to Make Your Bookkeeping Easy with Excel -1

May 29, 2016

 

Everybody uses Excel and we feel it is so easy to add  your income and expenses together by category. However, is that bookkeeping? Probably yes, if you only hold a sole proprietorship business and the only thing you need to do is adding up things line by line. However, it may not be efficient, as your bank statements and your receipts don't go that way. You may find yourself switching from worksheet to worksheet all the time and it takes time. Also, when you are required to provide supporting document to a specific transaction, you may totally lose your clue where to find it and how it was paid unless you organized all the receipts perfectly.

 

As for corporations, it will be in a totally different situation. Unlike sole proprietorship, you have to provide balance sheet information as well, so double entry system is required. I believe some of you can be very good at Excel, but that might just help you to make things more complicated instead of making things easier. Your bookkeeper or accountant will have to Make your balance sheet without a supporting General Ledger.

 

You then have two choices, go for an accounting software or continue with your Excel (normally with a template from your accountant, however I bet that template doesn't provide everything you need and you will have to maintain many many pages).

 

Now let's go back to my simple solutions for your small business. 

Will continue tomorrow...

Please reload

Featured Posts

I'm busy working on my blog posts. Watch this space!

Please reload

Recent Posts

October 10, 2016

Please reload

Archive
Please reload

Search By Tags

I'm busy working on my blog posts. Watch this space!

Please reload

Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square
Contact Us

LILY RAO, CPA


Landline:    (778) 379-5958

Cellphone:  (236) 978-5958

Email:        LILYRAOCPA@GMAIL.COM
Address​​​​​​:
    207-5050 Kingsway

                Burnaby, BC V5H 4H2

Website:    LIVETAX.CA

Wechat:    CPA2229 

 

My Business Hours

Monday:            9:15 am to 5:00 pm

Tuesday:           9:15 am to 5:00 pm

Wednesday:       9:15 am to 5:00 pm

Thursday:          9:15 am to 5:00 pm

Friday:               9:15 am to 5:00 pm

 

Weekends & After Hours:

By prescheduled appointment only         

Events
This site was designed with the
.com
website builder. Create your website today.
Start Now