Skip to Content

GET YOUR BANK STATEMENTS

First step - Obtain your bank statements used in your business. Understand the difference between the CSV and PDF file types and why you need both. 

Go directly to the videos below to Navigate your Specific Banking Website, step by step video.

 

BACK TO COURSE

 

Key Summary Points

1

Avoid Printing at Branch

It costs more if you visit your Bank and request a print out of the statements. Typing the information into Google Sheets Template will require you to type like a Ninja.  

2

Don't Type - Get CSV

Choose the csv file option when downloading the Bank Statements, this allows the most seamless way to get your information onto the Bookkeeping template, mere copy and paste. 

3

Reasons you need PDF 

Your Tax Guy and others wanting to verify your Bookkeeping records will request the PDF copy of your Bank Statement, because it harder to edit. 

Have this on hand, makes it easier.    

STEP BY STEP GUIDE - CLICK YOUR BANK TO SEE VIDEO

FINAL STEP

After you obtain your bank statements do this ...

Save in a Structured Folder

Create a Folder on your Google Drive called "BANKING" and save the statements in the recommended structure making it easier to find.

Click below for the File Structure we recommend. 

Update Bookkeeping Template

The Bookkeeping Template has a sheet named "BANKING" - copy and paste the information there.

Click the Video Below for guidance on how to update the Bookkeeping Template.

What is this BK Template?

If you have not Registered for your Bookkeeping Bootcamp, get your Free Copy of the Bookkeeping Template below.

I meet with a select few Business Owners over a period of 5 weeks to get their Business Records up to date and Tax Ready. To see if you qualify have a look at the course. 

Download a FREE copy of the Bookkeeping Template here.

Copy and paste the Bank Statement into the BANKING Tab and if you get confused with the 1 Column and 2 Column Format we will discuss this in more detail at our Live Session. 

Lastly look at the description and transactions on your Bank Statement and try update the first 30 lines of the template choosing the Category from the list provided - we will do this together in the live session so no stress!  
Rating
0 0

There are no comments for now.

to be the first to leave a comment.