+ Reply to Thread
Results 1 to 6 of 6

Running balance with multiple bank account transactions in one table

  1. #1
    Registered User
    Join Date
    08-13-2021
    Location
    New Orleans
    MS-Off Ver
    365 Home
    Posts
    3

    Running balance with multiple bank account transactions in one table

    Good afternoon.

    I'm currently working on an accounting/bookkeeping spreadsheet.

    I have a table to input and view transactions.

    In column J, i'm looking to create a running balance, however i would like to have the running balance based on the account listed in column A. This serves a few purposes, including being able to filter by account, and then see a consistent running balance for that account. Also i can quick glance on a certain transaction/date and know what an account balance was on that date.

    Example:
    Account Amount Running Balance
    (Column A) ------(Column H)--------- (Column J)
    Account 1 ------ 100.00 --------- 100.00
    Account 1 ------ 50.00 ---------- 150.00
    Account 2 ------ 75.00 ---------- 75.00
    Account 3 ------ 100.00 ---------- 100.00
    Account 3 ------ 25.00 ---------- 125.00

    Also would like the blank rows below the last transaction to show nothing in Account Balance instead of 0.

    Apologies if this is not a great representation for the sake of help.
    Please let me know what I can do to try to get assistance for this.

    Thank you!
    Attached Files Attached Files
    Last edited by bcarruthjr; 08-13-2021 at 01:53 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,954

    Re: Running balance with multiple bank account transactions in one table

    See yellow banner at top of page on how to attach a sample workbook.

  3. #3
    Registered User
    Join Date
    08-13-2021
    Location
    New Orleans
    MS-Off Ver
    365 Home
    Posts
    3

    Re: Running balance with multiple bank account transactions in one table

    Thank you John sorry about that. its Attached as AccountingTemplateBACKUP.xlsx

    The Transactions tab.
    Last edited by bcarruthjr; 08-13-2021 at 01:52 PM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,954

    Re: Running balance with multiple bank account transactions in one table

    Try

    in I6

    =SUMIF($A$6:A6,A6,$H$6:H6)

    copy down

  5. #5
    Registered User
    Join Date
    08-13-2021
    Location
    New Orleans
    MS-Off Ver
    365 Home
    Posts
    3

    Re: Running balance with multiple bank account transactions in one table

    worked flawlessly. Thank you John.

    Can the equation be modified to show the rows with no data yet to be blank instead of showing a zero?

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,954

    Re: Running balance with multiple bank account transactions in one table

    format as

    "$"#,##0.00_);[Red]("$"#,##0.00);;@

+ 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. [SOLVED] Running balance from table, depending on date and account.
    By JohannesB in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2020, 02:33 AM
  2. Forumla to reconcile receipts and bank account transactions
    By Alex Butler in forum Excel General
    Replies: 4
    Last Post: 11-22-2018, 10:03 AM
  3. Grouping transactions from bank account
    By ryangodammit in forum Excel General
    Replies: 9
    Last Post: 10-09-2017, 02:57 AM
  4. How do I create a rolling bank account balance?
    By Dubby20 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-16-2013, 09:08 AM
  5. bank account balance
    By kc27315 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2008, 02:48 PM
  6. Replies: 2
    Last Post: 08-10-2005, 01:05 PM
  7. What is the formula for bank account row balance column
    By Hazeldean in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2005, 12:06 AM

Tags for this Thread

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