1015-Bank, payroll Account Number and Name 1010-Petty cash 1020-Bank, general Tickmark legend G/L PY F Oceanview...

Transcribed Image Text:

1015-Bank, payroll Account Number and Name 1010-Petty cash 1020-Bank, general Tickmark legend G/L PY F Oceanview Marine Company Cash Leadsheet December 31, 2015 2015 Balance 200 G/L 20-5 2,000 G/L 1.317.896 G/L Total 1.320.096 F Agreed to general ledger. Agreed to prior year's workpapers. Footed without exception. Net Adjustments 2015 Adjusted Balance 2014 Balance 200 PY 2,000 PY 1.087.778 PY 1.089.978 F 20-1 % Change (before adjustment) 0.00% 0.00% 21.15% 21.11% Balance per bank statement Add: Deposits in transit Deduct: Outstanding checks: 11567 Nov. 30 2015 11575 Nov. 30 2015 11865 Dec. 14 2015 11883 Dec. 14 2015 Oceanview Marine Company Bank Reconciliation-Payroll December 31, 2015 11945 Dec. 28 2015 11948 Dec. 28 2015 11953 Dec. 28 2015 11965 Dec. 28 2015 11970 Dec. 28 2015 11983 Dec. 28 2015 11989 Dec. 28 2015 12003 Dec. 28 2015 12005 Dec. 28 2015 12008 Dec. 28 2015 Balance per bank, adjusted Tickmark Legend F 685.32 765.23 234.76 435.99 1,045.23^ 1,134.65- 446.89 678.90 456.89 341.19 890.24 402.91 467.66 465.32 F 10,451.38 20-7 0.00 8,451.38 2,000.00 F Balance per books, unadjusted Adjustments: Balance per books, adjusted 20-5 BC 2/04/2016 2,000.00 20-1 GA 0.00 PBC Agreed to check clearing with cutoff bank statement. Check did not clear with cintoff bank statement. Reviewed January 2016 bank statement, check cleared in January 2016. G/L Agreed to general ledger balance. Footed without exception. 2,000.00 F Oceanview Marine Company Bank Reconciliation-General Bank Account December 31, 2015 Balance per bank statement Add: Deposits in transit Dec. 30 2015 Dec. 30 2015 26,262.78 12,346.98 Deduct: Outstanding checks: 5835 Nov. 02 2015 5919 Nov. 23 2015 6016 Dec. 07 2015 6139 Dec. 21 2015 6245 Dec. 28 2015 6248 Dec. 28 2015 6249 Dec. 28 2015 6251 Dec. 28 2015 6252 Dec. 28 2015 6254 Dec. 28 2015 6256 Dec. 28 2015 6257 Dec. 28 2015 6258 Dec. 28 2015 6260 Dec. 28 2015 6261 Dec. 28 2015 6263 Dec. 28 2015 6264 Dec. 28 2015 6265 Dec. 28 2015 6266 Dec. 28 2015 6267 Dec. 28 2015 6268 Dec. 28 2015 6269 Dec. 28 2015 Balance per bank, adjusted Tickmark Legend G/L Agreed to general ledger balance. 1,516.18 375.75 679.00 345.00 5,670.00 984.00 2,350.49 321.48 3,781.70 672.58 1,251.83 12,987.35 337.12 1,841.80 456.90 149.15 1,385.29 456.86 3,450.91 7:33.00 200.00 13,454.30 20-8 1,332,686.93 38,609.76 53,400.69 1,317,896.00 20-6 Balance per books, adjusted PBC Balance per books, unadjusted 1,317,896.00 GL Adjustments: 0.00 1,317,896.00 f. Write the net effect of any adjustments you believe should be made to the year-end cash balances in the "Net Adjustments" column on the cash leadsheet (workpaper 20-1), and complete the "2015 Adjusted Balance" column. (If no adjustments are needed, write "0" in the "Net Adjustments" column.) 1015-Bank, payroll Account Number and Name 1010-Petty cash 1020-Bank, general Tickmark legend G/L PY F Oceanview Marine Company Cash Leadsheet December 31, 2015 2015 Balance 200 G/L 20-5 2,000 G/L 1.317.896 G/L Total 1.320.096 F Agreed to general ledger. Agreed to prior year's workpapers. Footed without exception. Net Adjustments 2015 Adjusted Balance 2014 Balance 200 PY 2,000 PY 1.087.778 PY 1.089.978 F 20-1 % Change (before adjustment) 0.00% 0.00% 21.15% 21.11% Balance per bank statement Add: Deposits in transit Deduct: Outstanding checks: 11567 Nov. 30 2015 11575 Nov. 30 2015 11865 Dec. 14 2015 11883 Dec. 14 2015 Oceanview Marine Company Bank Reconciliation-Payroll December 31, 2015 11945 Dec. 28 2015 11948 Dec. 28 2015 11953 Dec. 28 2015 11965 Dec. 28 2015 11970 Dec. 28 2015 11983 Dec. 28 2015 11989 Dec. 28 2015 12003 Dec. 28 2015 12005 Dec. 28 2015 12008 Dec. 28 2015 Balance per bank, adjusted Tickmark Legend F 685.32 765.23 234.76 435.99 1,045.23^ 1,134.65- 446.89 678.90 456.89 341.19 890.24 402.91 467.66 465.32 F 10,451.38 20-7 0.00 8,451.38 2,000.00 F Balance per books, unadjusted Adjustments: Balance per books, adjusted 20-5 BC 2/04/2016 2,000.00 20-1 GA 0.00 PBC Agreed to check clearing with cutoff bank statement. Check did not clear with cintoff bank statement. Reviewed January 2016 bank statement, check cleared in January 2016. G/L Agreed to general ledger balance. Footed without exception. 2,000.00 F Oceanview Marine Company Bank Reconciliation-General Bank Account December 31, 2015 Balance per bank statement Add: Deposits in transit Dec. 30 2015 Dec. 30 2015 26,262.78 12,346.98 Deduct: Outstanding checks: 5835 Nov. 02 2015 5919 Nov. 23 2015 6016 Dec. 07 2015 6139 Dec. 21 2015 6245 Dec. 28 2015 6248 Dec. 28 2015 6249 Dec. 28 2015 6251 Dec. 28 2015 6252 Dec. 28 2015 6254 Dec. 28 2015 6256 Dec. 28 2015 6257 Dec. 28 2015 6258 Dec. 28 2015 6260 Dec. 28 2015 6261 Dec. 28 2015 6263 Dec. 28 2015 6264 Dec. 28 2015 6265 Dec. 28 2015 6266 Dec. 28 2015 6267 Dec. 28 2015 6268 Dec. 28 2015 6269 Dec. 28 2015 Balance per bank, adjusted Tickmark Legend G/L Agreed to general ledger balance. 1,516.18 375.75 679.00 345.00 5,670.00 984.00 2,350.49 321.48 3,781.70 672.58 1,251.83 12,987.35 337.12 1,841.80 456.90 149.15 1,385.29 456.86 3,450.91 7:33.00 200.00 13,454.30 20-8 1,332,686.93 38,609.76 53,400.69 1,317,896.00 20-6 Balance per books, adjusted PBC Balance per books, unadjusted 1,317,896.00 GL Adjustments: 0.00 1,317,896.00 f. Write the net effect of any adjustments you believe should be made to the year-end cash balances in the "Net Adjustments" column on the cash leadsheet (workpaper 20-1), and complete the "2015 Adjusted Balance" column. (If no adjustments are needed, write "0" in the "Net Adjustments" column.)

Answer rating: 100% (QA)

Oceanview Marine Company Cash Leadsheet December 31 2015 Workpaper 201 Acc... View the full answer