+ Reply to Thread
Results 1 to 4 of 4

Convert Bank Statement to a Check Register Type Format?

  1. #1
    Registered User
    Join Date
    07-03-2022
    Location
    Ky
    MS-Off Ver
    Office 2016
    Posts
    2

    Convert Bank Statement to a Check Register Type Format?

    I have as an example a May bank statement and was trying to figure out what to do to make the balance on each line change whenever there is a withdrawal, deposit or nothing at all. I have watched a lot of youtube videos and applied different formulas but nothing seems to work. Maybe it's because all the data is already on the statement or that the starting balance which is 3-01-2022 is calculating from the bottom up to the top? This seems pretty simple, but I just don't know what I am doing wrong. Any help would be greatly appreciated....

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Convert Bank Statement to a Check Register Type Format?

    If you mean how to calculate the balance per line , then see attached,

    In column D:
    =D2+B3-C3
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-03-2022
    Location
    Ky
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Convert Bank Statement to a Check Register Type Format?

    Yeah, I did this also, but my starting balance was on D47, it gave me a #REF error when I tried copying the formula to the above boxes.

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Convert Bank Statement to a Check Register Type Format?

    Please upload your sample file.....

+ 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] Check Field data type (cell format) based on named range
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2019, 05:41 AM
  2. Bank Recon - How to convert 8 digit formatted check numbers to 6 digit
    By Quisp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2017, 09:55 PM
  3. Help! Need Check Register
    By bookbuyer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2016, 05:43 PM
  4. Replies: 2
    Last Post: 01-02-2013, 04:55 AM
  5. [SOLVED] Excel 2007 : Find bank balance in bank statement
    By Baldev Kumar in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 02:58 PM
  6. How To Check What type of Format the cell is Using VB.Net
    By pavel3002 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2011, 06:26 PM
  7. [SOLVED] Convert Julian dates back to date data type format?
    By Lara in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2006, 10:25 PM

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