How to Make Your Bookkeeping Easy with Excel -2

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.


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

If you feel totally confused, try using QuickBooks instead.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Search By Tags
No tags yet.
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square
Contact Us


Landline:    (778) 379-5958

Cellphone:  (236) 978-5958

    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         

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