+ Reply to Thread
Results 1 to 2 of 2

Grouping Bank statement transactions Macro maybe?

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    Boulder, Colorado
    MS-Off Ver
    Current
    Posts
    1

    Grouping Bank statement transactions Macro maybe?

    Hi all, this is my first post yet I always come here first to read up on solutions. I have a question of my own can someone help?

    I get a bank statement as to which I must reconcile to a different spreadsheet grouping the transactions based on the company. In my sample, there are three parts
    1. Being the Raw data
    2. How I would like the data to be transformed, in my sample, there are two added columns(Highlighted in yellow), type and company, Type has two options, Deposit, and withdrawal, a rule could be quickly written for greater than zero less than zero, yet I am unsure if that is macro worthy playing into the end result. There is also a company which could contain, Daily Deposit, Visa, Gift Card, Discover, Amex, Postmates, Grubhub, Uber, Doordash, CC Fee, and ACH. I can tell the transaction based on their description.
    3. The spreadsheet I must include in my monthly Profit and loss reports. This is the most important thing I need the macro to group the transactions within the bank column highlighted in yellow. they must be listed by date starting from oldest on top (ie 11.1.20) and newest on the bottom(11.31.20) assuming hypothetically today's date is 12.6.20.

    I will forever be in your debt if this can be accomplished as it would save me days worth of time saved each month. Please let me know how I can reward you for your time whether it be a review or whatever.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,565

    Re: Grouping Bank statement transactions Macro maybe?

    Hi JLew33,

    Welcome to the forum!!

    The following are my comments to your requests which relate to the attached.

    Type has two options, Deposit, and withdrawal, a rule could be quickly written for greater than zero less than zero
    Refer formula in Col. D of Data Result tab

    they must be listed by date starting from oldest on top (ie 11.1.20) and newest on the bottom(11.31.20)
    Macro1 sorts the data in the Data Result tab by date in ascending order.

    the most important thing I need the macro to group the transactions within the bank column highlighted in yellow
    I have created an additional tab called Output Lookup that tells the code what column to use to put the amount in Col. B of the Data Result tab into the Spreadsheet Result tab. This will make the process easy to maintain. I have also shifted the categories across the Spreadsheet Result tab so the amounts being copied into it do not overlap a category below. I have also included the expense categories to be populated as well.

    Regards,

    Robert
    Attached Files Attached Files
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Vlookup Partial Text - Transactions from Bank Statement
    By jowettluke in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-27-2025, 10:57 PM
  2. [SOLVED] Post bank transactions to bank Recon as individual amounts instead of sums
    By SjMaxwell in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-16-2018, 03:15 AM
  3. Looking to categorize bank transactions but need some help for some $$
    By berman53 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-14-2018, 04:48 PM
  4. [SOLVED] Sorting & categorizing bank transactions csv - pivot
    By Rocmel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-18-2017, 08:36 PM
  5. Grouping transactions from bank account
    By ryangodammit in forum Excel General
    Replies: 9
    Last Post: 10-09-2017, 02:57 AM
  6. sort my montly bank transactions in Excel: Please help!
    By Deicide5997 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2015, 07:05 AM
  7. How can I temporarily hide transactions in a bank statement?
    By bogglebogglehead in forum Excel General
    Replies: 1
    Last Post: 02-03-2014, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1