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

    Dec 7, 2017, 02:44 PM
    How to get the correct cash balance?
    Find the correct cash balance for the year end 12/31/2016 to be used in preparing financial statements
    Available data:
    -the entity is a non-profit organization, no checking account only savings account
    -has opening cash balance of 115,934.50 (Jan 1, 2016) actually it's in the bank
    -total cash receipts amount to 134,789.50 (9,600 loan repayment from employees, 125,189.50 rentals received from tenants)
    -total disbursements amount to 170,268.93 (includes cash advances to employees 51,505.00)
    -total deposits amount to 74,069.50 (bank interest on deposit amount to 607.19 which is not included in total deposit)
    -outstanding cash balance per bank record amount to 91,411.19 (Dec 31, 2016)

    Is the cash balance per bank will be the amount of cash to be used in the balance sheet balance?
    joypulv's Avatar
    joypulv Posts: 21,593, Reputation: 2941
    current pert

    Dec 7, 2017, 05:19 PM
    116 in bank + 135 in = 251
    170 out
    251 - 170 = 81 left. Only 74 deposited.
    where did the missing 7 go?
    How did the bank balance get to be MORE than it should? 91. Some should be interest, but not 10.

    Do you see how you have to do a simple rough calculation to see if it all makes sense? It doesn't.
    You either have 81 to put in the bank, or you explain how it got to 91.

    Is accounting cash or accrual? Are some rents unpaid etc?

    Do you see how you have to actually comprehend the whole scenario, not just a bunch of numbers?
    Try asking us again.
    OH and is this for a job or a course? It matters
    paraclete's Avatar
    paraclete Posts: 2,706, Reputation: 173
    Ultra Member

    Dec 11, 2017, 07:17 PM
    Is the cash balance per bank will be the amount of cash to be used in the balance sheet balance?

    No the true cash book balance is to be used. In your example the transactions do not balance by a significant amount

    Reasons for this
    Deposits outstanding at balance date
    Payments outstanding at balance date

    So first reconcile the bank balance with the cash book balance

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!

I can't get the correct end of the month cash balance [ 2 Answers ]

Sales are budgeted at : Nov $380,000 Dec $390,000 Jan $400,400 The following cash collection schedule is used : The month of sale - 70% Next month - 27% Uncollectible - 3% Cost of good sold: 65% of sale

On June 1 the cash balance was $162,000. During the month, cash receipts totaled $80, [ 1 Answers ]

On June 1 the cash balance was $162,000. During the month, cash receipts totaled $80,000 and the June 30 cash balance was $148,000. What is the total cash payments of June?

What was the correct balance of the Cash account at the close of business on April 3? [ 1 Answers ]

Abbey Bookkeeping Service, Inc. Trial Balance Apr. 8, 2011 Account Titles Debit Credit ------------------------------------------------------------------------- Cash 28,559.90 Accounts...

Calculate the correct balance for cash and prepare a trial balance? [ 1 Answers ]

The balances for the accounts of Mike's maintenance co. for the year ended December 31 are shown below. Each account shown had a normal balance. Accounts payable $6,500 Accounts receivable 7,000 Cash ? Maintenance supplies 1,200 Building 125,000 Supplies expense 21,500 Mike capital...

In a cash budget the cumulative cash balance is equal to? [ 1 Answers ]

a. Cumulative loan balance minus the ending cash balance. B. cumulative loan balance plus the ending cash balance. C. net cash flow minus the beginning cash balance. D. net cash flow plus the beginning cash balance.

View more questions Search