+ Reply to Thread
Results 1 to 9 of 9

Formulla for Next Day Auto Change the Opening Cash Balance

  1. #1
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Formulla for Next Day Auto Change the Opening Cash Balance

    r/ sir
    please send the formula for next day auto change the opening cash balance please send the formula for current date (22-01-2015) opening cash balance is (12500) than less other expenditures for the opening cash balance in C6 coloums the closing cash balance (1650) was display on the C5 columns and next date (23-01-2015) closing cash balance was Show on the next date show opening cash balance
    For Example
    Dated Opening Cash Balance (C6 coloums) Closing Cash Balance (C5 coloums )
    22-1-2015 12,500-00 1650-00
    Next Day Opening Cash Balance (C6 coloums) Closing Cash Balance (C5 coloums )
    23-1-2015 1650-00 This was display on less other Expenditures

    if any difficulties i am send the file please see the attachmnets
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    see the attached file 1 row was inserted with yellow color
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    r/ sir

    i am create simple excel sheet add daily cash report but i am create a new excel sheet expenditure & add daily cash report please see the attachments i am send the
    this excel sheet to i am working every day now you can see the excel sheet & edit my new excel sheet name Expenditure
    please see the attachments
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    R/ sir
    please solve my problum

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    Actually what is your requirement and one more thing the Closing balance was not matching with opening balances in some cases
    Please mention your requirement clearly, if possible show manually how your end result would be.

  6. #6
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    Actually my question is for Example : 30-1-2015 opening balance is 13000 & less all other Expanses for Example ( less Electricity bill = 450, Less Mobile Bill = 270, less Fright Charges = 180,plus cash in shop = 1500 example (13000-450-270-180+1500 = 13600) to the opening balance the closing balance is = 13600
    next day 31-1-2015 Previous closing balance = 13600 is the opening balance = 13600
    now you can see the last posted attachments & resolve my problum

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    Please re attach excel file with desired results

  8. #8
    Forum Contributor
    Join Date
    07-21-2014
    Location
    india
    MS-Off Ver
    2007
    Posts
    170

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    R/ Sir
    i am re send the attachments i am send the 2 files "Daily Cash Report Sale. Zip" Please see the Attachments i am working every day on this excel sheet but some
    problem was found in this excel sheet every day re enter the opening Balance than i am create a new excel sheet Name "Expenditure" i am fill all the information in this file the opening balance was auto change every day
    Actually my question is for Example : 30-1-2015 opening balance is 13000 & less all other Expanses for Example ( less Electricity bill = 450, Less Mobile Bill = 270,less Fright Charges = 180,plus cash in shop = 1500 example (13000-450-270-180+1500 = 13600) to the opening balance the closing balance is = 13600
    next day 31-1-2015 Previous closing balance = 13600 is the opening balance = 13600
    now you can see the last posted attachments & resolve my problem
    Attached Files Attached Files

  9. #9
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Formulla for Next Day Auto Change the Opening Cash Balance

    see the attached file
    I prepared the sheet from 1st January onwards
    I inserted one row on top to enter the starting opening balance (i,e on 1st Jan Opening Balance) in the start of the
    Attached Files Attached Files

+ 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] Month-end cash balance from the running cash balances
    By dache416 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-06-2014, 08:06 AM
  2. [SOLVED] Ending day cash balance
    By brandedadnan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-02-2014, 05:41 AM
  3. Opening balance and closing balance end of months.
    By sammy011 in forum Excel General
    Replies: 2
    Last Post: 01-31-2013, 02:12 PM
  4. Income Statement/balance sheet/cash flow summary generator
    By xleo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2012, 04:10 PM
  5. auto balance from previouse balance and value
    By phil_jackson in forum Excel General
    Replies: 7
    Last Post: 09-26-2010, 11:42 AM

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