+ Reply to Thread
Results 1 to 13 of 13

Checkbook register opening balance

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    maryland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Checkbook register opening balance

    I am using the checkbook register in Excel with one problem. I would like to indicate my opening balance and the program will not allow me to change the balance in the first line of the register. How do I work around this to set an opening balance amount?

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Checkbook register opening balance

    Put in a deposit for your opening balance.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-07-2012
    Location
    maryland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Checkbook register opening balance

    Good idea. This makes simple sense.

    Thank you.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Checkbook register opening balance

    I can't imagine a decent Checkbook register template that doesn't allow you to enter an actual starting balance. Contact the author and ask them what you're missing, it might be easy to add.

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  5. #5
    Registered User
    Join Date
    02-07-2012
    Location
    maryland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Checkbook register opening balance

    Its an excel template that came with the software How can I contact the author?

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Checkbook register opening balance

    Let's see the template. Click GO ADVANCED and use the paperclip icon to post up a copy of it.

  7. #7
    Registered User
    Join Date
    02-07-2012
    Location
    maryland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Checkbook register opening balance

    I would love to do this but it is filled with personal information. I will post a blank one. I hope this helps.
    Attached Files Attached Files

  8. #8
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Checkbook register opening balance

    Well, I had no problem entering a balance in J2.

  9. #9
    Registered User
    Join Date
    02-07-2012
    Location
    maryland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Checkbook register opening balance

    That might be because I inadvertently attached the wrong file. I have attached the correct one here. See if this helps you solve the problem. And thanks for your help and patience!
    Attached Files Attached Files

  10. #10
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Checkbook register opening balance

    Again, this doesn't look like much of a template. There are no formulas or much structure of any kind other than a few titles in row 1. I can still add a starting balance in G2, no problem.

  11. #11
    Registered User
    Join Date
    02-07-2012
    Location
    maryland
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Checkbook register opening balance

    I still cannot add a starting balance in G2 and I can't figure out why. Do you think there might be something in the preferences or some sort of lock that won't let me do this? I am a mac user and have used other templates in excel with no problem. This is a first for me.
    If there is anyone else out there that has used this template with similar results please do weigh in on this.
    The only solution I see to this that makes sense so far is to add a starting deposit to offset the inability to add a starting balance to G2 in my form. I just can't believe that that is the only possible solution.

  12. #12
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Checkbook register opening balance

    Perhaps the sheet is protected? If so, unlock the sheet, add your beginning balance, then protect the sheet again. I can't think of anything else at the moment.

  13. #13
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Checkbook register opening balance

    Which software are you getting this with?

    It looks like it should be filled from the software
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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