I have attached 2 Excel file.

The "fixed asset schedule" Excel file shows the amortization and depreciation details of the company's fixed asset. The "homework" Excel file is the company's fixed asset account reconciliation workbook.

In the "homework" Excel file, I need to build Fixed Asset Account Reconciliation. Therefore, I want to know how to build fixed asset account reconciliation by using the data in the "fixed asset schedule" Excel file?

AMORTIZATION & DEPRECIATION SCHEDULES Acquisition Date Description Vendor 05/20/2016 Web Domains (.com/,net) Calvin Kim reimbursement 15 Years INTANGIBLE ASSET-DOMAIN 10/12/2016 Cintiq for Nick Carpenter Amazon 2,884.70 07/03/2017 Apple Computer - Matt Apple 2,617.86 08/02/2017 Television - Matt Magnolia Hi Fi 3,239.49 5 Years COMPUTER EQUIPMENT 09/15/2018 Office Furniture Source Creative Interiors 69,081.59 10/30/2018 Office Furniture Big Daddy's Antiques 18,949.41 10/30/2018 Office Furniture Timothy Oulton 9,800.00 10/30/2018 Office Furniture HD Buttercup 1,589.32 11/06/2018 Office Furniture Corporate Office Interiors 8,132.25 11/26/2018 Office Furniture Rug & Weave 1,808.15 12/04/2018 Office Furniture Big Daddy's Antiques 12/10/2018 Office Furniture Source Creative Interiors 7 Years FURNITURE 07/13/2018 Windows & Doors Amighini Antique & Custom Doors 12/11/2018 App 3B & App 4 Turelk, Inc 6.5 Years LEASEHOLD IMPROVEMENTS COST 15,000.00 15,000.00 ### 8,742.05 ### 21,366.58 4,378.90 135,106.20 ### 47,948.75 257,441.34 305,390.09 ### #REF! #REF! Threshold Guidance Current Month Type Date FA depreciated the month it's aquired Jan-18 Vendor 1501 Comp 1/1/2017 Apple Description Owners Serial Number Macbook Pro Joe Smith N123456 Conference Chairs Various NA 1501 Computer Equipment - Total 1502 Furni 2/1/2017 Best Buy 1502 Furniture - Total 1501 Computer Equipment 1502 Furniture Total Amount 3,000 Term 36 Monthly Depreciation 83 3,000 5,000 36 Jan-18 Feb-18 83 83 83 83 139 Mar-18 Apr-18 May-18 Jun-18 - - - - 139 5,000 - 139 - - - - 3,000 5,000 83 - 83 139 - - - - 8,000 83 222 - - - - Jul-18 Aug-18 - Sep-18 - Oct-18 - Nov-18 - Dec-18 - A/D - ### NBV 166 2,834 166 2,834 139 4,861 - - - - - - ### 139 4,861 - - - - - - 166 139 2,834 4,861 - - - - - - ### 305 7,695