Equipment Reconciliation Worksheet

Top  Previous  Next

Equipment Reconciliation for Month Ending ___/___/____

1.

Before beginning any reconciliation, be sure to make a backup of your data and then index the company tables. The time required to create the selected index files varies with the type of file and the number of records in the file. NEVER TURN OFF OR RESTART YOUR COMPUTER DURING THE INDEX PROCESS, OTHERWISE THE DATA FILES MAY BECOME CORRUPT. If the system cannot re-index the files, an error message will be displayed. Select the Print button for a hard copy of the progress information and call AccuBuild's technical support staff for assistance.

 

2.

Next, interrogate the batch files for 'problem batches'. In the System Administrator > Batch Log Info option, select the Problem Batches option. This feature will search for any batch that does not have a completion time but has detail records posted to one or more data files. This may occur when a batch attempts to post and encounters too many record locks. Usually, the record tracking is disabled and the batch is re-posted which creates a new batch number. The first batch should be deleted as it would contain one or more of the same entries that are contained in the second batch. Before deleting a batch, be sure that the entries were properly posted in another batch (usually the next sequential batch). Also, you may not want to delete an old problem batch as the entry may have been reversed with a journal entry. If any problem batches were encountered and deleted, you must perform the next step otherwise your reconciliation would be incorrect.

 

3.

Run all of the integrity tests within the equipment module. Be sure to run the 'update' options found in the integrity tests menu before performing the 'All Tests' option. Again, if any errors are encountered, please contact AccuBuild for assistance before proceeding to the next step.

 

4.

Print a Trial Balance - Current Year report.  The report totals on the last page of the report should be zero for all four columns. If these totals are not zero, then the debits and credits are out of balance in the general ledger and need to be corrected.  If they are not zero, then please refer to the reconciliation worksheet in the General Ledger Module.        

 

5.

Print the Equipment List by Category Report in the Equipment Module.  The categories should list the original purchase price of each piece of equipment for that category.  The category totals should correspond to the fixed asset descriptions and totals on the balance sheet.        

 

6.

Print the Equipment Depreciation Report in the Equipment Module.  The total of the prior years depreciation and the current year depreciation for each category should equal the total accumulated depreciation on the balance sheet.