+ Reply to Thread
Results 1 to 7 of 7

Balance Sheet Not Balanacing

  1. #1
    Forum Contributor
    Join Date
    11-14-2007
    Posts
    111

    Balance Sheet Not Balanacing

    Hello

    This may not be the right place for this (the right forum that is) but i have had such luck in the past getting unstuck with some issues and while this one is embarrassing, I am hoping there is someone with Excel and accounting experience to help me unravel the thing.

    I have had this file for years. I am just now opening it up and looking to get the statements published for a funding round. When i made a ton of adjustments to the workbook to make it more in line with the new model, the balance sheet stopped balancing and for the life of me I can not figure out why.

    If anyone can check the workflow on the attached statements to see if there is a way to get the balance sheet check some to $0, that would be great. This feels like a "Monday Detail" that I am not seeing, but I am working this file in the wee hours of the morning lately.

    I am hoping to wrap this up by year-end for a scheduled launch on a crowdfunding platform.

    original posting: https://www.accountantforums.com/thr...lanced.169616/

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Balance Sheet Not Balanacing

    What did you change? Where has it 'stopped working'? Please be very specific, directing us to certain cells where you have problems and telling us what results (values) you'd expect to see there.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Balance Sheet Not Balanacing

    Please upload the workbook not a zip file. Don't make us jump through unnecessary hoops.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,397

    Re: Balance Sheet Not Balanacing

    Ada,

    Hopefully you have an "audit trail" of the "tons" of cells you added, changed or deleted to restructure the spreadsheets.

    The logical thing is to recreate the steps, which will highlight the point at which things went "out of sync". If you can't resolve that initial error yourself, post the "before and after" section on here and someone will be able to help you with it.
    But asking a freelancer to slog through the entire suite of formulae over the Christmas break and correct any anomolies is really something you should be paying a consultant to do, rather than relying on volunteers to do it all for you free of charge when the output will benefit you commercially?

    Ochimus

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Balance Sheet Not Balanacing

    For year 1, for instance, we have only the Ending balance., with unbalance btw asset and liabilities.

    Of course, at begining, it started with zero for every accounts.

    If Debit/Credit in pair, un-banlance issue would not happen.

    Therefore, check again the General Ledger:

    1) Is there any transaction with single A/C ( only debit or only credit) ?

    2) If not, is debit A/C or credit A/C registered in Balance sheet?
    For instant, when you buy a new truck, the transaction recorded:
    Debit "Truck"/ Credit: "Cash"
    But, has forgotten to add "Truck" in list of "Properly, Plant & Equipment" group.

    3) Does the "Retained Earnings" collect "ALL" revenue and cost?

    They are main reasons may caused the unbalance issue.

    If you could not figure it out, try to up load the general ledger, I will see what I can do.
    Quang PT

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Balance Sheet Not Balanacing

    This has now been marked as solved - is it?

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Balance Sheet Not Balanacing

    Ada01, your thread in accountancy forum has no reply so far

    Now you get it (though not sure these solutions/advices work or not), but you get it here, in this forum.

    Is that real "SOLVED"? Waiting to hear from you.

+ 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. Replies: 0
    Last Post: 11-07-2020, 05:59 AM
  2. Linking of Excel sheet balance to main snap sheet
    By vizagsuresh in forum Excel General
    Replies: 1
    Last Post: 06-30-2018, 03:55 AM
  3. Replies: 3
    Last Post: 10-01-2015, 12:38 AM
  4. IF function for running balance that wont show starting balance in all cells
    By Heather T in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-11-2015, 03:15 PM
  5. [SOLVED] Balance sheet
    By pccamara in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2014, 12:44 PM
  6. Replies: 4
    Last Post: 01-02-2011, 04:30 PM
  7. [SOLVED] rent received/balance owed/running balance spreadsheet
    By Quickbooks dummy in forum Excel General
    Replies: 1
    Last Post: 01-02-2006, 03:40 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