How to Make Your Bookkeeping Easy with Excel -2

October 10, 2016

 

Now the solution is:

 

* Copy your credit card and bank statements from CSV file to Spreadsheet.

* Each bank or credit card account should be copies into one worksheet.

* Each row should be considered as a double entry transaction. You can add one column for account name (eg. bank charges, supplies, telephone expense, shareholder loan, ARetc..) and one column for tax information (either the GST amount included or the tax code). That way you get all the information of the double entry.

* Transactions paid by cash or methods other than your regular accounts should be listed on a separate worksheet in same format.

* Transfers should be highlighted to avoid duplicate transactions.

* Invoices and sales should be listed, which can be exported from your billing system.

* AR and AP balances should be provided with details.

* General ledger entries are normally adjusted by your accountant as a part of year-end closing.

 

Tips:

Don't treat it as accounting. Treat it as simple maths.

If you feel totally confused, try using QuickBooks instead.

 

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