data validation excel accounting

User Generated

fnyznab96

Business Finance

Description

every thing is in the attachment please follow all the instructions i want 2 files to be sent sepratley i will put them in one zip

Unformatted Attachment Preview

Data Validation and Input Controls If you add extra controls features, you will also submit a brief note, typed in Word, as the documentation of the extras. You will submit the electronic document(s) in ONE ZIP archive . Create a spreadsheet in EXCEL to reconcile bank statement. Organize it as follows: • • • • • • All the cells must be appropriately formatted, e.g. dollar amounts must use the accounting format, etc. Other formatting such as bold, underline and italic are expected to be used in appropriate places. All the negative adjustments must be typed in as negative values. The input must be validated by using data validation tools. The values must also be displayed in RED by using conditional formatting. Appropriate input controls, such as range check or length check, must be applied to attributes/elements such as check numbers. All the (sub-)totals of continuous ranges must be prepared by using the aggregation functions provided in EXCEL. The IF function should be used to make logical judgment. Additional control features are encouraged but not required. Use the numbers below to show how your spreadsheet works. Balance per Bank Statement Balance per Book $ 107,525.33 $ 106,928.68 Collection of Notes receivable by the bank: Principal Interests Fee charged by the bank for collection $ 10,000.00 $ 30.00 $ 20.00 Interests on the reconciled account $ 11.95 Monthly Charge by the bank $ 25.00 Deposit in Transit Note Payment, Beethoven Payment, Mozart Payment, Mikey Refund, Pooh Amount $ 12,000.00 $ 13,000.00 $ 8,000.00 $ 7,000.00 Outstanding Cheks Check number 1234 1235 1237 1239 1240 Amount $ 2,256.75 $ 4,775.50 $ 3,567.45 $ 7,500.00 $ 12,500.00 1
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey, It's my hope that you're fine. Find the two completed files attached below for your review. I have used two different approaches to reconcile the bank balance and the cash book balance. Let me know in case you need anything edited.Best regards.

Data Validation

Name

...


Anonymous
Great! 10/10 would recommend using Studypool to help you study.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags