+ Reply to Thread
Results 1 to 3 of 3

Debits and credits

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Debits and credits

    I have a workbook that I compile every month of o going payments, which have outstanding charges and credits.

    The problem that I have is that sometimes folks pay their outstanding balances and sometimes not. Also I may have folks paying off their charges with credits balances.

    Since these debits and credits can keep going from month to month I need to figure out a way to keep them ongoing to the current worksheet.

    Cell E: Total Charge Persnl Mins
    Cell G: Payment Text Mins.
    Cell H: Other
    Cell I: Roaming Charge
    Cell J: Previous Debits
    Cell K: Previous Credits
    Cell M: Amt. Paying from Credit
    Cell N: Amt Paying
    Cell Q: Current Debit
    Cell R: Crurrent Credit
    Cell S: New Balance

    I have created the formulas but I am having a problems with the credits and debits. When the credit or debit does carry over to the next month how can it show as a debit and credit?

    Please help obviously I thought that the formulas that I had done would work but they are not.

    Thank you all for your time and expertise.

    I have attached a copy of what I am trying to do.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Debits and credits

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    08-06-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Debits and credits

    Please see attached new file.

    Thank you for all your help.
    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. How to delete Debits & credits off with a macro
    By gavinsmommie24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-22-2014, 11:42 PM
  2. [SOLVED] debits and credits in one column
    By childothe1980s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2013, 03:47 PM
  3. [SOLVED] Lookup Debits & Credits
    By Sniper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2012, 10:25 AM
  4. Highlighting Debits and Credits
    By vharjani in forum Excel General
    Replies: 15
    Last Post: 02-23-2012, 02:20 PM
  5. [SOLVED] Change debits to credits
    By Yo in forum Excel General
    Replies: 1
    Last Post: 04-10-2006, 08:20 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