Ask Experts Questions for FREE Help !
Ask
    titans2008's Avatar
    titans2008 Posts: 10, Reputation: 1
    New Member
    		  
    #1

    May 26, 2008, 05:58 PM
    Calculate unadjusted cash balance
    When doing bank reconciliations, how do you calculate unadjusted cash balances in the general ledger? Is there a 'formula" to be used here
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
    		  
    #2

    May 26, 2008, 11:16 PM
    For most problems, the company's cash balance is given. Since the unadjusted balance is just the ending balance from the cash account (or really, the check register), it's just all the ads and subtracts that have been going on in that account all month. Not what I'd call a "formula." The problem could give you a beginning balance, and then all the deposits and checks written for the month, and it would be easy to get the ending balance from there.

    Or you might just be confused over the fact that "unadjusted cash balance" for a bank rec is the same thing as your ending balance in the ledger cash account.
    titans2008's Avatar
    titans2008 Posts: 10, Reputation: 1
    New Member
    		  
    #3

    May 28, 2008, 08:11 PM
    I'm still not 100% sure where to start, so I am attaching an excel file, which gives all the information I have . I am hoping to get some pointers on where to begin.

    My opening book balance should be: 1075, and 2750 should be the cash balance, but I can't quite figure out how to get there.
    Attached Files
  1. File Type: xls Bank rec.xls (18.0 KB, 867 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Unadjusted Trial Balance [ 15 Answers ]

I am working on a final assignment in Financial Accounting, but I've gone completely blank. Where do the entries for the unadjusted trial balance come from? Is it the ending balances from the month prior? Thank you for your help.

Unadjusted trial balance [ 1 Answers ]

Does Cost of merchandise sold go on the debit or credit side? Accumulated Depreciation debit or credit?

Acc 101 - unadjusted trial balance [ 1 Answers ]

Does the debit and credit balances in your unadjusted trial balance always have to equal? I'm working on a project in class & my DR and CR balances in my journal equal and I went on to do my ledger, but when I got to my unadjusted trial balance.. I can't get them to equal for nothing... does that...

Unadjusted Trial Balance [ 3 Answers ]

First time user of this site, and hopefully I will enjoy it. As an accounting major, I am facing problems with correcting trial balance. I tried my best to solve it myself. My question is : Dr. A/R 13,710 Cr. A/P 13,710 ...

View more questions Search