Navigate to the bank account you use for your business. Select the desired dates and download to a spreadsheet, .csv, or comma delimited format.

Tip: My Preference is to have a main Tax folder, then subfolders for each tax year where you can save this information and anything else that applies to the year. Then you don't have to search as much when reviewing your business, or in preparing for tax time.

If you have multiple businesses, have separate bank accounts and tracking sheets for each.

Click "New, then "File Upload" to upload the file to Google Drive.

Select Row 1 and right click or Control click on it to bring up the menu.

Select "Insert 1 row above". You will use this to create a header row.

In this example, select Column C and hit delete to remove the unnecessary characters.

Add column headers according to the order of the data (it's different for each bank). Here, I used "DATE, AMOUNT, CATEGORY, and TRANSACTION"

Select Freeze then 1 row so column headings never move

Select the top left (empty) cell to highlight the entire sheet.

Google Drive is a cloud-based storage and synchronization service developed by Google. Learn how to upload files, videos, and others to Google Drive, share permissions, and more. Other tools in Google's suite of productivity include Docs, Sheets, and Slides, enabling real-time collaboration and easy access from any internet-connected device. Key features include file sharing, version history, robust search, offline access, and seamless organization.

Google Drive

Google Docs is a cloud-based document editing and collaboration platform. Learn how to change your doc margins, delete pages from docs, strikethrough text, and much more.

Guide: Downloading, organizing, and sorting bank statement data

Want to make guides like this in seconds? Yes, it's really that fast.