Guide: Downloading, organizing, and sorting bank statement data | Scribe

    Guide: Downloading, organizing, and sorting bank statement data

    • Sarah Covell |
    • 46 steps |
    • 3 minutes
    1
    Navigate to the bank account you use for your business. Select the desired dates and download to a spreadsheet, .csv, or comma delimited format.
    2
    Click "Download Account Activity"
    3
    Select your desired date range.
    4
    Click "Download"
    5
    Open Google Drive
    information ordinal icon
    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.
    6
    Click "New, then "File Upload" to upload the file to Google Drive.
    7
    Double-click the file to open it.
    8
    Click here to open with Google Sheets.
    9
    Select Row 1 and right click or Control click on it to bring up the menu.
    10
    Select "Insert 1 row above". You will use this to create a header row.
    11
    In this example, select Column C and hit delete to remove the unnecessary characters.
    12
    Add column headers according to the order of the data (it's different for each bank). Here, I used "DATE, AMOUNT, CATEGORY, and TRANSACTION"
    13
    Select Row 1, then click "View"
    14
    Select Freeze then 1 row so column headings never move
    15
    Select the top left (empty) cell to highlight the entire sheet.
    16
    Click "Data", then "Sort Range"
    17
    Click "Advanced range sorting options"
    18
    Click here to use header row titles.
    19
    Select "TRANSACTION".